Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5597 | 5597 | 109327 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2015 12:00:00 AM | 3 | Permit Number 774911 | 6003963.48635 | 2119408.0409999997 | 37.7997140999836 | -122.430404865987 | (37.7997140999836, -122.430404865987) | ||
| 14320 | 14320 | 106887 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1040 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014179.56003 | 2106221.50204 | 37.764080267023104 | -122.394129552957 | (37.7640802670231, -122.394129552957) | ||
| 14662 | 14662 | 106889 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1040 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014125.2334199995 | 2106217.58962 | 37.764066504685104 | -122.394317180299 | (37.7640665046851, -122.394317180299) | ||
| 15926 | 15926 | 106888 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1040 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014142.8658 | 2106218.65545 | 37.7640704113316 | -122.39425626922501 | (37.7640704113316, -122.394256269225) | ||
| 16067 | 16067 | 57625 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1040 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2014 12:00:00 AM | 3 | Permit Number 773355 | 6014196.28428 | 2106222.11039 | 37.7640828669594 | -122.39407175081399 | (37.7640828669594, -122.394071750814) | ||
| 16818 | 16818 | 51361 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 50 Pomona St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014122.20154 | 2094470.50183 | 37.7318113167403 | -122.39350548730499 | (37.7318113167403, -122.393505487305) |
| 17462 | 17462 | 5454 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 561 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2009 12:00:00 AM | 3 | 8 | 6004988.38949 | 2105109.00015 | 37.76051045761329 | -122.42583995496099 | (37.7605104576133, -122.425839954961) | ||
| 18067 | 18067 | 5516 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 839 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 6X6 | 6005075.66356 | 2103479.99989 | 37.756042537557605 | -122.425422183901 | (37.7560425375576, -122.425422183901) | ||
| 18146 | 18146 | 47497 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 2550 Lyon St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45389 | 5999248.391583701 | 2117560.95181211 | 37.7943742700193 | -122.446587797735 | (37.7943742700193, -122.446587797735) | ||
| 18273 | 18273 | 4175 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 3812X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6005112.58146 | 2100504.2814700003 | 37.747873990890604 | -122.425082788743 | (37.7478739908906, -122.425082788743) | ||
| 18416 | 18416 | 10006 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 165 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1991 12:00:00 AM | 6 | 3X2 | 6005478.902319999 | 2108028.91066 | 37.76855554623621 | -122.42435117768999 | (37.7685555462362, -122.42435117769) | ||
| 20926 | 20926 | 28271 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 1227 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5 | 6005204.12074 | 2101185.69152 | 37.749750156560395 | -122.424814719731 | (37.7497501565604, -122.424814719731) | |||
| 21108 | 21108 | 5697 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1551 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2007 12:00:00 AM | 3 | 6X6 | 6005311.69042 | 2099268.6032 | 37.7444923466503 | -122.424306405838 | (37.7444923466503, -122.424306405838) | ||
| 21328 | 21328 | 4211 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 3935 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004300.14403 | 2100415.02402 | 37.7475829828864 | -122.427885801087 | (37.7475829828864, -122.427885801087) | |||
| 21603 | 21603 | 4162 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 3754 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2011 12:00:00 AM | 3 | 3X3 | 6005539.04385 | 2100528.63943 | 37.7479649537167 | -122.42360983143801 | (37.7479649537167, -122.423609831438) | ||
| 22911 | 22911 | 238577 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 133 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004747.18096 | 2108954.98025 | 37.771056963743 | -122.426948105892 | (37.771056963743, -122.426948105892) | |||
| 23458 | 23458 | 40046 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1732 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767656 | 6014557.3351 | 2095185.1065900002 | 37.7337976439298 | -122.392051083889 | (37.7337976439298, -122.392051083889) |
| 23468 | 23468 | 136049 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2258 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999403.25073 | 2120854.72135 | 37.8034269240649 | -122.44628902201299 | (37.8034269240649, -122.446289022013) | |||
| 23912 | 23912 | 118028 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 51 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5984316.15967 | 2112798.24876 | 37.780433038793 | -122.49790243493 | (37.780433038793, -122.49790243493) | |||
| 24107 | 24107 | 120282 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 129 24th Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5988304.19862 | 2115114.50046 | 37.787025803891204 | -122.484276029631 | (37.7870258038912, -122.484276029631) | ||||
| 24828 | 24828 | 84481 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 59 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50146 | 6012081.070309999 | 2095312.02235 | 37.7340083335059 | -122.40062123629 | (37.7340083335059, -122.40062123629) | |
| 25056 | 25056 | 136041 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3399 Jackson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5998034.28644 | 2116116.0882900003 | 37.7903376361102 | -122.450684503481 | (37.7903376361102, -122.450684503481) | |||
| 25114 | 25114 | 249640 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999291.5931400005 | 2117167.12216 | 37.79329538582 | -122.446409970041 | (37.79329538582, -122.446409970041) | ||||
| 25162 | 25162 | 120283 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 139 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988317.15466 | 2115062.63745 | 37.786884157218 | -122.484227400222 | (37.786884157218, -122.484227400222) | ||||
| 25887 | 25887 | 239010 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 60 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010651.97236 | 2100432.84922 | 37.747989214748 | -122.405922704693 | (37.747989214748, -122.405922704693) | |||
| 26067 | 26067 | 46559 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 2631 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 1 | Permit Number 44696 | 5989232.26129309 | 2097435.52728728 | 37.7385381283555 | -122.47977106043501 | (37.7385381283555, -122.479771060435) | ||
| 26446 | 26446 | 238580 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 519 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) | |||
| 26465 | 26465 | 213721 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5993647.57824 | 2097426.08398 | 37.7387677148629 | -122.46450445281401 | (37.7387677148629, -122.464504452814) | ||||
| 26485 | 26485 | 196539 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1751 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012100.68573 | 2106521.94936 | 37.764789462490604 | -122.40134093046301 | (37.7647894624906, -122.401340930463) | |||
| 27493 | 27493 | 136046 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 20 Cherry St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5996087.67176 | 2116001.0032200003 | 37.789910026470004 | -122.45741128312001 | (37.78991002647, -122.45741128312) | ||||
| 28454 | 28454 | 106790 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 174 FAIRMOUNT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x6 | 6004503.2 | 2097272.2 | 37.7389649933023 | -122.426959842808 | (37.7389649933023, -122.426959842808) | |||
| 29799 | 29799 | 52709 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1@ JACKSON Cherry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2006 12:00:00 AM | 8 | Permit Number 48767 | 5996047.33493 | 2115997.05017 | 37.7898968555268 | -122.457550557933 | (37.7898968555268, -122.457550557933) | ||
| 30441 | 30441 | 196549 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 40 Ledyard St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011616.35938 | 2095078.6456799998 | 37.7333416013201 | -122.402211492182 | (37.7333416013201, -122.402211492182) | |||
| 32116 | 32116 | 238599 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 700 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007470.12204 | 2105516.97902 | 37.761770607447296 | -122.41728566930901 | (37.7617706074473, -122.417285669309) | |||
| 32816 | 32816 | 202152 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1951 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 7ft | 6013046.17664 | 2093441.4035900002 | 37.7289257780866 | -122.397153419018 | (37.7289257780866, -122.397153419018) | |||
| 34073 | 34073 | 83672 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 76 Santa Fe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52299 | 6012122.94965 | 2095206.11599 | 37.7337198723641 | -122.40046900895399 | (37.7337198723641, -122.400469008954) | |
| 34163 | 34163 | 61899 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 335 Maple St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1985 12:00:00 AM | 5 | Permit Number 21942 | 5996649.71832 | 2115128.18725 | 37.7875457744774 | -122.455403556547 | (37.7875457744774, -122.455403556547) | ||
| 34414 | 34414 | 249641 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2460 Lyon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999290.35855 | 2117187.34 | 37.7933508281386 | -122.44641569694599 | (37.7933508281386, -122.446415696946) | ||||
| 34641 | 34641 | 31877 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 457 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984054.95538 | 2112747.63581 | 37.780278753599895 | -122.49880230879499 | (37.7802787535999, -122.498802308795) | ||
| 34688 | 34688 | 239029 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 26 Harry St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003326.300869999 | 2097748.91757 | 37.740207332512796 | -122.431063031234 | (37.7402073325128, -122.431063031234) | |||
| 34745 | 34745 | 122200 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 171 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991476.58631 | 2114290.78647 | 37.784948318390995 | -122.473240288339 | (37.784948318391, -122.473240288339) | |||
| 34795 | 34795 | 238591 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1600 15th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6006521.80542 | 2107326.31519 | 37.7666852207654 | -122.42069397305599 | (37.7666852207654, -122.420693973056) | |||
| 35008 | 35008 | 250159 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999252.38937 | 2117479.90418 | 37.79415196309329 | -122.44656813112302 | (37.7941519630933, -122.446568131123) | ||||
| 35270 | 35270 | 239018 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 420 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6004647.998869999 | 2110037.7532599997 | 37.7740243865621 | -122.42736832580499 | (37.7740243865621, -122.427368325805) | |||
| 35400 | 35400 | 238585 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 73 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6005403.5867099995 | 2103307.08135 | 37.7555862656019 | -122.424275817175 | (37.7555862656019, -122.424275817175) | |||
| 35546 | 35546 | 239008 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2801 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009837.36864 | 2104524.2797 | 37.7591777783485 | -122.40902822738501 | (37.7591777783485, -122.409028227385) | |||
| 36090 | 36090 | 124683 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3899 Jackson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5995553.12452 | 2115771.60073 | 37.789249431740295 | -122.459244137371 | (37.7892494317403, -122.459244137371) | |||
| 36563 | 36563 | 202259 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013218.01399 | 2093376.8881599999 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | ||||
| 37158 | 37158 | 124379 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 37 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5996169.18438 | 2114263.97819 | 37.785145303793996 | -122.457003563892 | (37.785145303794, -122.457003563892) | |||
| 37530 | 37530 | 249638 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5999293.71803 | 2117149.90797 | 37.7932482415769 | -122.446401378842 | (37.7932482415769, -122.446401378842) | ||||
| 37648 | 37648 | 239009 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 60 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010637.01006 | 2100427.5195 | 37.747973743687794 | -122.405974068569 | (37.7479737436878, -122.405974068569) | |||
| 37677 | 37677 | 82345 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 254 Dublin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774176 | 6003940.30685 | 2088972.31262 | 37.716143507894294 | -122.428314680584 | (37.7161435078943, -122.428314680584) | |
| 38413 | 38413 | 52711 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1@ JACKSON Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2006 12:00:00 AM | 5 | Permit Number 48767 | 5996055.9612 | 2115990.01738 | 37.7898780408886 | -122.45752020296301 | (37.7898780408886, -122.457520202963) | ||
| 39099 | 39099 | 57747 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 3425 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/1977 12:00:00 AM | 8 | Permit Number 16667 | 5997831.65027 | 2116097.2527 | 37.7902743175622 | -122.45138424801 | (37.7902743175622, -122.45138424801) | ||
| 39605 | 39605 | 196537 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010635.96485 | 2105787.3610099996 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | |||
| 40125 | 40125 | 239006 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2801 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009817.729230001 | 2104524.2582 | 37.7591766191261 | -122.409096148662 | (37.7591766191261, -122.409096148662) | |||
| 41280 | 41280 | 124684 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3899 Jackson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5995566.4285 | 2115772.64492 | 37.7892530636592 | -122.459198183151 | (37.7892530636592, -122.459198183151) | |||
| 42356 | 42356 | 238592 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1600 15th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6006502.41381 | 2107324.73135 | 37.7666797789728 | -122.42076093298901 | (37.7666797789728, -122.420760932989) | |||
| 42905 | 42905 | 51703 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 54 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | 3 | Permit Number 47979 | 6001520.693580001 | 2121621.59135 | 37.805653247063 | -122.439016533799 | (37.805653247063, -122.439016533799) | ||
| 44190 | 44190 | 249661 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999232.658419999 | 2117208.86838 | 37.7934066436505 | -122.446616892353 | (37.7934066436505, -122.446616892353) | ||||
| 44257 | 44257 | 122964 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 98 09th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 5993049.94359 | 2114912.63546 | 37.7867467201865 | -122.46784226780301 | (37.7867467201865, -122.467842267803) | |||
| 45545 | 45545 | 250151 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2501 Lyon St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5999220.87756 | 2117406.8173700003 | 37.7939494861264 | -122.446671903881 | (37.7939494861264, -122.446671903881) | ||||
| 45709 | 45709 | 114678 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 726 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774712 | 6011027.757019999 | 2091361.80007 | 37.7231030455441 | -122.40398499123998 | (37.7231030455441, -122.40398499124) | ||
| 47285 | 47285 | 239027 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 26 Harry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6003403.2403 | 2097795.0981400004 | 37.740338493218005 | -122.43080030059299 | (37.740338493218, -122.430800300593) | ||||
| 47381 | 47381 | 239017 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 420 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004649.23928 | 2110026.77374 | 37.773994309630204 | -122.427363252712 | (37.7739943096302, -122.427363252712) | |||
| 47644 | 47644 | 136048 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 20 Cherry St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5996075.48126 | 2116002.11474 | 37.7899123782026 | -122.457453541344 | (37.7899123782026, -122.457453541344) | ||||
| 48164 | 48164 | 238594 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 51 Julian Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6006432.4699099995 | 2107376.01737 | 37.7668166557888 | -122.42100649915501 | (37.7668166557888, -122.421006499155) | |||
| 48169 | 48169 | 238589 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1600 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6006580.76101 | 2107327.1643 | 37.7666908748181 | -122.420490115647 | (37.7666908748181, -122.420490115647) | |||
| 48191 | 48191 | 31876 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 457 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 2 | Permit Number 35315 | 5984053.55944 | 2112762.76101 | 37.7803202011246 | -122.49880825564199 | (37.7803202011246, -122.498808255642) | ||
| 48466 | 48466 | 124156 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 970 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995846.0733900005 | 2112226.8341200002 | 37.7795332890719 | -122.457973944713 | (37.7795332890719, -122.457973944713) | |||
| 48638 | 48638 | 97484 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 50 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 3 | Permit Number 768208 | 5989917.9579 | 2114856.7979599996 | 37.786412055749395 | -122.47867399180001 | (37.7864120557494, -122.4786739918) | ||
| 48864 | 48864 | 50856 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 743 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47371 | 5985677.37672 | 2110827.17931 | 37.7751007543065 | -122.493048175392 | (37.7751007543065, -122.493048175392) | ||
| 48966 | 48966 | 196545 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 938 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6011854.06587 | 2104027.62304 | 37.7579268348784 | -122.40201856510599 | (37.7579268348784, -122.402018565106) | |||
| 49188 | 49188 | 239016 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 399 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004681.24572 | 2110023.15394 | 37.773986180653 | -122.427252279074 | (37.773986180653, -122.427252279074) | |||
| 50029 | 50029 | 239015 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 380 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004736.9455 | 2110029.27372 | 37.7740061339081 | -122.427060040012 | (37.7740061339081, -122.427060040012) | |||
| 51077 | 51077 | 202184 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1900 Armstrong Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6013198.98425 | 2093399.22832 | 37.7288184790723 | -122.396622193069 | (37.7288184790723, -122.396622193069) | ||||
| 51164 | 51164 | 196547 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 970 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 6ft | 6012751.3239400005 | 2103003.6751599996 | 37.7551653352247 | -122.398843585967 | (37.7551653352247, -122.398843585967) | |||
| 51654 | 51654 | 123364 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 770 04th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994764.09915 | 2110406.2546 | 37.774472238849704 | -122.461584898177 | (37.7744722388497, -122.461584898177) | |||
| 51933 | 51933 | 136039 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3434 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5999787.6972900005 | 2120389.7286799997 | 37.8021721279018 | -122.44492518756999 | (37.8021721279018, -122.44492518757) | |||
| 52033 | 52033 | 136050 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 584 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004583.8437 | 2110676.25728 | 37.7757739339551 | -122.427635749998 | (37.7757739339551, -122.427635749998) | |||
| 52342 | 52342 | 123363 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 770 04th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994763.50549 | 2110414.96281 | 37.77449611511621 | -122.461587583233 | (37.7744961151162, -122.461587583233) | |||
| 52492 | 52492 | 238598 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 51 Julian Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6006428.46561 | 2107477.24993 | 37.7670943907258 | -122.42102753790199 | (37.7670943907258, -122.421027537902) | |||
| 52627 | 52627 | 98408 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | ||
| 52660 | 52660 | 136037 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2810 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001581.50265 | 2118066.6307099997 | 37.795895723367295 | -122.438551222785 | (37.7958957233673, -122.438551222785) | |||
| 52889 | 52889 | 238582 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3456 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006754.5466 | 2100607.36077 | 37.748249640413206 | -122.41941224938 | (37.7482496404132, -122.41941224938) | |||
| 53262 | 53262 | 238586 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 991 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6011096.081069999 | 2103736.7001400003 | 37.7570856908704 | -122.40461953036501 | (37.7570856908704, -122.404619530365) | |||
| 53345 | 53345 | 249662 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2401 Lyon St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999235.55005 | 2117182.1724900003 | 37.79333350898529 | -122.446604965544 | (37.7933335089853, -122.446604965544) | ||||
| 54122 | 54122 | 239022 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 927 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6004402.676659999 | 2103488.0295 | 37.7560265386112 | -122.42775016985 | (37.7560265386112, -122.42775016985) | |||
| 54449 | 54449 | 196542 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1751 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012149.9266099995 | 2106523.64769 | 37.7647968728895 | -122.401170737335 | (37.7647968728895, -122.401170737335) | |||
| 54569 | 54569 | 136042 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 3399 Jackson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5998049.07867 | 2116118.00061 | 37.7903437335326 | -122.450633461567 | (37.7903437335326, -122.450633461567) | |||
| 55272 | 55272 | 179170 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 179 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001259.83204 | 2087347.3317200001 | 37.7115296332658 | -122.437463366848 | (37.7115296332658, -122.437463366848) | |||
| 55668 | 55668 | 213724 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5993565.41473 | 2097500.59466 | 37.738967565793295 | -122.46479394281 | (37.7389675657933, -122.46479394281) | ||||
| 55912 | 55912 | 239013 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 218 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6004120.43982 | 2107419.42718 | 37.766805248776606 | -122.429006525427 | (37.7668052487766, -122.429006525427) | |||
| 55981 | 55981 | 213730 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 290 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992101.64901 | 2095002.4809700001 | 37.732023872386996 | -122.46967311023701 | (37.732023872387, -122.469673110237) | |||
| 56136 | 56136 | 239026 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1340 Treat Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008687.9198 | 2100899.65847 | 37.7491609288407 | -122.412747338613 | (37.7491609288407, -122.412747338613) | |||
| 58499 | 58499 | 115309 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 500x Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6004961.032790001 | 2110755.75124 | 37.776013533141 | -122.426336618167 | (37.776013533141, -122.426336618167) | |||
| 58851 | 58851 | 114198 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1701x 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6012211.95597 | 2106527.54933 | 37.7648110462088 | -122.400956466675 | (37.7648110462088, -122.400956466675) | |||
| 59023 | 59023 | 122199 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 171 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991475.81854 | 2114309.23252 | 37.7849989216744 | -122.47324429032899 | (37.7849989216744, -122.473244290329) | |||
| 59320 | 59320 | 50359 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 1044 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 5 | Permit Number 47031 | 6014195.81741 | 2102278.81797 | 37.753255413506 | -122.3937973317 | (37.753255413506, -122.3937973317) | ||
| 59776 | 59776 | 41184 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 3414 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 4 | Permit Number 41902 | 5999801.3921300005 | 2120297.1759 | 37.801918784381705 | -122.4448711401 | (37.8019187843817, -122.4448711401) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");