Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131343 | 131343 | 39995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) |
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 153474 | 153474 | 196471 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | |||
| 102400 | 102400 | 6398 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977002 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | ||
| 88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
| 145234 | 145234 | 14624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.38008243669701 | (37.7314135402286, -122.380082436697) | ||
| 174583 | 174583 | 196509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6017994.96949 | 2094236.9761 | 37.731384523654704 | -122.380100165912 | (37.7313845236547, -122.380100165912) | |||
| 78561 | 78561 | 14625 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.2737729999 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | ||
| 181027 | 181027 | 196510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Matthew Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017931.224780001 | 2094293.63767 | 37.7315365882339 | -122.380324481997 | (37.7315365882339, -122.380324481997) | |||
| 83650 | 83650 | 4016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/27/2000 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) | ||
| 64185 | 64185 | 196507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016757.4280199995 | 2094967.1096700002 | 37.7333209726796 | -122.384429453683 | (37.7333209726796, -122.384429453683) | |||
| 34005 | 34005 | 196506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6016688.4000699995 | 2094936.9316 | 37.7332342924349 | -122.384666003252 | (37.7332342924349, -122.384666003252) | |||
| 159334 | 159334 | 196508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 97 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016637.34398 | 2094986.73553 | 37.7333682203685 | -122.38484598815901 | (37.7333682203685, -122.384845988159) | |||
| 9424 | 9424 | 16412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 9468 | 9468 | 16413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 97122 | 97122 | 16435 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1299X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | ||
| 101983 | 101983 | 16450 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 107698 | 107698 | 16451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2009 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 133460 | 133460 | 196469 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015764.4296 | 2101073.59632 | 37.750033173207 | -122.388288593857 | (37.750033173207, -122.388288593857) | |||
| 104746 | 104746 | 52158 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1418 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | Permit Number 48350 | 6015559.23625291 | 2093031.45294248 | 37.727939717782895 | -122.388436912151 | (37.7279397177829, -122.388436912151) | ||
| 151967 | 151967 | 196468 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.38875552004801 | (37.7500044578413, -122.388755520048) | |||
| 14286 | 14286 | 27729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.75028138877779 | -122.38878504659999 | (37.7502813887778, -122.3887850466) | ||
| 34283 | 34283 | 71395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1553 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015450.35777 | 2096531.9462 | 37.7375453329415 | -122.389057616714 | (37.7375453329415, -122.389057616714) | ||
| 13686 | 13686 | 27731 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | ||
| 63276 | 63276 | 59606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.9972599996 | 37.7582606677124 | -122.38918270881099 | (37.7582606677124, -122.389182708811) | |
| 51355 | 51355 | 196467 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6015482.81101 | 2101057.8670900003 | 37.7499743755266 | -122.389261356351 | (37.7499743755266, -122.389261356351) | |||
| 171137 | 171137 | 196466 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015450.2681 | 2101056.0343 | 37.7499675388841 | -122.389373764399 | (37.7499675388841, -122.389373764399) | |||
| 94527 | 94527 | 96396 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 3x3 | Permit Number 767136 | 6015449.8 | 2105317.4 | 37.7616683177051 | -122.389672976331 | (37.7616683177051, -122.389672976331) | ||
| 13815 | 13815 | 27724 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.113480001 | 2101161.82636 | 37.750252634763996 | -122.389717121075 | (37.750252634764, -122.389717121075) | ||
| 55544 | 55544 | 196465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015262.99985 | 2101056.82815 | 37.7499593343528 | -122.39002140848801 | (37.7499593343528, -122.390021408488) | |||
| 15791 | 15791 | 27728 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015202.17288 | 2101166.08495 | 37.750255956855 | -122.390239385253 | (37.750255956855, -122.390239385253) | ||
| 50959 | 50959 | 196483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 65 Colin P Kelly Jr St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015356.8087 | 2112701.6743900003 | 37.7819387497011 | -122.39051059018699 | (37.7819387497011, -122.390510590187) | |||
| 170802 | 170802 | 196438 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015044.32759 | 2101169.27402 | 37.7502559568629 | -122.390785451805 | (37.7502559568629, -122.390785451805) | |||
| 68841 | 68841 | 196464 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015016.3527 | 2101061.7401099997 | 37.7499591392145 | -122.390874677125 | (37.7499591392145, -122.390874677125) | |||
| 67796 | 67796 | 196439 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015016.02089 | 2101171.05558 | 37.7502592780626 | -122.39088346350401 | (37.7502592780626, -122.390883463504) | |||
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 28434 | 28434 | 196463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1301 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014925.6309 | 2101062.89752 | 37.7499572830217 | -122.39118848116999 | (37.7499572830217, -122.39118848117) | |||
| 31805 | 31805 | 196440 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014910.39402 | 2101173.59345 | 37.7502603851252 | -122.391248908417 | (37.7502603851252, -122.391248908417) | |||
| 67099 | 67099 | 83292 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1722 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52353 | 6014576.18583 | 2096214.42431 | 37.7366249865567 | -122.39205786839199 | (37.7366249865567, -122.392057868392) | |
| 55895 | 55895 | 40019 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Latona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 6 | Permit Number 41264 | 6014412.91208 | 2094585.9323200001 | 37.732144413937796 | -122.392508504263 | (37.7321444139378, -122.392508504263) | |
| 184937 | 184937 | 36732 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39511 | 6014611.904019999 | 2112877.2892299998 | 37.7823795964711 | -122.393099929045 | (37.7823795964711, -122.393099929045) | |
| 70449 | 70449 | 42715 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 43 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 10 | Permit Number 42728 | 6014158.74539 | 2094459.1278900001 | 37.731782116644794 | -122.393378351035 | (37.7317821166448, -122.393378351035) | |
| 152059 | 152059 | 65922 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | 6 | Permit Number 28938 | 6014500.58115 | 2112811.20719 | 37.7821919655182 | -122.393480434 | (37.7821919655182, -122.393480434) | |
| 93623 | 93623 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 103824 | 103824 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 114698 | 114698 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 172812 | 172812 | 196484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014481.0981 | 2112803.55306 | 37.7821698664821 | -122.393547301273 | (37.7821698664821, -122.393547301273) | |||
| 71271 | 71271 | 196492 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6014449.0241 | 2112477.93082 | 37.7812739996458 | -122.393635466299 | (37.7812739996458, -122.393635466299) | |||
| 167320 | 167320 | 196491 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014437.84547 | 2112488.6537099998 | 37.7813028211009 | -122.393674889898 | (37.7813028211009, -122.393674889898) | |||
| 131055 | 131055 | 196490 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014419.45189 | 2112508.88507 | 37.781357349710795 | -122.39373993965499 | (37.7813573497108, -122.393739939655) | |||
| 58101 | 58101 | 196489 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Jack London Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014409.66856 | 2112518.16121 | 37.781382276221706 | -122.393774434946 | (37.7813822762217, -122.393774434946) | |||
| 29741 | 29741 | 196461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542098999 | (37.7587393543665, -122.39411542099) | |||
| 55242 | 55242 | 196488 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014277.716990001 | 2112657.65169 | 37.781757951802504 | -122.394240695653 | (37.7817579518025, -122.394240695653) | |||
| 135168 | 135168 | 196487 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6014260.97705 | 2112675.46167 | 37.7818059234575 | -122.39429985577299 | (37.7818059234575, -122.394299855773) | |||
| 74304 | 74304 | 196486 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014249.44841 | 2112687.4163599997 | 37.7818381074737 | -122.394340577066 | (37.7818381074737, -122.394340577066) | |||
| 75240 | 75240 | 196485 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Jack London Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6014233.73328 | 2112701.00373 | 37.78187454172139 | -122.394395896169 | (37.7818745417214, -122.394395896169) | |||
| 183766 | 183766 | 196475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 58 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013844.58264 | 2093878.5960799998 | 37.730170634955705 | -122.39442385069401 | (37.7301706349557, -122.394423850694) | |||
| 46730 | 46730 | 40853 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | 11 | Permit Number 45449 | 6014213.93466 | 2112556.76874 | 37.781477404701 | -122.394454288235 | (37.781477404701, -122.394454288235) | |
| 116762 | 116762 | 4020 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 2X3 | 6013957.30178 | 2101067.5315943 | 37.7499162221241 | -122.39453736171801 | (37.7499162221241, -122.394537361718) | ||
| 13745 | 13745 | 4018 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1995 12:00:00 AM | 3 | 2X3 | 6013908.29896 | 2101074.88916 | 37.7499337000814 | -122.394707332299 | (37.7499337000814, -122.394707332299) | ||
| 49624 | 49624 | 196458 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013820.908980001 | 2101070.2514 | 37.7499161066554 | -122.395009208608 | (37.7499161066554, -122.395009208608) | |||
| 68445 | 68445 | 196459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013796.36432 | 2101069.01684 | 37.7499113519264 | -122.395093999398 | (37.7499113519264, -122.395093999398) | |||
| 81645 | 81645 | 104364 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Stillman St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013954.4 | 2112927.1 | 37.782479818597395 | -122.39537811084 | (37.7824798185974, -122.39537811084) | ||||
| 106003 | 106003 | 104361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Stillman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013954.4 | 2112927.1 | 37.782479818597395 | -122.39537811084 | (37.7824798185974, -122.39537811084) | ||||
| 141334 | 141334 | 104362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Stillman St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013954.4 | 2112927.1 | 37.782479818597395 | -122.39537811084 | (37.7824798185974, -122.39537811084) | ||||
| 144596 | 144596 | 104366 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Stillman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013954.4 | 2112927.1 | 37.782479818597395 | -122.39537811084 | (37.7824798185974, -122.39537811084) | ||||
| 144756 | 144756 | 104360 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Stillman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013954.4 | 2112927.1 | 37.782479818597395 | -122.39537811084 | (37.7824798185974, -122.39537811084) | ||||
| 15561 | 15561 | 43296 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 589 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775309 | 6013581.06232 | 2104334.57728 | 37.758865901566296 | -122.39606735184601 | (37.7588659015663, -122.396067351846) | ||
| 127709 | 127709 | 108189 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 490X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013735.53307 | 2112587.71036 | 37.781535757063104 | -122.396111508062 | (37.7815357570631, -122.396111508062) | ||||
| 73503 | 73503 | 37967 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 456 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013486.4792599995 | 2104950.0016 | 37.76055045945989 | -122.396437603638 | (37.7605504594599, -122.396437603638) | |
| 64152 | 64152 | 37966 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 456 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013485.30445 | 2104964.69116 | 37.7605907284002 | -122.396442696467 | (37.7605907284002, -122.396442696467) | |
| 147208 | 147208 | 196450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013387.24706 | 2101044.34817 | 37.7498208576628 | -122.39650702770001 | (37.7498208576628, -122.3965070277) | |||
| 158187 | 158187 | 196460 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 364 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013463.46293 | 2105385.87525 | 37.76174599211679 | -122.396547761567 | (37.7617459921168, -122.396547761567) | |||
| 59450 | 59450 | 196470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6013295.589480001 | 2097174.20298 | 37.7391891560441 | -122.39655273032899 | (37.7391891560441, -122.396552730329) | |||
| 77358 | 77358 | 47252 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | |
| 178948 | 178948 | 196451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013299.05466 | 2101039.80695 | 37.7498034800424 | -122.396811684714 | (37.7498034800424, -122.396811684714) | |||
| 2102 | 2102 | 196505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3536 Jennings St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6013064.418880001 | 2089502.0027700001 | 37.7181099951501 | -122.39681428375299 | (37.7181099951501, -122.396814283753) | |||
| 80258 | 80258 | 82918 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52501 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | |
| 86778 | 86778 | 82919 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
| 120968 | 120968 | 82634 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
| 129448 | 129448 | 82702 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
| 142036 | 142036 | 82701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
| 56860 | 56860 | 196452 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Cesar Chavez St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013266.78575 | 2101037.1874599997 | 37.7497944913407 | -122.396923089148 | (37.7497944913407, -122.396923089148) | |||
| 13759 | 13759 | 109718 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013027.725819999 | 2089252.6527099998 | 37.7174232872231 | -122.396923644015 | (37.7174232872231, -122.396923644015) | |||
| 73454 | 73454 | 109719 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013017.968169999 | 2089237.9100799998 | 37.7173822637496 | -122.39695633886002 | (37.7173822637496, -122.39695633886) | |||
| 58743 | 58743 | 109720 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013003.046630001 | 2089225.87008 | 37.7173483736975 | -122.39700707233999 | (37.7173483736975, -122.39700707234) | |||
| 53191 | 53191 | 102037 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 87806 | 87806 | 102038 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 124779 | 124779 | 102039 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 146079 | 146079 | 102036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 177891 | 177891 | 62079 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 595 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1985 12:00:00 AM | 14 | Permit Number 22161 | 6013301.58361 | 2104304.12984 | 37.7587667459021 | -122.397031791103 | (37.7587667459021, -122.397031791103) | |
| 171204 | 171204 | 109721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012983.30026 | 2089217.1759900001 | 37.717323402237 | -122.39707471754299 | (37.717323402237, -122.397074717543) | |||
| 61447 | 61447 | 109722 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012966.2543 | 2089212.97453 | 37.7173109169351 | -122.397133343428 | (37.7173109169351, -122.397133343428) | |||
| 180996 | 180996 | 196474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Neptune St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013054.126569999 | 2093955.76147 | 37.7303385419805 | -122.39716198774599 | (37.7303385419805, -122.397161987746) | |||
| 95982 | 95982 | 82672 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 69 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52500 | 6012954.77206528 | 2089215.57064421 | 37.7173174061263 | -122.397173214353 | (37.7173174061263, -122.397173214353) | ||
| 61906 | 61906 | 201275 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 6013023.37655 | 2092747.7881599998 | 37.7270199824665 | -122.39718362363399 | (37.7270199824665, -122.397183623634) | |||
| 170473 | 170473 | 82703 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52500 | 6012950.17329 | 2089208.10371 | 37.71729664739521 | -122.39718858698 | (37.7172966473952, -122.39718858698) | |
| 146355 | 146355 | 202308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 178 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6013012.36975 | 2092926.2043 | 37.7275092640335 | -122.39723417993099 | (37.7275092640335, -122.397234179931) | |||
| 162648 | 162648 | 82704 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 67 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | 6012930.127090001 | 2089200.7150299998 | 37.7172752435332 | -122.39725735994301 | (37.7172752435332, -122.397257359943) |
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");