trees
1,650 rows where qSpecies_id = 64 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646 | 19899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
| 3410 | 47847 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
| 3460 | 20048 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
| 4272 | 47849 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
| 8350 | 47846 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
| 8653 | 254419 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 3400X Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781063 | ||||||||||
| 9818 | 47845 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
| 15628 | 47848 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
| 15929 | 20047 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
| 16797 | 47844 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
| 1650 | 126124 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1055 Lombard St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6007293.98833 | 2120181.06921 | 37.8020247344007 | -122.418934936917 | (37.8020247344007, -122.418934936917) | 5 | 1 | 1 | 28858 | 32 | |||
| 24296 | 33072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1360 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37332 | 6011469.86115 | 2119995.38405 | 37.8017491407824 | -122.404471277147 | (37.8017491407824, -122.404471277147) | 3 | 1 | 10 | 308 | 23 | ||
| 59793 | 126128 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 10 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6008577.74955 | 2119176.39981 | 37.7993383659246 | -122.414421369076 | (37.7993383659246, -122.414421369076) | 5 | 1 | 10 | 308 | 32 | ||||
| 75106 | 126130 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 416 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6011413.17595 | 2119059.85446 | 37.7991772361891 | -122.40460154034 | (37.7991772361891, -122.40460154034) | 3 | 1 | 10 | 308 | 23 | |||
| 94701 | 126127 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 956 Vallejo St | 2 | Front Yard : Yard | Tree | Private 2 | 57 | 6008898.21639 | 2118715.71766 | 37.7980914442296 | -122.41327984251 | (37.7980914442296, -122.41327984251) | 3 | 1 | 10 | 308 | 21 | ||||
| 95997 | 249767 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 266 Lombard St | 3 | Front Yard : Yard | Tree | Private 2 | 45 | Width 0ft | 6010996.51868 | 2120736.58117 | 37.8037578224149 | -122.406161518736 | (37.8037578224149, -122.406161518736) | 3 | 1 | 10 | 308 | 23 | |||
| 97235 | 249765 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 266 Lombard St | 1 | Front Yard : Yard | Tree | Private 2 | 53 | Width 0ft | 6010998.40684 | 2120702.14433 | 37.8036633729317 | -122.406152556991 | (37.8036633729317, -122.406152556991) | 3 | 1 | 10 | 308 | 23 | |||
| 108603 | 126115 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5 Fallon Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6008854.23541 | 2118561.36121 | 37.797665150274 | -122.413421108023 | (37.797665150274, -122.413421108023) | 3 | 1 | 10 | 308 | 21 | |||
| 108639 | 126114 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 20 Reed St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6008207.05335 | 2117051.51427 | 37.7934831255889 | -122.415553587621 | (37.7934831255889, -122.415553587621) | 5 | 1 | 10 | 28858 | 21 | ||||
| 112752 | 126126 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 39 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 6007489.31877 | 2119355.11229 | 37.7997678614442 | -122.418200406634 | (37.7997678614442, -122.418200406634) | 5 | 1 | 1 | 28858 | 32 | |||
| 117644 | 126125 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1055 Lombard St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 5ft | 6007295.75973 | 2120178.53611 | 37.8020178788931 | -122.418928627254 | (37.8020178788931, -122.418928627254) | 5 | 1 | 1 | 28858 | 32 | |||
| 118002 | 126101 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4 Kimball Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008010.07653 | 2116418.05756 | 37.7917327355326 | -122.416190259997 | (37.7917327355326, -122.416190259997) | 5 | 1 | 10 | 28858 | 21 | |||
| 124263 | 249973 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 23 Napier Ln | 1 | Front Yard : Yard | Tree | Private 2 | 18 | Width 0ft | 6011640.89127 | 2120262.65175 | 37.8024925491592 | -122.403898248899 | (37.8024925491592, -122.403898248899) | 3 | 1 | 10 | 308 | 23 | |||
| 144831 | 249971 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 52 | Width 0ft | 6011749.26924 | 2120132.42748 | 37.8021410392439 | -122.403514037858 | (37.8021410392439, -122.403514037858) | 3 | 1 | 10 | 308 | 23 | |||
| 155319 | 250206 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 212 Union St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6011790.69838 | 2119796.4125 | 37.8012207378093 | -122.40334702027 | (37.8012207378093, -122.40334702027) | 3 | 1 | 10 | 308 | 23 | |||
| 161134 | 249996 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 41 Darrell Pl | 2 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011497.53106 | 2120284.14207 | 37.8025435461134 | -122.404395862681 | (37.8025435461134, -122.404395862681) | 3 | 1 | 10 | 308 | 23 | |||
| 164903 | 126100 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4 Kimball Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008010.60275 | 2116411.87051 | 37.7917157770027 | -122.416188000891 | (37.7917157770027, -122.416188000891) | 5 | 1 | 10 | 28858 | 21 | |||
| 165230 | 249766 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 266 Lombard St | 2 | Front Yard : Yard | Tree | Private 2 | 31 | Width 0ft | 6011007.58004 | 2120722.18976 | 37.80371892584 | -122.406122225582 | (37.80371892584, -122.406122225582) | 3 | 1 | 10 | 308 | 23 | |||
| 189785 | 249859 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 235 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011602.10875 | 2120412.3489 | 37.8029014142335 | -122.404042997489 | (37.8029014142335, -122.404042997489) | 3 | 1 | 10 | 308 | 23 | |||
| 183225 | 189281 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 975 Minna St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008056.3994 | 2110189.2113 | 37.7746324316857 | -122.415588777222 | (37.7746324316857, -122.415588777222) | 8 | 2 | 9 | 28853 | 34 | |||
| 137 | 189330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 23 | Median : Yard | Tree | DPW 1 | 15 | 6016163.75351 | 2096735.77367 | 37.7381445215441 | -122.386605256348 | (37.7381445215441, -122.386605256348) | 10 | 3 | 8 | 58 | 1 | ||||
| 1739 | 189348 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017793.1763 | 2096477.15047 | 37.7375244650907 | -122.380953492111 | (37.7375244650907, -122.380953492111) | 10 | 3 | 8 | 58 | 1 | |||
| 1960 | 189303 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013928.16034 | 2104751.39428 | 37.7600296962246 | -122.394896108974 | (37.7600296962246, -122.394896108974) | 10 | 3 | 8 | 28856 | 29 | |||
| 5453 | 189384 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017757.64488 | 2096623.78425 | 37.737925131039 | -122.381086534243 | (37.737925131039, -122.381086534243) | 10 | 3 | 8 | 58 | 1 | |||
| 10994 | 189372 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017835.15635 | 2096405.7352 | 37.7373306899522 | -122.380803382685 | (37.7373306899522, -122.380803382685) | 10 | 3 | 8 | 58 | 1 | |||
| 12123 | 189376 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017838.12886 | 2096499.84024 | 37.7375892477372 | -122.380799645108 | (37.7375892477372, -122.380799645108) | 10 | 3 | 8 | 58 | 1 | |||
| 13735 | 189282 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 17 | : Yard | Tree | Private 2 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | 10 | 3 | 8 | 28856 | 29 | ||||
| 13800 | 189286 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 70 | Front Yard : Yard | Tree | Private 2 | 3 | 6015368.15632 | 2102301.56591 | 37.7533829535663 | -122.389744698757 | (37.7533829535663, -122.389744698757) | 10 | 3 | 8 | 28856 | 29 | ||||
| 13936 | 189326 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 19 | Median : Yard | Tree | DPW 1 | 16 | 6016187.80706 | 2096717.46995 | 37.7380955948279 | -122.386520814503 | (37.7380955948279, -122.386520814503) | 10 | 3 | 8 | 58 | 1 | ||||
| 15027 | 189344 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017767.18086 | 2096543.26443 | 37.7377045660164 | -122.381047966792 | (37.7377045660164, -122.381047966792) | 10 | 3 | 8 | 58 | 1 | |||
| 15183 | 189306 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013832.17688 | 2104822.60916 | 37.7602198992576 | -122.395233060671 | (37.7602198992576, -122.395233060671) | 10 | 3 | 8 | 28856 | 29 | |||
| 17004 | 259318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 Wisconsin St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012713 | 2104246 | 37.7585743521834 | -122.399063317374 | (37.7585743521834, -122.399063317374) | 10 | 3 | 8 | 28856 | 29 | |||||
| 18677 | 189308 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1500 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6013530.98263 | 2103856.35073 | 37.7575500090417 | -122.396207035432 | (37.7575500090417, -122.396207035432) | 10 | 3 | 8 | 28856 | 29 | |||
| 19801 | 189390 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017676.30083 | 2096675.94876 | 37.7380638739522 | -122.38137140977 | (37.7380638739522, -122.38137140977) | 10 | 3 | 8 | 58 | 1 | |||
| 23277 | 189302 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013921.81731 | 2104751.14346 | 37.760028654829 | -122.394918029061 | (37.760028654829, -122.394918029061) | 10 | 3 | 8 | 28856 | 29 | |||
| 28673 | 189353 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017759.87057 | 2096360.05037 | 37.7372010931465 | -122.381060507862 | (37.7372010931465, -122.381060507862) | 10 | 3 | 8 | 58 | 1 | |||
| 37843 | 175909 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Nueva Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012814.5616 | 2086915.18102 | 37.7109931858583 | -122.397496617385 | (37.7109931858583, -122.397496617385) | 10 | 3 | 8 | 309 | 1 | |||
| 38452 | 189333 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 26 | Median : Yard | Tree | DPW 1 | 18 | 6016146.37557 | 2096749.3676 | 37.7381808856511 | -122.386666288817 | (37.7381808856511, -122.386666288817) | 10 | 3 | 8 | 58 | 1 | ||||
| 40739 | 189335 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 29 | Median : Yard | Tree | DPW 1 | 15 | 6016137.08007 | 2096756.05642 | 37.7381987371688 | -122.386698894633 | (37.7381987371688, -122.386698894633) | 10 | 3 | 8 | 58 | 1 | ||||
| 41722 | 189381 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017800.88124 | 2096579.49396 | 37.7378059052205 | -122.380933965155 | (37.7378059052205, -122.380933965155) | 10 | 3 | 8 | 58 | 1 | |||
| 42791 | 189300 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1345 20th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013904.84874 | 2104750.47011 | 37.7600258624144 | -122.394976668459 | (37.7600258624144, -122.394976668459) | 10 | 3 | 8 | 28856 | 29 | |||
| 44276 | 189389 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017682.88595 | 2096671.88866 | 37.7380530892708 | -122.381348359258 | (37.7380530892708, -122.381348359258) | 10 | 3 | 8 | 58 | 1 | |||
| 44839 | 175979 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 638 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6009368.17577 | 2092960.86405 | 37.7274008768318 | -122.409834679142 | (37.7274008768318, -122.409834679142) | 10 | 3 | 7 | 309 | 28 | |||
| 44940 | 49418 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 413@ 19th ST Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2003 12:00:00 AM | 5 | Permit Number 46364 | 6014094.43855 | 2105154.43805 | 37.7611456110148 | -122.394349248338 | (37.7611456110148, -122.394349248338) | 10 | 3 | 8 | 28856 | 29 | ||
| 45875 | 202071 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Gould St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012673.40671 | 2090736.38979 | 37.7214776018863 | -122.398252411218 | (37.7214776018863, -122.398252411218) | 10 | 3 | 8 | 58 | 1 | |||
| 46234 | 201493 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6018736.96879 | 2094929.02833 | 37.7333256725358 | -122.377582915835 | (37.7333256725358, -122.377582915835) | 10 | 3 | 8 | 58 | 1 | ||||
| 46426 | 29661 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 4 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
| 46489 | 43221 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 47 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 12 | Permit Number 43010 | 6008377.13505 | 2094049.0426 | 37.7303331919052 | -122.413337641019 | (37.7303331919052, -122.413337641019) | 9 | 3 | 7 | 309 | 28 | |
| 46882 | 189307 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1510x 22nd St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6013533.7803 | 2103828.56548 | 37.7574738724493 | -122.396195412608 | (37.7574738724493, -122.396195412608) | 10 | 3 | 8 | 28856 | 29 | |||
| 47870 | 189323 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 301x Cashmere St | 1 | Median : Yard | Tree | DPW 1 | 6 | 6016365.09613 | 2096197.70243 | 37.7366782309168 | -122.385871612795 | (37.7366782309168, -122.385871612795) | 10 | 3 | 8 | 58 | 1 | ||||
| 48440 | 189386 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017728.94519 | 2096639.35373 | 37.7379662974982 | -122.381186846422 | (37.7379662974982, -122.381186846422) | 10 | 3 | 8 | 58 | 1 | |||
| 48702 | 189322 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 31 | Median : Yard | Tree | DPW 1 | 2 | 6016409.15229 | 2096168.44158 | 37.736600324449 | -122.385717251362 | (37.736600324449, -122.385717251362) | 10 | 3 | 8 | 58 | 1 | ||||
| 49936 | 189354 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017754.93557 | 2096352.15892 | 37.7371791523904 | -122.381077022089 | (37.7371791523904, -122.381077022089) | 10 | 3 | 8 | 58 | 1 | |||
| 50934 | 189291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 31 | : Yard | Tree | Private 2 | 5 | 6014386.77773 | 2105894.38958 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | 14 | 3 | 8 | 28856 | 29 | ||||
| 51563 | 175974 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 569 Sweeny St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007998.20755 | 2094270.44936 | 37.7309198448607 | -122.414663311868 | (37.7309198448607, -122.414663311868) | 9 | 3 | 7 | 309 | 28 | |||
| 52466 | 189366 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017781.98855 | 2096299.50337 | 37.7370360639635 | -122.380979826963 | (37.7370360639635, -122.380979826963) | 10 | 3 | 8 | 58 | 1 | |||
| 52666 | 189345 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017780.12141 | 2096521.5523 | 37.7376456631085 | -122.381001715564 | (37.7376456631085, -122.381001715564) | 10 | 3 | 8 | 58 | 1 | |||
| 57494 | 189367 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017784.81791 | 2096314.09412 | 37.7370762834315 | -122.380971058572 | (37.7370762834315, -122.380971058572) | 10 | 3 | 8 | 58 | 1 | |||
| 59321 | 175910 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 256 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012412.28873 | 2087359.88016 | 37.7121918346656 | -122.398918168549 | (37.7121918346656, -122.398918168549) | 10 | 3 | 8 | 309 | 1 | |||
| 59726 | 189379 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017817.80282 | 2096554.03386 | 37.7377369308132 | -122.38087368899 | (37.7377369308132, -122.38087368899) | 10 | 3 | 8 | 58 | 1 | |||
| 64737 | 101784 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1017 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012216.2726 | 2103633.66044 | 37.7568653093127 | -122.400738217399 | (37.7568653093127, -122.400738217399) | 10 | 3 | 8 | 28856 | 29 | |||
| 65954 | 175978 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 185 Gaven St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6009545.28565 | 2095019.96322 | 37.7330646497202 | -122.409367659393 | (37.7330646497202, -122.409367659393) | 10 | 3 | 7 | 309 | 28 | |||
| 67804 | 189329 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 22 | Median : Yard | Tree | DPW 1 | 22 | 6016170.50674 | 2096734.91499 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) | 10 | 3 | 8 | 58 | 1 | ||||
| 68323 | 189358 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017825.61264 | 2096067.48761 | 37.736401402503 | -122.380812873212 | (37.736401402503, -122.380812873212) | 10 | 3 | 8 | 58 | 1 | |||
| 70216 | 175977 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1053 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | Width 6ft | 6007850.48463 | 2093695.04009 | 37.72933159448 | -122.41513330118 | (37.72933159448, -122.41513330118) | 9 | 3 | 7 | 309 | 28 | |||
| 70402 | 189371 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017827.39616 | 2096381.99519 | 37.7372650763112 | -122.380828563686 | (37.7372650763112, -122.380828563686) | 10 | 3 | 8 | 58 | 1 | |||
| 72134 | 189324 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 13 | Median : Yard | Tree | DPW 1 | 4 | 6016254.7178 | 2096666.03631 | 37.7379580722924 | -122.386285883701 | (37.7379580722924, -122.386285883701) | 10 | 3 | 8 | 58 | 1 | ||||
| 73136 | 189342 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017737.91821 | 2096573.15681 | 37.7377850292651 | -122.381151220665 | (37.7377850292651, -122.381151220665) | 10 | 3 | 8 | 58 | 1 | |||
| 73154 | 189297 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1458 Rhode Island St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 6011987.51457 | 2101577.28204 | 37.7512061823217 | -122.401384841636 | (37.7512061823217, -122.401384841636) | 10 | 3 | 8 | 28856 | 29 | |||
| 76388 | 189289 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 20 | : Yard | Tree | Private 2 | 10 | 6014461.84726 | 2105889.9963 | 37.7631857104708 | -122.393129998769 | (37.7631857104708, -122.393129998769) | 14 | 3 | 8 | 28856 | 29 | ||||
| 76547 | 189285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 64 | Front Yard : Yard | Tree | Private 2 | 3 | 6015362.87396 | 2102344.01113 | 37.7534992062408 | -122.389765930873 | (37.7534992062408, -122.389765930873) | 10 | 3 | 8 | 28856 | 29 | ||||
| 76937 | 189321 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 299x Cashmere St | 30 | Median : Yard | Tree | DPW 1 | 7 | 6016453.45941 | 2096140.51631 | 37.7365260988976 | -122.38556211562 | (37.7365260988976, -122.38556211562) | 10 | 3 | 8 | 58 | 1 | ||||
| 79813 | 189290 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 23 | : Yard | Tree | Private 2 | 5 | 6014424.75736 | 2105899.25329 | 37.7632090676603 | -122.393258929155 | (37.7632090676603, -122.393258929155) | 14 | 3 | 8 | 28856 | 29 | ||||
| 80298 | 189316 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1089 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6013485.95319 | 2089984.75612 | 37.7194589935203 | -122.395391011311 | (37.7194589935203, -122.395391011311) | 10 | 3 | 8 | 58 | 1 | ||||
| 80688 | 189369 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017814.97814 | 2096356.1819 | 37.7371935127733 | -122.380869704969 | (37.7371935127733, -122.380869704969) | 10 | 3 | 8 | 58 | 1 | |||
| 83280 | 175904 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Blanken Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012465.00059 | 2087095.54364 | 37.7114689560088 | -122.398717440763 | (37.7114689560088, -122.398717440763) | 10 | 3 | 8 | 309 | 1 | |||
| 83966 | 29660 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 3 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
| 84448 | 189370 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017823.73172 | 2096374.95367 | 37.737245539451 | -122.380840744109 | (37.737245539451, -122.380840744109) | 10 | 3 | 8 | 58 | 1 | |||
| 86494 | 202072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Gould St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012663.72375 | 2090703.30788 | 37.7213862262721 | -122.398283562861 | (37.7213862262721, -122.398283562861) | 10 | 3 | 8 | 58 | 1 | |||
| 86948 | 189373 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017841.36769 | 2096447.46788 | 37.7374456224015 | -122.380784807191 | (37.7374456224015, -122.380784807191) | 10 | 3 | 8 | 58 | 1 | |||
| 87273 | 201492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018741.78505 | 2094936.24141 | 37.7333457436025 | -122.377566764894 | (37.7333457436025, -122.377566764894) | 10 | 3 | 8 | 58 | 1 | ||||
| 88804 | 189332 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1427x Innes Ave | 25 | Median : Yard | Tree | DPW 1 | 5 | 6016155.51714 | 2096746.87389 | 37.7381745445247 | -122.386634507683 | (37.7381745445247, -122.386634507683) | 10 | 3 | 8 | 58 | 1 | ||||
| 89356 | 98812 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 290 Napoleon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6011936.39142 | 2099770.08858 | 37.7462411674082 | -122.401434638901 | (37.7462411674082, -122.401434638901) | 10 | 3 | 8 | 58 | 1 | |||
| 90586 | 189362 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017812.44528 | 2096136.32972 | 37.7365897025526 | -122.380863183095 | (37.7365897025526, -122.380863183095) | 10 | 3 | 8 | 58 | 1 | |||
| 90613 | 189341 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017727.65109 | 2096582.91421 | 37.7378112543843 | -122.381187397677 | (37.7378112543843, -122.381187397677) | 10 | 3 | 8 | 58 | 1 | |||
| 91754 | 189336 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017658.40577 | 2096642.73711 | 37.737971693433 | -122.381430973671 | (37.737971693433, -122.381430973671) | 10 | 3 | 8 | 58 | 1 | |||
| 92152 | 189388 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017704.60452 | 2096656.13327 | 37.7380110270928 | -122.381272171384 | (37.7380110270928, -122.381272171384) | 10 | 3 | 8 | 58 | 1 | |||
| 92797 | 29662 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198X Cashmere St | 5 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806342 | 37.7367893783748 | -122.386594949018 | (37.7367893783748, -122.386594949018) | 10 | 3 | 8 | 58 | 1 | ||
| 92831 | 29656 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 190X Cashmere St | 1 | Median : Cutout | Tree | DPW 1 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016261.8205744 | 2096260.7089353 | 37.7368455183428 | -122.386233075665 | (37.7368455183428, -122.386233075665) | 10 | 3 | 8 | 58 | 1 | ||
| 93177 | 189385 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017746.74315 | 2096627.19057 | 37.7379338823466 | -122.381124464031 | (37.7379338823466, -122.381124464031) | 10 | 3 | 8 | 58 | 1 |
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) );