trees
268 rows where qSpecies_id = 77 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29395 | 83672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 76 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52299 | 6012122.94965 | 2095206.11599 | 37.7337198723641 | -122.400469008954 | (37.7337198723641, -122.400469008954) | 10 | 3 | 8 | 58 | 1 | |
31602 | 196549 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 40 Ledyard St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011616.35938 | 2095078.64568 | 37.7333416013201 | -122.402211492182 | (37.7333416013201, -122.402211492182) | 10 | 3 | 8 | 58 | 1 | |||
42382 | 84481 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 59 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50146 | 6012081.07031 | 2095312.02235 | 37.7340083335059 | -122.40062123629 | (37.7340083335059, -122.40062123629) | 10 | 3 | 8 | 58 | 1 | |
45234 | 202184 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1900 Armstrong Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6013198.98425 | 2093399.22832 | 37.7288184790723 | -122.396622193069 | (37.7288184790723, -122.396622193069) | 10 | 3 | 8 | 58 | 1 | ||||
52279 | 196548 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1828 Illinois St | 1 | : | Tree | Private 2 | 7 | Width 4ft | 6016259.97415 | 2100569.45799 | 37.748676359729 | -122.386539809975 | (37.748676359729, -122.386539809975) | 10 | 3 | 8 | 58 | 1 | |||
76508 | 196550 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 44 Ledyard St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6011631.22474 | 2095058.90735 | 37.7332882337562 | -122.402158710982 | (37.7332882337562, -122.402158710982) | 10 | 3 | 8 | 58 | 1 | |||
114927 | 196551 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 48 Ledyard St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011647.63932 | 2095039.33012 | 37.7332353949856 | -122.402100585073 | (37.7332353949856, -122.402100585073) | 10 | 3 | 8 | 58 | 1 | |||
120545 | 202152 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1951 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6013046.17664 | 2093441.40359 | 37.7289257780866 | -122.397153419018 | (37.7289257780866, -122.397153419018) | 10 | 3 | 8 | 58 | 1 | |||
135957 | 40046 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1732 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 5 | 7.5x2.5 | Permit Number 767656 | 6014557.3351 | 2095185.10659 | 37.7337976439298 | -122.392051083889 | (37.7337976439298, -122.392051083889) | 10 | 3 | 8 | 58 | 1 |
142625 | 196552 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 56 Ledyard St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 6011678.30483 | 2094998.2948 | 37.7331244321513 | -122.401991681687 | (37.7331244321513, -122.401991681687) | 10 | 3 | 8 | 58 | 1 | |||
149200 | 96001 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 321 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767651 | 6013592.98879 | 2094402.89056 | 37.73159625106 | -122.395330363713 | (37.73159625106, -122.395330363713) | 10 | 3 | 8 | 58 | 1 |
152134 | 196553 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 43 Latona St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6014415.54504 | 2094422.50935 | 37.7316958338904 | -122.392487974535 | (37.7316958338904, -122.392487974535) | 10 | 3 | 8 | 58 | 1 | |||
160166 | 202259 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013218.01399 | 2093376.88816 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | 10 | 3 | 8 | 58 | 1 | ||||
174301 | 51361 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 50 Pomona St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014122.20154 | 2094470.50183 | 37.7318113167403 | -122.393505487305 | (37.7318113167403, -122.393505487305) | 10 | 3 | 8 | 58 | 1 |
174567 | 202188 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1900 Armstrong Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6013190.44315 | 2093406.40364 | 37.728837705679 | -122.39665222323 | (37.728837705679, -122.39665222323) | 10 | 3 | 8 | 58 | 1 | ||||
180557 | 96000 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 315 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767650 | 6013581.92641 | 2094423.84152 | 37.7316531628455 | -122.395370075974 | (37.7316531628455, -122.395370075974) | 10 | 3 | 8 | 58 | 1 |
2376 | 57631 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 724 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1976 12:00:00 AM | 8 | Permit Number 16529 | 6004511.94268 | 2110995.61836 | 37.7766467538829 | -122.427907235555 | (37.7766467538829, -122.427907235555) | 7 | 9 | 11 | 28852 | 10 | |
19717 | 47020 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 521 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 4 | Permit Number 45015 | 6004890.00739 | 2110720.29512 | 37.7759121642541 | -122.426579788542 | (37.7759121642541, -122.426579788542) | 7 | 9 | 11 | 28852 | 10 | |
22465 | 136051 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 584 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004614.40707 | 2110680.65398 | 37.7757877349621 | -122.427530336862 | (37.7757877349621, -122.427530336862) | 7 | 9 | 11 | 28852 | 10 | |||
22899 | 238577 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 133 Buchanan St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6004747.18096 | 2108954.98025 | 37.771056963743 | -122.426948105892 | (37.771056963743, -122.426948105892) | 7 | 9 | 11 | 28852 | 10 | |||
24045 | 141370 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001204.6932 | 2110218.0701 | 37.7743241488087 | -122.439292208301 | (37.7743241488087, -122.439292208301) | 15 | 5 | 11 | 29492 | 10 | |||
30391 | 239020 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 482 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004672.88732 | 2110370.92399 | 37.7749405996584 | -122.427305970394 | (37.7749405996584, -122.427305970394) | 7 | 9 | 11 | 28852 | 10 | |||
32892 | 238578 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 149 Buchanan St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6004732.39628 | 2109051.52361 | 37.7713212124262 | -122.427006123859 | (37.7713212124262, -122.427006123859) | 7 | 9 | 11 | 28852 | 10 | |||
53920 | 33647 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 532 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 6 | Permit Number 47617 | 6004852.49961 | 2110739.683 | 37.7759632781281 | -122.426710918693 | (37.7759632781281, -122.426710918693) | 7 | 9 | 11 | 28852 | 10 | |
92612 | 238575 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 1 | : | Tree | Private 2 | 05/02/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 45000 | 6004751.79623 | 2108930.40583 | 37.7709897493005 | -122.426930391028 | (37.7709897493005, -122.426930391028) | 7 | 9 | 11 | 28852 | 10 | |
94425 | 115309 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 500x Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2x2 | 6004961.03279 | 2110755.75124 | 37.776013533141 | -122.426336618167 | (37.776013533141, -122.426336618167) | 7 | 9 | 11 | 28852 | 10 | |||
94982 | 239017 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 420 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004649.23928 | 2110026.77374 | 37.7739943096302 | -122.427363252712 | (37.7739943096302, -122.427363252712) | 7 | 9 | 11 | 28852 | 10 | |||
116083 | 239015 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 380 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004736.9455 | 2110029.27372 | 37.7740061339081 | -122.427060040012 | (37.7740061339081, -122.427060040012) | 7 | 9 | 11 | 28852 | 10 | |||
122436 | 239021 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 530 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004598.87911 | 2110377.72269 | 37.7749550814495 | -122.427562465139 | (37.7749550814495, -122.427562465139) | 7 | 9 | 11 | 28852 | 10 | |||
135006 | 136050 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 584 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004583.8437 | 2110676.25728 | 37.7757739339551 | -122.427635749998 | (37.7757739339551, -122.427635749998) | 7 | 9 | 11 | 28852 | 10 | |||
143442 | 141371 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 430 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001203.2035 | 2110227.5052 | 37.7743499704497 | -122.439298037861 | (37.7743499704497, -122.439298037861) | 15 | 5 | 11 | 29492 | 10 | |||
146323 | 238579 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 415 Buchanan St | 1 | : | Tree | Private 2 | 7 | Width 6ft | 6004609.7624 | 2109940.50049 | 37.7737551915801 | -122.427493662508 | (37.7737551915801, -122.427493662508) | 7 | 9 | 11 | 28852 | 10 | |||
147344 | 239016 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 399 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004681.24572 | 2110023.15394 | 37.773986180653 | -122.427252279074 | (37.773986180653, -122.427252279074) | 7 | 9 | 11 | 28852 | 10 | |||
170138 | 239019 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 539 Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004833.64681 | 2110391.58665 | 37.7750064246485 | -122.426751340518 | (37.7750064246485, -122.426751340518) | 7 | 9 | 11 | 28852 | 10 | |||
183526 | 239018 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 420 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004647.99887 | 2110037.75326 | 37.7740243865621 | -122.427368325805 | (37.7740243865621, -122.427368325805) | 7 | 9 | 11 | 28852 | 10 | |||
190946 | 238580 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 519 Hickory St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) | 7 | 9 | 11 | 28852 | 10 | |||
192405 | 238576 | Private 9 | Prunus x yedoensis :: Yoshino Cherry 77 | 127 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | 3 | Width 3ft | Permit Number 782890 | 6004764 | 2108902 | 37.7709124438039 | -122.42688615445 | (37.7709124438039, -122.42688615445) | 7 | 9 | 11 | 28852 | 10 | |
24291 | 123575 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 118 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994297.68738 | 2114732.87451 | 37.7863251158785 | -122.463512352181 | (37.7863251158785, -122.463512352181) | 11 | 6 | 1 | 54 | 11 | |||
51211 | 122964 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 5ft | 5993049.94359 | 2114912.63546 | 37.7867467201865 | -122.467842267803 | (37.7867467201865, -122.467842267803) | 11 | 6 | 1 | 54 | 11 | |||
70516 | 123029 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 730 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5991968.39214 | 2110452.13533 | 37.7744368966539 | -122.471259036935 | (37.7744368966539, -122.471259036935) | 11 | 6 | 2 | 54 | 11 | |||
83042 | 123363 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5994763.50549 | 2110414.96281 | 37.7744961151162 | -122.461587583233 | (37.7744961151162, -122.461587583233) | 11 | 6 | 2 | 54 | 11 | |||
97447 | 84400 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 611-613 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51577 | 5993447.66428 | 2111301.75717 | 37.7768551863663 | -122.466203752377 | (37.7768551863663, -122.466203752377) | 11 | 6 | 2 | 54 | 11 | |
103313 | 122967 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 98 09th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993050.69162 | 2114890.11462 | 37.7866849273422 | -122.467838041215 | (37.7866849273422, -122.467838041215) | 11 | 6 | 1 | 54 | 11 | |||
140943 | 38818 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 221 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2005 12:00:00 AM | 4 | Permit Number 47857 | 5994895.35063 | 2113953.79381 | 37.7842203879728 | -122.461388106023 | (37.7842203879728, -122.461388106023) | 11 | 6 | 2 | 54 | 11 | |
152029 | 123081 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 756 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992285.07246 | 2110293.11916 | 37.7740185941965 | -122.470152007973 | (37.7740185941965, -122.470152007973) | 11 | 6 | 2 | 54 | 11 | |||
182789 | 123365 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5994764.07466 | 2110395.82025 | 37.7744435874791 | -122.461584226231 | (37.7744435874791, -122.461584226231) | 11 | 6 | 2 | 54 | 11 | |||
183292 | 123364 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 770 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994764.09915 | 2110406.2546 | 37.7744722388497 | -122.461584898177 | (37.7744722388497, -122.461584898177) | 11 | 6 | 2 | 54 | 11 | |||
187703 | 99226 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 112 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768858 | 5992130.04894 | 2114624.94934 | 37.7859036525669 | -122.47100389023 | (37.7859036525669, -122.47100389023) | 11 | 6 | 2 | 54 | 11 | |
192755 | 52450 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 672 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48563 | 5992577.48944 | 2110887.44098 | 37.7756673423473 | -122.469183761515 | (37.7756673423473, -122.469183761515) | 11 | 6 | 2 | 54 | 11 |
69930 | 57837 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1339 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2009 12:00:00 AM | 3x3 | Permit Number 52005 | 5994540.33028408 | 2106409.85629846 | 37.763486295989 | -122.46206907635 | (37.763486295989, -122.46206907635) | 1 | 5 | 11 | 56 | 12 | ||
137712 | 35083 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1541 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43889 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
146207 | 213717 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1783 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5991214.07731 | 2103294.38523 | 37.7547399684927 | -122.47334616449 | (37.7547399684927, -122.47334616449) | 1 | 8 | 4 | 56 | 12 | |||
147761 | 35082 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43889 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
166572 | 213719 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 306 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993051.46655 | 2103255.88389 | 37.754740477507 | -122.466989225694 | (37.754740477507, -122.466989225694) | 1 | 8 | 4 | 56 | 12 | |||
186719 | 213718 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1705 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992771.0421 | 2103829.02772 | 37.7562979917618 | -122.468000688697 | (37.7562979917618, -122.468000688697) | 1 | 8 | 4 | 56 | 12 | |||
36420 | 124156 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995846.07339 | 2112226.83412 | 37.7795332890719 | -122.457973944713 | (37.7795332890719, -122.457973944713) | 11 | 6 | 2 | 54 | 16 | |||
39652 | 124172 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 81 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995886.79128 | 2112251.90704 | 37.7796044719959 | -122.457834899878 | (37.7796044719959, -122.457834899878) | 11 | 6 | 2 | 54 | 16 | |||
79691 | 124155 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 970 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5995858.43793 | 2112228.39454 | 37.7795382839593 | -122.457931283713 | (37.7795382839593, -122.457931283713) | 11 | 6 | 2 | 54 | 16 | |||
84948 | 107672 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 184 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773528 | 5997643.33289 | 2112648.90363 | 37.7807952777935 | -122.45178694364 | (37.7807952777935, -122.45178694364) | 15 | 6 | 2 | 54 | 16 | |
135365 | 124512 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2656 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5996425.61433 | 2110792.8133 | 37.7756291250409 | -122.455865383128 | (37.7756291250409, -122.455865383128) | 11 | 6 | 2 | 54 | 16 | |||
27412 | 65777 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1796- 1796 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1990 12:00:00 AM | 3 | Permit Number 28742 | 6004431.04108 | 2118780.7342 | 37.7980181503743 | -122.428742211078 | (37.7980181503743, -122.428742211078) | 13 | 9 | 1 | 57 | 17 | |
48308 | 136039 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3434 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999787.69729 | 2120389.72868 | 37.8021721279018 | -122.44492518757 | (37.8021721279018, -122.44492518757) | 13 | 9 | 1 | 57 | 17 | |||
121753 | 136038 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2400 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001472.99161 | 2118372.51035 | 37.7967294155856 | -122.438948622379 | (37.7967294155856, -122.438948622379) | 13 | 9 | 1 | 57 | 17 | |||
128463 | 109327 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2015 12:00:00 AM | 3 | Permit Number 774911 | 6003963.48635 | 2119408.041 | 37.7997140999836 | -122.430404865987 | (37.7997140999836, -122.430404865987) | 13 | 9 | 1 | 57 | 17 | ||
158219 | 136036 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2901 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001479.25997 | 2118476.71669 | 37.7970158955175 | -122.438934404121 | (37.7970158955175, -122.438934404121) | 13 | 9 | 1 | 57 | 17 | |||
163299 | 136049 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2258 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999403.25073 | 2120854.72135 | 37.8034269240649 | -122.446289022013 | (37.8034269240649, -122.446289022013) | 13 | 9 | 1 | 57 | 17 | |||
169416 | 51703 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 54 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 3 | Permit Number 47979 | 6001520.69358 | 2121621.59135 | 37.805653247063 | -122.439016533799 | (37.805653247063, -122.439016533799) | 13 | 9 | 1 | 57 | 17 | ||
174724 | 136037 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2810 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001581.50265 | 2118066.63071 | 37.7958957233673 | -122.438551222785 | (37.7958957233673, -122.438551222785) | 13 | 9 | 1 | 57 | 17 | |||
182334 | 41184 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3414 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 4 | Permit Number 41902 | 5999801.39213 | 2120297.1759 | 37.8019187843817 | -122.4448711401 | (37.8019187843817, -122.4448711401) | 13 | 9 | 1 | 57 | 17 | |
21481 | 41610 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
25428 | 238585 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.58671 | 2103307.08135 | 37.7555862656019 | -122.424275817175 | (37.7555862656019, -122.424275817175) | 2 | 4 | 5 | 28859 | 19 | |||
26278 | 239005 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 250 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6005423.80449 | 2102247.03404 | 37.7526767636284 | -122.424130513718 | (37.7526767636284, -122.424130513718) | 2 | 4 | 5 | 28859 | 19 | |||
29597 | 238598 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006428.46561 | 2107477.24993 | 37.7670943907258 | -122.421027537902 | (37.7670943907258, -122.421027537902) | 8 | 4 | 7 | 28853 | 19 | |||
30515 | 238584 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 73 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005403.70836 | 2103296.31784 | 37.7555567183818 | -122.42427463098 | (37.7555567183818, -122.42427463098) | 2 | 4 | 5 | 28859 | 19 | |||
35128 | 5454 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 561 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2009 12:00:00 AM | 3 | 8 | 6004988.38949 | 2105109.00015 | 37.7605104576133 | -122.425839954961 | (37.7605104576133, -122.425839954961) | 2 | 4 | 5 | 28859 | 19 | ||
43319 | 239004 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1299 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010075.23485 | 2101730.69719 | 37.751520546657 | -122.40800856074 | (37.751520546657, -122.40800856074) | 2 | 4 | 7 | 28859 | 19 | |||
46845 | 238593 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006434.12493 | 2107338.12771 | 37.7667127130356 | -122.420998084205 | (37.7667127130356, -122.420998084205) | 8 | 4 | 7 | 28853 | 19 | |||
51859 | 238588 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006604.02075 | 2107329.38217 | 37.7666982753322 | -122.420409821465 | (37.7666982753322, -122.420409821465) | 8 | 4 | 7 | 28853 | 19 | |||
52717 | 5516 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.7560425375576 | -122.425422183901 | (37.7560425375576, -122.425422183901) | 2 | 4 | 5 | 28859 | 19 | ||
54637 | 238586 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 6011096.08107 | 2103736.70014 | 37.7570856908704 | -122.404619530365 | (37.7570856908704, -122.404619530365) | 10 | 4 | 8 | 28859 | 19 | |||
56637 | 239007 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009827.40599 | 2104524.43186 | 37.7591776380486 | -122.409062693893 | (37.7591776380486, -122.409062693893) | 2 | 4 | 7 | 28859 | 19 | |||
80849 | 238589 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006580.76101 | 2107327.1643 | 37.7666908748181 | -122.420490115647 | (37.7666908748181, -122.420490115647) | 8 | 4 | 7 | 28853 | 19 | |||
83140 | 41607 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
84425 | 41604 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
100212 | 238582 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 3456 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006754.5466 | 2100607.36077 | 37.7482496404132 | -122.41941224938 | (37.7482496404132, -122.41941224938) | 2 | 4 | 7 | 28859 | 19 | |||
104300 | 196537 | Planning Code 138.1 required 2 | Prunus x yedoensis :: Yoshino Cherry 77 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782869 | 6010635.96485 | 2105787.36101 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | 8 | 4 | 8 | 28859 | 19 | |
113302 | 238592 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006502.41381 | 2107324.73135 | 37.7666797789728 | -122.420760932989 | (37.7666797789728, -122.420760932989) | 8 | 4 | 7 | 28853 | 19 | |||
119873 | 239006 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009817.72923 | 2104524.2582 | 37.7591766191261 | -122.409096148662 | (37.7591766191261, -122.409096148662) | 2 | 4 | 7 | 28859 | 19 | |||
121757 | 238594 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006432.46991 | 2107376.01737 | 37.7668166557888 | -122.421006499155 | (37.7668166557888, -122.421006499155) | 8 | 4 | 7 | 28853 | 19 | |||
129057 | 238591 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1600 15th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006521.80542 | 2107326.31519 | 37.7666852207654 | -122.420693973056 | (37.7666852207654, -122.420693973056) | 8 | 4 | 7 | 28853 | 19 | |||
129753 | 238587 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 88 Hoff St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006547.66375 | 2106304.16095 | 37.763880083309 | -122.420531969171 | (37.763880083309, -122.420531969171) | 8 | 4 | 7 | 28859 | 19 | |||
132173 | 85064 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 57 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2007 12:00:00 AM | Permit Number 49430 | 6005948 | 2102270 | 37.7527694058254 | -122.422319381816 | (37.7527694058254, -122.422319381816) | 2 | 4 | 5 | 28859 | 19 | |||
139200 | 44049 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
143199 | 44048 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3388 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43579 | 6006265.44420171 | 2106129.68857398 | 37.7633851144388 | -122.421495691304 | (37.7633851144388, -122.421495691304) | 8 | 4 | 7 | 28859 | 19 | |||
144554 | 28271 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 1227 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5 | 6005204.12074 | 2101185.69152 | 37.7497501565604 | -122.424814719731 | (37.7497501565604, -122.424814719731) | 2 | 4 | 5 | 28859 | 19 | |||
147009 | 41609 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 3338 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |||
151721 | 41603 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 98X Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42107 | 6006559.89893522 | 2106145.26349714 | 37.7634444777116 | -122.420478371661 | (37.7634444777116, -122.420478371661) | 8 | 4 | 7 | 28859 | 19 | |
152123 | 43636 | Permitted Site 7 | Prunus x yedoensis :: Yoshino Cherry 77 | 375 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2000 12:00:00 AM | Permit Number 43286 | 6006792.72953639 | 2101606.12998031 | 37.750994184096 | -122.419351056484 | (37.750994184096, -122.419351056484) | 2 | 4 | 7 | 28859 | 19 | ||
162237 | 238597 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 51 Julian Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6006428.61387 | 2107454.83624 | 37.7670328563946 | -122.421025433495 | (37.7670328563946, -122.421025433495) | 8 | 4 | 7 | 28853 | 19 | |||
162524 | 239008 | DPW Maintained 1 | Prunus x yedoensis :: Yoshino Cherry 77 | 2801 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009837.36864 | 2104524.2797 | 37.7591777783485 | -122.409028227385 | (37.7591777783485, -122.409028227385) | 2 | 4 | 7 | 28859 | 19 |
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) );