trees
603 rows where qSpecies_id = 172 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
88123 | 101366 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 1348 Noe St | Unaccepted Street : Yard | Tree | Private 2 | 24 | Owner: Brent Sommer 519-1119 nocmout@gmail.com | 6003163.2 | 2100416 | 37.7475212781449 | -122.43181735246 | (37.7475212781449, -122.43181735246) | 2 | 4 | 5 | 63 | 22 | ||||
73557 | 103414 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1490X Plymouth Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2013 12:00:00 AM | Permit Number 770026 | 5995919.3 | 2094026.5 | 37.7295639775589 | -122.456404198854 | (37.7295639775589, -122.456404198854) | 9 | 7 | 4 | 28861 | 40 | |||
28932 | 105444 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard | Tree | Private 2 | 6005075.5 | 2108088.5 | 37.7686963767089 | -122.425750755404 | (37.7686963767089, -122.425750755404) | 8 | 4 | 5 | 28853 | 19 | |||||
149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
83096 | 109209 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 2401x CASTRO ST | 5 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
27055 | 110561 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 401x FRANCONIA ST | 1 | Front Yard : Yard | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777241 | 6009999 | 2098658 | 37.7430793263277 | -122.408055517439 | (37.7430793263277, -122.408055517439) | 10 | 7 | 7 | 28859 | 2 | |
67633 | 111097 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 SAINT CHARLES AVE | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||||
86423 | 111242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 745X SANCHEZ ST | 3 | Median : Yard | Tree | DPW 1 | 8 | 3x3 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | |||
144216 | 111439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6 | 5999870.68262 | 2091075.24274 | 37.7216865575792 | -122.442532100582 | (37.7216865575792, -122.442532100582) | 9 | 7 | 6 | 28861 | 25 | |||
2760 | 111440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 12 | 5999883.47669 | 2091070.55057 | 37.7216744032298 | -122.442487538293 | (37.7216744032298, -122.442487538293) | 9 | 7 | 6 | 28861 | 25 | |||
135580 | 111441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5 | 5999897.1183 | 2091063.84845 | 37.7216567783095 | -122.442439902078 | (37.7216567783095, -122.442439902078) | 9 | 7 | 6 | 28861 | 25 | |||
52169 | 111442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 32 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 8 | 5999909.42688 | 2091057.17434 | 37.7216391542992 | -122.44239687581 | (37.7216391542992, -122.44239687581) | 9 | 7 | 6 | 28861 | 25 | |||
129541 | 111443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | 9 | 7 | 6 | 28861 | 25 | |||
74404 | 111444 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.7215516403644 | -122.442184051271 | (37.7215516403644, -122.442184051271) | 9 | 7 | 6 | 28861 | 25 | ||
116073 | 111445 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 7 | 5999980.84773 | 2091017.84349 | 37.7215352313433 | -122.442147171851 | (37.7215352313433, -122.442147171851) | 9 | 7 | 6 | 28861 | 25 | |||
79021 | 111446 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
147980 | 111447 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
83216 | 111448 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | |||
4150 | 111749 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 4124 23rd St | 1 | Back Yard : Yard | Tree | Private 2 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | 2 | 4 | 5 | 28862 | 22 | |||||
109691 | 113439 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 401x POWHATTAN AVE | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 3x3 | 6008174 | 2098184 | 37.7416754763214 | -122.414332364983 | (37.7416754763214, -122.414332364983) | 2 | 7 | 7 | 28859 | 2 | |||
181117 | 113496 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 200x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6011235.51183 | 2090583.52363 | 37.7209776633755 | -122.403212099473 | (37.7209776633755, -122.403212099473) | 10 | 3 | 7 | 309 | 28 | |||
119840 | 113507 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 200x Mansell St | 13 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6011128.47606 | 2090549.92676 | 37.720879434926 | -122.40357972974 | (37.720879434926, -122.40357972974) | 10 | 3 | 7 | 309 | 28 | |||
80659 | 116197 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 355x BRADFORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009473 | 2096548 | 37.7372562599827 | -122.409725389456 | (37.7372562599827, -122.409725389456) | 10 | 7 | 7 | 28859 | 2 | |||
37888 | 116374 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 170 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5987438.38703 | 2114824.73848 | 37.7861797499018 | -122.487250214084 | (37.7861797499018, -122.487250214084) | 11 | 6 | 1 | 55 | 33 | |||
30357 | 116670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
63486 | 116675 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 14 | Unaccepted Street : Yard | Tree | DPW 1 | 14 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | ||||
126104 | 116750 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2255 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6002535.32204955 | 2107055.77989845 | 37.7657169099067 | -122.434463175931 | (37.7657169099067, -122.434463175931) | 15 | 5 | 5 | 28862 | 3 | ||||
77392 | 116877 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 401x Franconia St | 2 | Front Yard : Yard | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | Permit Number 777241 | 6009999.3 | 2098658.1 | 37.743079617703 | -122.408054487165 | (37.743079617703, -122.408054487165) | 10 | 7 | 7 | 28859 | 2 | ||
102949 | 117130 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2671 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988936.0754 | 2097168.6937 | 37.7377882614801 | -122.480775587362 | (37.7377882614801, -122.480775587362) | 1 | 8 | 3 | 29491 | 35 | |||
193001 | 117207 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 1 | Median : Cutout | Tree | Private 2 | 13 | 6012255.77341 | 2102253.00873 | 37.753076544652 | -122.40050462841 | (37.753076544652, -122.40050462841) | 10 | 3 | 8 | 28856 | 29 | ||||
14029 | 117209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7X CONGO ST | 1 | Median : Cutout | Tree | DPW 1 | 18 | 30x20 | 6000046 | 2093900 | 37.7294526827424 | -122.442128742048 | (37.7294526827424, -122.442128742048) | 9 | 7 | 4 | 63 | 40 | |||
111605 | 118668 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4240 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5982392.89244 | 2111033.85887 | 37.7754756009165 | -122.504425054608 | (37.7754756009165, -122.504425054608) | 11 | 6 | 2 | 55 | 26 | |||
36046 | 122242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1628 Lake St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5990370.4799 | 2114772.22238 | 37.7862060986385 | -122.477102214032 | (37.7862060986385, -122.477102214032) | 11 | 6 | 1 | 55 | 33 | |||
44586 | 122351 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
109347 | 122352 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
190127 | 122355 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
97885 | 122356 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
61391 | 122357 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
58477 | 122359 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
190068 | 122360 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
155440 | 122361 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
158798 | 122362 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
160964 | 122363 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
52164 | 122364 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
130307 | 122365 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
177369 | 122366 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
56774 | 122370 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
25708 | 122371 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
14987 | 122372 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
93435 | 122493 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 69x Bonview St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
43774 | 123184 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 695 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993153.85102 | 2110782.22133 | 37.7754117246383 | -122.467182349196 | (37.7754117246383, -122.467182349196) | 11 | 6 | 2 | 54 | 11 | |||
21634 | 123489 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 600 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 5995672.03179 | 2111788.60232 | 37.7783200198099 | -122.458544293173 | (37.7783200198099, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | |||
128545 | 12728 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 2 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | ||
112600 | 12733 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 5990471.06768 | 2114763.19979 | 37.7861871602608 | -122.476753550914 | (37.7861871602608, -122.476753550914) | 11 | 6 | 1 | 55 | 33 | |||
125434 | 136272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2 Emerson St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998704.619 | 2113641.52424 | 37.7835814810315 | -122.448186950386 | (37.7835814810315, -122.448186950386) | 15 | 6 | 1 | 54 | 31 | |||
107700 | 136273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2 Emerson St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 5998702.99762 | 2113658.22587 | 37.7836272466556 | -122.448193762735 | (37.7836272466556, -122.448193762735) | 15 | 6 | 1 | 54 | 31 | |||
69456 | 136274 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 5 Dicha Aly | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 5998311.91421 | 2113781.70863 | 37.7839439330129 | -122.449555656482 | (37.7839439330129, -122.449555656482) | 15 | 6 | 1 | 54 | 31 | |||
122071 | 136275 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 699 Webster St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6003966.4578 | 2111069.22256 | 37.7768179785099 | -122.429799478365 | (37.7768179785099, -122.429799478365) | 7 | 9 | 11 | 29492 | 10 | |||
153607 | 136276 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1927 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004921.8107 | 2117075.88034 | 37.7933648188709 | -122.426922521966 | (37.7933648188709, -122.426922521966) | 13 | 9 | 1 | 28858 | 27 | |||
161288 | 136277 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2745 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6006529.34062 | 2120636.08267 | 37.8032309995586 | -122.421613321221 | (37.8032309995586, -122.421613321221) | 5 | 9 | 1 | 28858 | 32 | ||||
86665 | 136278 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2507 Larkin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006657.1862 | 2120015.9614 | 37.8015355122184 | -122.421126848223 | (37.8015355122184, -122.421126848223) | 5 | 9 | 1 | 28858 | 32 | |||
85274 | 136279 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1151 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6006698.81265 | 2120089.55435 | 37.8017399263049 | -122.420988029784 | (37.8017399263049, -122.420988029784) | 5 | 1 | 1 | 28858 | 32 | ||||
135496 | 136280 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1080 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008340.68232 | 2118631.36541 | 37.797828516615 | -122.415203104753 | (37.797828516615, -122.415203104753) | 5 | 1 | 10 | 308 | 21 | ||||
72764 | 136281 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 8 | Front Yard : Yard | Tree | Private 2 | 3 | 6008944.09485 | 2118690.11186 | 37.7980237126691 | -122.413119277553 | (37.7980237126691, -122.413119277553) | 3 | 1 | 10 | 308 | 21 | ||||
18562 | 136282 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 12 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 09:08:00 AM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
137430 | 141623 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1801 GROVE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998914.533 | 2110398.874 | 37.7746899995309 | -122.44722727877 | (37.7746899995309, -122.44722727877) | 15 | 5 | 11 | 29492 | 16 | |||
3335 | 142293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 475 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000600.6108 | 2110614.5346 | 37.775378345569 | -122.441410289609 | (37.775378345569, -122.441410289609) | 15 | 5 | 11 | 29492 | 16 | |||
3558 | 142294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 465 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000605.0602 | 2110593.7708 | 37.7753215869011 | -122.441393407901 | (37.7753215869011, -122.441393407901) | 15 | 5 | 11 | 29492 | 16 | |||
142891 | 142295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 455 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000605.8018 | 2110575.2317 | 37.7752707254694 | -122.441389511979 | (37.7752707254694, -122.441389511979) | 15 | 5 | 11 | 29492 | 16 | |||
14339 | 151836 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 20 Rosemont Pl | 2 | Back Yard : Yard | Tree | Private 2 | 0 | Width 3ft | 6005099.05709 | 2108071.10762 | 37.7686499525699 | -122.425668035147 | (37.7686499525699, -122.425668035147) | 8 | 4 | 5 | 28853 | 19 | |||
23217 | 173610 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 344 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6001093 | 2097562 | 37.7395672975157 | -122.438771477593 | (37.7395672975157, -122.438771477593) | 2 | 7 | 5 | 63 | 7 | |||
63706 | 179337 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2134 San Jose Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5999049.37698 | 2091335.56426 | 37.7223544903593 | -122.445389834901 | (37.7223544903593, -122.445389834901) | 9 | 7 | 6 | 28861 | 25 | |||
127893 | 179338 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2134 San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5998927.16036 | 2091160.9726 | 37.7218681244079 | -122.445799757562 | (37.7218681244079, -122.445799757562) | 9 | 7 | 6 | 28861 | 25 | |||
156991 | 179339 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 340 Tocoloma Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012524.83653 | 2086861.12373 | 37.7108286189149 | -122.398494192156 | (37.7108286189149, -122.398494192156) | 10 | 3 | 8 | 309 | 1 | |||
77611 | 179340 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6011654.04439 | 2090707.03922 | 37.7213401773752 | -122.401774025963 | (37.7213401773752, -122.401774025963) | 10 | 7 | 8 | 309 | 28 | |||
13698 | 179341 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6011434.85378 | 2090631.08875 | 37.7211193983363 | -122.402526372706 | (37.7211193983363, -122.402526372706) | 10 | 7 | 8 | 309 | 28 | |||
33436 | 179343 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 26 Ervine St | 11 | Front Yard : Yard | Tree | Private 2 | 7 | 6009596.1537 | 2089161.02063 | 37.7169800734552 | -122.408778591782 | (37.7169800734552, -122.408778591782) | 9 | 7 | 8 | 309 | 18 | ||||
83050 | 179344 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 26 Ervine St | 4 | Front Yard : Yard | Tree | Private 2 | 7 | 6009638.38592 | 2089289.77346 | 37.7173359675679 | -122.408641692459 | (37.7173359675679, -122.408641692459) | 9 | 7 | 8 | 309 | 18 | ||||
13419 | 179345 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Alpha St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.99338 | 2088244.36018 | 37.7145443783829 | -122.40369233834 | (37.7145443783829, -122.40369233834) | 9 | 7 | 8 | 309 | 39 | ||||
170903 | 179346 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004743.0308 | 2092717.80551 | 37.7264732027495 | -122.425806528059 | (37.7264732027495, -122.425806528059) | 9 | 7 | 6 | 28861 | 5 | ||||
55357 | 179347 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6004743.78868 | 2092719.75542 | 37.7264785996005 | -122.42580404683 | (37.7264785996005, -122.42580404683) | 9 | 7 | 6 | 28861 | 5 | ||||
101569 | 179348 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 111 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6004744.90542 | 2092721.69826 | 37.7264839973183 | -122.425800324532 | (37.7264839973183, -122.425800324532) | 9 | 7 | 6 | 28861 | 5 | ||||
137603 | 181532 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984901.4756 | 2105774.4271 | 37.7611819183613 | -122.495359430973 | (37.7611819183613, -122.495359430973) | 1 | 8 | 3 | 56 | 35 | |||
80427 | 181533 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984877.5263 | 2105773.8702 | 37.7611789869773 | -122.495442219064 | (37.7611789869773, -122.495442219064) | 1 | 8 | 3 | 56 | 35 | |||
29268 | 181535 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984891.4503 | 2105792.8068 | 37.7612317968807 | -122.495395459242 | (37.7612317968807, -122.495395459242) | 1 | 8 | 3 | 56 | 35 | |||
87837 | 183952 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2100 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985056.1616 | 2100499.6436 | 37.746707872476 | -122.494435602922 | (37.746707872476, -122.494435602922) | 1 | 8 | 3 | 29491 | 35 | |||
182740 | 184050 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984953.7413 | 2103846.6967 | 37.7558919667936 | -122.495036518918 | (37.7558919667936, -122.495036518918) | 1 | 8 | 3 | 56 | 35 | |||
160547 | 184053 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 54 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984911.7478 | 2103852.1605 | 37.7559045104069 | -122.495182146902 | (37.7559045104069, -122.495182146902) | 1 | 8 | 3 | 56 | 35 | |||
178335 | 184054 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984938.5987 | 2103876.5136 | 37.7559729492589 | -122.495091084788 | (37.7559729492589, -122.495091084788) | 1 | 8 | 3 | 56 | 35 | |||
41047 | 184063 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984913.1434 | 2103955.4845 | 37.7561882912046 | -122.495184939624 | (37.7561882912046, -122.495184939624) | 1 | 8 | 3 | 56 | 35 | |||
93802 | 184351 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1251 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984664.2495 | 2106477.5617 | 37.76309863602 | -122.496231762252 | (37.76309863602, -122.496231762252) | 1 | 8 | 3 | 56 | 35 | |||
159166 | 184356 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1251 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984656.2754 | 2106611.6026 | 37.7634662075597 | -122.496269232033 | (37.7634662075597, -122.496269232033) | 1 | 8 | 3 | 56 | 35 | |||
79415 | 184748 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984700.7025 | 2106122.714 | 37.762126459046 | -122.496079504872 | (37.762126459046, -122.496079504872) | 1 | 8 | 3 | 56 | 35 | |||
33720 | 184764 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984675.2613 | 2106104.8671 | 37.7620759662771 | -122.496166178125 | (37.7620759662771, -122.496166178125) | 1 | 8 | 3 | 56 | 35 | |||
76127 | 184769 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984710.0056 | 2106073.3504 | 37.7619914653387 | -122.496043687563 | (37.7619914653387, -122.496043687563) | 1 | 8 | 3 | 56 | 35 | |||
22894 | 185174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985128.7096 | 2097775.6475 | 37.7392327606429 | -122.493984021674 | (37.7392327606429, -122.493984021674) | 1 | 8 | 3 | 29491 | 35 | |||
138093 | 185178 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985128.0455 | 2097804.2012 | 37.7393111225821 | -122.49398842161 | (37.7393111225821, -122.49398842161) | 1 | 8 | 3 | 29491 | 35 | |||
135363 | 185183 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985128.0455 | 2097828.1066 | 37.7393767603936 | -122.493990182941 | (37.7393767603936, -122.493990182941) | 1 | 8 | 3 | 29491 | 35 | |||
98768 | 185397 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 10 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985126.1289 | 2099011.9385 | 37.742627131937 | -122.494084037578 | (37.742627131937, -122.494084037578) | 1 | 8 | 3 | 29491 | 35 | |||
50901 | 185402 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 16 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985125.6291 | 2099042.93 | 37.7427121969825 | -122.494088049359 | (37.7427121969825, -122.494088049359) | 1 | 8 | 3 | 29491 | 35 |
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) );