4,014 rows where qSpecies_id = 40 sorted by Longitude

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);