trees
4,014 rows where qSpecies_id = 40 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8324 | 78480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001855.96209 | 2090141.35003 | 37.719235261989 | -122.435602746878 | (37.719235261989, -122.435602746878) | 9 | 7 | 6 | 28861 | 5 | |||
| 10601 | 78363 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001858.24783 | 2090145.25438 | 37.7192461122881 | -122.435595125122 | (37.7192461122881, -122.435595125122) | 9 | 7 | 6 | 28861 | 5 | |||
| 127591 | 179014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 174 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004359.78757 | 2090147.30101 | 37.7193934976835 | -122.426948390073 | (37.7193934976835, -122.426948390073) | 9 | 7 | 6 | 28861 | 5 | |||
| 144027 | 179012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001860.73543 | 2090148.27679 | 37.7192545524417 | -122.435586742551 | (37.7192545524417, -122.435586742551) | 9 | 7 | 6 | 28861 | 5 | |||
| 183872 | 179013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 575 Lisbon St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6001863.70015 | 2090153.04553 | 37.719267814726 | -122.435576835623 | (37.719267814726, -122.435576835623) | 9 | 7 | 6 | 28861 | 5 | |||
| 16875 | 108379 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 125 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 01:08:00 PM | 3 | 3x3 | Permit Number 773806 | 6000690.09097 | 2090159.58738 | 37.7192190489897 | -122.439634019098 | (37.7192190489897, -122.439634019098) | 9 | 7 | 6 | 28861 | 25 |
| 41283 | 179015 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 570 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003097.37584 | 2090169.87122 | 37.7193840071539 | -122.431313686676 | (37.7193840071539, -122.431313686676) | 9 | 7 | 6 | 28861 | 5 | |||
| 44676 | 179010 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 600 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002473.36292 | 2090193.09579 | 37.7194123924534 | -122.433472324014 | (37.7194123924534, -122.433472324014) | 9 | 7 | 6 | 28861 | 5 | |||
| 37555 | 213318 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 347 Howth St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997130.27848 | 2090199.39045 | 37.7191250833297 | -122.45194174763 | (37.7191250833297, -122.45194174763) | 9 | 8 | 6 | 28861 | 24 | |||
| 13408 | 28246 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | 10 | 7 | 8 | 309 | 28 | ||
| 47273 | 179009 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 600 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002484.54609 | 2090211.44806 | 37.7194634181906 | -122.433434978747 | (37.7194634181906, -122.433434978747) | 9 | 7 | 6 | 28861 | 5 | |||
| 139955 | 213317 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 341 Howth St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 5997142.77814 | 2090220.59605 | 37.7191840249054 | -122.451900070344 | (37.7191840249054, -122.451900070344) | 9 | 8 | 6 | 28861 | 24 | |||
| 49138 | 179008 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 600 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002499.6579 | 2090233.80705 | 37.7195256683641 | -122.433384339735 | (37.7195256683641, -122.433384339735) | 9 | 7 | 6 | 28861 | 5 | |||
| 182790 | 213315 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Howth St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5997161.75267 | 2090255.45529 | 37.7192808270242 | -122.451836996388 | (37.7192808270242, -122.451836996388) | 9 | 8 | 6 | 28861 | 24 | |||
| 15892 | 78237 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1215 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Permit Number 779512 | 5999758.88688 | 2090259.2057 | 37.7194395330998 | -122.442859978114 | (37.7194395330998, -122.442859978114) | 9 | 7 | 6 | 28861 | 25 | ||
| 16604 | 213316 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Howth St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5997165.98186 | 2090264.50059 | 37.7193059055324 | -122.451823029928 | (37.7193059055324, -122.451823029928) | 9 | 8 | 6 | 28861 | 24 | |||
| 121940 | 28245 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3312 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2002 12:00:00 AM | 8 | 2X3 | 6011933.46331 | 2090279.87862 | 37.7201828704297 | -122.400778152699 | (37.7201828704297, -122.400778152699) | 10 | 7 | 8 | 309 | 28 | ||
| 116091 | 91235 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 470 Ramsell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52048 | 5993008 | 2090300 | 37.719164355766 | -122.466198071834 | (37.719164355766, -122.466198071834) | 9 | 8 | 6 | 64 | 24 | |||
| 113484 | 179006 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 428 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002479.44778 | 2090313.33929 | 37.7197428996051 | -122.433459879172 | (37.7197428996051, -122.433459879172) | 9 | 7 | 6 | 28861 | 5 | |||
| 12067 | 78234 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5999806.62934 | 2090324.19629 | 37.7196207041996 | -122.44269961461 | (37.7196207041996, -122.44269961461) | 9 | 7 | 6 | 28861 | 25 | |||
| 39968 | 213340 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Ralston St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5992193.1878 | 2090324.68996 | 37.7191851031829 | -122.469016337141 | (37.7191851031829, -122.469016337141) | 9 | 8 | 6 | 64 | 24 | |||
| 12254 | 213339 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 375 Ralston St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992194.58269 | 2090348.43318 | 37.7192503768696 | -122.469013242585 | (37.7192503768696, -122.469013242585) | 9 | 8 | 6 | 64 | 24 | |||
| 69984 | 213291 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 66 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994463.86124 | 2090359.9518 | 37.7194128591858 | -122.461170094944 | (37.7194128591858, -122.461170094944) | 9 | 8 | 6 | 28861 | 24 | |||
| 61781 | 179022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008892.67807 | 2090361.86972 | 37.7202379269127 | -122.411294959597 | (37.7202379269127, -122.411294959597) | 9 | 3 | 7 | 309 | 28 | |||
| 14705 | 78251 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 559 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 6002953.55708 | 2090366.3939 | 37.7199154633005 | -122.431824838869 | (37.7199154633005, -122.431824838869) | 9 | 7 | 6 | 28861 | 5 | |||
| 190138 | 179023 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008910.54006 | 2090367.60541 | 37.7202546776964 | -122.411233621349 | (37.7202546776964, -122.411233621349) | 9 | 3 | 7 | 309 | 28 | |||
| 129435 | 179024 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008925.8511 | 2090372.55179 | 37.7202691181059 | -122.411181045172 | (37.7202691181059, -122.411181045172) | 9 | 3 | 7 | 309 | 28 | |||
| 49052 | 179025 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 947 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008937.54219 | 2090376.09955 | 37.7202795151651 | -122.411140883254 | (37.7202795151651, -122.411140883254) | 9 | 3 | 7 | 309 | 28 | |||
| 1688 | 213308 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 219 Tara St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997858.51511 | 2090428.83634 | 37.7197967734736 | -122.44944104777 | (37.7197967734736, -122.44944104777) | 9 | 8 | 6 | 28861 | 24 | |||
| 110302 | 213307 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 247 Louisburg St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5997575.96644 | 2090467.37945 | 37.7198864367809 | -122.450420491319 | (37.7198864367809, -122.450420491319) | 9 | 8 | 6 | 28861 | 24 | |||
| 59977 | 50487 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 247 Louisburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47123 | 5997593.4002378 | 2090478.75871424 | 37.7199186793696 | -122.450361048898 | (37.7199186793696, -122.450361048898) | 9 | 8 | 6 | 28861 | 24 | ||
| 120852 | 213296 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 845 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996989.86469 | 2090498.61018 | 37.7199386271407 | -122.452448682867 | (37.7199386271407, -122.452448682867) | 9 | 8 | 6 | 28861 | 24 | |||
| 187542 | 213354 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 142 Garfield St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993565.63371 | 2090507.60393 | 37.7197665436602 | -122.464285624407 | (37.7197665436602, -122.464285624407) | 9 | 8 | 6 | 64 | 24 | |||
| 136442 | 28244 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3260 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/20/2003 12:00:00 AM | 12 | 2X3 | 6011894.92216 | 2090508.59301 | 37.7208087239121 | -122.40092743836 | (37.7208087239121, -122.40092743836) | 10 | 7 | 8 | 309 | 28 | ||
| 46490 | 213295 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 845 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996972.21157 | 2090510.38577 | 37.7199699487432 | -122.452510552626 | (37.7199699487432, -122.452510552626) | 9 | 8 | 6 | 28861 | 24 | |||
| 50575 | 213355 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 430 Garfield St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5992826.5059 | 2090512.32679 | 37.7197368804329 | -122.466840849243 | (37.7197368804329, -122.466840849243) | 9 | 8 | 6 | 64 | 24 | |||
| 149029 | 50785 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 525 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/04/2004 12:00:00 AM | 11 | Permit Number 47311 | 6001785.39603 | 2090541.73065 | 37.7203306092564 | -122.435875299 | (37.7203306092564, -122.435875299) | 9 | 7 | 6 | 28861 | 5 | ||
| 11717 | 78354 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1125 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000366.91048 | 2090562.17909 | 37.7203060748337 | -122.440779991907 | (37.7203060748337, -122.440779991907) | 9 | 7 | 6 | 28861 | 25 | |||
| 131863 | 65791 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 523 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1990 12:00:00 AM | 7 | Permit Number 28759 | 6001804.02439 | 2090571.26735 | 37.7204127686105 | -122.435813019178 | (37.7204127686105, -122.435813019178) | 9 | 7 | 6 | 28861 | 5 | ||
| 135771 | 213289 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 524 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995193.9429 | 2090587.80207 | 37.7200804700272 | -122.458662975743 | (37.7200804700272, -122.458662975743) | 9 | 8 | 6 | 28861 | 24 | |||
| 128008 | 95644 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767414 | 6003055 | 2090608 | 37.7205846102013 | -122.431491425064 | (37.7205846102013, -122.431491425064) | 9 | 7 | 6 | 28861 | 5 | |
| 123683 | 28243 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | 10 | 7 | 8 | 309 | 28 | ||
| 134889 | 214831 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 114 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996535.21399 | 2090645.46472 | 37.7203157965229 | -122.45403084487 | (37.7203157965229, -122.45403084487) | 9 | 8 | 6 | 28861 | 24 | |||
| 192977 | 179005 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 500 Paris St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001802.30971 | 2090646.62638 | 37.7206195902147 | -122.435824335343 | (37.7206195902147, -122.435824335343) | 9 | 7 | 6 | 28861 | 5 | |||
| 76488 | 179004 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 500 Paris St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001810.04061 | 2090659.99307 | 37.7206567312996 | -122.435798567961 | (37.7206567312996, -122.435798567961) | 9 | 7 | 6 | 28861 | 5 | |||
| 42647 | 179003 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 500 Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001817.20315 | 2090671.49151 | 37.7206887102981 | -122.435774631595 | (37.7206887102981, -122.435774631595) | 9 | 7 | 6 | 28861 | 5 | |||
| 19073 | 78215 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 869 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6010959.76408 | 2090685.67745 | 37.7212427529373 | -122.404172468398 | (37.7212427529373, -122.404172468398) | 10 | 3 | 7 | 309 | 28 | |||
| 136490 | 213347 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 529 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5993232.83209 | 2090695.61301 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | 9 | 8 | 6 | 64 | 24 | |||
| 61800 | 213321 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 325 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5991673.59488 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | 9 | 8 | 6 | 64 | 24 | |||
| 174868 | 213322 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 329 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991674.00828 | 2090730.18875 | 37.7202684921693 | -122.470840448222 | (37.7202684921693, -122.470840448222) | 9 | 8 | 6 | 64 | 24 | |||
| 97613 | 213327 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5991934.3542 | 2090733.05166 | 37.7202914059971 | -122.469940735003 | (37.7202914059971, -122.469940735003) | 9 | 8 | 6 | 64 | 24 | |||
| 44722 | 84826 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 855 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 7 | Permit Number 53480 | 6010945.70103 | 2090738.74134 | 37.7213876696754 | -122.404224813428 | (37.7213876696754, -122.404224813428) | 10 | 3 | 7 | 309 | 28 | ||
| 59384 | 213326 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 333 Byxbee St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991939.84993 | 2090759.93539 | 37.7203655398194 | -122.469923694617 | (37.7203655398194, -122.469923694617) | 9 | 8 | 6 | 64 | 24 | |||
| 121822 | 213320 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 238 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5991458.7746 | 2090762.70401 | 37.7203453212587 | -122.471586801009 | (37.7203453212587, -122.471586801009) | 9 | 8 | 6 | 64 | 24 | |||
| 11922 | 78132 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 738 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6009313.83221 | 2090783.01669 | 37.7214179201914 | -122.409868876754 | (37.7214179201914, -122.409868876754) | 9 | 3 | 7 | 309 | 28 | |||
| 189691 | 213342 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 442 Vernon St | 2 | : | Tree | Private 2 | 10 | Width 3ft | 5992492.2832 | 2090792.26428 | 37.7204862252464 | -122.468016479897 | (37.7204862252464, -122.468016479897) | 9 | 8 | 6 | 64 | 24 | |||
| 21882 | 213345 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 542 Arch St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992754.74517 | 2090800.4755 | 37.7205239248105 | -122.467109837375 | (37.7205239248105, -122.467109837375) | 9 | 8 | 6 | 64 | 24 | |||
| 83604 | 213287 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 333 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994725.25239 | 2090808.70805 | 37.7206600758943 | -122.460299065575 | (37.7206600758943, -122.460299065575) | 9 | 8 | 6 | 28861 | 24 | |||
| 1021 | 213351 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 752 Head St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5993534.80603 | 2090819.23886 | 37.7206204409725 | -122.464414798499 | (37.7206204409725, -122.464414798499) | 9 | 8 | 6 | 64 | 24 | |||
| 64457 | 213288 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1039 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995905.05181 | 2090820.42623 | 37.7207600463335 | -122.456221739052 | (37.7207600463335, -122.456221739052) | 9 | 8 | 6 | 28861 | 24 | |||
| 149693 | 213352 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 752 Head St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5993533.94375 | 2090828.77797 | 37.7206465833581 | -122.464418471345 | (37.7206465833581, -122.464418471345) | 9 | 8 | 6 | 64 | 24 | |||
| 75701 | 213325 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 351 Byxbee St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5991942.47046 | 2090861.00435 | 37.7206432019019 | -122.469921991317 | (37.7206432019019, -122.469921991317) | 9 | 8 | 6 | 64 | 24 | |||
| 110791 | 213341 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 455 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5992454.16583 | 2090885.02641 | 37.7207387260928 | -122.468154982671 | (37.7207387260928, -122.468154982671) | 9 | 8 | 6 | 64 | 24 | |||
| 119831 | 213324 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 355 Byxbee St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5991941.51913 | 2090886.05993 | 37.7207119433918 | -122.469927103079 | (37.7207119433918, -122.469927103079) | 9 | 8 | 6 | 64 | 24 | |||
| 113427 | 213319 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 262 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991459.9673 | 2090912.89222 | 37.7207577701313 | -122.471593616958 | (37.7207577701313, -122.471593616958) | 9 | 8 | 6 | 64 | 24 | |||
| 19033 | 213284 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 152 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994475.62527 | 2090947.51619 | 37.7210268472907 | -122.461171998816 | (37.7210268472907, -122.461171998816) | 9 | 8 | 6 | 28861 | 24 | |||
| 167908 | 213290 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.72101711662 | -122.462357593044 | (37.72101711662, -122.462357593044) | 9 | 8 | 6 | 28861 | 24 | |||
| 26963 | 213286 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 361 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994727.85244 | 2090960.34895 | 37.7210765950904 | -122.460301059362 | (37.7210765950904, -122.460301059362) | 9 | 8 | 6 | 28861 | 24 | |||
| 56692 | 213285 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 361 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994728.21943 | 2090977.86647 | 37.721124715118 | -122.460301059356 | (37.721124715118, -122.460301059356) | 9 | 8 | 6 | 28861 | 24 | |||
| 138969 | 202042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 52 Exeter St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012532.81359 | 2090984.99672 | 37.7221523937885 | -122.398755844523 | (37.7221523937885, -122.398755844523) | 10 | 3 | 8 | 58 | 1 | |||
| 59096 | 202045 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 41 Exeter St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012584.35783 | 2091031.24341 | 37.7222822496095 | -122.398580911082 | (37.7222822496095, -122.398580911082) | 10 | 3 | 8 | 58 | 1 | |||
| 130160 | 178986 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 61 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6000882.20287 | 2091063.41972 | 37.7217117008072 | -122.439034703684 | (37.7217117008072, -122.439034703684) | 9 | 7 | 6 | 28861 | 25 | |||
| 128179 | 37775 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 718 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 16 | Permit Number 40113 | 6009462.43641 | 2091064.86672 | 37.7222001487066 | -122.409375071617 | (37.7222001487066, -122.409375071617) | 9 | 3 | 7 | 309 | 28 | |
| 104438 | 97562 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2012 12:00:00 AM | Permit Number 768967 | 5994515.7 | 2091119.6 | 37.7215016543215 | -122.461045939781 | (37.7215016543215, -122.461045939781) | 9 | 8 | 6 | 28861 | 24 | |||
| 47979 | 46833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 471 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | 9 | Permit Number 44906 | 6002821.93172 | 2091174.08119 | 37.7221257307043 | -122.4323374767 | (37.7221257307043, -122.4323374767) | 9 | 7 | 6 | 28861 | 5 | |
| 111822 | 213323 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 395 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991938.55148 | 2091189.98285 | 37.7215462696313 | -122.469959478668 | (37.7215462696313, -122.469959478668) | 9 | 8 | 6 | 64 | 24 | |||
| 60812 | 214828 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5996730.05288 | 2091219.63097 | 37.7219034920315 | -122.453398786937 | (37.7219034920315, -122.453398786937) | 9 | 8 | 4 | 28861 | 24 | |||
| 171070 | 214832 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 300 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995877.45425 | 2091234.14535 | 37.7218944367507 | -122.456347034403 | (37.7218944367507, -122.456347034403) | 9 | 8 | 4 | 28861 | 24 | |||
| 10377 | 91396 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2009 12:00:00 AM | 3x3 | Permit Number 52091 | 5996731.3 | 2091236.4 | 37.7219496073249 | -122.453395686079 | (37.7219496073249, -122.453395686079) | 9 | 8 | 4 | 28861 | 24 | ||
| 17185 | 78318 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 605 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x6 | 6008900.36842 | 2091273.56909 | 37.7227416934471 | -122.411332749116 | (37.7227416934471, -122.411332749116) | 9 | 3 | 7 | 309 | 28 | ||
| 19321 | 78229 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 605 Colby St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 3x9 | 6008895.81383 | 2091285.82356 | 37.7227750861924 | -122.411349358704 | (37.7227750861924, -122.411349358704) | 9 | 3 | 7 | 309 | 28 | ||
| 132224 | 17504 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 132 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002139.26197 | 2091310.46109 | 37.7224614665061 | -122.43470704369 | (37.7224614665061, -122.43470704369) | 9 | 7 | 6 | 28861 | 5 | |||
| 160750 | 179149 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 387 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6003556.4774 | 2091326.81384 | 37.7225867240926 | -122.429809220726 | (37.7225867240926, -122.429809220726) | 9 | 7 | 6 | 28861 | 5 | |||
| 127876 | 52943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 428 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 4 | Permit Number 48930 | 6000112.39427 | 2091327.92801 | 37.722394148651 | -122.441714695073 | (37.722394148651, -122.441714695073) | 9 | 7 | 6 | 28861 | 25 | |
| 48851 | 179148 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 305 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004516.54682 | 2091330.14296 | 37.722650185652 | -122.426490709795 | (37.722650185652, -122.426490709795) | 9 | 7 | 6 | 28861 | 5 | |||
| 95905 | 178989 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 342 Oneida Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5999402.14397 | 2091356.43076 | 37.7224319165768 | -122.444171904613 | (37.7224319165768, -122.444171904613) | 9 | 7 | 6 | 28861 | 25 | |||
| 93016 | 178988 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 438 Delano Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999531.66128 | 2091360.09609 | 37.7224493688267 | -122.443724457718 | (37.7224493688267, -122.443724457718) | 9 | 7 | 6 | 28861 | 25 | |||
| 124796 | 37808 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 925 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 14 | Permit Number 40128 | 6009009.75323 | 2091360.17391 | 37.7229856264714 | -122.410960741867 | (37.7229856264714, -122.410960741867) | 9 | 3 | 7 | 309 | 28 | |
| 191627 | 178987 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 438 Delano Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5999543.39819 | 2091383.90085 | 37.722515400656 | -122.443685595329 | (37.722515400656, -122.443685595329) | 9 | 7 | 6 | 28861 | 25 | |||
| 170314 | 178990 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 342 Oneida Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5999327.15458 | 2091397.10095 | 37.7225393091341 | -122.44443404622 | (37.7225393091341, -122.44443404622) | 9 | 7 | 6 | 28861 | 25 | |||
| 43195 | 178991 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 342 Oneida Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5999304.0712 | 2091408.36096 | 37.7225689094196 | -122.444514648859 | (37.7225689094196, -122.444514648859) | 9 | 7 | 6 | 28861 | 25 | |||
| 116245 | 178984 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 33 Leo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001422.09119 | 2091414.6513 | 37.7227068078594 | -122.437193590922 | (37.7227068078594, -122.437193590922) | 9 | 7 | 6 | 28861 | 25 | |||
| 184246 | 68094 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 51 Wanda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | 7 | Permit Number 31838 | 6000539.95972 | 2091455.59429 | 37.7227690436428 | -122.440245854872 | (37.7227690436428, -122.440245854872) | 9 | 7 | 6 | 28861 | 25 | |
| 28873 | 214833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 229 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995622.68342 | 2091459.34176 | 37.7224981435639 | -122.457243989416 | (37.7224981435639, -122.457243989416) | 9 | 8 | 4 | 28861 | 24 | |||
| 80971 | 179111 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1362 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007634.67362 | 2091466.7715 | 37.7232011166284 | -122.415721669126 | (37.7232011166284, -122.415721669126) | 9 | 3 | 7 | 309 | 28 | |||
| 92165 | 37862 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 286 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | 10 | Permit Number 40149 | 6004552.23885 | 2091481.5698 | 37.7230679881701 | -122.426378106562 | (37.7230679881701, -122.426378106562) | 9 | 7 | 6 | 28861 | 5 | |
| 32574 | 179138 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 614 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009724.98077 | 2091494.32662 | 37.7233940625658 | -122.408497793739 | (37.7233940625658, -122.408497793739) | 9 | 3 | 7 | 309 | 28 | |||
| 11785 | 72266 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325117 | (37.7230023412585, -122.43384325117) | 9 | 7 | 6 | 28861 | 5 | |||
| 4459 | 78281 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 34 Wanda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6000546.67018 | 2091525.62315 | 37.7229617089923 | -122.440227677765 | (37.7229617089923, -122.440227677765) | 9 | 7 | 6 | 28861 | 25 | |||
| 3215 | 48784 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 268 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | 7 | Permit Number 46039 | 6000083.90087 | 2091529.02554 | 37.7229446929396 | -122.441827615748 | (37.7229446929396, -122.441827615748) | 9 | 7 | 6 | 28861 | 25 |
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) );