trees
213 rows where SiteOrder = 3 and qSpecies_id = 31 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
428 | 119830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
7980 | 260398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
8784 | 46303 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
9242 | 119783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
23251 | 119710 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
37614 | 119819 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
51199 | 119795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
127662 | 119677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
189843 | 119701 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 3 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
191279 | 119748 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
3172 | 138586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2702 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000914.7508 | 2114889.5525 | 37.7871343442132 | -122.440630309715 | (37.7871343442132, -122.440630309715) | 13 | 6 | 1 | 29490 | 27 | |||
14091 | 65135 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 29 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1989 12:00:00 AM | 24 | 6x25 | Permit Number 27110 | 5990777 | 2114840 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | 11 | 6 | 1 | 54 | 33 | |
24118 | 97269 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2050X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769192 | 5999973.8 | 2116027.1 | 37.79020412496 | -122.443967546887 | (37.79020412496, -122.443967546887) | 13 | 6 | 1 | 29490 | 27 | |||
30309 | 137034 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1756 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005175.40466 | 2117844.84093 | 37.7954905257115 | -122.426099835651 | (37.7954905257115, -122.426099835651) | 13 | 9 | 1 | 28858 | 27 | |||
36744 | 136985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998649.64618 | 2115048.5568 | 37.7874416806303 | -122.448478497988 | (37.7874416806303, -122.448478497988) | 13 | 6 | 1 | 54 | 31 | |||
41548 | 89025 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2724 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774819 | 6000906.5 | 2116912.2 | 37.7926875389812 | -122.440804001611 | (37.7926875389812, -122.440804001611) | 13 | 6 | 1 | 29490 | 27 | |
58992 | 136977 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 304 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5998585.82745 | 2115521.28488 | 37.7887360181866 | -122.448733358666 | (37.7887360181866, -122.448733358666) | 13 | 6 | 1 | 54 | 31 | |||
59964 | 93910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 3x3 | 6001101.2138 | 2114914.769 | 37.7872141986511 | -122.439986998855 | (37.7872141986511, -122.439986998855) | 13 | 6 | 1 | 29490 | 27 | ||
69027 | 45652 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | 13 | 6 | 1 | 29490 | 27 | |||
69088 | 136964 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2590 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000622.04414 | 2118252.24291 | 37.7963507407448 | -122.441884450223 | (37.7963507407448, -122.441884450223) | 13 | 9 | 1 | 57 | 17 | |||
74737 | 137014 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2795 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000218.16422 | 2117453.42518 | 37.7941343759438 | -122.443224553374 | (37.7941343759438, -122.443224553374) | 13 | 9 | 1 | 57 | 27 | |||
99141 | 18008 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X4 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 | |||
100819 | 97270 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3099 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2011 12:00:00 AM | 3x3 | Permit Number 768129 | 5999976 | 2116041.4 | 37.7902435145098 | -122.443960962963 | (37.7902435145098, -122.443960962963) | 13 | 6 | 1 | 29490 | 27 | ||
120365 | 136962 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2460 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001208.87225 | 2118332.01325 | 37.7966031903358 | -122.439859628443 | (37.7966031903358, -122.439859628443) | 13 | 9 | 1 | 57 | 17 | |||
162657 | 120388 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 151 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5988095.61955 | 2115306.53234 | 37.7875409216626 | -122.485011751628 | (37.7875409216626, -122.485011751628) | 11 | 6 | 1 | 55 | 33 | |||
176355 | 137021 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6003013.18529 | 2117480.30225 | 37.7943671528679 | -122.433555411475 | (37.7943671528679, -122.433555411475) | 13 | 9 | 1 | 29490 | 27 | |||
184326 | 136987 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1508 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005725.54512 | 2118613.25141 | 37.7976314643833 | -122.424250931151 | (37.7976314643833, -122.424250931151) | 13 | 9 | 1 | 57 | 17 | |||
185104 | 136960 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6000577.85533 | 2118280.57754 | 37.7964260220962 | -122.442039387228 | (37.7964260220962, -122.442039387228) | 13 | 9 | 1 | 57 | 17 | |||
185644 | 141076 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 189 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5996534.5761 | 2113062.8589 | 37.7818683255127 | -122.455652579934 | (37.7818683255127, -122.455652579934) | 11 | 6 | 1 | 54 | 31 | |||
186333 | 103276 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
187100 | 137013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2920 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 5999627.95657 | 2117064.96637 | 37.7930340986073 | -122.445238785654 | (37.7930340986073, -122.445238785654) | 13 | 9 | 1 | 57 | 27 | |||
191398 | 137007 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2110 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6000409.78884 | 2115912.00692 | 37.7899129699478 | -122.442450796488 | (37.7899129699478, -122.442450796488) | 13 | 6 | 1 | 29490 | 27 | |||
3023 | 137045 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.7925550234358 | -122.412997178389 | (37.7925550234358, -122.412997178389) | 5 | 1 | 10 | 28857 | 21 | |||
97382 | 137049 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008515.90058 | 2116780.94571 | 37.7927575660663 | -122.414465794683 | (37.7927575660663, -122.414465794683) | 5 | 1 | 10 | 28858 | 21 | |||
116030 | 35674 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
116258 | 137062 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011753.78546 | 2118398.85013 | 37.7973813080638 | -122.40337638132 | (37.7973813080638, -122.40337638132) | 3 | 1 | 10 | 308 | 23 | |||
147272 | 137039 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009772.70737 | 2116813.88249 | 37.7929185267084 | -122.410119497111 | (37.7929185267084, -122.410119497111) | 3 | 1 | 10 | 28857 | 21 | |||
180728 | 137057 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011992.2179 | 2118432.89222 | 37.7974880935481 | -122.402553733674 | (37.7974880935481, -122.402553733674) | 3 | 1 | 10 | 308 | 23 | |||
190372 | 137058 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 440 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011933.40589 | 2118423.08303 | 37.7974578763363 | -122.402756549698 | (37.7974578763363, -122.402756549698) | 3 | 1 | 10 | 308 | 23 | |||
16049 | 258892 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
26272 | 9765 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.7782631876883 | -122.440226567073 | (37.7782631876883, -122.440226567073) | 15 | 5 | 11 | 29490 | 41 | ||
31677 | 138807 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | 13 | 9 | 11 | 29490 | 27 | |||
37362 | 242429 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005025.33066 | 2109905.44475 | 37.7736824328302 | -122.426053649163 | (37.7736824328302, -122.426053649163) | 7 | 9 | 11 | 28852 | 10 | |||
48013 | 17920 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
53194 | 138169 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1884 BUSH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004466.1638 | 2115036.3369 | 37.7877389735872 | -122.428353661193 | (37.7877389735872, -122.428353661193) | 13 | 9 | 11 | 28858 | 27 | |||
60396 | 245223 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | 7 | 9 | 11 | 28852 | 10 | |||
61528 | 136986 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 Hayes St | 3 | : | Tree | Private 2 | 19 | Width 4ft | 6004705.5479 | 2110850.60835 | 37.7762595426756 | -122.427227166401 | (37.7762595426756, -122.427227166401) | 7 | 9 | 11 | 28852 | 10 | |||
70010 | 14840 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.433664099691 | (37.7783201948721, -122.433664099691) | 15 | 5 | 11 | 29492 | 41 | ||
80826 | 141750 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004009.3479 | 2113234.7782 | 37.7827664857396 | -122.429805607802 | (37.7827664857396, -122.429805607802) | 7 | 9 | 11 | 29490 | 41 | |||
87612 | 244235 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | 7 | 9 | 11 | 28852 | 10 | |||
88042 | 244423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | 7 | 9 | 11 | 28852 | 10 | |||
92624 | 138802 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.7877110857669 | -122.435020465254 | (37.7877110857669, -122.435020465254) | 13 | 9 | 11 | 29490 | 27 | |||
95390 | 141891 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1335 EDDY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004124.0082 | 2112861.9655 | 37.7817493272221 | -122.42938233739 | (37.7817493272221, -122.42938233739) | 7 | 9 | 11 | 29490 | 41 | |||
104664 | 17810 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1900X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 4 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | 13 | 9 | 11 | 28858 | 27 | ||
127916 | 137642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002857.7118 | 2111638.0989 | 37.7783171230031 | -122.433675627626 | (37.7783171230031, -122.433675627626) | 15 | 5 | 11 | 29492 | 41 | |||
138929 | 246537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | 7 | 9 | 11 | 28852 | 10 | |||
151315 | 38063 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1805X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40255 | 6000940.99475203 | 2111717.60117276 | 37.77842647246 | -122.440311948792 | (37.77842647246, -122.440311948792) | 15 | 5 | 11 | 29490 | 41 | |
155333 | 23808 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1375X Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003890.67101 | 2112819.25759 | 37.7816188487105 | -122.430186526557 | (37.7816188487105, -122.430186526557) | 7 | 9 | 11 | 29490 | 41 | |||
157796 | 244256 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | 7 | 9 | 11 | 28852 | 10 | |||
158406 | 141756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003949.9068 | 2113305.5788 | 37.7829575203066 | -122.430016301018 | (37.7829575203066, -122.430016301018) | 7 | 9 | 11 | 29490 | 41 | |||
165684 | 14591 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/09/2011 12:00:00 AM | 3 | 3x3 | 5999412.7083 | 2108624.4902 | 37.7698464448905 | -122.445376387082 | (37.7698464448905, -122.445376387082) | 15 | 5 | 11 | 29492 | 9 | ||
171503 | 246549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 6005737.248 | 2109452.92689 | 37.7724801381679 | -122.423558835368 | (37.7724801381679, -122.423558835368) | 7 | 9 | 11 | 28852 | 10 | |||
171951 | 141786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1471 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003844.5104 | 2113167.1525 | 37.7825714667037 | -122.430371049321 | (37.7825714667037, -122.430371049321) | 7 | 9 | 11 | 29490 | 41 | |||
181645 | 244373 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | 7 | 9 | 11 | 28852 | 10 | |||
182106 | 244315 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.424428160556 | (37.7754801903482, -122.424428160556) | 7 | 9 | 11 | 28852 | 10 | |||
182723 | 244355 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.424130226226 | (37.7750804055544, -122.424130226226) | 7 | 9 | 11 | 28852 | 10 | |||
186650 | 17941 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2016 12:00:00 AM | 18 | 3x3 | 6002249.5312774 | 2115023.8576257 | 37.7875790308508 | -122.436021882306 | (37.7875790308508, -122.436021882306) | 13 | 6 | 11 | 29490 | 27 | ||
187670 | 142236 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004695.4808 | 2110855.1353 | 37.77627140325 | -122.427262313822 | (37.77627140325, -122.427262313822) | 7 | 9 | 11 | 28852 | 10 | |||
50402 | 121875 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 198 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 5990257.12502 | 2114144.50591 | 37.784475988028 | -122.477448493001 | (37.784475988028, -122.477448493001) | 11 | 6 | 2 | 55 | 26 | |||
83460 | 108482 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
129503 | 183427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2419 22nd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 0ft | 5989498.023 | 2098855.9096 | 37.7424535651362 | -122.478956057135 | (37.7424535651362, -122.478956057135) | 1 | 8 | 3 | 29491 | 35 | |||
4061 | 46914 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
30298 | 215566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.7357680072927 | -122.463427186434 | (37.7357680072927, -122.463427186434) | 9 | 8 | 4 | 59 | 40 | |||
40289 | 215500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618 | -122.463015880573 | (37.736806354618, -122.463015880573) | 9 | 8 | 4 | 59 | 40 | |||
118544 | 11877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | 9 | 8 | 4 | 64 | 24 | |||
122804 | 215495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 69 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993977.51854 | 2097401.11032 | 37.7387181577226 | -122.463361871354 | (37.7387181577226, -122.463361871354) | 1 | 8 | 4 | 59 | 40 | |||
137860 | 215557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994081.97838 | 2096463.44747 | 37.7361495860356 | -122.462932691498 | (37.7361495860356, -122.462932691498) | 9 | 8 | 4 | 59 | 40 | |||
152752 | 215513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993924.28661 | 2096292.23015 | 37.7356703813878 | -122.463465470563 | (37.7356703813878, -122.463465470563) | 9 | 8 | 4 | 59 | 40 | |||
169600 | 215560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994063.02887 | 2096405.49286 | 37.7359893655189 | -122.462994003686 | (37.7359893655189, -122.462994003686) | 9 | 8 | 4 | 59 | 40 | |||
170664 | 215542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993945.30252 | 2097292.64109 | 37.7384184721345 | -122.463465388735 | (37.7384184721345, -122.463465388735) | 1 | 8 | 4 | 59 | 40 | |||
172603 | 215549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994024.47246 | 2096717.64037 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | 9 | 8 | 4 | 59 | 40 | |||
29698 | 242600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002217.82403 | 2096159.00983 | 37.7357789394319 | -122.434782025597 | (37.7357789394319, -122.434782025597) | 2 | 7 | 5 | 63 | 7 | |||
31801 | 242443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1331 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003922.38967 | 2100509.16496 | 37.7478200945407 | -122.429198764536 | (37.7478200945407, -122.429198764536) | 2 | 4 | 5 | 63 | 22 | |||
35624 | 38383 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3815-3817 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769372 | 6003483 | 2105926 | 37.762668556024 | -122.431104719068 | (37.762668556024, -122.431104719068) | 15 | 4 | 5 | 28862 | 3 | ||||
37774 | 111106 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199X Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6002254 | 2096173 | 37.7358194070146 | -122.43465795136 | (37.7358194070146, -122.43465795136) | 2 | 7 | 5 | 63 | 7 | |||
38103 | 242736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6000751.24207 | 2105647.23063 | 37.761747947223 | -122.440532872599 | (37.761747947223, -122.440532872599) | 15 | 5 | 5 | 28862 | 3 | |||
48109 | 242378 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005393.3739 | 2103473.26085 | 37.7560419790638 | -122.424322955135 | (37.7560419790638, -122.424322955135) | 2 | 4 | 5 | 28859 | 19 | |||
58932 | 31077 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.7665636495047 | -122.422496504935 | (37.7665636495047, -122.422496504935) | 8 | 4 | 5 | 28853 | 19 | |
79500 | 242723 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 291 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004435.5728 | 2103937.20176 | 37.7572617205823 | -122.42766840527 | (37.7572617205823, -122.42766840527) | 2 | 4 | 5 | 28862 | 3 | |||
110911 | 242684 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 415 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002983.5288 | 2105821.24462 | 37.7623526073126 | -122.432824725778 | (37.7623526073126, -122.432824725778) | 15 | 4 | 5 | 28862 | 3 | |||
118124 | 242675 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3995 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003246.40491 | 2102411.67746 | 37.7530056556116 | -122.43167209619 | (37.7530056556116, -122.43167209619) | 2 | 4 | 5 | 28862 | 22 | |||
149987 | 242679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 381 Elizabeth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003962.28874 | 2102142.64479 | 37.7523075073868 | -122.429177250923 | (37.7523075073868, -122.429177250923) | 2 | 4 | 5 | 28862 | 22 | |||
150045 | 242592 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4412 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000533.60664 | 2102299.68252 | 37.752544002129 | -122.44104541512 | (37.752544002129, -122.44104541512) | 2 | 4 | 5 | 28862 | 22 | |||
175777 | 242603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 3 | : | Tree | Private 2 | 8 | Width 3ft | 5999039.00902 | 2105211.58372 | 37.7604541213822 | -122.446423435607 | (37.7604541213822, -122.446423435607) | 15 | 5 | 5 | 28862 | 12 | |||
184440 | 242655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 502 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001805.86123 | 2102847.44693 | 37.7541204147416 | -122.436684955058 | (37.7541204147416, -122.436684955058) | 2 | 4 | 5 | 28862 | 22 | |||
192321 | 242417 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3652 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005352.57915 | 2101976.52488 | 37.7519299863868 | -122.424357585351 | (37.7519299863868, -122.424357585351) | 2 | 4 | 5 | 28859 | 19 | |||
8303 | 180530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
25169 | 17576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.7201172080443 | -122.429795147634 | (37.7201172080443, -122.429795147634) | 9 | 7 | 6 | 28861 | 5 | |||
43659 | 17498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.434870362385 | (37.72266164479, -122.434870362385) | 9 | 7 | 6 | 28861 | 5 | |||
44226 | 180517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004131.62894 | 2090104.37161 | 37.7192627191689 | -122.427733992853 | (37.7192627191689, -122.427733992853) | 9 | 7 | 6 | 28861 | 5 |
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) );