trees
603 rows where qSpecies_id = 172 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32249 | 240288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3980 22nd St | 2 | : | Tree | Private 2 | 20 | 6001954.91678 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | 2 | 4 | 5 | 28862 | 22 | ||||
94863 | 240289 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3980 22nd St | 7 | : | Tree | Private 2 | 13 | 6001910.30544 | 2102943.06886 | 37.7543889046321 | -122.436330605077 | (37.7543889046321, -122.436330605077) | 2 | 4 | 5 | 28862 | 22 | ||||
98321 | 240209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 51 13th St | 5 | : | Tree | Private 2 | 2 | Width 3ft | 6008179.63015 | 2108279.36025 | 37.7693953565286 | -122.415027287282 | (37.7693953565286, -122.415027287282) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
148885 | 240210 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 51 13th St | 7 | : | Tree | Private 2 | 17 | Width 5ft | 6008246.66601 | 2108275.00033 | 37.7693871520159 | -122.414795103918 | (37.7693871520159, -122.414795103918) | 8 | 4 | 7 | 28853 | 19 | |||
179483 | 214001 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 10 Caine Ave | 14 | : | Tree | Private 2 | 5 | Width 0ft | 5997555.12173 | 2089578.95708 | 37.7174458422426 | -122.450428532174 | (37.7174458422426, -122.450428532174) | 9 | 8 | 6 | 28861 | 24 | |||
99401 | 214005 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 50 Circular Ave | 2 | : Yard | Tree | Private 2 | 17 | 6000114.23279 | 2093911.68117 | 37.7294886448689 | -122.441893693449 | (37.7294886448689, -122.441893693449) | 9 | 7 | 4 | 63 | 40 | ||||
3221 | 261757 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 394X Mullen Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010560 | 2099457 | 37.7453046014302 | -122.406172001215 | (37.7453046014302, -122.406172001215) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
10284 | 262216 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 4124 23rd St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002319 | 2102413 | 37.7529566754079 | -122.43487933109 | (37.7529566754079, -122.43487933109) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||
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 | |||||
78983 | 249881 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 230 Greenwich St | 17 | Back Yard : Yard | Tree | Private 2 | 16 | Width 0ft | 6011514.20842 | 2120460.74576 | 37.8030293886471 | -122.404350588107 | (37.8030293886471, -122.404350588107) | 3 | 1 | 10 | 28860 | 6 | |||
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 | |||||
18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 | ||||
20150 | 256573 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 145 Castenada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5994569 | 2100949 | 37.74849383418 | -122.461573977381 | (37.74849383418, -122.461573977381) | 1 | 8 | 4 | 29491 | 40 | ||||
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 | ||||
14083 | 247836 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 98 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6009033.20454 | 2098111.94521 | 37.7415258573291 | -122.411356422868 | (37.7415258573291, -122.411356422868) | 10 | 7 | 7 | 28859 | 2 | ||||
14514 | 264671 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 14 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 02:25:00 PM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
15073 | 264670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 13 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 02:23:00 PM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
15924 | 260485 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 79 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 6009047.04881 | 2098111.66242 | 37.7415258573221 | -122.411308533958 | (37.7415258573221, -122.411308533958) | 10 | 7 | 7 | 28859 | 2 | |||||
15999 | 247969 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 20 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 6010279.3453 | 2098938.24575 | 37.7438645128489 | -122.407105904041 | (37.7438645128489, -122.407105904041) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||
20981 | 197177 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 6 | Front Yard : Yard | Tree | Private 2 | 13 | 6012740.29154 | 2102830.02856 | 37.7546879247201 | -122.398869552986 | (37.7546879247201, -122.398869552986) | 10 | 3 | 8 | 28856 | 29 | ||||
26215 | 247066 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6002738.03181 | 2098489.47143 | 37.742207369874 | -122.433149926022 | (37.742207369874, -122.433149926022) | 2 | 7 | 5 | 63 | 22 | ||||
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 | |
33362 | 247610 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6009501.25197 | 2096696.3834 | 37.7376652719307 | -122.409638179058 | (37.7376652719307, -122.409638179058) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
35806 | 247833 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009033.18663 | 2098163.22314 | 37.7416666542973 | -122.411360106478 | (37.7416666542973, -122.411360106478) | 10 | 7 | 7 | 28859 | 2 | ||||
36136 | 197192 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6015810.17797 | 2099864.72659 | 37.7467164033528 | -122.388046043088 | (37.7467164033528, -122.388046043088) | 3 | 8 | 58 | 1 | |||||
36639 | 197190 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 9 | Front Yard : Yard | Tree | Private 2 | 13 | 6015846.29737 | 2099899.92461 | 37.7468150508735 | -122.387923600389 | (37.7468150508735, -122.387923600389) | 3 | 8 | 58 | 1 | |||||
43750 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1451 Bay St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||||
43771 | 247195 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900 Waller St | 9 | Front Yard : Yard | Tree | Private 2 | 20 | 6001251.02187 | 2108666.7471 | 37.7700672400275 | -122.439020747112 | (37.7700672400275, -122.439020747112) | 15 | 5 | 11 | 29492 | 9 | ||||
46764 | 247825 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Banks St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6008677.79642 | 2098169.294 | 37.7416633843669 | -122.412589360112 | (37.7416633843669, -122.412589360112) | 10 | 7 | 7 | 28859 | 2 | ||||
49665 | 247614 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6009490.01081 | 2096755.59346 | 37.7378272200383 | -122.40968122332 | (37.7378272200383, -122.40968122332) | 10 | 7 | 7 | 28859 | 2 | ||||
54045 | 247106 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 24 | Front Yard : Yard | Tree | Private 2 | 10 | 6002702.97811 | 2098815.334 | 37.7431001241765 | -122.433294410209 | (37.7431001241765, -122.433294410209) | 2 | 7 | 5 | 63 | 22 | ||||
54174 | 240323 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 10 | Front Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6000286.14451 | 2106902.79812 | 37.7651689296139 | -122.442231589424 | (37.7651689296139, -122.442231589424) | 15 | 5 | 5 | 28862 | 3 | |||
55180 | 240213 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1000 San Jose Ave | 101 | Front Yard : Yard | Tree | Private 2 | 3 | 6005074.47126 | 2096982.94014 | 37.738203036831 | -122.424964073757 | (37.738203036831, -122.424964073757) | 2 | 7 | 5 | 28859 | 7 | ||||
55783 | 249701 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2400 Baker St | 33 | Front Yard : Yard | Tree | Private 2 | 3 | 5999708.51738 | 2117216.5698 | 37.7934549597209 | -122.444970945052 | (37.7934549597209, -122.444970945052) | 13 | 9 | 1 | 57 | 27 | ||||
56517 | 247618 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 9 | Front Yard : Yard | Tree | Private 2 | 1 | 6009527.21147 | 2096859.2716 | 37.738113982375 | -122.409559917383 | (37.738113982375, -122.409559917383) | 10 | 7 | 7 | 28859 | 2 | ||||
56754 | 247097 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 15 | Front Yard : Yard | Tree | Private 2 | 3 | 6002735.73038 | 2098630.4546 | 37.7425943463453 | -122.433167954764 | (37.7425943463453, -122.433167954764) | 2 | 7 | 5 | 63 | 22 | ||||
57213 | 246766 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 70 Waltham St | 10 | Front Yard : Yard | Tree | Private 2 | 16 | 6009306.88166 | 2098893.44076 | 37.7436870190318 | -122.41046530715 | (37.7436870190318, -122.41046530715) | 2 | 7 | 7 | 28859 | 2 | ||||
58970 | 246765 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 70 Waltham St | 9 | Front Yard : Yard | Tree | Private 2 | 16 | 6009296.5447 | 2098891.99812 | 37.7436824783558 | -122.410500948159 | (37.7436824783558, -122.410500948159) | 2 | 7 | 7 | 28859 | 2 | ||||
60580 | 247622 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 13 | Front Yard : Yard | Tree | Private 2 | 1 | 6009485.42402 | 2096845.0974 | 37.7380727214716 | -122.409703397886 | (37.7380727214716, -122.409703397886) | 10 | 7 | 7 | 28859 | 2 | ||||
63896 | 247832 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6009025.09178 | 2098164.32129 | 37.7416692155576 | -122.411388173425 | (37.7416692155576, -122.411388173425) | 10 | 7 | 7 | 28859 | 2 | ||||
65516 | 247617 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 8 | Front Yard : Yard | Tree | Private 2 | 3 | 6009482.85815 | 2096793.30694 | 37.7379303722797 | -122.409708614859 | (37.7379303722797, -122.409708614859) | 10 | 7 | 7 | 28859 | 2 | ||||
68785 | 247615 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6009480.45148 | 2096767.81016 | 37.7378602287673 | -122.409715136771 | (37.7378602287673, -122.409715136771) | 10 | 7 | 7 | 28859 | 2 | ||||
71019 | 247068 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 4 | Front Yard : Yard | Tree | Private 2 | 2 | 6002725.31206 | 2098419.39316 | 37.7420142296685 | -122.433188900843 | (37.7420142296685, -122.433188900843) | 2 | 7 | 5 | 63 | 22 | ||||
71282 | 247616 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 7 | Front Yard : Yard | Tree | Private 2 | 2 | 6009490.26965 | 2096786.76921 | 37.7379128364137 | -122.409682528235 | (37.7379128364137, -122.409682528235) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
73178 | 240317 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 755 Sanchez St | 3 | Front Yard : Yard | Tree | Private 2 | 7 | Width 3ft | 6003689.25928 | 2103856.71067 | 37.7569984674284 | -122.430243705703 | (37.7569984674284, -122.430243705703) | 2 | 4 | 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 | ||
77708 | 247065 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6002733.02117 | 2098501.54815 | 37.7422402455053 | -122.433168113944 | (37.7422402455053, -122.433168113944) | 2 | 7 | 5 | 63 | 22 | ||||
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 | ||||
83115 | 197183 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1501 22nd St | 14 | Front Yard : Yard | Tree | Private 2 | 9 | 6013372.36986 | 2103823.70957 | 37.7574515566677 | -122.396753298024 | (37.7574515566677, -122.396753298024) | 10 | 3 | 8 | 28856 | 29 | ||||
85761 | 247621 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 12 | Front Yard : Yard | Tree | Private 2 | 2 | 6009492.19647 | 2096844.20783 | 37.7380706584199 | -122.409679919288 | (37.7380706584199, -122.409679919288) | 10 | 7 | 7 | 28859 | 2 | ||||
91236 | 240322 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 8 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6000307.84049 | 2106905.28674 | 37.7651769992311 | -122.442156727144 | (37.7651769992311, -122.442156727144) | 15 | 5 | 5 | 28862 | 3 | |||
91699 | 197189 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 7 | Front Yard : Yard | Tree | Private 2 | 21 | 6015936.19644 | 2099934.12978 | 37.7469139511226 | -122.387615121238 | (37.7469139511226, -122.387615121238) | 3 | 8 | 58 | 1 | |||||
94487 | 197184 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1501 22nd St | 20 | Front Yard : Yard | Tree | Private 2 | 8 | 6013333.16365 | 2103831.67556 | 37.7574712473141 | -122.396889448187 | (37.7574712473141, -122.396889448187) | 10 | 3 | 8 | 28856 | 29 | ||||
95771 | 240212 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1000 San Jose Ave | 82 | Front Yard : Yard | Tree | Private 2 | 7 | 6005076.07974 | 2097014.35872 | 37.738289396023 | -122.424960747163 | (37.738289396023, -122.424960747163) | 2 | 7 | 5 | 63 | 7 | ||||
97861 | 248043 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 37 Rutledge St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010549.4244 | 2099412.1414 | 37.7451808379205 | -122.406205410152 | (37.7451808379205, -122.406205410152) | 2 | 7 | 7 | 28859 | 2 | ||||
101728 | 247827 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 97 Banks St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 6008690.10957 | 2098158.02098 | 37.7416331221736 | -122.412545988525 | (37.7416331221736, -122.412545988525) | 10 | 7 | 7 | 28859 | 2 | ||||
109087 | 247075 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 11 | Front Yard : Yard | Tree | Private 2 | 5 | 6002772.7491 | 2098496.73645 | 37.7422292872545 | -122.433030403449 | (37.7422292872545, -122.433030403449) | 2 | 7 | 5 | 63 | 22 | ||||
111898 | 247837 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 98 Nevada St | 3 | Front Yard : Yard | Tree | Private 2 | 5 | 6009030.26469 | 2098089.72611 | 37.7414646836551 | -122.411365018597 | (37.7414646836551, -122.411365018597) | 10 | 7 | 7 | 28859 | 2 | ||||
113073 | 197196 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1951 Revere Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6013056.64262 | 2095884.22793 | 37.7356338527108 | -122.397288471104 | (37.7356338527108, -122.397288471104) | 10 | 3 | 8 | 58 | 1 | ||||
114570 | 247111 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 29 | Front Yard : Yard | Tree | Private 2 | 2 | 6002712.02693 | 2098697.32849 | 37.7427766218445 | -122.433254691659 | (37.7427766218445, -122.433254691659) | 2 | 7 | 5 | 63 | 22 | ||||
116223 | 197175 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | 6012742.61039 | 2102842.03619 | 37.7547210242675 | -122.398862376408 | (37.7547210242675, -122.398862376408) | 10 | 3 | 8 | 28856 | 29 | ||||
118045 | 247613 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 4 | Front Yard : Yard | Tree | Private 2 | 2 | 6009478.23642 | 2096751.70134 | 37.7378158733003 | -122.409721658635 | (37.7378158733003, -122.409721658635) | 10 | 7 | 7 | 28859 | 2 | ||||
125368 | 247116 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 34 | Front Yard : Yard | Tree | Private 2 | 2 | 6002706.05137 | 2098649.0279 | 37.742643660667 | -122.433271902871 | (37.742643660667, -122.433271902871) | 2 | 7 | 5 | 63 | 22 | ||||
129326 | 197194 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 37 | Front Yard : Yard | Tree | Private 2 | 12 | 6015675.19682 | 2099860.17709 | 37.746696432096 | -122.388512480964 | (37.746696432096, -122.388512480964) | 3 | 8 | 58 | 1 | |||||
136991 | 247826 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Banks St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 6008666.54857 | 2098148.46053 | 37.7416055489639 | -122.412626779128 | (37.7416055489639, -122.412626779128) | 10 | 7 | 7 | 28859 | 2 | ||||
137807 | 247611 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6009478.11673 | 2096708.87716 | 37.7376982806503 | -122.409719050602 | (37.7376982806503, -122.409719050602) | 10 | 7 | 7 | 28859 | 2 | ||||
138624 | 240321 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 7 | Front Yard : Yard | Tree | Private 2 | 10 | Width 3ft | 6000321.62859 | 2106905.98054 | 37.7651796900124 | -122.442109087376 | (37.7651796900124, -122.442109087376) | 15 | 5 | 5 | 28862 | 3 | |||
139293 | 247619 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 10 | Front Yard : Yard | Tree | Private 2 | 4 | 6009506.60291 | 2096847.67057 | 37.738080973649 | -122.409630353184 | (37.738080973649, -122.409630353184) | 10 | 7 | 7 | 28859 | 2 | ||||
140654 | 240211 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1001 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 2 | 6005198.75303 | 2096936.51441 | 37.7380825816504 | -122.424531067257 | (37.7380825816504, -122.424531067257) | 2 | 7 | 5 | 28859 | 2 | ||||
143954 | 247841 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 77 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009047.64568 | 2098175.65883 | 37.7417016109343 | -122.411310990032 | (37.7417016109343, -122.411310990032) | 10 | 7 | 7 | 28859 | 2 | ||||
146842 | 247840 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 77 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6009043.26333 | 2098169.73656 | 37.7416851038897 | -122.41132572452 | (37.7416851038897, -122.41132572452) | 10 | 7 | 7 | 28859 | 2 | ||||
150842 | 247067 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 3 | Front Yard : Yard | Tree | Private 2 | 2 | 6002720.65307 | 2098435.27212 | 37.7420575653112 | -122.43320614446 | (37.7420575653112, -122.43320614446) | 2 | 7 | 5 | 63 | 22 | ||||
152026 | 197193 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 15 | Front Yard : Yard | Tree | Private 2 | 10 | 6015814.64437 | 2099848.11828 | 37.7466710478274 | -122.388029439803 | (37.7466710478274, -122.388029439803) | 3 | 8 | 58 | 1 | |||||
155576 | 197176 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6012733.87653 | 2102837.73579 | 37.7547087296482 | -122.398892278868 | (37.7547087296482, -122.398892278868) | 10 | 3 | 8 | 28856 | 29 | ||||
155710 | 197191 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 12 | Front Yard : Yard | Tree | Private 2 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.387947067298 | (37.7467614521736, -122.387947067298) | 3 | 8 | 58 | 1 | |||||
156170 | 197174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6012741.09137 | 2102852.39923 | 37.754749394281 | -122.3988683569 | (37.754749394281, -122.3988683569) | 10 | 3 | 8 | 28856 | 29 | ||||
156431 | 247194 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900 Waller St | 8 | Front Yard : Yard | Tree | Private 2 | 14 | 6001245.27883 | 2108670.04776 | 37.7700759760472 | -122.439040848753 | (37.7700759760472, -122.439040848753) | 15 | 5 | 11 | 29492 | 9 | ||||
157388 | 247095 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 6002730.40723 | 2098617.72179 | 37.7425590830422 | -122.433185451064 | (37.7425590830422, -122.433185451064) | 2 | 7 | 5 | 63 | 22 | ||||
158309 | 247107 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 25 | Front Yard : Yard | Tree | Private 2 | 4 | 6002697.86088 | 2098808.57666 | 37.7430812797894 | -122.433311621447 | (37.7430812797894, -122.433311621447) | 2 | 7 | 5 | 63 | 22 | ||||
167080 | 247828 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 97 Banks St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | 6008690.7766 | 2098166.57943 | 37.7416566592328 | -122.412544286997 | (37.7416566592328, -122.412544286997) | 10 | 7 | 7 | 28859 | 2 | ||||
169716 | 197173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 6012739.26156 | 2102864.49072 | 37.7547824929244 | -122.398875533502 | (37.7547824929244, -122.398875533502) | 10 | 3 | 8 | 28856 | 29 | ||||
176251 | 247620 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 11 | Front Yard : Yard | Tree | Private 2 | 3 | 6009499.0149 | 2096845.57138 | 37.7380747845204 | -122.409656440699 | (37.7380747845204, -122.409656440699) | 10 | 7 | 7 | 28859 | 2 | ||||
177390 | 247612 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 3 | Front Yard : Yard | Tree | Private 2 | 2 | 6009485.09614 | 2096718.12659 | 37.7377240687023 | -122.409695572001 | (37.7377240687023, -122.409695572001) | 10 | 7 | 7 | 28859 | 2 | ||||
182101 | 247103 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 21 | Front Yard : Yard | Tree | Private 2 | 3 | 6002737.73752 | 2098774.19927 | 37.7429891496381 | -122.433171283123 | (37.7429891496381, -122.433171283123) | 2 | 7 | 5 | 63 | 22 | ||||
188279 | 247115 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 33 | Front Yard : Yard | Tree | Private 2 | 2 | 6002710.00454 | 2098655.04681 | 37.7426604114562 | -122.433258663951 | (37.7426604114562, -122.433258663951) | 2 | 7 | 5 | 63 | 22 | ||||
193488 | 240320 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 6 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6000338.40748 | 2106908.57124 | 37.7651877596278 | -122.442051239382 | (37.7651877596278, -122.442051239382) | 15 | 5 | 5 | 28862 | 3 | |||
1132 | 87818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 85 Mendosa Ave | 1 | Median : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | Permit Number 50680 | 5993356 | 2100787 | 37.747979128324 | -122.465756707117 | (37.747979128324, -122.465756707117) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
40489 | 6510 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1200X Evans Ave | 2 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6017613.51756 | 2097076.90112 | 37.7391613427334 | -122.381616361724 | (37.7391613427334, -122.381616361724) | 10 | 3 | 8 | 58 | 1 | |||
47338 | 99497 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1400X Plymouth Ave | 4 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
66489 | 96226 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 14X CAINE AVE | 11 | Median : Cutout | Tree | DPW 1 | 08/24/2011 12:00:00 AM | 3 | 6x300 | 5997641.2 | 2089761.8 | 37.7179528127364 | -122.450144172407 | (37.7179528127364, -122.450144172407) | 9 | 8 | 6 | 28861 | 24 | ||
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 | |||
77433 | 29594 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900X Junipero Serra Blvd | 3 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991181.08119 | 2091145.24325 | 37.7213796099522 | -122.472574562389 | (37.7213796099522, -122.472574562389) | 9 | 8 | 4 | 64 | 40 |
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) );