trees
252 rows where qSpecies_id = 195 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39633 | 88672 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016937.47244 | 2102122.13561 | 37.7529771731841 | -122.384305125986 | (37.7529771731841, -122.384305125986) | 10 | 3 | 8 | 58 | 1 | |
184059 | 88671 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016898.17998 | 2102118.14564 | 37.7529640448765 | -122.384440730253 | (37.7529640448765, -122.384440730253) | 10 | 3 | 8 | 58 | 1 | |
111900 | 88670 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016858.92761 | 2102116.14694 | 37.7529563862427 | -122.384576334524 | (37.7529563862427, -122.384576334524) | 10 | 3 | 8 | 58 | 1 | |
68301 | 88669 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016819.28345 | 2102114.55479 | 37.7529498220865 | -122.384713321982 | (37.7529498220865, -122.384713321982) | 10 | 3 | 8 | 58 | 1 | |
50849 | 88668 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51637 | 6016777.63149 | 2102112.60454 | 37.7529421634534 | -122.38485722789 | (37.7529421634534, -122.38485722789) | 10 | 3 | 8 | 58 | 1 | |
36130 | 91470 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
44361 | 91472 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
51608 | 91481 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
53985 | 91478 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
63957 | 91477 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
116901 | 91479 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
117650 | 91480 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
127542 | 91474 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
173705 | 91475 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
174568 | 91473 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
184805 | 91471 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
193244 | 91476 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | 10 | 3 | 8 | 58 | 1 | ||
16213 | 2506 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1501 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/16/1999 12:00:00 AM | 3 | 3x3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | ||
109512 | 88667 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016620.61413 | 2102104.21301 | 37.7529104362915 | -122.38539964408 | (37.7529104362915, -122.38539964408) | 10 | 3 | 8 | 58 | 1 | |
84227 | 88666 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016578.93003 | 2102100.67029 | 37.7528984024518 | -122.385543550016 | (37.7528984024518, -122.385543550016) | 10 | 3 | 8 | 58 | 1 | |
139571 | 88664 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016498.80939 | 2102095.90957 | 37.7528808971534 | -122.385820292998 | (37.7528808971534, -122.385820292998) | 10 | 3 | 8 | 58 | 1 | |
72668 | 88663 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016462.36488 | 2102094.25346 | 37.7528743330038 | -122.38594621066 | (37.7528743330038, -122.38594621066) | 10 | 3 | 8 | 58 | 1 | |
15867 | 88662 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016419.52899 | 2102093.1245 | 37.7528688624307 | -122.386094267831 | (37.7528688624307, -122.386094267831) | 10 | 3 | 8 | 58 | 1 | |
67915 | 88661 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51637 | 6016379.4847 | 2102091.54106 | 37.752862298279 | -122.386232639338 | (37.752862298279, -122.386232639338) | 10 | 3 | 8 | 58 | 1 | |
176450 | 2539 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1575 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/05/1999 12:00:00 AM | 3 | 3X3 | 6016305.53274 | 2099035.35536 | 37.7444665522926 | -122.386275327464 | (37.7444665522926, -122.386275327464) | 10 | 3 | 8 | 58 | 1 | ||
137876 | 88660 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 601 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51637 | 6016339.82415 | 2102089.15306 | 37.7528535460529 | -122.386369627673 | (37.7528535460529, -122.386369627673) | 10 | 3 | 8 | 58 | 1 | |
115156 | 190954 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015962.97968 | 2113739.68127 | 37.7848224915123 | -122.388485974355 | (37.7848224915123, -122.388485974355) | 6 | 2 | 9 | 28856 | 6 | |||
54259 | 95597 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1625 Carroll Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6013964.9434 | 2092060.83 | 37.7251861069453 | -122.393880551992 | (37.7251861069453, -122.393880551992) | 10 | 3 | 8 | 58 | 1 | |||
112239 | 49145 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1010 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2003 12:00:00 AM | 4 | Permit Number 46270 | 6013902.9734 | 2089731.1325 | 37.7187857786642 | -122.393931770521 | (37.7187857786642, -122.393931770521) | 10 | 3 | 8 | 58 | 1 | ||
2741 | 202190 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1900 Armstrong Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6013173.69096 | 2093416.62895 | 37.7288648499236 | -122.396710853637 | (37.7288648499236, -122.396710853637) | 10 | 3 | 8 | 58 | 1 | ||||
130961 | 202159 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1907 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6013147.17786 | 2093363.32947 | 37.7287170247605 | -122.39679877675 | (37.7287170247605, -122.39679877675) | 10 | 3 | 8 | 58 | 1 | |||
174635 | 202158 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1913 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6013140.94695 | 2093368.78005 | 37.7287316441256 | -122.396820699517 | (37.7287316441256, -122.396820699517) | 10 | 3 | 8 | 58 | 1 | |||
23182 | 202194 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1928 Armstrong Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 7ft | 6013120.24399 | 2093453.13638 | 37.7289621170018 | -122.396898183325 | (37.7289621170018, -122.396898183325) | 10 | 3 | 8 | 58 | 1 | |||
140419 | 202157 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1919 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6013116.58632 | 2093387.72348 | 37.7287823029563 | -122.39690624394 | (37.7287823029563, -122.39690624394) | 10 | 3 | 8 | 58 | 1 | |||
190330 | 202156 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1925 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6013109.74623 | 2093393.80545 | 37.7287986220599 | -122.396930316988 | (37.7287986220599, -122.396930316988) | 10 | 3 | 8 | 58 | 1 | |||
25247 | 202195 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1938 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6013111.07859 | 2093460.11869 | 37.7289807788209 | -122.396930358355 | (37.7289807788209, -122.396930358355) | 10 | 3 | 8 | 58 | 1 | |||
144459 | 202155 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1931 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6013085.35579 | 2093411.26351 | 37.7288452006287 | -122.397015860514 | (37.7288452006287, -122.397015860514) | 10 | 3 | 8 | 58 | 1 | |||
184828 | 202154 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1937 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6013078.37637 | 2093416.60548 | 37.7288594800651 | -122.397040363418 | (37.7288594800651, -122.397040363418) | 10 | 3 | 8 | 58 | 1 | |||
107688 | 202201 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1948 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6013078.4423 | 2093486.02938 | 37.7290501075616 | -122.397045001251 | (37.7290501075616, -122.397045001251) | 10 | 3 | 8 | 58 | 1 | |||
67173 | 202153 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1943 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6013054.85353 | 2093433.92218 | 37.7289057187068 | -122.397122897799 | (37.7289057187068, -122.397122897799) | 10 | 3 | 8 | 58 | 1 | |||
176191 | 202202 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1956 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6013055.77305 | 2093504.05261 | 37.7290983337043 | -122.397124634419 | (37.7290983337043, -122.397124634419) | 10 | 3 | 8 | 58 | 1 | |||
141166 | 67529 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 662 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 13 | Permit Number 31067 | 6013257.86111 | 2104004.0948 | 37.7579404811792 | -122.397161966172 | (37.7579404811792, -122.397161966172) | 10 | 3 | 8 | 28856 | 29 | |
103289 | 202151 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1955 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6013019.68164 | 2093458.45731 | 37.7289711290907 | -122.397246210158 | (37.7289711290907, -122.397246210158) | 10 | 3 | 8 | 58 | 1 | |||
34627 | 202207 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1968 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6013020.76239 | 2093529.61913 | 37.7291665850463 | -122.397247462005 | (37.7291665850463, -122.397247462005) | 10 | 3 | 8 | 58 | 1 | |||
9490 | 202206 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1976 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6013013.79593 | 2093534.14859 | 37.7291786341692 | -122.397271863302 | (37.7291786341692, -122.397271863302) | 10 | 3 | 8 | 58 | 1 | |||
35948 | 202150 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1961 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 7ft | 6013012.27457 | 2093463.5941 | 37.7289848212876 | -122.397272177194 | (37.7289848212876, -122.397272177194) | 10 | 3 | 8 | 58 | 1 | |||
10756 | 202149 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1967 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 6012987.61375 | 2093482.17002 | 37.7290344539678 | -122.397358734241 | (37.7290344539678, -122.397358734241) | 10 | 3 | 8 | 58 | 1 | |||
96940 | 202148 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1973 Armstrong Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6012979.95623 | 2093488.41205 | 37.7290511669581 | -122.397385644629 | (37.7290511669581, -122.397385644629) | 10 | 3 | 8 | 58 | 1 | |||
51346 | 202196 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1996 Armstrong Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012954.27353 | 2093570.59908 | 37.7292754057276 | -122.397480193965 | (37.7292754057276, -122.397480193965) | 10 | 3 | 8 | 58 | 1 | |||
104317 | 202197 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1998 Armstrong Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012952.41894 | 2093581.14048 | 37.7293042469875 | -122.397487344489 | (37.7293042469875, -122.397487344489) | 10 | 3 | 8 | 58 | 1 | |||
161526 | 202198 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1998 Armstrong Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6012950.89039 | 2093587.34994 | 37.7293212117817 | -122.397493064171 | (37.7293212117817, -122.397493064171) | 10 | 3 | 8 | 58 | 1 | |||
144688 | 202145 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1991 Armstrong Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6012926.39508 | 2093534.52233 | 37.7291747940604 | -122.397574043633 | (37.7291747940604, -122.397574043633) | 10 | 3 | 8 | 58 | 1 | |||
97306 | 202144 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1999 Armstrong Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6012917.46969 | 2093534.23595 | 37.7291735107263 | -122.397604879586 | (37.7291735107263, -122.397604879586) | 10 | 3 | 8 | 58 | 1 | |||
74452 | 202143 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1999 Armstrong Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6012908.83816 | 2093533.00853 | 37.7291696598447 | -122.397634633656 | (37.7291696598447, -122.397634633656) | 10 | 3 | 8 | 58 | 1 | |||
33144 | 190953 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 28 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6013222.07397 | 2116219.26645 | 37.7914785844106 | -122.398142697526 | (37.7914785844106, -122.398142697526) | 12 | 2 | 9 | 28855 | 6 | |||
62989 | 176083 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011939.3192 | 2086886.00886 | 37.7108643121037 | -122.400519634499 | (37.7108643121037, -122.400519634499) | 10 | 3 | 8 | 309 | 1 | |||
104716 | 251395 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2101 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012226 | 2101445 | 37.7508562677445 | -122.400550836744 | (37.7508562677445, -122.400550836744) | 10 | 3 | 8 | 28856 | 29 | |||||
107483 | 190950 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6012271.11353 | 2104059.64338 | 37.7580380234458 | -122.400578478917 | (37.7580380234458, -122.400578478917) | 10 | 3 | 8 | 28856 | 29 | |||
113051 | 176082 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011914.48918 | 2086894.19237 | 37.7108853976137 | -122.400606027845 | (37.7108853976137, -122.400606027845) | 10 | 3 | 8 | 309 | 1 | |||
77319 | 190951 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 6012249.68745 | 2104070.76225 | 37.7580673584483 | -122.400653360983 | (37.7580673584483, -122.400653360983) | 10 | 3 | 8 | 28856 | 29 | |||
130064 | 190952 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6012228.79731 | 2104083.07063 | 37.7580999894276 | -122.400726473151 | (37.7580999894276, -122.400726473151) | 10 | 3 | 8 | 28856 | 29 | |||
4066 | 57816 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48159 | 6012187.5358 | 2104146.00992 | 37.7582705054092 | -122.400873595956 | (37.7582705054092, -122.400873595956) | 10 | 3 | 8 | 28856 | 29 | ||
143942 | 121793 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6012186.53897 | 2104166.90751 | 37.7583278299834 | -122.400878511655 | (37.7583278299834, -122.400878511655) | 10 | 3 | 8 | 28856 | 29 | ||||
38068 | 121794 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6012184.33668 | 2104198.44513 | 37.7584143024936 | -122.400888343944 | (37.7584143024936, -122.400888343944) | 10 | 3 | 8 | 28856 | 29 | ||||
11256 | 42750 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
95116 | 42745 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
118849 | 42746 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
132014 | 42748 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
152219 | 42752 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
156541 | 42751 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
162782 | 42753 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
183379 | 42747 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
183731 | 42749 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
188770 | 42744 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 333 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42738 | 6011765.57664352 | 2086774.37059761 | 37.7105480846287 | -122.401112293424 | (37.7105480846287, -122.401112293424) | 10 | 3 | 8 | 309 | 1 | ||
156404 | 176091 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011761.10909 | 2086779.81535 | 37.7105627856051 | -122.401128116692 | (37.7105627856051, -122.401128116692) | 10 | 3 | 8 | 309 | 1 | |||
153648 | 176090 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011757.62292 | 2086765.56215 | 37.7105234546691 | -122.401139164846 | (37.7105234546691, -122.401139164846) | 10 | 3 | 8 | 309 | 1 | |||
125481 | 176089 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011754.14508 | 2086751.70672 | 37.7104852163938 | -122.401150212131 | (37.7104852163938, -122.401150212131) | 10 | 3 | 8 | 309 | 1 | |||
2695 | 176088 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011749.37983 | 2086733.50039 | 37.710434959589 | -122.401165403463 | (37.710434959589, -122.401165403463) | 10 | 3 | 8 | 309 | 1 | |||
192487 | 176087 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011745.86132 | 2086717.65639 | 37.710391258824 | -122.401176451643 | (37.710391258824, -122.401176451643) | 10 | 3 | 8 | 309 | 1 | |||
93514 | 176086 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011743.19031 | 2086704.18251 | 37.7103541132169 | -122.401184737092 | (37.7103541132169, -122.401184737092) | 10 | 3 | 8 | 309 | 1 | |||
71240 | 176085 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011737.82332 | 2086688.14713 | 37.710309783833 | -122.401202160576 | (37.710309783833, -122.401202160576) | 10 | 3 | 8 | 309 | 1 | |||
172412 | 176084 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 301 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011735.35451 | 2086672.51042 | 37.7102667108031 | -122.401209595273 | (37.7102667108031, -122.401209595273) | 10 | 3 | 8 | 309 | 1 | |||
94430 | 32623 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 39 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 6 | Permit Number 37079 | 6011706.39653 | 2110130.09648 | 37.7746746089772 | -122.402958479854 | (37.7746746089772, -122.402958479854) | 14 | 2 | 9 | 28853 | 34 | |
8950 | 74227 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 796 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6011650.43252 | 2109615.42877 | 37.7732583242335 | -122.403115862114 | (37.7732583242335, -122.403115862114) | 14 | 2 | 9 | 28853 | 34 | |||
38137 | 190955 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 577 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011602.79384 | 2109609.35058 | 37.7732389744272 | -122.403280224009 | (37.7732389744272, -122.403280224009) | 14 | 2 | 9 | 28853 | 34 | |||
63800 | 190956 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 577 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011592.10905 | 2109620.43241 | 37.7732688058471 | -122.403317964073 | (37.7732688058471, -122.403317964073) | 14 | 2 | 9 | 28853 | 34 | |||
54844 | 190960 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011539.8139 | 2109577.65401 | 37.7731484252993 | -122.403495850865 | (37.7731484252993, -122.403495850865) | 14 | 2 | 9 | 28853 | 34 | |||
1597 | 190959 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011525.3711 | 2109592.00933 | 37.773187034992 | -122.403546820846 | (37.773187034992, -122.403546820846) | 14 | 2 | 9 | 28853 | 34 | |||
49024 | 121763 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
119429 | 121764 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
134751 | 121762 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
177645 | 121761 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779456 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |
79652 | 190958 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011508.79909 | 2109607.32506 | 37.7732281627925 | -122.403605223729 | (37.7732281627925, -122.403605223729) | 14 | 2 | 9 | 28853 | 34 | |||
48724 | 190957 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011496.47934 | 2109620.41486 | 37.7732634162043 | -122.403648760805 | (37.7732634162043, -122.403648760805) | 14 | 2 | 9 | 28853 | 34 | |||
85318 | 34306 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38094 | 6010824.33318422 | 2102458.44647529 | 37.7535606982702 | -122.405469321452 | (37.7535606982702, -122.405469321452) | 10 | 4 | 8 | 28859 | 19 | ||
166095 | 223269 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010823.03156 | 2102440.75531 | 37.7535120494589 | -122.405472576922 | (37.7535120494589, -122.405472576922) | 10 | 4 | 8 | 28859 | 19 | |||
155057 | 248033 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010558.59528 | 2099039.59827 | 37.7441584283672 | -122.406147456957 | (37.7441584283672, -122.406147456957) | 2 | 7 | 7 | 28859 | 2 | |||
90186 | 34210 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38026 | 6010548.9850675 | 2099059.00866257 | 37.7442111875512 | -122.406182054391 | (37.7442111875512, -122.406182054391) | 2 | 7 | 7 | 28859 | 2 | ||
192687 | 33995 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521 | (37.7442517881202, -122.40634471521) | 2 | 7 | 7 | 28859 | 2 | ||
162640 | 248034 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010483.27046 | 2099064.93889 | 37.7442237946989 | -122.406409700143 | (37.7442237946989, -122.406409700143) | 2 | 7 | 7 | 28859 | 2 |
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) );