trees
897 rows where qSpecies_id = 160 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44613 | 234336 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6004864.24492 | 2105581.16954 | 37.7617999064621 | -122.426302932261 | (37.7617999064621, -122.426302932261) | 8 | 4 | 5 | 28862 | 3 | |||
| 44648 | 119407 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375 32nd Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 9ft | 5985884.85714 | 2113320.57304 | 37.7819590323137 | -122.492514128744 | (37.7819590323137, -122.492514128744) | 11 | 6 | 2 | 55 | 26 | |||
| 45318 | 194287 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 32 | Median : Yard | Tree | DPW 1 | 31 | 6014435.32238 | 2095233.37666 | 37.7339234087228 | -122.392476296866 | (37.7339234087228, -122.392476296866) | 10 | 3 | 8 | 58 | 1 | ||||
| 45636 | 132102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 10ft | 6012409.88323 | 2120572.11734 | 37.8033851982182 | -122.401258897879 | (37.8033851982182, -122.401258897879) | 3 | 1 | 10 | 28860 | 6 | |||
| 45682 | 28024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.30001 | 2117911.22501 | 37.7961756855245 | -122.39506688845 | (37.7961756855245, -122.39506688845) | 3 | 2 | 10 | 28860 | 6 | ||
| 46127 | 25143 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1798X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6005303.4758509 | 2097774.014097 | 37.7403880804322 | -122.42422853473 | (37.7403880804322, -122.42422853473) | 2 | 7 | 5 | 28859 | 7 | |||
| 46369 | 28229 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 46729 | 25006 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 470X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004864.935088 | 2105663.9116337 | 37.7620271356236 | -122.426306436493 | (37.7620271356236, -122.426306436493) | 8 | 4 | 5 | 28862 | 3 | |||
| 46829 | 96681 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 375@32nd Ave 32nd Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/28/2011 12:00:00 AM | 25 | Permit Number 768040 | 5985880.88078 | 2113443.18167 | 37.7822954478301 | -122.492536917233 | (37.7822954478301, -122.492536917233) | 11 | 6 | 2 | 55 | 26 | ||
| 47535 | 25745 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 47545 | 24964 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
| 48140 | 194380 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 6015792.97899 | 2115653.31942 | 37.7900674842722 | -122.389207795421 | (37.7900674842722, -122.389207795421) | 6 | 2 | 9 | 28855 | 6 | |||
| 48409 | 132091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.8063057411882 | -122.405269766312 | (37.8063057411882, -122.405269766312) | 3 | 1 | 10 | 308 | 23 | |||
| 48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
| 48677 | 25052 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005070.62845 | 2102872.02457 | 37.7543728949014 | -122.42539633287 | (37.7543728949014, -122.42539633287) | 2 | 4 | 5 | 28862 | 22 | |||
| 49036 | 25075 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1198 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005087.7 | 2101404.7 | 37.7503449269028 | -122.425232889951 | (37.7503449269028, -122.425232889951) | 2 | 4 | 5 | 28862 | 22 | |||
| 49188 | 234397 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3932 22nd St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 25 | Width 4ft | 6002267.50929 | 2102984.90864 | 37.7545240763369 | -122.435098296447 | (37.7545240763369, -122.435098296447) | 2 | 4 | 5 | 28862 | 22 | |||
| 49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
| 49369 | 25015 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004955.91822 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | 2 | 4 | 5 | 28862 | 3 | |||
| 49577 | 25506 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1998X Market St | 6 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6004905.96284 | 2108444.17955 | 37.7696634052537 | -122.426362499197 | (37.7696634052537, -122.426362499197) | 7 | 4 | 5 | 28852 | 10 | ||
| 49888 | 25532 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 7 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002592.5231 | 2106186.5128 | 37.7633333608706 | -122.43420318117 | (37.7633333608706, -122.43420318117) | 15 | 4 | 5 | 28862 | 3 | ||
| 50694 | 28220 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 50720 | 25534 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 9 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.7632555258533 | -122.434311693987 | (37.7632555258533, -122.434311693987) | 15 | 4 | 5 | 28862 | 3 | ||
| 50815 | 194375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 310x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 27 | Width 8ft | 6016059.60857 | 2115304.27364 | 37.7891238616108 | -122.388260900137 | (37.7891238616108, -122.388260900137) | 6 | 2 | 9 | 28855 | 6 | |||
| 50904 | 194330 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 6 | Median : Yard | Tree | DPW 1 | 32 | Width 8ft | 6015863.58652 | 2112149.96757 | 37.7804519868963 | -122.38871883132 | (37.7804519868963, -122.38871883132) | 6 | 2 | 9 | 28856 | 20 | |||
| 51227 | 194309 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 The Embarcadero | 1 | : | Tree | Private 2 | 24 | Width 7ft | 6015233.93882 | 2116624.33128 | 37.7927026516602 | -122.39120994708 | (37.7927026516602, -122.39120994708) | 12 | 2 | 9 | 28855 | 6 | |||
| 51299 | 233936 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 230x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 34 | 6004841.8872 | 2106976.70647 | 37.7656304545194 | -122.426479630127 | (37.7656304545194, -122.426479630127) | 8 | 4 | 5 | 28862 | 3 | ||||
| 52151 | 132109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011459.50109 | 2121569.1071 | 37.8060696196846 | -122.404617975463 | (37.8060696196846, -122.404617975463) | 3 | 1 | 10 | 308 | 23 | |||
| 52333 | 234371 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 35 | 6005338.50183 | 2098008.71997 | 37.7410345073494 | -122.42412411595 | (37.7410345073494, -122.42412411595) | 2 | 7 | 5 | 63 | 7 | ||||
| 52419 | 234367 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1650x Dolores St | 5 | Median : Yard | Tree | DPW 1 | 44 | 6005309.50054 | 2098532.58451 | 37.7424712831236 | -122.424261641173 | (37.7424712831236, -122.424261641173) | 2 | 7 | 5 | 63 | 22 | ||||
| 52518 | 13388 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Marietta Dr | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5 | 5997667.52153 | 2098758.8322 | 37.7426580336411 | -122.45070150969 | (37.7426580336411, -122.45070150969) | 9 | 7 | 4 | 59 | 40 | |||
| 52598 | 25009 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 50 | 20 | 6004942.00867 | 2105066.11314 | 37.7603900788595 | -122.425997312043 | (37.7603900788595, -122.425997312043) | 2 | 4 | 5 | 28862 | 3 | |||
| 53273 | 25679 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 350X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 53288 | 210910 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 151 Garcia Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994660.64772 | 2099277.20114 | 37.743908769387 | -122.461135900907 | (37.743908769387, -122.461135900907) | 1 | 8 | 4 | 59 | 40 | |||
| 53310 | 194279 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 21 | Front Yard : Yard | Tree | Private 2 | 4 | 6016113.78589 | 2100276.91255 | 37.7478649967659 | -122.387024931273 | (37.7478649967659, -122.387024931273) | 3 | 8 | 58 | 1 | |||||
| 53552 | 28226 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 53587 | 24987 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6004879.52665 | 2106321.34538 | 37.7638331171148 | -122.426302779348 | (37.7638331171148, -122.426302779348) | 8 | 4 | 5 | 28859 | 3 | |||
| 53940 | 28194 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 54034 | 210911 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 443 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5997433.82925 | 2094957.55837 | 37.7322072729454 | -122.451235463261 | (37.7322072729454, -122.451235463261) | 9 | 7 | 4 | 59 | 40 | ||||
| 54047 | 18560 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014546.06488 | 2095149.21711 | 37.7336984729967 | -122.392087539714 | (37.7336984729967, -122.392087539714) | 10 | 3 | 8 | 58 | 1 | |||
| 54070 | 26030 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.13731 | 37.7961592508003 | -122.395048997307 | (37.7961592508003, -122.395048997307) | 3 | 2 | 10 | 28860 | 6 | ||
| 54159 | 27775 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 54424 | 27963 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 54599 | 25021 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 750X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6005015.54343 | 2103801.2681 | 37.7569212678239 | -122.425652964336 | (37.7569212678239, -122.425652964336) | 2 | 4 | 5 | 28862 | 3 | |||
| 54880 | 194304 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014519.25252 | 2117262.79206 | 37.7944160283404 | -122.393727518235 | (37.7944160283404, -122.393727518235) | 12 | 2 | 10 | 28855 | 6 | |||
| 55170 | 25007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004931.59557 | 2105384.62551 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | 2 | 4 | 5 | 28862 | 3 | |||
| 55277 | 194276 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2347 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | 6010780.52383 | 2105047.83738 | 37.7606681393399 | -122.405803207256 | (37.7606681393399, -122.405803207256) | 10 | 3 | 8 | 28856 | 29 | ||||
| 55390 | 25061 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | 2 | 4 | 5 | 28862 | 22 | |||
| 55447 | 194394 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 920x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014490.42947 | 2089308.04208 | 37.7176566864975 | -122.391871584628 | (37.7176566864975, -122.391871584628) | 10 | 3 | 8 | 58 | 1 | |||
| 55472 | 25504 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1950X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 8 | 6005007.7768 | 2108494.7101 | 37.769807904671 | -122.426013925385 | (37.769807904671, -122.426013925385) | 8 | 2 | 5 | 28853 | 19 | ||
| 55831 | 25003 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 470X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 40 | 20 | 6004864.935088 | 2105663.9116337 | 37.7620271356236 | -122.426306436493 | (37.7620271356236, -122.426306436493) | 8 | 4 | 5 | 28862 | 3 | |||
| 55917 | 86731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Pico Ave | Front Yard : Cutout | Tree | Private 2 | Permit Number 49705 | 5994102.9 | 2092171.9 | 37.7243672527805 | -122.462549157922 | (37.7243672527805, -122.462549157922) | 9 | 8 | 4 | 59 | 40 | |||||
| 56033 | 25025 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 10 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 56236 | 118759 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 544 45th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | Width 5ft | 5981951.74748 | 2112030.16523 | 37.7781852088244 | -122.506024939755 | (37.7781852088244, -122.506024939755) | 11 | 6 | 2 | 55 | 26 | |||
| 57058 | 194389 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 36 | 6013123.75243 | 2089902.89375 | 37.7192140640518 | -122.396637279208 | (37.7192140640518, -122.396637279208) | 10 | 3 | 8 | 58 | 1 | ||||
| 57209 | 194341 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 25 | Width 8ft | 6016036.61123 | 2112738.53497 | 37.7820776491035 | -122.388161338867 | (37.7820776491035, -122.388161338867) | 6 | 2 | 9 | 28856 | 6 | |||
| 57723 | 132097 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012695.81427 | 2120154.08889 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | 3 | 1 | 10 | 28860 | 6 | |||
| 57730 | 25005 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 11 | Median : Cutout | Tree | DPW 1 | 60 | 20 | 6004909.62219 | 2105744.11353 | 37.7622498768445 | -122.426157591005 | (37.7622498768445, -122.426157591005) | 8 | 4 | 5 | 28859 | 3 | |||
| 57913 | 234378 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1 Bird St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 5ft | 6005998.07456 | 2105729.78745 | 37.7622720010628 | -122.422392021673 | (37.7622720010628, -122.422392021673) | 8 | 4 | 5 | 28859 | 19 | |||
| 58327 | 132127 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6014286.02329 | 2117523.57721 | 37.7951191201157 | -122.394552795494 | (37.7951191201157, -122.394552795494) | 4 | 2 | 10 | 28860 | 6 | |||
| 58643 | 25738 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 58770 | 25528 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002714.6296 | 2106302.2301 | 37.7636580221412 | -122.433789126424 | (37.7636580221412, -122.433789126424) | 15 | 4 | 5 | 28862 | 3 | ||
| 58771 | 25047 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.7548322263474 | -122.425437427413 | (37.7548322263474, -122.425437427413) | 2 | 4 | 5 | 28862 | 22 | |||
| 58811 | 194359 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 33 | Width 8ft | 6016151.3585 | 2114078.17293 | 37.7857623505017 | -122.387857866272 | (37.7857623505017, -122.387857866272) | 6 | 2 | 9 | 28856 | 6 | |||
| 59030 | 27777 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 60029 | 25524 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2194X Market St | 11 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6003574.351798 | 2107172.9273566 | 37.7660974938136 | -122.430877759148 | (37.7660974938136, -122.430877759148) | 7 | 4 | 5 | 28862 | 3 | ||
| 60030 | 246357 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2100x Market St | 4 | Median : Cutout | Tree | DPW 1 | 32 | Width 0ft | 6003963.462 | 2107490.3857 | 37.7669911968193 | -122.429554546796 | (37.7669911968193, -122.429554546796) | 8 | 4 | 5 | 28862 | 3 | |||
| 60479 | 124659 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 199 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | Width 8ft | 5995478.86593 | 2115238.56038 | 37.7877815776324 | -122.459462441459 | (37.7877815776324, -122.459462441459) | 11 | 6 | 1 | 54 | 11 | |||
| 61055 | 234337 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 3ft | 6004866.41274 | 2105541.33089 | 37.7616906415182 | -122.426292598133 | (37.7616906415182, -122.426292598133) | 8 | 4 | 5 | 28862 | 3 | |||
| 61170 | 25079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1162 DOLORES ST | 1 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6005068.3 | 2101554.8 | 37.7507559707678 | -122.425310656505 | (37.7507559707678, -122.425310656505) | 2 | 4 | 5 | 28862 | 22 | |||
| 62567 | 194289 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 38 | Median : Yard | Tree | DPW 1 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.392613948889 | (37.734007417094, -122.392613948889) | 10 | 3 | 8 | 58 | 1 | ||||
| 63037 | 118547 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 8140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5981731.05099 | 2112390.85514 | 37.7791625633163 | -122.506815156259 | (37.7791625633163, -122.506815156259) | 11 | 6 | 2 | 55 | 26 | |||
| 63593 | 25152 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958274 | (37.768035057311, -122.42669958274) | 8 | 4 | 5 | 28862 | 3 | |||
| 63944 | 25748 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
| 64082 | 25669 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 65015 | 194291 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 41 | Median : Yard | Tree | DPW 1 | 38 | 6014364.32912 | 2095287.31351 | 37.7340675655682 | -122.392725516077 | (37.7340675655682, -122.392725516077) | 10 | 3 | 8 | 58 | 1 | ||||
| 65475 | 96830 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 24 | 20x225 | 6004936 | 2104486.3 | 37.7587977092663 | -122.425976818319 | (37.7587977092663, -122.425976818319) | 2 | 4 | 5 | 28862 | 3 | |||
| 65491 | 132120 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 5ft | 6014198.1938 | 2117703.48543 | 37.795608222696 | -122.394869307388 | (37.795608222696, -122.394869307388) | 4 | 2 | 10 | 28860 | 6 | |||
| 66070 | 18558 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 13 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014793.6967997 | 2095004.1424748 | 37.7333138733401 | -122.391221258932 | (37.7333138733401, -122.391221258932) | 10 | 3 | 8 | 58 | 1 | |||
| 66185 | 25498 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1745X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 24 | 20 | 6005901.64349 | 2109360.28288 | 37.7722350378549 | -122.422983588528 | (37.7722350378549, -122.422983588528) | 7 | 2 | 9 | 28853 | 19 | ||
| 66198 | 194347 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 418x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 32 | Width 8ft | 6016017.18881 | 2113128.44937 | 37.7831471903209 | -122.388255753298 | (37.7831471903209, -122.388255753298) | 6 | 2 | 9 | 28856 | 6 | |||
| 66457 | 234341 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 3ft | 6004869.93402 | 2105476.54682 | 37.7615129588681 | -122.426275806884 | (37.7615129588681, -122.426275806884) | 8 | 4 | 5 | 28862 | 3 | |||
| 66677 | 28227 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
| 66690 | 24339 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2020X Market St | 3 | Median : Cutout | Tree | DPW 1 | 05/07/1993 12:00:00 AM | 36 | 8 | 6004378.3201 | 2107887.5635 | 37.7681052320451 | -122.428147925504 | (37.7681052320451, -122.428147925504) | 8 | 4 | 5 | 28862 | 3 | ||
| 66787 | 194390 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1031 Key Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | 6013152.66051 | 2089880.87187 | 37.7191552052161 | -122.396535811395 | (37.7191552052161, -122.396535811395) | 10 | 3 | 8 | 58 | 1 | ||||
| 66930 | 25109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1496 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005218.8222955 | 2099617.195839 | 37.7454442580108 | -122.424652317948 | (37.7454442580108, -122.424652317948) | 2 | 7 | 5 | 63 | 22 | |||
| 67382 | 25783 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013938.98446 | 2118296.9177 | 37.7972232315271 | -122.395807826386 | (37.7972232315271, -122.395807826386) | 3 | 1 | 10 | 28860 | 6 | ||
| 67446 | 210916 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 587 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 38 | Width 4ft | 5994027.5569 | 2099288.55437 | 37.7439034894442 | -122.46332578967 | (37.7439034894442, -122.46332578967) | 1 | 8 | 4 | 59 | 40 | |||
| 67451 | 201687 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 401 08th St | 23 | Front Yard : Yard | Tree | Private 2 | 23 | 6010195.30306 | 2109846.89146 | 37.7738124981919 | -122.408165701983 | (37.7738124981919, -122.408165701983) | 14 | 2 | 9 | 28853 | 34 | ||||
| 67467 | 194329 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 5 | Median : Yard | Tree | DPW 1 | 29 | Width 8ft | 6015829.09984 | 2112179.7817 | 37.7805319384279 | -122.388840220015 | (37.7805319384279, -122.388840220015) | 6 | 2 | 9 | 28856 | 20 | |||
| 68051 | 255454 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 218 Joost Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000622 | 2094989 | 37.7324756340381 | -122.440215522188 | (37.7324756340381, -122.440215522188) | 9 | 7 | 5 | 63 | 40 | ||||
| 68062 | 28186 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6 | 6014324.7762427 | 2110655.258445 | 37.7762624487031 | -122.393937678457 | (37.7762624487031, -122.393937678457) | 6 | 2 | 9 | 28856 | 20 | |||
| 68276 | 25044 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
| 69224 | 25031 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 700X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 25 | 20 | 6005006.55303 | 2104135.22937 | 37.7578377390251 | -122.425707825673 | (37.7578377390251, -122.425707825673) | 2 | 4 | 5 | 28862 | 3 | |||
| 69730 | 132101 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 17 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | 3 | 1 | 10 | 28860 | 6 | |||
| 69904 | 194333 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 9 | Median : Yard | Tree | DPW 1 | 31 | Width 8ft | 6015903.37717 | 2112286.34189 | 37.7808286454598 | -122.38859069772 | (37.7808286454598, -122.38859069772) | 6 | 2 | 9 | 28856 | 20 | |||
| 69989 | 178087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 201 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6003003.32466 | 2086943.97699 | 37.7105210777575 | -122.431408625424 | (37.7105210777575, -122.431408625424) | 9 | 7 | 6 | 28861 | 5 | |||
| 70644 | 25017 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 710X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 70 | 20 | 6004949.2547318 | 2104210.5607703 | 37.7580413433618 | -122.425911349448 | (37.7580413433618, -122.425911349448) | 2 | 4 | 5 | 28862 | 3 | |||
| 70733 | 234339 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | Width 3ft | 6004868.93824 | 2105500.74139 | 37.7615793351331 | -122.426280973507 | (37.7615793351331, -122.426280973507) | 8 | 4 | 5 | 28862 | 3 | |||
| 70812 | 210921 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380 Kingston St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 4ft | 5994023.0507 | 2099217.557 | 37.7437082889086 | -122.463336220006 | (37.7437082889086, -122.463336220006) | 1 | 8 | 4 | 59 | 40 |
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) );