trees
39,840 rows where qLegalStatus_id = 7 sorted by qSpecies_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 680 | 47114 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45098 | 6008176.0434029 | 2098254.72889507 | 37.7418697970416 | -122.414330302805 | (37.7418697970416, -122.414330302805) | 2 | 7 | 7 | 28859 | 2 | ||
| 733 | 218511 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 318 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43359 | 5996829.51445 | 2089654.64111 | 37.7176120972009 | -122.45294206803 | (37.7176120972009, -122.45294206803) | 9 | 8 | 6 | 28861 | 24 | |
| 1112 | 8732 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3210 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1996 12:00:00 AM | 6 | 3X3 | 5997102.31429 | 2113088.26659 | 37.7819706522719 | -122.453690315182 | (37.7819706522719, -122.453690315182) | 11 | 6 | 1 | 54 | 31 | ||
| 1125 | 101207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 1247 | 214916 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1993 12:00:00 AM | 13 | Width 2ft | Permit Number 32246 | 5993222.12997 | 2093186.27538 | 37.7271017173463 | -122.465667493867 | (37.7271017173463, -122.465667493867) | 9 | 8 | 4 | 59 | 40 | |
| 1358 | 109891 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013218 | 2106201 | 37.7639704813344 | -122.397453893083 | (37.7639704813344, -122.397453893083) | 14 | 3 | 8 | 28856 | 29 | ||||
| 1651 | 37169 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.7462364463923 | -122.423472053683 | (37.7462364463923, -122.423472053683) | 2 | 7 | 5 | 28859 | 22 | ||
| 2937 | 104069 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1340 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 3x3 | Permit Number 770297 | 6007143.4 | 2107674.1 | 37.7676751698972 | -122.418568643249 | (37.7676751698972, -122.418568643249) | 8 | 4 | 7 | 28853 | 19 | ||
| 3012 | 15898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5647X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 5998341.15292 | 2087120.08013 | 37.7107392839911 | -122.447534700696 | (37.7107392839911, -122.447534700696) | 9 | 7 | 6 | 28861 | 5 | ||
| 3747 | 36212 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/2006 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 4009 | 54330 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1257 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2012 12:00:00 AM | Permit Number 769330 | 5994831.50805386 | 2106979.48216267 | 37.7650671008227 | -122.461103283683 | (37.7650671008227, -122.461103283683) | 15 | 5 | 11 | 56 | 12 | |||
| 4328 | 36209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 4458 | 37157 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 88 29th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | 2 | 7 | 5 | 28859 | 2 | |||
| 4712 | 39418 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 5291 | 95249 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 483 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.4815747855 | (37.778566675209, -122.4815747855) | 11 | 6 | 2 | 55 | 26 | ||||
| 5558 | 38535 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4517 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40515 | 6015241.886192 | 2096337.56497418 | 37.7370000434098 | -122.389764834673 | (37.7370000434098, -122.389764834673) | 10 | 3 | 8 | 58 | 1 | ||
| 5603 | 36757 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1578 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39522 | 5993099.35503511 | 2104739.07158377 | 37.7588156897013 | -122.466931435386 | (37.7588156897013, -122.466931435386) | 1 | 8 | 4 | 56 | 12 | |||
| 5875 | 99834 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 | ||
| 6355 | 100391 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 226 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x7 | 6002817 | 2092256 | 37.7250961583897 | -122.432431760897 | (37.7250961583897, -122.432431760897) | 9 | 7 | 6 | 28861 | 5 | ||||
| 6672 | 39412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
| 7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 8819 | 218630 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 823 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777479 | 5990637.31518 | 2099027.3446 | 37.7429903745186 | -122.475029277203 | (37.7429903745186, -122.475029277203) | 1 | 8 | 4 | 29491 | 40 | |
| 9127 | 95439 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1874 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767301 | 5986339.2 | 2102491.9 | 37.7522530747906 | -122.490145565656 | (37.7522530747906, -122.490145565656) | 1 | 8 | 3 | 56 | 35 | |
| 9274 | 218494 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 248 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 772989 | 5994534.17979 | 2089038.5715 | 37.7157887100619 | -122.460831317629 | (37.7157887100619, -122.460831317629) | 9 | 8 | 6 | 28861 | 24 | |
| 9597 | 88675 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 9772 | 95689 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767440 | 5982968.9 | 2098671.4 | 37.7415656423265 | -122.501517800216 | (37.7415656423265, -122.501517800216) | 1 | 8 | 3 | 29491 | 35 | |
| 9965 | 83767 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 3x3 | Permit Number 51874 | 6004709.30002437 | 2099902.50025003 | 37.7461988489012 | -122.42643447623 | (37.7461988489012, -122.42643447623) | 2 | 7 | 5 | 63 | 22 | ||
| 10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 10508 | 220252 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1421 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782294 | 6002022.45837 | 2099900.18777 | 37.7460402480521 | -122.435725060979 | (37.7460402480521, -122.435725060979) | 2 | 7 | 5 | 63 | 22 | |
| 10638 | 15720 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4357X Mission St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/1995 12:00:00 AM | 6 | 3x3 | 6002851.16985 | 2093165.53011 | 37.7275954613369 | -122.432378570152 | (37.7275954613369, -122.432378570152) | 9 | 7 | 6 | 28861 | 5 | ||
| 10640 | 41309 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2000 12:00:00 AM | Permit Number 41981 | 5992910.03093479 | 2098919.83529447 | 37.7428266345167 | -122.467163100034 | (37.7428266345167, -122.467163100034) | 1 | 8 | 4 | 59 | 40 | |||
| 10847 | 17720 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |
| 11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 11388 | 101208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 11880 | 42194 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1016 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42470 | 6010410.48288619 | 2109291.59089856 | 37.772299817533 | -122.407382201369 | (37.772299817533, -122.407382201369) | 14 | 2 | 9 | 28853 | 34 | ||
| 12582 | 32159 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
| 12958 | 36213 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1455 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | 10 | 3 | 8 | 58 | 1 | ||
| 13150 | 44035 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1147 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2000 12:00:00 AM | Permit Number 43570 | 6003860.00449326 | 2101604.35206058 | 37.75082369093 | -122.429492581147 | (37.75082369093, -122.429492581147) | 2 | 4 | 5 | 28862 | 22 | |||
| 13160 | 36755 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39521 | 6011153.23525132 | 2095168.62195256 | 37.733562795365 | -122.403818978685 | (37.733562795365, -122.403818978685) | 10 | 3 | 8 | 58 | 1 | |||
| 13565 | 104520 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 295-299 Lee Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2013 12:00:00 AM | 3x3 | Permit Number 770416 | 5996485.8 | 2091712.7 | 37.723243339338 | -122.454278699409 | (37.723243339338, -122.454278699409) | 9 | 8 | 4 | 28861 | 24 | ||
| 13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 14294 | 220251 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1421 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782294 | 6002021.86814 | 2099888.44032 | 37.746007958796 | -122.435726261582 | (37.746007958796, -122.435726261582) | 2 | 7 | 5 | 63 | 22 | |
| 14317 | 38265 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 711 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | 6 | 3x3 | Permit Number 40366 | 6015782.17100529 | 2103924.24418542 | 37.7578614341223 | -122.388426186906 | (37.7578614341223, -122.388426186906) | 10 | 3 | 8 | 28856 | 29 |
| 14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 14366 | 32816 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3770 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37175 | 6003302.6047116 | 2103041.70072149 | 37.7547387357637 | -122.431522720463 | (37.7547387357637, -122.431522720463) | 2 | 4 | 5 | 28862 | 22 | ||
| 14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 14454 | 32825 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4388 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37183 | 6000688.62823937 | 2102311.71658566 | 37.752585873246 | -122.440510188354 | (37.752585873246, -122.440510188354) | 2 | 4 | 5 | 28862 | 22 | ||
| 15581 | 46699 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1399X FUNSTON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | 8 | 3x3 | Permit Number 44828 | 5992090 | 2106254 | 37.7629169745179 | -122.470532554608 | (37.7629169745179, -122.470532554608) | 1 | 8 | 11 | 56 | 12 |
| 15987 | 87029 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 98 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775743 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | 8 | 2 | 9 | 28853 | 19 | |
| 16177 | 12190 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1463 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016279.6460328 | 2095463.27872 | 37.734656922024 | -122.386115870582 | (37.734656922024, -122.386115870582) | 10 | 3 | 8 | 58 | 1 | ||
| 16251 | 28441 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2301 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5992413.94145 | 2094015.73092 | 37.7293325470846 | -122.468521689844 | (37.7293325470846, -122.468521689844) | 9 | 8 | 4 | 59 | 40 | ||
| 16478 | 49101 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2003 12:00:00 AM | Permit Number 46246 | 6012933.18722113 | 2110757.22353588 | 37.7764649850887 | -122.398758756879 | (37.7764649850887, -122.398758756879) | 14 | 2 | 9 | 28856 | 20 | |||
| 17243 | 218510 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 330 Lakeview Ave | 1 | : | Tree | Private 2 | 07/25/2000 12:00:00 AM | 7 | Width 3ft | Permit Number 43360 | 5996781.43157 | 2089689.53525 | 37.7177051527504 | -122.453110785357 | (37.7177051527504, -122.453110785357) | 9 | 8 | 6 | 28861 | 24 | |
| 17490 | 255503 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 335 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781972 | 5997864.63144 | 2093785.59571 | 37.729013998385 | -122.449661668302 | (37.729013998385, -122.449661668302) | 9 | 7 | 4 | 28861 | 40 |
| 17820 | 101211 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800X Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.388118852688 | (37.7611831239758, -122.388118852688) | 10 | 3 | 8 | 28856 | 29 | |||
| 18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 18527 | 217598 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1433 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 4 | Width 0ft | 5995477.9337 | 2092057.9786 | 37.7241335428618 | -122.457787649757 | (37.7241335428618, -122.457787649757) | 9 | 8 | 4 | 28861 | 24 | ||
| 18643 | 36313 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39291 | 5996172.05456486 | 2093809.43581436 | 37.7289824784834 | -122.455514723268 | (37.7289824784834, -122.455514723268) | 9 | 7 | 4 | 28861 | 40 | ||
| 19007 | 216971 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991715.0131 | 2104457.47271 | 37.7579624956851 | -122.471698563334 | (37.7579624956851, -122.471698563334) | 1 | 8 | 4 | 56 | 12 |
| 19722 | 28629 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1299 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | 3X3 | 5996025.31382 | 2091881.53932 | 37.7236805140054 | -122.455882701682 | (37.7236805140054, -122.455882701682) | 9 | 8 | 4 | 28861 | 24 | ||
| 19766 | 100334 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1X Gorham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x9 | 6002317.2 | 2094130.8 | 37.7302155808393 | -122.43429348768 | (37.7302155808393, -122.43429348768) | 9 | 7 | 5 | 28861 | 25 | ||||
| 20046 | 216968 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991682.07127 | 2104398.96183 | 37.7577999342364 | -122.471808224875 | (37.7577999342364, -122.471808224875) | 1 | 8 | 4 | 56 | 12 |
| 20053 | 88130 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 822 Duncan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51154 | 6001234 | 2099702 | 37.7454512540188 | -122.438437243524 | (37.7454512540188, -122.438437243524) | 2 | 4 | 5 | 63 | 22 | |||
| 20288 | 26672 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495X Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 8 | 3X3 | 5998682.3051661 | 2090785.318168 | 37.7208226804469 | -122.446619141783 | (37.7208226804469, -122.446619141783) | 9 | 7 | 6 | 28861 | 25 | |||
| 20387 | 40292 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3695X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41437 | 6005149.32455817 | 2101953.724968 | 37.7518559035882 | -122.425058847152 | (37.7518559035882, -122.425058847152) | 2 | 4 | 5 | 28859 | 19 | ||
| 20403 | 217605 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 4 | Width 0ft | 5996058.7204 | 2091888.0044 | 37.7237001828408 | -122.455767688681 | (37.7237001828408, -122.455767688681) | 9 | 8 | 4 | 28861 | 24 | ||
| 20409 | 34062 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1960 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37964 | 6008029.26997895 | 2107027.39297988 | 37.7659492963405 | -122.415458730511 | (37.7659492963405, -122.415458730511) | 8 | 4 | 7 | 28853 | 19 | ||
| 21046 | 95730 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 207 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767476 | 6004003.2 | 2092421.6 | 37.7256180518537 | -122.428342990208 | (37.7256180518537, -122.428342990208) | 9 | 7 | 6 | 28861 | 5 | |
| 21110 | 87947 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 145 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50970 | 6000915.1 | 2105542.6 | 37.7614699863558 | -122.439958652567 | (37.7614699863558, -122.439958652567) | 15 | 5 | 5 | 28862 | 3 | ||
| 21609 | 75037 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1695 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51135 | 5988394.66653183 | 2103793.82497453 | 37.755947632918 | -122.483132944316 | (37.755947632918, -122.483132944316) | 1 | 8 | 3 | 56 | 35 | ||
| 21713 | 88316 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093 | 37.7219225920035 | -122.431143024225 | (37.7219225920035, -122.431143024225) | 9 | 7 | 6 | 28861 | 5 | |||
| 21800 | 49894 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 38 Samoset St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/2012 12:00:00 AM | Permit Number 769410 | 6009978.40832944 | 2099202.86648775 | 37.7445742579885 | -122.408165137802 | (37.7445742579885, -122.408165137802) | 2 | 7 | 7 | 28859 | 2 | ||
| 21946 | 104709 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 375X Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | Permit Number 769024 | 6011230.99687 | 2113233.86621 | 37.7831702808186 | -122.404821553875 | (37.7831702808186, -122.404821553875) | 12 | 2 | 9 | 28853 | 34 | |||
| 22046 | 35863 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 827 Vienna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1998 12:00:00 AM | Permit Number 39077 | 6002288.79188076 | 2088794.75109809 | 37.7155623744331 | -122.434010413526 | (37.7155623744331, -122.434010413526) | 9 | 7 | 6 | 28861 | 5 | |||
| 22494 | 32586 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1495 33rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | Permit Number 37056 | 5985867.67151542 | 2105066.25689491 | 37.7592940037764 | -122.49196567934 | (37.7592940037764, -122.49196567934) | 1 | 8 | 3 | 56 | 35 | ||
| 22771 | 36260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 30 Elmhurst Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1998 12:00:00 AM | Permit Number 39271 | 5991253.03942343 | 2094450.93126102 | 37.730460371115 | -122.472566711187 | (37.730460371115, -122.472566711187) | 9 | 8 | 4 | 64 | 40 | ||
| 22950 | 116203 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
| 23109 | 217611 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 4 | Width 0ft | 5996185.5817 | 2091853.3157 | 37.7236122156709 | -122.455326647671 | (37.7236122156709, -122.455326647671) | 9 | 8 | 4 | 28861 | 24 | ||
| 23214 | 84608 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50841 | 6005059.05085072 | 2120549.16999723 | 37.8029093444786 | -122.426695114755 | (37.8029093444786, -122.426695114755) | 13 | 9 | 1 | 57 | 17 | ||
| 23278 | 88325 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 346 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623 | 2091442 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | 9 | 7 | 6 | 28861 | 5 | |||
| 23436 | 82875 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Girard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52475 | 6010457.79461314 | 2094219.31159395 | 37.730917314013 | -122.406156470326 | (37.730917314013, -122.406156470326) | 10 | 3 | 7 | 309 | 28 | ||
| 23831 | 34208 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 615 Edinburg St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1997 12:00:00 AM | Permit Number 38025 | 6002522.9923571 | 2090183.36055345 | 37.719388477306 | -122.433300078328 | (37.719388477306, -122.433300078328) | 9 | 7 | 6 | 28861 | 5 | |||
| 23904 | 88195 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 443 Tehama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51199 | 6011062 | 2112189 | 37.7802918756168 | -122.405332612017 | (37.7802918756168, -122.405332612017) | 14 | 2 | 9 | 28853 | 34 | |||
| 23964 | 51424 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 33 McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | Permit Number 47746 | 6006388.07711494 | 2109118.29405382 | 37.7715980307524 | -122.421283782095 | (37.7715980307524, -122.421283782095) | 8 | 2 | 9 | 28853 | 19 | |||
| 24013 | 67828 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 710 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | 3x3 | Permit Number 31489 | 5999080 | 2108181 | 37.768609734872 | -122.446495301803 | (37.768609734872, -122.446495301803) | 15 | 5 | 11 | 29492 | 9 | ||
| 24158 | 106174 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1500 Van Ness Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.421653930851 | (37.7898405898041, -122.421653930851) | 13 | 9 | 10 | 28858 | 21 | ||||
| 24202 | 54896 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 168 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1972 12:00:00 AM | 3x3 | Permit Number 10761 | 5997518.11388038 | 2107130.00064711 | 37.7656346240705 | -122.451821882169 | (37.7656346240705, -122.451821882169) | 15 | 5 | 11 | 29492 | 9 | ||
| 24203 | 88677 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 601 25th St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
| 24246 | 26260 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1550 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2003 12:00:00 AM | 16 | 3X3 | 6005878.3965356 | 2099932.1533401 | 37.746346288341 | -122.422393986743 | (37.746346288341, -122.422393986743) | 2 | 7 | 5 | 28859 | 22 | ||
| 24253 | 86716 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 396 Capp St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2007 12:00:00 AM | Permit Number 49702 | 6007196 | 2105003 | 37.7603439142388 | -122.418197308773 | (37.7603439142388, -122.418197308773) | 2 | 4 | 7 | 28859 | 19 | ||||
| 24258 | 36324 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 243 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39297 | 5996005.37027262 | 2094359.08502134 | 37.7304821167644 | -122.456130683218 | (37.7304821167644, -122.456130683218) | 9 | 7 | 4 | 28861 | 40 | ||
| 24611 | 217610 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2003 12:00:00 AM | 3 | Width 0ft | 5996168.7329 | 2091856.7846 | 37.7236207736962 | -122.455385141266 | (37.7236207736962, -122.455385141266) | 9 | 8 | 4 | 28861 | 24 | ||
| 24633 | 116207 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3773 Sacramento St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5996831.55660521 | 2114970.89612566 | 37.787124327035 | -122.454763067438 | (37.787124327035, -122.454763067438) | 11 | 6 | 1 | 54 | 31 | ||||
| 24734 | 136867 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 800 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2014 12:00:00 AM | 7 | Width 4ft | Permit Number 773338 | 6006067.02029 | 2112827.44756 | 37.7817643621779 | -122.42265796469 | (37.7817643621779, -122.42265796469) | 7 | 9 | 11 | 28852 | 41 | |
| 25230 | 107929 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 495 09th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 774012 | 5993087.78951 | 2112168.62834 | 37.7792146104853 | -122.467511711649 | (37.7792146104853, -122.467511711649) | 11 | 6 | 2 | 54 | 11 | ||
| 25625 | 15936 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5810X MISSION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 5997175 | 2086632 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | 9 | 7 | 6 | 28861 | 25 | |||
| 25698 | 105278 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 568-570 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6x9 | Permit Number 771026 | 6002982 | 2104934 | 37.7599163606325 | -122.432766629071 | (37.7599163606325, -122.432766629071) | 2 | 4 | 5 | 28862 | 3 | ||
| 26134 | 22497 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6325 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/1993 12:00:00 AM | 6 | 3x3 | 6013219.52561 | 2090374.53789 | 37.7205144342923 | -122.396339265181 | (37.7205144342923, -122.396339265181) | 10 | 3 | 8 | 58 | 1 | ||
| 26142 | 95527 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2320 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767318 | 5986850 | 2102357 | 37.7519124926116 | -122.488369249357 | (37.7519124926116, -122.488369249357) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );