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)
77068 82672 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 69 Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM   3x3 Permit Number 52500 6012954.77206528 2089215.57064421 37.7173174061263 -122.397173214353 (37.7173174061263, -122.397173214353) 10 3 8 58 1
182681 201275 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 Kalmanovitz St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 2ft   6013023.37655 2092747.78816 37.7270199824665 -122.397183623634 (37.7270199824665, -122.397183623634) 10 3 8 58 1
160003 82703 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 67 Jennings Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 6 3x3 Permit Number 52500 6012950.17329 2089208.10371 37.7172966473952 -122.39718858698 (37.7172966473952, -122.39718858698) 10 3 8 58 1
117759 202308 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 178 Orsi Cir 1 : Tree Private 2     2 Width 2ft   6013012.36975 2092926.2043 37.7275092640335 -122.397234179931 (37.7275092640335, -122.397234179931) 10 3 8 58 1
13441 82704 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 67 Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012930.12709 2089200.71503 37.7172752435332 -122.397257359943 (37.7172752435332, -122.397257359943) 10 3 8 58 1
173058 202147 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1979 Armstrong Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 7ft   6012955.25231 2093506.82348 37.7291003454988 -122.397472339298 (37.7291003454988, -122.397472339298) 10 3 8 58 1
77137 57611 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 356 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1976 12:00:00 AM 13   Permit Number 16500 6013179.72476 2105412.69394 37.7618038355947 -122.397530985864 (37.7618038355947, -122.397530985864) 10 3 8 28856 29
77381 22521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 6600 03rd St 1 Median : Cutout Tree DPW 1   02/20/1992 12:00:00 AM 3 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
183446 22527 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 6600 03rd St 7 Median : Cutout Tree DPW 1     3 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
185997 94869 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53939 6012921 2095173 37.7336734157115 -122.397707572671 (37.7336734157115, -122.397707572671) 10 3 8 58 1
189754 196482 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 282 Bridgeview Dr 1 : Tree Private 2     5 Width 2ft   6012916.33928 2095157.16046 37.7336296640747 -122.39772257563 (37.7336296640747, -122.39772257563) 10 3 8 58 1
164139 196453 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 7 : Tree Private 2     2 Width 3ft   6012987.92898 2101021.89129 37.7497369652948 -122.397886321506 (37.7497369652948, -122.397886321506) 10 3 8 28856 1
141653 196472 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Newhall St 2 : Tree Private 2     5 Width 3ft   6012828.31305 2093641.68277 37.7294635726784 -122.39792063783 (37.7294635726784, -122.39792063783) 10 3 8 58 1
58370 196473 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Newhall St 3 : Tree Private 2     5 Width 3ft   6012815.80377 2093626.35145 37.7294207793372 -122.397962808852 (37.7294207793372, -122.397962808852) 10 3 8 58 1
82225 196447 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Madera St 1 : Tree Private 2     11 Width 3ft   6012994.61219 2103283.12733 37.7559462030644 -122.398021821446 (37.7559462030644, -122.398021821446) 10 3 8 28856 29
149692 196448 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Madera St 2 : Tree Private 2     6 Width 3ft   6012976.23669 2103282.94556 37.7559446805133 -122.398085357651 (37.7559446805133, -122.398085357651) 10 3 8 28856 29
84132 196449 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Madera St 3 : Tree Private 2     2 Width 3ft   6012958.79837 2103280.94306 37.7559382107998 -122.398145525023 (37.7559382107998, -122.398145525023) 10 3 8 28856 29
185279 196454 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 10 : Tree Private 2     1 Width 3ft   6012891.82767 2101016.42082 37.7497165920542 -122.398218262172 (37.7497165920542, -122.398218262172) 10 3 8 28856 1
145893 196455 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 11 : Tree Private 2     6 Width 3ft   6012871.43703 2101015.96129 37.7497141944763 -122.39828874204 (37.7497141944763, -122.39828874204) 10 3 8 28856 1
157822 196456 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012848.61003 2101014.24206 37.7497082022719 -122.398367558612 (37.7497082022719, -122.398367558612) 10 3 8 28856 1
108668 32947 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 301 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM     Permit Number 37265 6012942.48941846 2105645.52533205 37.7624299268392 -122.39836783116 (37.7624299268392, -122.39836783116) 14 3 8 28856 29
87718 196457 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 13 : Tree Private 2     3 Width 3ft   6012824.47283 2101012.76758 37.7497028090569 -122.398450923095 (37.7497028090569, -122.398450923095) 10 3 8 28856 1
59096 202045 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Exeter St 1 : Tree Private 2     1 Width 3ft   6012584.35783 2091031.24341 37.7222822496095 -122.398580911082 (37.7222822496095, -122.398580911082) 10 3 8 58 1
155160 50012 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2009 12:00:00 AM 3   Permit Number 52022 6012815.30679 2102898.98068 37.7548814318474 -122.398614966606 (37.7548814318474, -122.398614966606) 10 3 8 28856 29
180637 63769 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 55 Hawthorne St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2013 12:00:00 AM 18 3x3 Permit Number 768706 6013040.47104 2113998.55413 37.7853709106802 -122.398615140189 (37.7853709106802, -122.398615140189) 6 2 9 28855 6
81146 50013 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2009 12:00:00 AM 2   Permit Number 52022 6012813.23846 2102916.22313 37.7549286606329 -122.398623329429 (37.7549286606329, -122.398623329429) 10 3 8 28856 29
54353 92795 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 52022 6012811.72806 2102960.97452 37.7550514540675 -122.398631693097 (37.7550514540675, -122.398631693097) 10 3 8 28856 29
34890 196480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 6 Side Yard : Yard Tree Private 2     4 Width 3ft   6012679.65409 2096682.3113 37.737804227083 -122.39864786201 (37.737804227083, -122.39864786201) 10 3 8 58 1
129113 201292 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82 Lydia Ave 1 : Tree Private 2     2 Width 2ft   6012604.14806 2093027.69229 37.7277651940081 -122.398652533104 (37.7277651940081, -122.398652533104) 10 3 8 58 1
38048 196479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 3 Side Yard : Yard Tree Private 2     3 Width 3ft   6012661.09972 2096663.01157 37.7377502003122 -122.398710659866 (37.7377502003122, -122.398710659866) 10 3 8 58 1
39552 196478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 2 Side Yard : Yard Tree Private 2     2 Width 3ft   6012656.37794 2096656.54864 37.7377321913814 -122.398726532018 (37.7377321913814, -122.398726532018) 10 3 8 58 1
64129 196477 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 1 Side Yard : Yard Tree Private 2     6 Width 3ft   6012648.61518 2096647.76204 37.7377076327033 -122.398752755335 (37.7377076327033, -122.398752755335) 10 3 8 58 1
138969 202042 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Exeter St 1 : Tree Private 2     1 Width 3ft   6012532.81359 2090984.99672 37.7221523937885 -122.398755844523 (37.7221523937885, -122.398755844523) 10 3 8 58 1
32351 196476 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2074 Revere Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6012584.77785 2096296.25792 37.7367389189762 -122.398948809344 (37.7367389189762, -122.398948809344) 10 3 8 58 1
30199 196446 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 701 Wisconsin St 1 : Tree Private 2     4 Width 3ft   6012741.003 2104236.29493 37.7585492646472 -122.398965788556 (37.7585492646472, -122.398965788556) 10 3 8 28856 29
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
7115 4034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/28/1995 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
103046 4032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
179139 4028 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/17/2003 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
187810 4031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/06/2015 02:05:00 PM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
114422 39603 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 636 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM 10   Permit Number 41005 6012670.17637 2104503.85017 37.7592799656157 -122.399229521944 (37.7592799656157, -122.399229521944) 10 3 8 28856 29
116975 196498 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 649 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6012784.03099 2111475.7584 37.7784296058662 -122.399325187321 (37.7784296058662, -122.399325187321) 6 2 9 28856 34
16544 84392 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2101 Jerrold Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012504.25768 2099077.65785 37.7443715685998 -122.399422411225 (37.7443715685998, -122.399422411225) 10 3 8 58 1
75745 28262 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3624 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2003 12:00:00 AM 12 3x3   6012194.48746 2088681.14992 37.7158076389797 -122.399763675165 (37.7158076389797, -122.399763675165) 10 7 8 309 39
190080 196481 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2075 Palou Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6012348.97653 2097093.78891 37.738915629056 -122.399820067148 (37.738915629056, -122.399820067148) 10 3 8 58 1
64136 121586 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 855 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6012479.74347 2103984.11738 37.7578422788274 -122.399851639655 (37.7578422788274, -122.399851639655) 10 3 8 28856 29
81775 28260 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3562 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2003 12:00:00 AM 12 3x3   6012130.0554759 2089144.2345931 37.7170755844057 -122.400018884967 (37.7170755844057, -122.400018884967) 10 7 8 309 39
130349 28259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3562 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/21/2004 12:00:00 AM 10 3x3   6012127.60331 2089140.68412 37.717065698801 -122.400027111788 (37.717065698801, -122.400027111788) 10 7 8 309 39
192795 54425 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 664 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1972 12:00:00 AM 10   Permit Number 10199 6012377.17429 2104832.12129 37.7601649920327 -122.400265927655 (37.7601649920327, -122.400265927655) 10 3 8 28856 29
152902 28256 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3476 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/19/2003 12:00:00 AM 6 3x3   6012060.981 2089540.19012 37.7181589470551 -122.400285438425 (37.7181589470551, -122.400285438425) 10 7 8 309 39
88121 28255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3476 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/25/2003 12:00:00 AM 6 3x3   6012058.00542 2089554.66958 37.7181985388057 -122.400296740219 (37.7181985388057, -122.400296740219) 10 7 8 309 39
148202 28253 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3432 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/2002 12:00:00 AM 3 3X3   6012031.1541281 2089723.1062284 37.7186595344993 -122.400401378772 (37.7186595344993, -122.400401378772) 10 7 8 309 39
153913 28302 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3410 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 3X3   6012014.9954 2089805.78131 37.7188856424495 -122.400463037438 (37.7188856424495, -122.400463037438) 10 7 8 309 39
127124 28254 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3410 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/2002 12:00:00 AM 8 3X3   6012011.64722 2089824.91922 37.7189380045612 -122.400475954423 (37.7189380045612, -122.400475954423) 10 7 8 309 39
14192 28301 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3336 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2003 12:00:00 AM 8 3X3   6011974.10308 2090046.14983 37.719543365213 -122.400621263274 (37.719543365213, -122.400621263274) 10 7 8 309 28
176896 67488 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1117 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3   Permit Number 773109 6012239.52235 2103185.1315 37.7556350439301 -122.400626303061 (37.7556350439301, -122.400626303061) 10 3 8 28856 29
13408 28246 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3326 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/23/2002 12:00:00 AM 3 2X3   6011947.80562 2090200.17318 37.7199648154144 -122.400722979282 (37.7199648154144, -122.400722979282) 10 7 8 309 28
121940 28245 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3312 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2002 12:00:00 AM 8 2X3   6011933.46331 2090279.87862 37.7201828704297 -122.400778152699 (37.7201828704297, -122.400778152699) 10 7 8 309 28
16871 83424 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 987 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012206.17554 2103813.08601 37.7573574093248 -122.400785742066 (37.7573574093248, -122.400785742066) 10 3 8 28856 29
136442 28244 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3260 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2003 12:00:00 AM 12 2X3   6011894.92216 2090508.59301 37.7208087239121 -122.40092743836 (37.7208087239121, -122.40092743836) 10 7 8 309 28
18514 79061 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1006 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012156.57413 2103666.55961 37.7569523133274 -122.400946989616 (37.7569523133274, -122.400946989616) 10 3 8 28856 29
123683 28243 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3230 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/21/2004 12:00:00 AM 8 2X3   6011870.75873 2090643.72462 37.7211784199346 -122.401020454343 (37.7211784199346, -122.401020454343) 10 7 8 309 28
37357 196493 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012209.40916 2110147.41872 37.7747502473676 -122.401219664968 (37.7747502473676, -122.401219664968) 14 2 9 28853 34
40196 196441 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 768 De Haro St 1 Sidewalk: Property side : Yard Tree Private 2     12     6012093.04476 2104807.3138 37.7600810286241 -122.401246859559 (37.7600810286241, -122.401246859559) 10 3 8 28856 29
161112 196494 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012174.00966 2110114.91402 37.7746590219179 -122.401339835074 (37.7746590219179, -122.401339835074) 14 2 9 28853 34
147096 196495 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 728 Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012138.91764 2110082.47387 37.7745679907399 -122.401458945783 (37.7745679907399, -122.401458945783) 14 2 9 28853 34
5062 80388 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1746 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011768.66094 2092717.74347 37.7268675545821 -122.401519069956 (37.7268675545821, -122.401519069956) 10 3 8 58 1
192611 114543 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011964.29912 2103715.17017 37.7570750599871 -122.401615369369 (37.7570750599871, -122.401615369369) 10 3 8 28856 29
38729 196443 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2309 25th St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011925.40712 2101842.83313 37.7519318623815 -122.401618279553 (37.7519318623815, -122.401618279553) 10 3 8 28856 29
3431 80385 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1754 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011729.10125 2092748.56003 37.7269499630479 -122.401657992736 (37.7269499630479, -122.401657992736) 10 3 8 58 1
152097 114542 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 1   Permit Number 774983 6011944.84803 2103714.66509 37.7570725877403 -122.401682603564 (37.7570725877403, -122.401682603564) 10 3 8 28856 29
148491 136019 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Greenwich St 2 Sidewalk: Curb side : Yard Tree Private 2     10     6012283.42018 2120515.08235 37.8032215378072 -122.401692519489 (37.8032215378072, -122.401692519489) 3 1 10 28860 6
163625 4050 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 3 3X3   6011878.42608 2100960.18387 37.7495056776496 -122.401718713171 (37.7495056776496, -122.401718713171) 10 3 8 58 1
173420 136018 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 11 Greenwich St 1 Sidewalk: Curb side : Yard Tree Private 2     11     6012250.39299 2120519.5939 37.8032320823636 -122.401807129095 (37.8032320823636, -122.401807129095) 3 1 10 28860 6
141200 4051 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6011835.74556 2100958.0718 37.749497496525 -122.401866156092 (37.749497496525, -122.401866156092) 10 3 8 58 1
134237 94878 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 56 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53946 6011673 2095004 37.73313980136 -122.402010422944 (37.73313980136, -122.402010422944) 10 3 8 58 1
2569 49452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1483 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2003 12:00:00 AM 4   Permit Number 46386 6011771.85534 2101466.16969 37.7508890570981 -122.402122808245 (37.7508890570981, -122.402122808245) 10 3 8 28856 29
189602 94876 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 48 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53945 6011636 2095053 37.7332722799512 -122.402141786329 (37.7332722799512, -122.402141786329) 10 3 8 58 1
74016 94875 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 44 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53944 6011618 2095077 37.7333371742049 -122.402205704408 (37.7333371742049, -122.402205704408) 10 3 8 58 1
18789 71443 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 924 Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     6012090.03782 2119001.59006 37.7990550614973 -122.402255254071 (37.7990550614973, -122.402255254071) 3 1 10 28860 6
100494 94874 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53943 6011600 2095102 37.7334048142135 -122.402269692882 (37.7334048142135, -122.402269692882) 10 3 8 58 1
189431 179142 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Woolsey St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011536.91523 2092140.59723 37.7252698963774 -122.402279652698 (37.7252698963774, -122.402279652698) 10 3 7 309 28
177743 111661 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1398x Kansas St 1 Median : Cutout Tree DPW 1   06/25/2015 01:32:00 PM 3 3x3   6011721.86925 2101900.79241 37.7520796461774 -122.402326221379 (37.7520796461774, -122.402326221379) 10 3 8 28856 29
89344 179141 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Woolsey St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011519.75007 2092135.22888 37.7252541978079 -122.402338614032 (37.7252541978079, -122.402338614032) 10 3 7 309 28
133446 179140 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Woolsey St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6011506.15031 2092130.79684 37.7252412691581 -122.402385315842 (37.7252412691581, -122.402385315842) 10 3 7 309 28
146975 121620 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300x Kansas St 1 Median : Cutout Tree DPW 1     1 3x3   6011700.39266 2102280.30315 37.7531205008135 -122.402427173876 (37.7531205008135, -122.402427173876) 10 3 8 28856 29
178892 179139 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 101 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6011492.5608 2092126.86899 37.7252297254637 -122.402432017638 (37.7252297254637, -122.402432017638) 10 3 7 309 28
96306 92531 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1298X Kansas St 1 Median : Cutout Tree DPW 1     4     6011695.14318 2102366.06354 37.7533556870153 -122.402451357562 (37.7533556870153, -122.402451357562) 10 3 8 28856 29
15749 108724 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773100 6011759.6093 2105732.18704 37.7626019164795 -122.402465094694 (37.7626019164795, -122.402465094694) 8 3 8 28856 29
95145 196444 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200x Kansas St 2 Median : Cutout Tree DPW 1     5 Width 5ft   6011674.76736 2102721.10758 37.7543294225845 -122.402546786399 (37.7543294225845, -122.402546786399) 10 3 8 28856 29
13155 196442 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 971 Kansas St 3 Sidewalk: Curb side : Pot Tree Private 2     1 Width 5ft   6011633.49107 2103859.13783 37.7574518984069 -122.402769561075 (37.7574518984069, -122.402769561075) 10 3 8 28856 29
41480 179144 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 27 Wayland St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6011384.73394 2092575.30647 37.7264550220761 -122.402836290783 (37.7264550220761, -122.402836290783) 10 3 7 309 28
129774 39575 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 885 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM 13   Permit Number 40992 6011619.84178 2104260.65443 37.7585536119741 -122.40284500429 (37.7585536119741, -122.40284500429) 10 3 8 28856 29
123212 179145 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 102 Wayland St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011376.8849 2092609.12278 37.7265474363946 -122.402865802033 (37.7265474363946, -122.402865802033) 10 3 7 309 28
50590 39571 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 835 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM 8   Permit Number 40989 6011610.45833 2104449.83114 37.7590725253066 -122.402890761795 (37.7590725253066, -122.402890761795) 10 3 8 28856 29
181672 179146 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 102 Wayland St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011358.3265 2092604.64263 37.7265340985502 -122.402929643103 (37.7265340985502, -122.402929643103) 10 3 7 309 28
73927 50360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 807 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 3   Permit Number 47032 6011601.76017 2104587.37273 37.7594496982747 -122.402930518137 (37.7594496982747, -122.402930518137) 10 3 8 28856 29
135524 179143 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 27 Wayland St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6011356.63077 2092564.16396 37.7264228578115 -122.402932659438 (37.7264228578115, -122.402932659438) 10 3 7 309 28
115597 196503 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 351 Tehama St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6011737.82052 2112830.87734 37.7820920832107 -122.403039783975 (37.7820920832107, -122.403039783975) 6 2 9 28853 34
50913 50957 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 860 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2004 12:00:00 AM 3   Permit Number 47450 6011554.87685 2104354.20942 37.7588068655572 -122.403076264082 (37.7588068655572, -122.403076264082) 10 3 8 28856 29

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