Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131438 | 131438 | 126378 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1976 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003585.79025 | 2118315.11213 | 37.7966917978451 | -122.431633760802 | (37.7966917978451, -122.431633760802) | |||
132226 | 132226 | 206527 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.46691330850099 | (37.7430441224891, -122.466913308501) | |||
132280 | 132280 | 223046 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 77 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005471.50149 | 2099604.5609999998 | 37.7454238329391 | -122.423777694396 | (37.7454238329391, -122.423777694396) | |||
132401 | 132401 | 206621 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 1912 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993175.256709999 | 2102431.1044799997 | 37.7524829903015 | -122.46650118519301 | (37.7524829903015, -122.466501185193) | |||
132461 | 132461 | 206523 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | |||
133199 | 133199 | 206579 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257004 | -122.46587337656601 | (37.744949720257, -122.465873376566) | |||
133979 | 133979 | 206590 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994099.18491 | 2099823.6206900002 | 37.745376773231 | -122.463116933812 | (37.745376773231, -122.463116933812) | |||
134479 | 134479 | 206645 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994475.58114 | 2100840.87711 | 37.748191578392294 | -122.461889176638 | (37.7481915783923, -122.461889176638) | |||
135645 | 135645 | 223028 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 42 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5998401.231319999 | 2106021.8866 | 37.7626425622232 | -122.448687567871 | (37.7626425622232, -122.448687567871) | |||
137986 | 137986 | 223050 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001422.84544 | 2108013.2139 | 37.7682825750187 | -122.43837958446301 | (37.7682825750187, -122.438379584463) | |||
148248 | 148248 | 206529 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992989.732419999 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | |||
148350 | 148350 | 206542 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 351 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994154.36407 | 2101104.3868400003 | 37.748896611800106 | -122.46301904261999 | (37.7488966118001, -122.46301904262) | |||
148911 | 148911 | 206583 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | |||
149027 | 149027 | 206693 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 609 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997804.54909 | 2098010.1173 | 37.740610086694396 | -122.45017375511999 | (37.7406100866944, -122.45017375512) | |||
150656 | 150656 | 247816 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 550 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6003030.78831 | 2098349.34835 | 37.741839226995204 | -122.43212766126899 | (37.7418392269952, -122.432127661269) | |||
151039 | 151039 | 206692 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 582 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996416.06092 | 2095880.8714400001 | 37.7346841407625 | -122.45482078325199 | (37.7346841407625, -122.454820783252) | |||
151724 | 151724 | 206687 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996087.4467400005 | 2095957.96527 | 37.7348769661929 | -122.45596247889 | (37.7348769661929, -122.45596247889) | |||
152052 | 152052 | 223044 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008324.57166 | 2099444.87133 | 37.7451460071793 | -122.413900908902 | (37.7451460071793, -122.413900908902) | |||
153258 | 153258 | 206575 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 120 Montalvo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993692.18131 | 2099632.63233 | 37.744828913423 | -122.464510409921 | (37.744828913423, -122.464510409921) | |||
153437 | 153437 | 206522 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.47370838535801 | (37.7465686447317, -122.473708385358) | |||
153873 | 153873 | 206585 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993961.3420400005 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | |||
154984 | 154984 | 206629 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.46257206157101 | (37.7509117433916, -122.462572061571) | |||
155591 | 155591 | 206679 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995939.36036 | 2096013.8239 | 37.7350218397738 | -122.456478499997 | (37.7350218397738, -122.456478499997) | |||
156496 | 156496 | 206639 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 175 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994510.39425 | 2100823.8744099997 | 37.748146897381794 | -122.461767562235 | (37.7481468973818, -122.461767562235) | |||
157023 | 157023 | 206694 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 125 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001630.15209 | 2095380.35715 | 37.733607556928 | -122.43675811218999 | (37.733607556928, -122.43675811219) | |||
157129 | 157129 | 206655 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994255.40167 | 2101538.8525799997 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | |||
157297 | 157297 | 206589 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994086.716030001 | 2099812.2565200003 | 37.7453448518007 | -122.463159224416 | (37.7453448518007, -122.463159224416) | |||
158004 | 158004 | 223037 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 203 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002071.560219999 | 2096098.27883 | 37.7356038810064 | -122.435283373351 | (37.7356038810064, -122.435283373351) | |||
158121 | 158121 | 206588 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | |||
158851 | 158851 | 223045 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 13 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008341.10325 | 2099446.02772 | 37.745150110794896 | -122.413843827126 | (37.7451501107949, -122.413843827126) | |||
160214 | 160214 | 206681 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995960.60425 | 2096012.63655 | 37.735019799206 | -122.45640496693399 | (37.735019799206, -122.456404966934) | |||
161837 | 161837 | 206649 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994518.46873 | 2100904.0082799997 | 37.7483673895631 | -122.461745450587 | (37.7483673895631, -122.461745450587) | |||
162090 | 162090 | 206642 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994408.53923 | 2100777.89876 | 37.7480147959636 | -122.46211643714899 | (37.7480147959636, -122.462116437149) | |||
162977 | 162977 | 223033 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006248.27078 | 2096110.4955099998 | 37.735873731571395 | -122.420843728155 | (37.7358737315714, -122.420843728155) | |||
164232 | 164232 | 206634 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994552.462069999 | 2100915.6770099998 | 37.748401385725 | -122.461628749166 | (37.748401385725, -122.461628749166) | |||
165454 | 165454 | 206630 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 81 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994323.8061 | 2101846.4166200003 | 37.7509437961254 | -122.46248693172701 | (37.7509437961254, -122.462486931727) | |||
165477 | 165477 | 206591 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993709.625030001 | 2099698.37793 | 37.745010439781296 | -122.464454865994 | (37.7450104397813, -122.464454865994) | |||
165652 | 165652 | 206674 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995208.64941 | 2095407.77696 | 37.7333158051714 | -122.458960944512 | (37.7333158051714, -122.458960944512) | |||
165826 | 165826 | 206688 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5996101.05251 | 2095948.39142 | 37.7348514596286 | -122.455914747394 | (37.7348514596286, -122.455914747394) | |||
166442 | 166442 | 206532 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993345.963169999 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | |||
167831 | 167831 | 206678 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 657 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5995925.9256 | 2096013.7330599998 | 37.7350208190394 | -122.456524941888 | (37.7350208190394, -122.456524941888) | |||
168058 | 168058 | 223039 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 543 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007708.387180001 | 2096815.6091900002 | 37.7378920108046 | -122.41584542843201 | (37.7378920108046, -122.415845428432) | |||
170709 | 170709 | 206644 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994467.924 | 2100831.48615 | 37.748165352368105 | -122.46191497372 | (37.7481653523681, -122.46191497372) | |||
171063 | 171063 | 206569 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2435 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992009.07535 | 2098867.5883299997 | 37.7426311295378 | -122.47027451837099 | (37.7426311295378, -122.470274518371) | |||
171384 | 171384 | 206647 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 180 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994503.49405 | 2100867.53113 | 37.748266370491 | -122.461794587759 | (37.748266370491, -122.461794587759) | |||
172567 | 172567 | 206643 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 196 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994392.211730001 | 2100761.6142700003 | 37.74796914278121 | -122.462171715751 | (37.7479691427812, -122.462171715751) | |||
174269 | 174269 | 223032 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 281 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006256.18709 | 2096109.4549 | 37.735871320489395 | -122.42081628443898 | (37.7358713204894, -122.420816284439) | |||
174439 | 174439 | 206625 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374828999 | (37.7507963531822, -122.46262374829) | |||
174659 | 174659 | 206543 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 347 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994159.12368 | 2101087.0695700003 | 37.7488493371331 | -122.463001327749 | (37.7488493371331, -122.463001327749) | |||
175013 | 175013 | 206619 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 181 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994070.38957 | 2104649.5630900003 | 37.758625920162295 | -122.463566678468 | (37.7586259201623, -122.463566678468) | |||
175120 | 175120 | 206659 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | |||
177415 | 177415 | 223049 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002666.83309 | 2105626.92623 | 37.7618010890622 | -122.433906166852 | (37.7618010890622, -122.433906166852) | |||
177772 | 177772 | 206633 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 145 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994552.3071099995 | 2100925.23177 | 37.7484276117632 | -122.461629977659 | (37.7484276117632, -122.461629977659) | |||
177940 | 177940 | 206677 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 228 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994904.4684 | 2095946.32835 | 37.7347770452256 | -122.46005157662901 | (37.7347770452256, -122.460051576629) | |||
179119 | 179119 | 206587 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 348 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994044.71238 | 2099771.06427 | 37.745229328484704 | -122.46330147648099 | (37.7452293284847, -122.463301476481) | |||
179932 | 179932 | 206676 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 240 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994971.50428 | 2095856.22795 | 37.7345335069973 | -122.459813287749 | (37.7345335069973, -122.459813287749) | |||
181759 | 181759 | 206559 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 355 Yerba Buena Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995306.63453 | 2095221.10602 | 37.7328088843117 | -122.458608676455 | (37.7328088843117, -122.458608676455) | |||
181807 | 181807 | 206656 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 45 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994277.8238699995 | 2101540.85875 | 37.75010216378529 | -122.46262377888 | (37.7501021637853, -122.46262377888) | |||
183187 | 183187 | 206695 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 140 Hamerton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001321.914580001 | 2095363.51303 | 37.7335437842173 | -122.437822570471 | (37.7335437842173, -122.437822570471) | |||
184549 | 184549 | 206626 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994084.99265 | 2101862.2244599997 | 37.750973444992205 | -122.46331391231199 | (37.7509734449922, -122.463313912312) | |||
185359 | 185359 | 206567 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991381.7608900005 | 2098233.80223 | 37.74085462674589 | -122.472397375252 | (37.7408546267459, -122.472397375252) | |||
185968 | 185968 | 206624 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994298.51296 | 2101800.2527099997 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | |||
186378 | 186378 | 206627 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 40 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994076.75455 | 2101874.6545700002 | 37.751007100296604 | -122.463343302157 | (37.7510071002966, -122.463343302157) | |||
186945 | 186945 | 206566 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991741.264830001 | 2097200.972 | 37.738039538296206 | -122.471079130991 | (37.7380395382962, -122.471079130991) | |||
186978 | 186978 | 190925 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 651 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011562.1933699995 | 2105343.91486 | 37.761524784975 | -122.40312057635 | (37.761524784975, -122.40312057635) | |||
187180 | 187180 | 223054 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 701 Church St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004339.171130001 | 2104460.25399 | 37.758692444824206 | -122.42803907256099 | (37.7586924448242, -122.428039072561) | |||
188058 | 188058 | 206537 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | |||
188155 | 188155 | 206686 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 629 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996075.5527099995 | 2095969.20127 | 37.7349071348466 | -122.456004412496 | (37.7349071348466, -122.456004412496) | |||
188288 | 188288 | 206675 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 300 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995199.651459999 | 2095433.83543 | 37.733386838132 | -122.458993938825 | (37.733386838132, -122.458993938825) | |||
189037 | 189037 | 206564 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2044 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993156.7665 | 2101574.66751 | 37.7501303674196 | -122.46650288401399 | (37.7501303674196, -122.466502884014) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");