trees
603 rows where qSpecies_id = 172 sorted by Zip Codes
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 | |||||||||||||
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 | |||||
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 | |||
126888 | 197203 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 05th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010503.85094 | 2113243.76912 | 37.7831568013875 | -122.407337895824 | (37.7831568013875, -122.407337895824) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | |||
20588 | 197185 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 651 Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6013630.37789 | 2103829.16713 | 37.7574808988518 | -122.395861379221 | (37.7574808988518, -122.395861379221) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
31480 | 197172 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900x Carolina St | 24 | Median : Yard | Tree | DPW 1 | 3 | 6012477.22941 | 2103487.19338 | 37.7564776943092 | -122.39982544149 | (37.7564776943092, -122.39982544149) | 10 | 3 | 8 | 28856 | 29 | ||||
51341 | 97051 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
67171 | 53858 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 730 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1972 12:00:00 AM | 6 | Permit Number 9568 | 6015422.25071 | 2105620.89151 | 37.762500112301 | -122.389789458021 | (37.762500112301, -122.389789458021) | 10 | 3 | 8 | 28856 | 29 | ||
71600 | 197181 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Rhode Island St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 7ft | 6011998.69489 | 2102279.56036 | 37.7531351094233 | -122.401395527392 | (37.7531351094233, -122.401395527392) | 10 | 3 | 8 | 28856 | 29 | |||
73008 | 197182 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1750 22nd St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6012809.54728 | 2103799.82503 | 37.7573546331292 | -122.398698099955 | (37.7573546331292, -122.398698099955) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
86307 | 197178 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 24 | Median : Yard | Tree | DPW 1 | 1 | 6012271.91368 | 2102115.47955 | 37.7526998195515 | -122.400439152361 | (37.7526998195515, -122.400439152361) | 10 | 3 | 8 | 28856 | 29 | ||||
87367 | 197179 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 13 | Median : Yard | Tree | DPW 1 | 2 | 6012255.14184 | 2102164.55152 | 37.7528336251844 | -122.400500599441 | (37.7528336251844, -122.400500599441) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
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 | ||||
152360 | 197180 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 11 | Median : Yard | Tree | DPW 1 | 1 | 6012255.35088 | 2102175.8421 | 37.752864638318 | -122.400500669565 | (37.752864638318, -122.400500669565) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
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 | ||||
156274 | 197171 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 670 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015971.35988 | 2105878.87725 | 37.7632389206717 | -122.387908275953 | (37.7632389206717, -122.387908275953) | 14 | 3 | 8 | 28856 | 29 | |||
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 | ||||
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 | ||||
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 | |||
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 | |
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 | |||
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 | |||
1380 | 240268 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 601x Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008545.16525 | 2098123.68757 | 37.7415307145772 | -122.413044731843 | (37.7415307145772, -122.413044731843) | 10 | 7 | 7 | 28859 | 2 | ||||
2164 | 240263 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 400X Powhattan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6008170.52393 | 2098149.53855 | 37.7415806575183 | -122.414341946344 | (37.7415806575183, -122.414341946344) | 2 | 7 | 7 | 28859 | 2 | ||||
2307 | 240272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 99 Prentiss St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008870 | 2098076 | 37.7414180046723 | -122.41191819098 | (37.7414180046723, -122.41191819098) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
4654 | 240225 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006210.25986 | 2095801.94104 | 37.7350243668737 | -122.420953246717 | (37.7350243668737, -122.420953246717) | 2 | 7 | 7 | 28859 | 2 | |||
4897 | 240251 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005903.53457 | 2096951.45984 | 37.7381633947238 | -122.422095344327 | (37.7381633947238, -122.422095344327) | 2 | 7 | 7 | 28859 | 2 | |||
5010 | 240274 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008888.17456 | 2098091.89033 | 37.7414626556745 | -122.411856472021 | (37.7414626556745, -122.411856472021) | 10 | 7 | 7 | 28859 | 2 | ||||
7385 | 240269 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 701X Powhattan Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008659.36547 | 2098106.42787 | 37.7414897333626 | -122.412648645239 | (37.7414897333626, -122.412648645239) | 10 | 7 | 7 | 28859 | 2 | ||||
7421 | 240271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 99 Banks St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008711 | 2098131 | 37.741560100881 | -122.412471846631 | (37.741560100881, -122.412471846631) | 10 | 7 | 7 | 28859 | 2 | ||||
8335 | 240290 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401x Powhattan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 3ft | 6008169.50136 | 2098124.42294 | 37.7415116381522 | -122.414343705408 | (37.7415116381522, -122.414343705408) | 2 | 7 | 7 | 28859 | 2 | |||
11645 | 240229 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006267.81246 | 2095797.32513 | 37.7350149365947 | -122.420753938963 | (37.7350149365947, -122.420753938963) | 2 | 7 | 7 | 28859 | 2 | |||
11781 | 240270 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 98 Banks St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008655 | 2098137 | 37.7415734327052 | -122.412665900326 | (37.7415734327052, -122.412665900326) | 10 | 7 | 7 | 28859 | 2 | ||||
12507 | 240276 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008927.20227 | 2098089.49395 | 37.7414582651784 | -122.411721357863 | (37.7414582651784, -122.411721357863) | 10 | 7 | 7 | 28859 | 2 | ||||
13296 | 240275 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6008914.92276 | 2098091.07722 | 37.7414619236323 | -122.411763928179 | (37.7414619236323, -122.411763928179) | 10 | 7 | 7 | 28859 | 2 | ||||
13394 | 240273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008878.25951 | 2098091.29342 | 37.7414604604356 | -122.411890712802 | (37.7414604604356, -122.411890712802) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
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 | ||||
15042 | 240277 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 877 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007991.30005 | 2102784.81683 | 37.7542980236532 | -122.415289699587 | (37.7542980236532, -122.415289699587) | 2 | 4 | 7 | 28859 | 19 | |||
15301 | 240264 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 400X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008183.28194 | 2098148.67915 | 37.741579014462 | -122.414297772542 | (37.741579014462, -122.414297772542) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
18184 | 240293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2956 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008497.16322 | 2103323.50605 | 37.7558055598955 | -122.413578388654 | (37.7558055598955, -122.413578388654) | 2 | 4 | 7 | 28859 | 19 | |||
18370 | 247631 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1021 Jarboe Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009422.11073 | 2096880.05562 | 37.7381651609976 | -122.409924771417 | (37.7381651609976, -122.409924771417) | 10 | 7 | 7 | 28859 | 2 | ||||
20751 | 247952 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 5 | Side Yard : Yard | Tree | Private 2 | 6 | 6010434.68219 | 2098863.51365 | 37.7436680064839 | -122.406563517508 | (37.7436680064839, -122.406563517508) | 2 | 7 | 7 | 28859 | 2 | ||||
21952 | 240259 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005695.76113 | 2097061.18418 | 37.7384529521271 | -122.422821518092 | (37.7384529521271, -122.422821518092) | 2 | 7 | 7 | 28859 | 2 | |||
22747 | 240246 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006060.34827 | 2096863.07989 | 37.7379295664827 | -122.42154688469 | (37.7379295664827, -122.42154688469) | 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 | ||||
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 | |
29708 | 247953 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 6 | Side Yard : Yard | Tree | Private 2 | 10 | 6010438.9217 | 2098856.89307 | 37.7436500649912 | -122.406548391799 | (37.7436500649912, -122.406548391799) | 2 | 7 | 7 | 28859 | 2 | ||||
30244 | 247948 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
30406 | 240234 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006339.6227 | 2095791.19011 | 37.7350021383438 | -122.420505229653 | (37.7350021383438, -122.420505229653) | 2 | 7 | 7 | 28859 | 2 | |||
31893 | 240235 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006361.75511 | 2095789.26395 | 37.7349980967903 | -122.420428573244 | (37.7349980967903, -122.420428573244) | 2 | 7 | 7 | 28859 | 2 | |||
32109 | 256217 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 159X Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 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 | ||||
34414 | 240245 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006078.33577 | 2096854.32708 | 37.737906547446 | -122.42148407153 | (37.737906547446, -122.42148407153) | 2 | 7 | 7 | 28859 | 2 | |||
34820 | 240239 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006416.61409 | 2095785.43959 | 37.7349906872665 | -122.420238634604 | (37.7349906872665, -122.420238634604) | 2 | 7 | 7 | 28859 | 2 | |||
35222 | 248061 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 18 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6010675.96291 | 2099385.23379 | 37.7451140326787 | -122.40576596453 | (37.7451140326787, -122.40576596453) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
36674 | 240226 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006225.25616 | 2095800.40659 | 37.735020998922 | -122.420901290175 | (37.735020998922, -122.420901290175) | 2 | 7 | 7 | 28859 | 2 | |||
43964 | 240231 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006293.37748 | 2095794.59249 | 37.7350088742503 | -122.420665357522 | (37.7350088742503, -122.420665357522) | 2 | 7 | 7 | 28859 | 2 | |||
43977 | 247900 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 353 Mayflower St | 2 | Side Yard : Yard | Tree | Private 2 | 20 | 6009993.56525 | 2098391.56097 | 37.7423474383843 | -122.408055523371 | (37.7423474383843, -122.408055523371) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
46694 | 240227 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006241.01631 | 2095800.08306 | 37.7350209989201 | -122.420846778675 | (37.7350209989201, -122.420846778675) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
48760 | 255654 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 298X Coso Ave | 2 | Side Yard : Yard | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | 10x10 | Permit Number 776462 | 6007785 | 2099424 | 37.7450583812321 | -122.415765181935 | (37.7450583812321, -122.415765181935) | 2 | 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 | ||||
50121 | 240237 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006385.38025 | 2095788.04313 | 37.7349960760111 | -122.420346805985 | (37.7349960760111, -122.420346805985) | 2 | 7 | 7 | 28859 | 2 | |||
50577 | 240228 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006254.27366 | 2095797.84836 | 37.735015610176 | -122.420800784622 | (37.735015610176, -122.420800784622) | 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 | ||||
53600 | 247634 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 351 Bradford St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6009494.55377 | 2096596.6066 | 37.7373909310424 | -122.409654297605 | (37.7373909310424, -122.409654297605) | 10 | 7 | 7 | 28859 | 2 | ||||
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 |
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) );