trees
4,014 rows where qSpecies_id = 40 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6813 | 256911 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 26 Lily St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782765 | |||||||||||
153844 | 39995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 869 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2004 12:00:00 AM | 6 | 3x3 | Permit Number 47551 | 6019405.77873 | 2094282.05396 | 37.7315860320638 | -122.375225801726 | (37.7315860320638, -122.375225801726) | 10 | 3 | 8 | 58 | 1 |
70689 | 94959 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.378088153142 | (37.7364745658864, -122.378088153142) | 10 | 3 | 8 | 58 | 1 | ||||
142295 | 196471 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1 Middle Point Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6018269.46967 | 2096338.3756 | 37.7371696942217 | -122.379297066815 | (37.7371696942217, -122.379297066815) | 10 | 3 | 8 | 58 | 1 | |||
104059 | 6398 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | 10 | 3 | 8 | 58 | 1 | ||
64315 | 14623 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837712 | 37.7313920698281 | -122.380024515102 | (37.7313920698281, -122.380024515102) | 10 | 3 | 8 | 58 | 1 | ||
191921 | 14624 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.380082436697 | (37.7314135402286, -122.380082436697) | 10 | 3 | 8 | 58 | 1 | ||
150047 | 196509 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Matthew Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6017994.96949 | 2094236.9761 | 37.7313845236547 | -122.380100165912 | (37.7313845236547, -122.380100165912) | 10 | 3 | 8 | 58 | 1 | |||
40527 | 14625 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.273773 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | 10 | 3 | 8 | 58 | 1 | ||
151292 | 196510 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Matthew Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017931.22478 | 2094293.63767 | 37.7315365882339 | -122.380324481997 | (37.7315365882339, -122.380324481997) | 10 | 3 | 8 | 58 | 1 | |||
39148 | 4016 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 700X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/27/2000 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.382788188693 | (37.7506230149756, -122.382788188693) | 10 | 3 | 8 | 58 | 1 | ||
184209 | 196507 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016757.42802 | 2094967.10967 | 37.7333209726796 | -122.384429453683 | (37.7333209726796, -122.384429453683) | 10 | 3 | 8 | 58 | 1 | |||
59811 | 196506 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1301 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6016688.40007 | 2094936.9316 | 37.7332342924349 | -122.384666003252 | (37.7332342924349, -122.384666003252) | 10 | 3 | 8 | 58 | 1 | |||
87296 | 196508 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 97 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016637.34398 | 2094986.73553 | 37.7333682203685 | -122.384845988159 | (37.7333682203685, -122.384845988159) | 10 | 3 | 8 | 58 | 1 | |||
169456 | 16412 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | ||
171132 | 16413 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | ||
89163 | 16435 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1299X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | ||
107262 | 16450 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
120351 | 16451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1395 Newcomb Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/29/2009 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
171569 | 10995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016004.21156 | 2097242.69659 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | 10 | 3 | 8 | 58 | 1 | |||
180723 | 256031 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1431 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015779 | 2093470 | 37.7291560564579 | -122.387707761404 | (37.7291560564579, -122.387707761404) | 10 | 3 | 8 | 58 | 1 | ||||
124827 | 256030 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1439 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015739 | 2093499 | 37.7292334688727 | -122.387848068648 | (37.7292334688727, -122.387848068648) | 10 | 3 | 8 | 58 | 1 | ||||
124385 | 196469 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Cesar Chavez St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6015764.4296 | 2101073.59632 | 37.750033173207 | -122.388288593857 | (37.750033173207, -122.388288593857) | 10 | 3 | 8 | 58 | 1 | |||
124816 | 52158 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1418 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | Permit Number 48350 | 6015559.23625291 | 2093031.45294248 | 37.7279397177829 | -122.388436912151 | (37.7279397177829, -122.388436912151) | 10 | 3 | 8 | 58 | 1 | ||
160146 | 196468 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Cesar Chavez St | 12 | : | Tree | Private 2 | 8 | Width 3ft | 6015629.24905 | 2101065.86664 | 37.7500044578413 | -122.388755520048 | (37.7500044578413, -122.388755520048) | 10 | 3 | 8 | 58 | 1 | |||
52392 | 27729 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.7502813887778 | -122.3887850466 | (37.7502813887778, -122.3887850466) | 10 | 3 | 8 | 28856 | 1 | ||
3608 | 71395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1553 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015450.35777 | 2096531.9462 | 37.7375453329415 | -122.389057616714 | (37.7375453329415, -122.389057616714) | 10 | 3 | 8 | 58 | 1 | |||
31187 | 27731 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | 10 | 3 | 8 | 28856 | 1 | ||
156328 | 59606 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1077 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 1 | 3x3 | Permit Number 19007 | 6015566.4484 | 2104073.99726 | 37.7582606677124 | -122.389182708811 | (37.7582606677124, -122.389182708811) | 10 | 3 | 8 | 28856 | 29 | |
63494 | 196467 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Cesar Chavez St | 8 | : | Tree | Private 2 | 4 | Width 3ft | 6015482.81101 | 2101057.86709 | 37.7499743755266 | -122.389261356351 | (37.7499743755266, -122.389261356351) | 10 | 3 | 8 | 58 | 1 | |||
124323 | 196466 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Cesar Chavez St | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6015450.2681 | 2101056.0343 | 37.7499675388841 | -122.389373764399 | (37.7499675388841, -122.389373764399) | 10 | 3 | 8 | 58 | 1 | |||
83351 | 96396 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 800 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 3x3 | Permit Number 767136 | 6015449.8 | 2105317.4 | 37.7616683177051 | -122.389672976331 | (37.7616683177051, -122.389672976331) | 10 | 3 | 8 | 28856 | 29 | ||
22886 | 27724 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.11348 | 2101161.82636 | 37.750252634764 | -122.389717121075 | (37.750252634764, -122.389717121075) | 10 | 3 | 8 | 28856 | 1 | ||
160198 | 196465 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Cesar Chavez St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6015262.99985 | 2101056.82815 | 37.7499593343528 | -122.390021408488 | (37.7499593343528, -122.390021408488) | 10 | 3 | 8 | 58 | 1 | |||
136588 | 27728 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1200 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015202.17288 | 2101166.08495 | 37.750255956855 | -122.390239385253 | (37.750255956855, -122.390239385253) | 10 | 3 | 8 | 28856 | 1 | ||
14747 | 260897 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | ||||
17422 | 260898 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | ||||
126486 | 196483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 65 Colin P Kelly Jr St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015356.8087 | 2112701.67439 | 37.7819387497011 | -122.390510590187 | (37.7819387497011, -122.390510590187) | 6 | 2 | 9 | 28856 | 6 | |||
93608 | 196438 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015044.32759 | 2101169.27402 | 37.7502559568629 | -122.390785451805 | (37.7502559568629, -122.390785451805) | 10 | 3 | 8 | 28856 | 1 | |||
121388 | 196464 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1301 Cesar Chavez St | 6 | : | Tree | Private 2 | 9 | Width 3ft | 6015016.3527 | 2101061.74011 | 37.7499591392145 | -122.390874677125 | (37.7499591392145, -122.390874677125) | 10 | 3 | 8 | 58 | 1 | |||
191876 | 196439 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1300 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015016.02089 | 2101171.05558 | 37.7502592780626 | -122.390883463504 | (37.7502592780626, -122.390883463504) | 10 | 3 | 8 | 28856 | 1 | |||
29803 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1600X Oakdale Ave | 2 | Front Yard : Cutout | Tree | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.83637 | 37.735069048787 | -122.391004288315 | (37.735069048787, -122.391004288315) | 10 | 3 | 8 | 58 | 1 | |||
31761 | 196463 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1301 Cesar Chavez St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6014925.6309 | 2101062.89752 | 37.7499572830217 | -122.39118848117 | (37.7499572830217, -122.39118848117) | 10 | 3 | 8 | 58 | 1 | |||
68166 | 196440 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1400 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014910.39402 | 2101173.59345 | 37.7502603851252 | -122.391248908417 | (37.7502603851252, -122.391248908417) | 10 | 3 | 8 | 28856 | 1 | |||
49769 | 83292 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1722 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52353 | 6014576.18583 | 2096214.42431 | 37.7366249865567 | -122.392057868392 | (37.7366249865567, -122.392057868392) | 10 | 3 | 8 | 58 | 1 | |
59546 | 40019 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 12 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 6 | Permit Number 41264 | 6014412.91208 | 2094585.93232 | 37.7321444139378 | -122.392508504263 | (37.7321444139378, -122.392508504263) | 10 | 3 | 8 | 58 | 1 | |
98261 | 36732 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 South Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39511 | 6014611.90402 | 2112877.28923 | 37.7823795964711 | -122.393099929045 | (37.7823795964711, -122.393099929045) | 6 | 2 | 9 | 28856 | 6 | |
190180 | 42715 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 43 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 10 | Permit Number 42728 | 6014158.74539 | 2094459.12789 | 37.7317821166448 | -122.393378351035 | (37.7317821166448, -122.393378351035) | 10 | 3 | 8 | 58 | 1 | |
126194 | 65922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | 6 | Permit Number 28938 | 6014500.58115 | 2112811.20719 | 37.7821919655182 | -122.393480434 | (37.7821919655182, -122.393480434) | 6 | 2 | 9 | 28856 | 6 | |
78450 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
101013 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
135218 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 50 Pomona St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.393495086444 | (37.7317422564721, -122.393495086444) | 10 | 3 | 8 | 58 | 1 | ||||
147470 | 196484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 22 South Park | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014481.0981 | 2112803.55306 | 37.7821698664821 | -122.393547301273 | (37.7821698664821, -122.393547301273) | 6 | 2 | 9 | 28856 | 6 | |||
68283 | 196492 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014449.0241 | 2112477.93082 | 37.7812739996458 | -122.393635466299 | (37.7812739996458, -122.393635466299) | 6 | 2 | 9 | 28856 | 6 | |||
75212 | 196491 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014437.84547 | 2112488.65371 | 37.7813028211009 | -122.393674889898 | (37.7813028211009, -122.393674889898) | 6 | 2 | 9 | 28856 | 6 | |||
143063 | 196490 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014419.45189 | 2112508.88507 | 37.7813573497108 | -122.393739939655 | (37.7813573497108, -122.393739939655) | 6 | 2 | 9 | 28856 | 6 | |||
129562 | 196489 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014409.66856 | 2112518.16121 | 37.7813822762217 | -122.393774434946 | (37.7813822762217, -122.393774434946) | 6 | 2 | 9 | 28856 | 6 | |||
9279 | 196461 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 615 Mississippi St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542099 | (37.7587393543665, -122.39411542099) | 10 | 3 | 8 | 28856 | 29 | |||
7876 | 196488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014277.71699 | 2112657.65169 | 37.7817579518025 | -122.394240695653 | (37.7817579518025, -122.394240695653) | 6 | 2 | 9 | 28856 | 6 | |||
49289 | 196487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014260.97705 | 2112675.46167 | 37.7818059234575 | -122.394299855773 | (37.7818059234575, -122.394299855773) | 6 | 2 | 9 | 28856 | 6 | |||
172790 | 196486 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014249.44841 | 2112687.41636 | 37.7818381074737 | -122.394340577066 | (37.7818381074737, -122.394340577066) | 6 | 2 | 9 | 28856 | 6 | |||
85090 | 196485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Jack London Aly | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6014233.73328 | 2112701.00373 | 37.7818745417214 | -122.394395896169 | (37.7818745417214, -122.394395896169) | 6 | 2 | 9 | 28856 | 6 | |||
124216 | 196475 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 58 Ceres St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6013844.58264 | 2093878.59608 | 37.7301706349557 | -122.394423850694 | (37.7301706349557, -122.394423850694) | 10 | 3 | 8 | 58 | 1 | |||
184202 | 40853 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 126 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/2002 12:00:00 AM | 11 | Permit Number 45449 | 6014213.93466 | 2112556.76874 | 37.781477404701 | -122.394454288235 | (37.781477404701, -122.394454288235) | 6 | 2 | 9 | 28856 | 6 | |
169537 | 4020 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1760 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1995 12:00:00 AM | 3 | 2X3 | 6013957.30178 | 2101067.5315943 | 37.7499162221241 | -122.394537361718 | (37.7499162221241, -122.394537361718) | 10 | 3 | 8 | 58 | 1 | ||
173375 | 4018 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1760 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1995 12:00:00 AM | 3 | 2X3 | 6013908.29896 | 2101074.88916 | 37.7499337000814 | -122.394707332299 | (37.7499337000814, -122.394707332299) | 10 | 3 | 8 | 58 | 1 | ||
61693 | 196458 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1760 Cesar Chavez St | 4 | : | Tree | Private 2 | 4 | Width 2ft | 6013820.90898 | 2101070.2514 | 37.7499161066554 | -122.395009208608 | (37.7499161066554, -122.395009208608) | 10 | 3 | 8 | 58 | 1 | |||
192027 | 196459 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1760 Cesar Chavez St | 5 | : | Tree | Private 2 | 5 | Width 2ft | 6013796.36432 | 2101069.01684 | 37.7499113519264 | -122.395093999398 | (37.7499113519264, -122.395093999398) | 10 | 3 | 8 | 58 | 1 | |||
47299 | 104364 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
130909 | 104361 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
173357 | 104362 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
180426 | 104366 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
188115 | 104360 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
72009 | 43296 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 589 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775309 | 6013581.06232 | 2104334.57728 | 37.7588659015663 | -122.396067351846 | (37.7588659015663, -122.396067351846) | 10 | 3 | 8 | 28856 | 29 | ||
22165 | 108189 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 490X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013735.53307 | 2112587.71036 | 37.7815357570631 | -122.396111508062 | (37.7815357570631, -122.396111508062) | 6 | 2 | 9 | 28856 | 6 | ||||
60473 | 37967 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 456 Missouri St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013486.47926 | 2104950.0016 | 37.7605504594599 | -122.396437603638 | (37.7605504594599, -122.396437603638) | 10 | 3 | 8 | 28856 | 29 | |
148935 | 37966 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 456 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013485.30445 | 2104964.69116 | 37.7605907284002 | -122.396442696467 | (37.7605907284002, -122.396442696467) | 10 | 3 | 8 | 28856 | 29 | |
156519 | 196450 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013387.24706 | 2101044.34817 | 37.7498208576628 | -122.3965070277 | (37.7498208576628, -122.3965070277) | 10 | 3 | 8 | 28856 | 1 | |||
34248 | 196460 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 364 Missouri St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6013463.46293 | 2105385.87525 | 37.7617459921168 | -122.396547761567 | (37.7617459921168, -122.396547761567) | 10 | 3 | 8 | 28856 | 29 | |||
134486 | 196470 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6013295.58948 | 2097174.20298 | 37.7391891560441 | -122.396552730329 | (37.7391891560441, -122.396552730329) | 10 | 3 | 8 | 58 | 1 | |||
29809 | 47252 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.396634995972 | (37.718267407089, -122.396634995972) | 10 | 3 | 8 | 58 | 1 | |
108318 | 196451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013299.05466 | 2101039.80695 | 37.7498034800424 | -122.396811684714 | (37.7498034800424, -122.396811684714) | 10 | 3 | 8 | 28856 | 1 | |||
167856 | 196505 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3536 Jennings St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013064.41888 | 2089502.00277 | 37.7181099951501 | -122.396814283753 | (37.7181099951501, -122.396814283753) | 10 | 3 | 8 | 58 | 1 | |||
27189 | 82702 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.7175004844817 | -122.396915777424 | (37.7175004844817, -122.396915777424) | 10 | 3 | 8 | 58 | 1 | ||
46888 | 82918 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52501 | 6013030.57044013 | 2089280.70970627 | 37.7175004844817 | -122.396915777424 | (37.7175004844817, -122.396915777424) | 10 | 3 | 8 | 58 | 1 | |
69169 | 82919 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.7175004844817 | -122.396915777424 | (37.7175004844817, -122.396915777424) | 10 | 3 | 8 | 58 | 1 | ||
155204 | 82634 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 863 Meade Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.7175004844817 | -122.396915777424 | (37.7175004844817, -122.396915777424) | 10 | 3 | 8 | 58 | 1 | ||
178020 | 82701 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 863 Meade Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.7175004844817 | -122.396915777424 | (37.7175004844817, -122.396915777424) | 10 | 3 | 8 | 58 | 1 | ||
54061 | 196452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950 Cesar Chavez St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6013266.78575 | 2101037.18746 | 37.7497944913407 | -122.396923089148 | (37.7497944913407, -122.396923089148) | 10 | 3 | 8 | 28856 | 1 | |||
162381 | 109718 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013027.72582 | 2089252.65271 | 37.7174232872231 | -122.396923644015 | (37.7174232872231, -122.396923644015) | 10 | 3 | 8 | 58 | 1 | |||
24175 | 109719 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013017.96817 | 2089237.91008 | 37.7173822637496 | -122.39695633886 | (37.7173822637496, -122.39695633886) | 10 | 3 | 8 | 58 | 1 | |||
114826 | 109720 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013003.04663 | 2089225.87008 | 37.7173483736975 | -122.39700707234 | (37.7173483736975, -122.39700707234) | 10 | 3 | 8 | 58 | 1 | |||
19539 | 102037 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
33364 | 102039 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
73535 | 102038 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
191654 | 102036 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
82301 | 62079 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 595 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1985 12:00:00 AM | 14 | Permit Number 22161 | 6013301.58361 | 2104304.12984 | 37.7587667459021 | -122.397031791103 | (37.7587667459021, -122.397031791103) | 10 | 3 | 8 | 28856 | 29 | |
185463 | 109721 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6012983.30026 | 2089217.17599 | 37.717323402237 | -122.397074717543 | (37.717323402237, -122.397074717543) | 10 | 3 | 8 | 58 | 1 | |||
50077 | 109722 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 91x Jennings Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012966.2543 | 2089212.97453 | 37.7173109169351 | -122.397133343428 | (37.7173109169351, -122.397133343428) | 10 | 3 | 8 | 58 | 1 | |||
66249 | 196474 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 74 Neptune St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013054.12657 | 2093955.76147 | 37.7303385419805 | -122.397161987746 | (37.7303385419805, -122.397161987746) | 10 | 3 | 8 | 58 | 1 |
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) );