trees
508 rows where qSpecies_id = 25
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25511 | 94960 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 20 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998206 | 2108519 | 37.7694878371786 | -122.449542741076 | (37.7694878371786, -122.449542741076) | 15 | 5 | 11 | 29492 | 9 | ||||
| 27196 | 225957 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 38 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007027 | 2096768 | 37.7377229562927 | -122.418197948284 | (37.7377229562927, -122.418197948284) | 2 | 7 | 7 | 28859 | 2 | |||
| 27374 | 176498 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 144 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005795.48549 | 2087494.48765 | 37.7121905153633 | -122.421797376475 | (37.7121905153633, -122.421797376475) | 9 | 7 | 8 | 309 | 18 | |||
| 27739 | 49765 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 333 Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 5 | Permit Number 46559 | 6008653.27394 | 2086377.17589 | 37.7092833534188 | -122.411841080097 | (37.7092833534188, -122.411841080097) | 9 | 7 | 8 | 309 | 39 | |
| 27755 | 82843 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 719 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52435 | 6009401.3474 | 2110338.98679 | 37.7751191888227 | -122.410946896775 | (37.7751191888227, -122.410946896775) | 8 | 2 | 9 | 28853 | 34 | |
| 27821 | 29763 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 530 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6008751.4918274 | 2121120.9717011 | 37.8046874335197 | -122.41395779393 | (37.8046874335197, -122.41395779393) | 3 | 1 | 10 | 308 | 23 | |||
| 28119 | 36065 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 28366 | 36001 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39150 | 6007547.55752373 | 2100224.75713647 | 37.7472437298861 | -122.41664293336 | (37.7472437298861, -122.41664293336) | 2 | 7 | 7 | 28859 | 2 | ||
| 28535 | 41155 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 21 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1999 12:00:00 AM | Permit Number 41884 | 5997452.09163541 | 2113544.02640038 | 37.7832420947214 | -122.452513152989 | (37.7832420947214, -122.452513152989) | 15 | 6 | 1 | 54 | 31 | |||
| 29333 | 225916 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005165.83624 | 2104308.70302 | 37.7583230563848 | -122.425169300823 | (37.7583230563848, -122.425169300823) | 2 | 4 | 5 | 28859 | 19 | |||
| 29499 | 244210 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003934.6479 | 2109752.6175 | 37.7732011032912 | -122.429815586143 | (37.7732011032912, -122.429815586143) | 7 | 9 | 11 | 29492 | 10 | |||
| 29569 | 105213 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 2400X 21ST AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 5989837 | 2098691 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | 1 | 8 | 3 | 29491 | 35 | |||
| 30350 | 225979 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 171 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003500.9012 | 2108793.5344 | 37.7705431243846 | -122.431247500167 | (37.7705431243846, -122.431247500167) | 15 | 9 | 11 | 29492 | 10 | |||
| 30403 | 32983 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | ||
| 30741 | 176516 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6006459.4617 | 2087377.28485 | 37.7119061227438 | -122.419494165041 | (37.7119061227438, -122.419494165041) | 9 | 7 | 8 | 309 | 39 | |||
| 30868 | 95394 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 208 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767264 | 6004579 | 2098715 | 37.7429308791836 | -122.426800483584 | (37.7429308791836, -122.426800483584) | 2 | 7 | 5 | 63 | 22 | |
| 31110 | 48958 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1521 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | 2 | 7 | 7 | 28859 | 2 | |||
| 31262 | 69447 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 479 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33557 | 5985917.32246977 | 2112668.61009419 | 37.7801708274431 | -122.492353790965 | (37.7801708274431, -122.492353790965) | 11 | 6 | 2 | 55 | 26 | ||
| 31931 | 219011 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995317.53334 | 2090902.82075 | 37.7209525389978 | -122.458258556883 | (37.7209525389978, -122.458258556883) | 9 | 8 | 6 | 28861 | 24 | |||
| 32183 | 225901 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005825.23106 | 2106352.45228 | 37.7639719400684 | -122.423034081872 | (37.7639719400684, -122.423034081872) | 8 | 4 | 5 | 28859 | 19 | |||
| 32236 | 32806 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1686 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943365 | (37.7742503589901, -122.44417943365) | 15 | 5 | 11 | 29492 | 16 | ||
| 32550 | 59941 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1706 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1981 12:00:00 AM | 0 | Permit Number 19415 | 5999632.27517388 | 2110547.02087839 | 37.7751377580465 | -122.444755123369 | (37.7751377580465, -122.444755123369) | 15 | 5 | 11 | 29492 | 16 | |
| 33078 | 52211 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3778 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48395 | 6005137.28408737 | 2104311.29818782 | 37.758328569096 | -122.425268231472 | (37.758328569096, -122.425268231472) | 2 | 4 | 5 | 28859 | 19 | ||
| 33525 | 67084 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30482 | 6007092.73898781 | 2097018.14574656 | 37.738413501248 | -122.417988384197 | (37.738413501248, -122.417988384197) | 2 | 7 | 7 | 28859 | 2 | ||
| 33588 | 192415 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1400 20th St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6013731.20085 | 2104795.92406 | 37.7601410116297 | -122.39558042201 | (37.7601410116297, -122.39558042201) | 10 | 3 | 8 | 28856 | 29 | |||
| 34506 | 128874 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1270 Clay St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.414254814618 | (37.7933104368651, -122.414254814618) | 5 | 1 | 10 | 28857 | 21 | |||
| 34641 | 108168 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009949 | 2099997 | 37.74675312806 | -122.40832282803 | (37.74675312806, -122.40832282803) | 2 | 7 | 7 | 28859 | 2 | ||||
| 35443 | 73660 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 157 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2013 12:00:00 AM | 15 | Permit Number 770522 | 5995314.7940966 | 2090940.29616255 | 37.7210552801536 | -122.458270736601 | (37.7210552801536, -122.458270736601) | 9 | 8 | 6 | 28861 | 24 | ||
| 35598 | 102652 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 203X Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994989.5 | 2088377.3 | 37.7139992025898 | -122.459209674514 | (37.7139992025898, -122.459209674514) | 9 | 8 | 6 | 28861 | 24 | |||||
| 35833 | 142337 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 500 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999743.369 | 2110239.8651 | 37.774300725553 | -122.44434874809 | (37.774300725553, -122.44434874809) | 15 | 5 | 11 | 29492 | 16 | |||
| 35950 | 10087 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 673 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 6005642.33302 | 2105078.49447 | 37.7604636299235 | -122.423576092482 | (37.7604636299235, -122.423576092482) | 2 | 4 | 5 | 28859 | 19 | |||
| 37150 | 176505 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 178 Brookdale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005616.04698 | 2087112.68704 | 37.7111320510829 | -122.422390458676 | (37.7111320510829, -122.422390458676) | 9 | 7 | 8 | 309 | 18 | |||
| 37585 | 105310 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 355 17TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3 x4 | 5990544.7 | 2113008.3 | 37.781372965217 | -122.476370566984 | (37.781372965217, -122.476370566984) | 11 | 6 | 2 | 55 | 26 | |||
| 38044 | 255484 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2147 Beach St | : | Tree | Private 2 | FUF | 05/30/2018 12:00:00 AM | 3 | Permit Number 781954 | 5999947.25363 | 2120887.03087 | 37.8035466909489 | -122.444408807729 | (37.8035466909489, -122.444408807729) | 13 | 9 | 1 | 57 | 17 | ||
| 38084 | 10079 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 614 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6005561.0033 | 2105378.47551 | 37.7612827162343 | -122.423878706238 | (37.7612827162343, -122.423878706238) | 2 | 4 | 5 | 28859 | 19 | |||
| 38898 | 225905 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3620 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006092.03845 | 2100850.85024 | 37.7488808700704 | -122.421720479039 | (37.7488808700704, -122.421720479039) | 2 | 4 | 5 | 28859 | 19 | |||
| 39253 | 66067 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1425 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 12 | Permit Number 29107 | 6013650.29046 | 2104740.70593 | 37.7599848938155 | -122.395856385278 | (37.7599848938155, -122.395856385278) | 10 | 3 | 8 | 28856 | 29 | |
| 40018 | 105804 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 117 ALPINE TER | 1 | Front Yard : Cutout | Tree | Private 2 | 04/10/2014 12:00:00 AM | 14 | 3x3 | Permit Number 772090 | 6001724.2 | 2108149.5 | 37.7686739192463 | -122.437346990121 | (37.7686739192463, -122.437346990121) | 15 | 5 | 5 | 29492 | 3 | |
| 40331 | 45143 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1306 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43999 | 6000301.66695276 | 2109252.99284462 | 37.7716228610878 | -122.442346636259 | (37.7716228610878, -122.442346636259) | 15 | 5 | 11 | 29492 | 9 | ||
| 40615 | 225925 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 357 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004205.07883 | 2098948.09387 | 37.7435497528103 | -122.428110007472 | (37.7435497528103, -122.428110007472) | 2 | 7 | 5 | 63 | 22 | |||
| 40882 | 219016 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 23 Gaviota Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998493.11217 | 2097521.42795 | 37.7393076426268 | -122.447757806504 | (37.7393076426268, -122.447757806504) | 9 | 7 | 4 | 59 | 40 | |||
| 40896 | 247270 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1520 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999196.9373 | 2109093.7955 | 37.7711227186713 | -122.446156493551 | (37.7711227186713, -122.446156493551) | 15 | 5 | 11 | 29492 | 9 | |||
| 41440 | 10174 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1038 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 2x2 | 6005692.3267338 | 2102916.9952862 | 37.7545314795937 | -122.423249534916 | (37.7545314795937, -122.423249534916) | 2 | 4 | 5 | 28859 | 19 | |||
| 41477 | 34073 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 2055 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37966 | 6008112.18575803 | 2106463.32400128 | 37.764405154005 | -122.415132009891 | (37.764405154005, -122.415132009891) | 8 | 4 | 7 | 28859 | 19 | ||
| 41661 | 49835 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 587 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 11 | Permit Number 46618 | 6014427.95757 | 2104386.86383 | 37.7590565524297 | -122.393142029905 | (37.7590565524297, -122.393142029905) | 10 | 3 | 8 | 28856 | 29 | |
| 41836 | 32486 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 212 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | Permit Number 36993 | 6000839.7187841 | 2106514.92813142 | 37.7641354685469 | -122.440289096409 | (37.7641354685469, -122.440289096409) | 15 | 5 | 5 | 28862 | 3 | ||
| 42046 | 51909 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 490X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48114 | 6002971.47862471 | 2105361.83743697 | 37.7610905025589 | -122.432833581883 | (37.7610905025589, -122.432833581883) | 15 | 4 | 5 | 28862 | 3 | |
| 42236 | 66180 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1409 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1990 12:00:00 AM | 12 | Permit Number 29257 | 6013724.4666 | 2104745.52937 | 37.7600022642143 | -122.395600181905 | (37.7600022642143, -122.395600181905) | 10 | 3 | 8 | 28856 | 29 | |
| 42399 | 7700 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.8044437236489 | -122.415905321467 | (37.8044437236489, -122.415905321467) | 5 | 1 | 10 | 308 | 23 | |||
| 42562 | 192418 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 2 | : | Tree | Private 2 | 9 | Width 5ft | 6013740.02795 | 2104156.22974 | 37.7583850412574 | -122.395505075892 | (37.7583850412574, -122.395505075892) | 10 | 3 | 8 | 28856 | 29 | |||
| 43247 | 35398 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 540 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38853 | 6003072.48314636 | 2098933.73753739 | 37.743446188104 | -122.43202521517 | (37.743446188104, -122.43202521517) | 2 | 7 | 5 | 63 | 22 | ||
| 43636 | 94704 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 670 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53844 | 5992265.91007 | 2110887.94739 | 37.7756507238334 | -122.470261618584 | (37.7756507238334, -122.470261618584) | 11 | 6 | 2 | 54 | 11 |
| 43646 | 176517 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 49 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6006489.32827 | 2087380.0454 | 37.7119153848503 | -122.419391133293 | (37.7119153848503, -122.419391133293) | 9 | 7 | 8 | 309 | 39 | |||
| 43773 | 21413 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | ||||
| 44035 | 117516 | Undocumented 4 | Geijera parviflora :: Australian Willow 25 | 1115 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010054 | 2102576 | 37.7538403715297 | -122.408141603779 | (37.7538403715297, -122.408141603779) | 2 | 4 | 7 | 28859 | 19 | |||
| 44550 | 192417 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 1 | : | Tree | Private 2 | 11 | Width 5ft | 6013758.38911 | 2104156.54332 | 37.7583869235411 | -122.395441596376 | (37.7583869235411, -122.395441596376) | 10 | 3 | 8 | 28856 | 29 | |||
| 44632 | 36064 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1398 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394 | 2107812 | 37.7681802592774 | -122.410793808029 | (37.7681802592774, -122.410793808029) | 8 | 4 | 7 | 28853 | 19 | |||
| 44918 | 67927 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31640 | 6003789.22877148 | 2095116.32621568 | 37.7330050563948 | -122.429274738173 | (37.7330050563948, -122.429274738173) | 9 | 7 | 5 | 28861 | 25 | ||
| 45175 | 225948 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 123 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6003779.75499 | 2095097.51754 | 37.7329528756765 | -122.429306150766 | (37.7329528756765, -122.429306150766) | 9 | 7 | 5 | 28861 | 25 | |||
| 45794 | 108472 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 462 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773779 | 5993142.3505 | 2112335.01081 | 37.7796746015568 | -122.467335065866 | (37.7796746015568, -122.467335065866) | 11 | 6 | 2 | 54 | 11 | |||
| 45964 | 67574 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 601 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 13 | Permit Number 31129 | 6013300.57075 | 2104280.61777 | 37.7587021305084 | -122.397033645504 | (37.7587021305084, -122.397033645504) | 10 | 3 | 8 | 28856 | 29 | |
| 46410 | 6257 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1324X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004503.4535 | 2113305.70612 | 37.782989203891 | -122.428101266861 | (37.782989203891, -122.428101266861) | 7 | 9 | 11 | 29490 | 41 | |||
| 46773 | 10037 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x2 | 6005536.77146 | 2106975.88456 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | 8 | 4 | 5 | 28853 | 19 | |||
| 46881 | 128878 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | 5 | 9 | 1 | 28858 | 32 | |||
| 47126 | 60044 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 126 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2008 12:00:00 AM | 3x3 | Permit Number 51412 | 6004702.07588502 | 2097279.21146554 | 37.7389954885734 | -122.426272720335 | (37.7389954885734, -122.426272720335) | 2 | 7 | 5 | 63 | 7 | ||
| 47916 | 128869 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6001642.59008 | 2116017.92803 | 37.7902739929064 | -122.438193013824 | (37.7902739929064, -122.438193013824) | 13 | 6 | 1 | 29490 | 27 | |||
| 48618 | 142233 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004546.0223 | 2110772.1475 | 37.7760350855974 | -122.427773417679 | (37.7760350855974, -122.427773417679) | 7 | 9 | 11 | 28852 | 10 | |||
| 49249 | 176502 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005669.88649 | 2087297.20509 | 37.7116417355373 | -122.42221747678 | (37.7116417355373, -122.42221747678) | 9 | 7 | 8 | 309 | 18 | |||
| 49712 | 47473 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2713 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45374 | 6001758.37714 | 2115982.95149 | 37.7901845409254 | -122.437789893616 | (37.7901845409254, -122.437789893616) | 13 | 6 | 1 | 29490 | 27 | |
| 49729 | 192424 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6012214.21558 | 2107593.00345 | 37.767736670334 | -122.401023519214 | (37.767736670334, -122.401023519214) | 14 | 3 | 8 | 28856 | 20 | |||
| 50638 | 192419 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2 Sierra St | 3 | : | Tree | Private 2 | 8 | Width 5ft | 6013725.78081 | 2104155.14731 | 37.7583812766799 | -122.395554273333 | (37.7583812766799, -122.395554273333) | 10 | 3 | 8 | 28856 | 29 | |||
| 50698 | 66557 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 3772 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/10/1991 12:00:00 AM | Permit Number 29741 | 6005175.23956871 | 2104313.40408574 | 37.7583364956152 | -122.425137114448 | (37.7583364956152, -122.425137114448) | 2 | 4 | 5 | 28859 | 19 | ||
| 50795 | 225950 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 646 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001193.5542 | 2102647.97152 | 37.7535378869843 | -122.438788164466 | (37.7535378869843, -122.438788164466) | 2 | 4 | 5 | 28862 | 22 | |||
| 51015 | 225924 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 145 Guerrero St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6005469.65475 | 2108205.80814 | 37.7690407421536 | -122.424395748072 | (37.7690407421536, -122.424395748072) | 8 | 4 | 5 | 28853 | 19 | |||
| 51655 | 225914 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 611 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009855.21876 | 2105398.04081 | 37.7615779286091 | -122.409028144648 | (37.7615779286091, -122.409028144648) | 2 | 4 | 8 | 28859 | 19 | |||
| 51882 | 32986 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
| 52069 | 60140 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 1807 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19670 | 5991211.56683637 | 2103102.96288703 | 37.7542142276367 | -122.473340885597 | (37.7542142276367, -122.473340885597) | 1 | 8 | 4 | 56 | 12 | ||
| 52646 | 59406 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 31 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 770712 | 6003751.60013387 | 2095492.67978387 | 37.7340363078834 | -122.42943165971 | (37.7340363078834, -122.42943165971) | 2 | 7 | 5 | 28861 | 25 | ||
| 52777 | 225919 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1683 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009340.70254 | 2099660.44823 | 37.745794948977 | -122.410402509267 | (37.745794948977, -122.410402509267) | 2 | 7 | 7 | 28859 | 2 | |||
| 53060 | 128866 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2610 Clay St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001800.9878 | 2116040.20004 | 37.7903441535036 | -122.43764656594 | (37.7903441535036, -122.43764656594) | 13 | 6 | 1 | 29490 | 27 | |||
| 53260 | 10131 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 899 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005716.19449 | 2103799.35315 | 37.7569555760466 | -122.423229711377 | (37.7569555760466, -122.423229711377) | 2 | 4 | 5 | 28859 | 19 | ||
| 53315 | 34425 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 245 Roanoke St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2008 12:00:00 AM | 3x3 | Permit Number 50336 | 6003617.84008567 | 2095979.02625995 | 37.7353641309188 | -122.429928789613 | (37.7353641309188, -122.429928789613) | 2 | 7 | 5 | 63 | 7 | ||
| 53663 | 142232 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 600 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004552.0651 | 2110734.2793 | 37.7759314506272 | -122.427749815271 | (37.7759314506272, -122.427749815271) | 7 | 9 | 11 | 28852 | 10 | |||
| 55179 | 176501 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 170 Brookdale Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6005674.86736 | 2087315.91925 | 37.7116934016018 | -122.422201590246 | (37.7116934016018, -122.422201590246) | 9 | 7 | 8 | 309 | 18 | |||
| 55201 | 113388 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5994493 | 2100782 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | 1 | 8 | 4 | 29491 | 40 | ||||
| 55349 | 115881 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1663 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015043.9945 | 2096491.09601 | 37.737410632491 | -122.390459765022 | (37.737410632491, -122.390459765022) | 10 | 3 | 8 | 58 | 1 | ||
| 55505 | 225970 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 2846 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | 6009214.74518 | 2103362.9385 | 37.7559541000213 | -122.411099534231 | (37.7559541000213, -122.411099534231) | 2 | 4 | 7 | 28859 | 19 | |||
| 57051 | 225959 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 20 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2005 12:00:00 AM | 12 | Width 3ft | Permit Number 48238 | 6006979.14621 | 2096796.63822 | 37.7377988968125 | -122.418365432231 | (37.7377988968125, -122.418365432231) | 2 | 7 | 7 | 28859 | 2 | |
| 57319 | 65448 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 72 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/1989 12:00:00 AM | 9 | Permit Number 28322 | 5994279.76671 | 2115099.74179 | 37.7873314010144 | -122.463600988074 | (37.7873314010144, -122.463600988074) | 11 | 6 | 1 | 54 | 11 | ||
| 57421 | 32985 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 10X Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | 10 | 3 | 8 | 28856 | 29 | |
| 58299 | 225971 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3446 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006565.68979 | 2104973.14116 | 37.7602264301236 | -122.420375142719 | (37.7602264301236, -122.420375142719) | 2 | 4 | 7 | 28859 | 19 | |||
| 58362 | 142702 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 520 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008814.8812 | 2121126.1728 | 37.8047052743397 | -122.413738796098 | (37.8047052743397, -122.413738796098) | 3 | 1 | 10 | 308 | 23 | |||
| 58513 | 102247 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 337 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5x9 | 6014078.6922 | 2105447.06495 | 37.7619482253485 | -122.394424198727 | (37.7619482253485, -122.394424198727) | 10 | 3 | 8 | 28856 | 29 | |||
| 59021 | 221893 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.7510043375848 | -122.413092739446 | (37.7510043375848, -122.413092739446) | 2 | 4 | 7 | 28859 | 19 | |||
| 60037 | 93902 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 546 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2011 12:00:00 AM | 3x3 | Permit Number 768056 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||
| 60771 | 36002 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 183 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39151 | 6007567.43623945 | 2100291.02417946 | 37.747426802297 | -122.416578887563 | (37.747426802297, -122.416578887563) | 2 | 7 | 7 | 28859 | 2 | ||
| 61119 | 225949 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 119 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003777.8476 | 2095128.93714 | 37.7330390388203 | -122.429314984812 | (37.7330390388203, -122.429314984812) | 9 | 7 | 5 | 28861 | 25 | |||
| 62095 | 176509 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 127 Brookdale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6006088.90588 | 2087444.93251 | 37.7120709900614 | -122.420779711712 | (37.7120709900614, -122.420779711712) | 9 | 7 | 8 | 309 | 39 | |||
| 62340 | 95571 | Permitted Site 7 | Geijera parviflora :: Australian Willow 25 | 960 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767362 | 6003109 | 2102648 | 37.7536467518763 | -122.432164143819 | (37.7536467518763, -122.432164143819) | 2 | 4 | 5 | 28862 | 22 | |
| 63017 | 176519 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 1501 Sunnydale Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007411.664 | 2087356.69589 | 37.7119031774593 | -122.416201620236 | (37.7119031774593, -122.416201620236) | 9 | 7 | 8 | 309 | 39 |
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) );