trees
420 rows where qSpecies_id = 116 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51586 | 215436 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 670 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5996989.65534 | 2095298.72051 | 37.7331185802561 | -122.452795679095 | (37.7331185802561, -122.452795679095) | 9 | 7 | 4 | 59 | 40 | |||
115633 | 16314 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 6 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
158182 | 16313 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 5 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
176905 | 16312 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 758X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997070.7706475 | 2094757.2260752 | 37.7316364140758 | -122.452476180169 | (37.7316364140758, -122.452476180169) | 9 | 7 | 4 | 59 | 40 | ||
60671 | 103568 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 223 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5997125.5 | 2106655.6 | 37.7643095465843 | -122.453145590268 | (37.7643095465843, -122.453145590268) | 15 | 5 | 11 | 29492 | 12 | |||
152907 | 50801 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/11/2004 12:00:00 AM | Permit Number 47598 | 5997189.59146779 | 2093842.28323419 | 37.7291310061031 | -122.451999409113 | (37.7291310061031, -122.451999409113) | 9 | 7 | 4 | 28861 | 40 | ||
54851 | 16285 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
57490 | 16286 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
96877 | 16284 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 700X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | G | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096627 | (37.7316223027997, -122.45117096627) | 9 | 7 | 4 | 59 | 40 | ||
62921 | 16273 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
151718 | 28415 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 692X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 3X3 | 5997509.7184819 | 2094751.8939266 | 37.7316469123248 | -122.450958273614 | (37.7316469123248, -122.450958273614) | 9 | 7 | 4 | 59 | 40 | ||
150544 | 215413 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 423 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5997941.5079 | 2094069.28168 | 37.7297973308762 | -122.44941633349 | (37.7297973308762, -122.44941633349) | 9 | 7 | 4 | 28861 | 40 | |||
59259 | 215414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 423 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5997954.5929 | 2094069.33464 | 37.7297982247933 | -122.449371101191 | (37.7297982247933, -122.449371101191) | 9 | 7 | 4 | 28861 | 40 | |||
145108 | 28414 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 600X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998107.3609693 | 2094732.8027768 | 37.7316286888145 | -122.448890739326 | (37.7316286888145, -122.448890739326) | 9 | 7 | 4 | 59 | 40 | ||
111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | ||||
48943 | 16228 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
81686 | 16227 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 564X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.2808419 | 2094738.2735002 | 37.7316571419822 | -122.44807897208 | (37.7316571419822, -122.44807897208) | 9 | 7 | 4 | 59 | 40 | ||
99590 | 241201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998490.81522 | 2107264.49374 | 37.7660595705173 | -122.448467223189 | (37.7660595705173, -122.448467223189) | 15 | 5 | 11 | 29492 | 9 | |||
75935 | 241200 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998502.5017 | 2107263.12139 | 37.7660564705643 | -122.448426703328 | (37.7660564705643, -122.448426703328) | 15 | 5 | 11 | 29492 | 9 | |||
103122 | 241199 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | 15 | 5 | 11 | 29492 | 9 | |||
155667 | 47386 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 400 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2002 12:00:00 AM | Permit Number 45302 | 5998534.7421818 | 2087640.83447452 | 37.7121802187249 | -122.446903063491 | (37.7121802187249, -122.446903063491) | 9 | 7 | 6 | 28861 | 25 | |||
167583 | 215437 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5998668.44451 | 2093778.09263 | 37.729039350777 | -122.446882296697 | (37.729039350777, -122.446882296697) | 9 | 7 | 4 | 28861 | 40 | |||
85930 | 215438 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5998696.43814 | 2093778.97623 | 37.7290433761531 | -122.446785584491 | (37.7290433761531, -122.446785584491) | 9 | 7 | 4 | 28861 | 40 | |||
117606 | 215439 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 217 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5998709.41817 | 2093777.72882 | 37.729040692553 | -122.44674062198 | (37.729040692553, -122.44674062198) | 9 | 7 | 4 | 28861 | 40 | |||
20538 | 42308 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | ||
89456 | 42310 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
116195 | 42309 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 249 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2000 12:00:00 AM | Permit Number 42531 | 5998732.34943109 | 2093642.59637242 | 37.7286709604577 | -122.446651628377 | (37.7286709604577, -122.446651628377) | 9 | 7 | 4 | 28861 | 40 | |||
46226 | 16202 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
171394 | 16201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 500X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998782.1299536 | 2094714.7967047 | 37.7316178141427 | -122.446556643647 | (37.7316178141427, -122.446556643647) | 9 | 7 | 4 | 59 | 40 | ||
48118 | 179956 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5998852.53516 | 2088480.84158 | 37.7145048379104 | -122.44586505734 | (37.7145048379104, -122.44586505734) | 9 | 7 | 6 | 28861 | 25 | |||
84902 | 179955 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 78 Sala Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5998862.1125 | 2088471.16796 | 37.7144788232093 | -122.445831259031 | (37.7144788232093, -122.445831259031) | 9 | 7 | 6 | 28861 | 25 | |||
158744 | 136747 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2859 Filbert St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999233.55999 | 2118349.36625 | 37.7965381990226 | -122.446695870812 | (37.7965381990226, -122.446695870812) | 13 | 9 | 1 | 57 | 17 | |||
169945 | 179965 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 86 Arago St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999606.18552 | 2093002.38033 | 37.7269629528551 | -122.443584762453 | (37.7269629528551, -122.443584762453) | 9 | 7 | 6 | 28861 | 25 | ||||
181839 | 215435 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 271 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5999640.40097 | 2095213.212 | 37.7330353327146 | -122.443625232838 | (37.7330353327146, -122.443625232838) | 9 | 7 | 4 | 63 | 40 | |||
14508 | 246217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | 15 | 5 | 11 | 29492 | 9 | |||
20297 | 246216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999835.3063 | 2107870.2944 | 37.7677997276311 | -122.443860441452 | (37.7677997276311, -122.443860441452) | 15 | 5 | 11 | 29492 | 9 | |||
30420 | 52305 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 715 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | 15 | 5 | 5 | 29492 | 9 | ||
53968 | 52306 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 715 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2016 12:00:00 AM | 3 | Permit Number 48465 | 5999876.8 | 2107852.1 | 37.7677521370965 | -122.443715612896 | (37.7677521370965, -122.443715612896) | 15 | 5 | 5 | 29492 | 9 | ||
40644 | 247521 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1101 Waller St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6000007.86979 | 2108477.01107 | 37.7694754609529 | -122.443307149811 | (37.7694754609529, -122.443307149811) | 15 | 5 | 11 | 29492 | 9 | ||||
47804 | 136746 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2908 Broderick St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000043.09421 | 2118605.60705 | 37.7972879782152 | -122.443913133705 | (37.7972879782152, -122.443913133705) | 13 | 9 | 1 | 57 | 17 | |||
156301 | 136745 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2908 Broderick St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000044.84961 | 2118592.59728 | 37.7972523569702 | -122.443906124388 | (37.7972523569702, -122.443906124388) | 13 | 9 | 1 | 57 | 17 | |||
145163 | 136744 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2906 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000047.06944 | 2118581.72583 | 37.7972226334754 | -122.443897661751 | (37.7972226334754, -122.443897661751) | 13 | 9 | 1 | 57 | 17 | |||
124321 | 136743 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6000050.87786 | 2118557.23395 | 37.7971556025074 | -122.44388272313 | (37.7971556025074, -122.44388272313) | 13 | 9 | 1 | 57 | 17 | |||
8935 | 136742 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000053.33945 | 2118542.13589 | 37.7971142876507 | -122.443873120143 | (37.7971142876507, -122.443873120143) | 13 | 9 | 1 | 57 | 17 | |||
21140 | 136741 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000055.17715 | 2118534.11341 | 37.7970923648718 | -122.443866184587 | (37.7970923648718, -122.443866184587) | 13 | 9 | 1 | 57 | 17 | |||
123376 | 113776 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1710 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000070.198 | 2114878.1306 | 37.7870548531015 | -122.443551447546 | (37.7870548531015, -122.443551447546) | 13 | 6 | 1 | 29490 | 27 | |||
88237 | 67807 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31458 | 6000311.37446381 | 2101639.91617819 | 37.7507197829758 | -122.441766583241 | (37.7507197829758, -122.441766583241) | 2 | 4 | 5 | 28862 | 22 | ||
91363 | 241216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 6 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6000321.631 | 2101619.05614 | 37.7506630907493 | -122.441729618453 | (37.7506630907493, -122.441729618453) | 2 | 4 | 5 | 28862 | 22 | |||
189828 | 38219 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 118 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2000 12:00:00 AM | Permit Number 40340 | 6000363.19569215 | 2109305.86913973 | 37.7717715527779 | -122.44213760158 | (37.7717715527779, -122.44213760158) | 15 | 5 | 11 | 29492 | 9 | ||
193666 | 50830 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 621 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 9 | Permit Number 47349 | 6000535.8217 | 2111139.1847 | 37.7768152106013 | -122.441672069607 | (37.7768152106013, -122.441672069607) | 15 | 5 | 11 | 29492 | 16 | ||
133818 | 52311 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
142362 | 52312 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
142699 | 52313 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400HOFFMAN 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2009 12:00:00 AM | 3x3 | Permit Number 52154 | 6000634.55195661 | 2101724.81174328 | 37.7509712947951 | -122.440655099281 | (37.7509712947951, -122.440655099281) | 2 | 4 | 5 | 28862 | 22 | ||
112460 | 85491 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4400 24th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2007 12:00:00 AM | 3x3 | Permit Number 52154 | 6000641 | 2101716 | 37.7509474670616 | -122.440632169404 | (37.7509474670616, -122.440632169404) | 2 | 4 | 5 | 28862 | 22 | |||
58738 | 241224 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 44 Museum Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000710.17183 | 2106760.2697 | 37.7648017391332 | -122.440754760547 | (37.7648017391332, -122.440754760547) | 15 | 5 | 5 | 28862 | 3 | |||
71574 | 51838 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 135 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 8 | Permit Number 48065 | 6000803.77084 | 2087905.29553 | 37.7130357386885 | -122.43907959427 | (37.7130357386885, -122.43907959427) | 9 | 7 | 6 | 28861 | 5 | ||
71242 | 136740 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1920 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6000976.88542 | 2121020.42839 | 37.8039716578185 | -122.44085530385 | (37.8039716578185, -122.44085530385) | 13 | 9 | 1 | 57 | 17 | |||
100468 | 16027 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 160 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3X3 | 6001078.56062 | 2094701.12537 | 37.7317111799206 | -122.438616467699 | (37.7317111799206, -122.438616467699) | 9 | 7 | 4 | 63 | 40 | ||
28105 | 63543 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1715 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33376 | 6001376.18344652 | 2111778.57795299 | 37.7786186676026 | -122.438810841545 | (37.7786186676026, -122.438810841545) | 15 | 5 | 11 | 29490 | 41 | ||
123985 | 141332 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 HAYES ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 6001489.2623 | 2110460.5875 | 37.7750062304087 | -122.438325211171 | (37.7750062304087, -122.438325211171) | 15 | 5 | 11 | 29492 | 10 | |||
111572 | 57900 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1977 12:00:00 AM | 5 | Permit Number 16856 | 6001502.5818 | 2110462.7186 | 37.7750128394498 | -122.438279288937 | (37.7750128394498, -122.438279288937) | 15 | 5 | 11 | 29492 | 10 | ||
129198 | 247212 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 800 Duboce Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001824.51541 | 2108284.91798 | 37.7690514458872 | -122.437009703838 | (37.7690514458872, -122.437009703838) | 15 | 5 | 5 | 29492 | 9 | |||
78460 | 67800 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 4318 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31444 | 6001831.31402978 | 2100620.67337741 | 37.7480076719463 | -122.436437569325 | (37.7480076719463, -122.436437569325) | 2 | 4 | 5 | 28862 | 22 | ||
28989 | 247209 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 800 Duboce Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001860.51527 | 2108286.6653 | 37.7690582897368 | -122.436885307832 | (37.7690582897368, -122.436885307832) | 15 | 5 | 5 | 29492 | 9 | |||
111657 | 241225 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4049 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001920.58101 | 2105839.72544 | 37.7623430070574 | -122.436502382779 | (37.7623430070574, -122.436502382779) | 15 | 5 | 5 | 28862 | 3 | |||
81340 | 41897 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2500 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42262 | 6001987.05760353 | 2105790.14936536 | 37.762210660505 | -122.436268917311 | (37.762210660505, -122.436268917311) | 15 | 4 | 5 | 28862 | 3 | ||
29995 | 117607 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
113741 | 117606 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 420 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002292.2454566 | 2105806.2278627 | 37.7622721434766 | -122.435214539817 | (37.7622721434766, -122.435214539817) | 15 | 4 | 5 | 28862 | 3 | |||
26740 | 87392 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3322 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002333.63287 | 2119648.29419 | 37.8002813140837 | -122.436061950612 | (37.8002813140837, -122.436061950612) | 13 | 9 | 1 | 57 | 17 | |
168165 | 87391 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3322 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002335.87278 | 2119635.99284 | 37.800247665053 | -122.436053318908 | (37.800247665053, -122.436053318908) | 13 | 9 | 1 | 57 | 17 | |
50905 | 179971 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 160 Baltimore Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6002384.15556 | 2086207.41957 | 37.7084635404231 | -122.43349600315 | (37.7084635404231, -122.43349600315) | 9 | 7 | 6 | 28861 | 5 | |||
85163 | 136748 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 165 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6002698.42353 | 2121575.97678 | 37.8055949413272 | -122.434937570523 | (37.8055949413272, -122.434937570523) | 13 | 9 | 1 | 57 | 17 | |||
46615 | 179964 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002952.82685 | 2087126.87824 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | 9 | 7 | 6 | 28861 | 5 | |||
117066 | 179963 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 85 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002963.44574 | 2087110.53022 | 37.7109761365014 | -122.431558338255 | (37.7109761365014, -122.431558338255) | 9 | 7 | 6 | 28861 | 5 | |||
130858 | 241218 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6003089.92025 | 2100398.1705 | 37.7474681682179 | -122.432069476034 | (37.7474681682179, -122.432069476034) | 2 | 4 | 5 | 63 | 22 | |||
64512 | 100205 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 4085 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2012 12:00:00 AM | 12 | 3x4 | Permit Number 769140 | 6003091 | 2104064 | 37.7575337303282 | -122.432327515179 | (37.7575337303282, -122.432327515179) | 2 | 4 | 5 | 28862 | 3 | |
88243 | 241217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6003092.5802 | 2100398.11558 | 37.7474681682247 | -122.432060274186 | (37.7474681682247, -122.432060274186) | 2 | 4 | 5 | 63 | 22 | |||
24606 | 241219 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4130 Cesar Chavez St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6003095.93223 | 2100399.37123 | 37.7474718059861 | -122.432048772745 | (37.7474718059861, -122.432048772745) | 2 | 4 | 5 | 63 | 22 | |||
74715 | 68587 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 32485 | 6003450.61209517 | 2097770.88653532 | 37.7402746975659 | -122.430634780555 | (37.7402746975659, -122.430634780555) | 2 | 7 | 5 | 63 | 7 | ||
77815 | 241226 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 102 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003452.26052 | 2097778.5444 | 37.7402958176893 | -122.43062962727 | (37.7402958176893, -122.43062962727) | 2 | 7 | 5 | 63 | 7 | |||
180712 | 241227 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 104 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003479.82073 | 2097757.75572 | 37.7402402980644 | -122.430532852122 | (37.7402402980644, -122.430532852122) | 2 | 7 | 5 | 63 | 7 | |||
70826 | 241228 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 128 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003596.19295 | 2097670.16809 | 37.7400063942798 | -122.430124237037 | (37.7400063942798, -122.430124237037) | 2 | 7 | 5 | 63 | 7 | |||
110970 | 65602 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 114 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 13 | Permit Number 28504 | 6004165.03379 | 2093741.91359 | 37.729252495484 | -122.427877581308 | (37.729252495484, -122.427877581308) | 9 | 7 | 6 | 28861 | 5 | |
177846 | 179970 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 307 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6004288.05392 | 2091472.8528 | 37.7230291158735 | -122.427290720601 | (37.7230291158735, -122.427290720601) | 9 | 7 | 6 | 28861 | 5 | |||
76957 | 241198 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.7546903196133 | -122.426677105059 | (37.7546903196133, -122.426677105059) | 2 | 4 | 5 | 28862 | 22 | |||
51525 | 161041 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 200 Munich St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781115 | 6004713.602 | 2091215.63937 | 37.722346921643 | -122.425801386648 | (37.722346921643, -122.425801386648) | 9 | 7 | 6 | 28861 | 5 | |
84384 | 241181 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 4 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004757.30529 | 2108409.26199 | 37.7695591257908 | -122.42687421397 | (37.7695591257908, -122.42687421397) | 7 | 9 | 5 | 28862 | 10 | |
20099 | 241180 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004770.13014 | 2108408.30025 | 37.7695572102182 | -122.426829784767 | (37.7695572102182, -122.426829784767) | 7 | 9 | 5 | 28862 | 10 | |
50237 | 241179 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 7 | Width 3ft | Permit Number 43693 | 6004783.47466 | 2108409.88584 | 37.769562318364 | -122.426783739481 | (37.769562318364, -122.426783739481) | 7 | 9 | 5 | 28862 | 10 | |
187547 | 241178 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/20/2001 12:00:00 AM | 8 | Width 3ft | Permit Number 43693 | 6004795.38967 | 2108410.10559 | 37.7695635954031 | -122.426742541533 | (37.7695635954031, -122.426742541533) | 7 | 9 | 5 | 28862 | 10 | |
110485 | 44261 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
129342 | 44264 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
146756 | 44262 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
166497 | 44263 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 300 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2001 12:00:00 AM | Permit Number 43693 | 6004891.25445895 | 2108442.06671817 | 37.7696567724968 | -122.426413224583 | (37.7696567724968, -122.426413224583) | 7 | 4 | 5 | 28852 | 10 | |||
124283 | 246465 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 220 Duncan St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005035.80445 | 2099919.28541 | 37.7462633887397 | -122.425306657892 | (37.7462633887397, -122.425306657892) | 2 | 7 | 5 | 63 | 22 | |||
120616 | 179966 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005255.40982 | 2092462.48384 | 37.725801087223 | -122.424017104714 | (37.725801087223, -122.424017104714) | 9 | 7 | 6 | 309 | 5 | |||
109219 | 241183 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1720 Dolores St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005264.11037 | 2098316.58265 | 37.7418756279601 | -122.424403226839 | (37.7418756279601, -122.424403226839) | 2 | 7 | 5 | 63 | 7 | |||
66245 | 241184 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1720 Dolores St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005265.18206 | 2098303.13157 | 37.7418387548635 | -122.424398564767 | (37.7418387548635, -122.424398564767) | 2 | 7 | 5 | 63 | 7 | |||
68174 | 179967 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 716 Peru Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6005275.29843 | 2092450.03888 | 37.7257680389529 | -122.423947466603 | (37.7257680389529, -122.423947466603) | 9 | 7 | 6 | 309 | 5 | |||
100358 | 4167 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3781 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/04/1993 12:00:00 AM | 12 | 3X3 | 6005338.8489102 | 2100470.98597 | 37.7477953482432 | -122.424297997893 | (37.7477953482432, -122.424297997893) | 2 | 4 | 5 | 28859 | 22 |
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) );