trees
603 rows where qSpecies_id = 172 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1168 | 39947 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
3382 | 46731 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
5647 | 46732 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
6590 | 39944 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
7296 | 39946 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
9758 | 46722 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
10645 | 46730 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
11952 | 39952 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
12633 | 39951 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
14549 | 39950 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
14616 | 39953 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
15472 | 46729 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
17495 | 39948 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
18303 | 39949 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
18519 | 260473 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 520 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||||
33386 | 18939 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.7893621369983 | -122.438275289198 | (37.7893621369983, -122.438275289198) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
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 | |||
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 | ||||
53513 | 42689 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
88785 | 42687 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | ||
90638 | 87803 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1955 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50568 | 6004869.41354 | 2117067.20941 | 37.793338047856 | -122.427103202078 | (37.793338047856, -122.427103202078) | 13 | 9 | 1 | 28858 | 27 | |
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 | |||
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 | |||
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 | ||
134429 | 18936 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2721 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001590.13521 | 2115636.51425 | 37.7892237457171 | -122.438347166582 | (37.7892237457171, -122.438347166582) | 13 | 6 | 1 | 29490 | 27 | |||
138725 | 42690 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
139340 | 96616 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2943 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 3 | 3x6 | Permit Number 767742 | 6002898.54873 | 2118761.82237 | 37.7978793705859 | -122.434043718143 | (37.7978793705859, -122.434043718143) | 13 | 9 | 1 | 57 | 17 | |
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 | ||||
174772 | 42688 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
182050 | 18938 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2730 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/21/2001 12:00:00 AM | 6 | 4X4 | 6001751.73398 | 2115704.11419 | 37.7894185478752 | -122.437792899137 | (37.7894185478752, -122.437792899137) | 13 | 6 | 1 | 29490 | 27 | ||
185856 | 27293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1628 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 5990401.75859 | 2114777.42415 | 37.7862221958377 | -122.476994379351 | (37.7862221958377, -122.476994379351) | 11 | 6 | 1 | 55 | 33 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
14733 | 255398 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 637 MASONIC AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999139.3301 | 2110590.1819 | 37.7752281241925 | -122.446463429304 | (37.7752281241925, -122.446463429304) | 15 | 5 | 11 | 29492 | 16 | ||||
22077 | 49434 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4746@ COLE 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 46372 | 5998472.35815921 | 2105699.24121629 | 37.7617607258811 | -122.448418330414 | (37.7617607258811, -122.448418330414) | 15 | 5 | 11 | 29492 | 9 | ||
25855 | 244078 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1768 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998103.3126 | 2108943.7673 | 37.7706482646329 | -122.449928548475 | (37.7706482646329, -122.449928548475) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||||
45451 | 88773 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
51002 | 240326 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 343 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004069.13295 | 2109034.20183 | 37.7712361239812 | -122.429299145951 | (37.7712361239812, -122.429299145951) | 7 | 9 | 11 | 29492 | 10 | |||
84814 | 88772 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
85848 | 247534 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Waller St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6000131.92851 | 2108487.4209 | 37.7695111172828 | -122.442878784742 | (37.7695111172828, -122.442878784742) | 15 | 5 | 11 | 29492 | 9 | ||||
113121 | 247545 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 815 Buena Vista Ave West | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6000159.70367 | 2108448.81538 | 37.7694066996778 | -122.442779939341 | (37.7694066996778, -122.442779939341) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
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 | |||
143972 | 247528 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Waller St | 9 | Side Yard : Yard | Tree | Private 2 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||||
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 | |||
22365 | 43747 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 271 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43383 | 5991501.55503 | 2113612.76885 | 37.7830881153357 | -122.47310444242 | (37.7830881153357, -122.47310444242) | 11 | 6 | 2 | 54 | 26 | |
27487 | 90241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986391.93511 | 2111177.84451 | 37.7761053454235 | -122.490602199432 | (37.7761053454235, -122.490602199432) | 11 | 6 | 2 | 55 | 26 | ||
33649 | 90242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986371.9113 | 2111177.50971 | 37.7761032565147 | -122.490671441556 | (37.7761032565147, -122.490671441556) | 11 | 6 | 2 | 55 | 26 | ||
39611 | 46658 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 239 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | 12 | Permit Number 44789 | 5988674.72219 | 2113730.06993 | 37.7832461170437 | -122.482892615104 | (37.7832461170437, -122.482892615104) | 11 | 6 | 2 | 55 | 26 | |
41673 | 90239 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986460.59173 | 2111180.188 | 37.7761157900861 | -122.490364873506 | (37.7761157900861, -122.490364873506) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
45804 | 90968 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4149X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982697.48853 | 2110986.30028 | 37.7753629296515 | -122.503367879459 | (37.7753629296515, -122.503367879459) | 11 | 6 | 2 | 55 | 26 | ||
50608 | 90293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
82205 | 90292 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
97911 | 90236 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986564.88308 | 2111184.05617 | 37.7761325015309 | -122.49000439126 | (37.7761325015309, -122.49000439126) | 11 | 6 | 2 | 55 | 26 | ||
98190 | 90273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4138 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982680.48649 | 2111041.10638 | 37.7755124117331 | -122.50343075165 | (37.7755124117331, -122.50343075165) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
116691 | 90294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
118932 | 90237 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986502.49805 | 2111182.03545 | 37.7761233100942 | -122.490220046223 | (37.7761233100942, -122.490220046223) | 11 | 6 | 2 | 55 | 26 | ||
120475 | 90731 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4575 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981455 | 2110247 | 37.7732599086068 | -122.50761099125 | (37.7732599086068, -122.50761099125) | 11 | 6 | 2 | 55 | 26 | ||
121538 | 90297 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4545X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981520.769284 | 2110951.300184 | 37.7751975846267 | -122.50743575643 | (37.7751975846267, -122.50743575643) | 11 | 6 | 2 | 55 | 26 | |
140411 | 90246 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986239.468923 | 2111161.958067 | 37.7760528187899 | -122.491128444049 | (37.7760528187899, -122.491128444049) | 11 | 6 | 2 | 55 | 26 | |
140708 | 92256 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 854 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52705 | 5981409.14795 | 2109916.38361 | 37.7723494315348 | -122.507745058107 | (37.7723494315348, -122.507745058107) | 11 | 6 | 2 | 55 | 26 | |
157288 | 90245 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986200.19499 | 2111171.72975 | 37.7760773543178 | -122.491265020448 | (37.7760773543178, -122.491265020448) | 11 | 6 | 2 | 55 | 26 | ||
160862 | 90295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
168158 | 90298 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981574.06475 | 2110953.226782 | 37.7752060137503 | -122.507251541607 | (37.7752060137503, -122.507251541607) | 11 | 6 | 2 | 55 | 26 | |
169840 | 34698 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 715 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/10/2002 12:00:00 AM | 2 | Permit Number 45251 | 5981951.23217 | 2110867.89053 | 37.7749939133636 | -122.505940528656 | (37.7749939133636, -122.505940528656) | 11 | 6 | 2 | 55 | 26 | |
171828 | 90244 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986220.07913 | 2111172.67589 | 37.7760811139804 | -122.491196306516 | (37.7760811139804, -122.491196306516) | 11 | 6 | 2 | 55 | 26 | ||
176100 | 90288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4790X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980763.025413 | 2110963.934321 | 37.7751876098256 | -122.51005785431 | (37.7751876098256, -122.51005785431) | 11 | 6 | 2 | 55 | 26 | |
177162 | 90271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4100X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982889.660166 | 2111040.818849 | 37.7755239169344 | -122.502707160377 | (37.7755239169344, -122.502707160377) | 11 | 6 | 2 | 55 | 26 | |
183826 | 90272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4122 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982765.5809 | 2111043.53002 | 37.7755240685037 | -122.503136574036 | (37.7755240685037, -122.503136574036) | 11 | 6 | 2 | 55 | 26 | ||
187334 | 83256 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 606 40th Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/22/2009 12:00:00 AM | 3x3 | Permit Number 52675 | 5983524.4637113 | 2111665.45809924 | 37.7772762800291 | -122.500557454432 | (37.7772762800291, -122.500557454432) | 11 | 6 | 2 | 55 | 26 | ||
2184 | 185987 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984879.8852 | 2101041.6583 | 37.7481857789236 | -122.495085101033 | (37.7481857789236, -122.495085101033) | 1 | 8 | 3 | 29491 | 35 | |||
8057 | 185640 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2100 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985051.8314 | 2100435.5567 | 37.7465316538612 | -122.494445852676 | (37.7465316538612, -122.494445852676) | 1 | 8 | 3 | 29491 | 35 | |||
19946 | 185718 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2101 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984903.2589 | 2100385.7239 | 37.7463861302867 | -122.494955918818 | (37.7463861302867, -122.494955918818) | 1 | 8 | 3 | 29491 | 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 | |||
26973 | 186271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985012.6813 | 2102437.2405 | 37.7520254389338 | -122.494728778892 | (37.7520254389338, -122.494728778892) | 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 | |||
33320 | 186228 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1701 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984813.4188 | 2103368.4703 | 37.7545706737005 | -122.495486523075 | (37.7545706737005, -122.495486523075) | 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 | |||
36291 | 185651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2100 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985060.0587 | 2100520.4285 | 37.7467651702303 | -122.494423659241 | (37.7467651702303, -122.494423659241) | 1 | 8 | 3 | 29491 | 35 | |||
38694 | 186265 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985011.4731 | 2102352.6681 | 37.7517931556361 | -122.494726722368 | (37.7517931556361, -122.494726722368) | 1 | 8 | 3 | 56 | 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) );