trees
1,650 rows where qSpecies_id = 64 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
167020 | 189317 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1015 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013888.25038 | 2089668.52955 | 37.7186130651163 | -122.393978282498 | (37.7186130651163, -122.393978282498) | 10 | 3 | 8 | 58 | 1 | ||||
57292 | 175890 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 623 London St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6001228.09445 | 2090159.83888 | 37.7192503462927 | -122.43777436682 | (37.7192503462927, -122.43777436682) | 9 | 7 | 6 | 28861 | 5 | ||||
80298 | 189316 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1089 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6013485.95319 | 2089984.75612 | 37.7194589935203 | -122.395391011311 | (37.7194589935203, -122.395391011311) | 10 | 3 | 8 | 58 | 1 | ||||
39300 | 205340 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 494 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993277.92087 | 2090411.70077 | 37.719486628792 | -122.465273175336 | (37.719486628792, -122.465273175336) | 9 | 8 | 6 | 64 | 24 | |||
155777 | 189319 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1121 Jamestown Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6013379.93959 | 2090055.27551 | 37.7196467287812 | -122.395762402515 | (37.7196467287812, -122.395762402515) | 10 | 3 | 8 | 58 | 1 | ||||
182551 | 189318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1121 Jamestown Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013359.03533 | 2090071.72065 | 37.7196907209338 | -122.395835813273 | (37.7196907209338, -122.395835813273) | 10 | 3 | 8 | 58 | 1 | ||||
184279 | 175891 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002024.38538 | 2090403.55892 | 37.7199647938133 | -122.435039315322 | (37.7199647938133, -122.435039315322) | 9 | 7 | 6 | 28861 | 5 | |||
171710 | 175894 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002021.18873 | 2090405.02227 | 37.7199686303329 | -122.435050469629 | (37.7199686303329, -122.435050469629) | 9 | 7 | 6 | 28861 | 5 | |||
139022 | 175892 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002025.69366 | 2090405.76725 | 37.7199709316807 | -122.435034950912 | (37.7199709316807, -122.435034950912) | 9 | 7 | 6 | 28861 | 5 | |||
61631 | 175895 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002022.35684 | 2090407.2335 | 37.7199747682043 | -122.435046589945 | (37.7199747682043, -122.435046589945) | 9 | 7 | 6 | 28861 | 5 | |||
115365 | 175893 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002027.28832 | 2090408.24905 | 37.7199778366966 | -122.435029616133 | (37.7199778366966, -122.435029616133) | 9 | 7 | 6 | 28861 | 5 | |||
3731 | 175896 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002023.9515 | 2090409.71529 | 37.7199816731933 | -122.435041255167 | (37.7199816731933, -122.435041255167) | 9 | 7 | 6 | 28861 | 5 | |||
145262 | 205322 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1022 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995074.24683 | 2090726.75234 | 37.7204551141018 | -122.459086777635 | (37.7204551141018, -122.459086777635) | 9 | 8 | 6 | 28861 | 24 | |||
27224 | 95764 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 425 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767500 | 6004118.7 | 2090668.4 | 37.7208106862046 | -122.427818850767 | (37.7208106862046, -122.427818850767) | 9 | 7 | 6 | 28861 | 5 | |
157471 | 205341 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1400 Holloway Ave | 5 | : | Tree | Private 2 | 3 | Width 0ft | 5990799.69787 | 2091134.9811 | 37.7213293495637 | -122.47389213663 | (37.7213293495637, -122.47389213663) | 9 | 8 | 4 | 64 | 40 | |||
86494 | 202072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Gould St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012663.72375 | 2090703.30788 | 37.7213862262721 | -122.398283562861 | (37.7213862262721, -122.398283562861) | 10 | 3 | 8 | 58 | 1 | |||
45696 | 24382 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1450 Holloway Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 5X5 | 5990869.8996566 | 2091172.9547398 | 37.7214376817414 | -122.473652239882 | (37.7214376817414, -122.473652239882) | 9 | 8 | 4 | 64 | 40 | |||
45875 | 202071 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Gould St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012673.40671 | 2090736.38979 | 37.7214776018863 | -122.398252411218 | (37.7214776018863, -122.398252411218) | 10 | 3 | 8 | 58 | 1 | |||
23466 | 175898 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 9 Prague St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6004985.20772 | 2091051.63703 | 37.721911951944 | -122.424850846398 | (37.721911951944, -122.424850846398) | 9 | 7 | 6 | 28861 | 5 | |||
26820 | 175899 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 9 Prague St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6004990.6414 | 2091058.46133 | 37.7219309968925 | -122.424832548789 | (37.7219309968925, -122.424832548789) | 9 | 7 | 6 | 28861 | 5 | |||
128306 | 202036 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 74 Crane St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6012239.5705 | 2090921.68995 | 37.7219622231619 | -122.399765078106 | (37.7219622231619, -122.399765078106) | 10 | 3 | 8 | 58 | 1 | |||
51269 | 205321 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 226 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994485.43985 | 2091431.41668 | 37.7223560866494 | -122.461173131037 | (37.7223560866494, -122.461173131037) | 9 | 8 | 4 | 28861 | 24 | |||
188730 | 38208 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 769 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 4 | Permit Number 45186 | 6010823.6408 | 2091130.33405 | 37.7224560813761 | -122.404674297295 | (37.7224560813761, -122.404674297295) | 10 | 3 | 7 | 309 | 28 | |
79271 | 94199 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 355 Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | |||
102031 | 94194 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 355 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | ||||
103902 | 94195 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 355 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | ||||
136881 | 94193 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 355@ Delano Ave Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | ||||
66924 | 175888 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 438 Delano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999569.83671 | 2091433.93704 | 37.7226542964383 | -122.443597796299 | (37.7226542964383, -122.443597796299) | 9 | 7 | 6 | 28861 | 25 | |||
109475 | 175887 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 438 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999582.40572 | 2091457.72453 | 37.7227203282603 | -122.44355605607 | (37.7227203282603, -122.44355605607) | 9 | 7 | 6 | 28861 | 25 | |||
48775 | 100847 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
125598 | 100846 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 1 Estero Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
183199 | 175886 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 438 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999601.07711 | 2091494.65352 | 37.7228227916262 | -122.443494164739 | (37.7228227916262, -122.443494164739) | 9 | 7 | 6 | 28861 | 25 | |||
190066 | 95741 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 85 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767487 | 6004901.6 | 2091388.4 | 37.7228319067102 | -122.42516380777 | (37.7228319067102, -122.42516380777) | 9 | 7 | 6 | 28861 | 5 | |
49709 | 86947 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 283 Athens St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | Permit Number 49915 | 6004370.91908 | 2091607.61661 | 37.7234038337052 | -122.427013866101 | (37.7234038337052, -122.427013866101) | 9 | 7 | 6 | 28861 | 5 | |||
50937 | 95708 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767467 | 6004392 | 2091652 | 37.7235268927559 | -122.426944152742 | (37.7235268927559, -122.426944152742) | 9 | 7 | 6 | 28861 | 5 | ||
80340 | 95710 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767467 | 6004400.77828 | 2091660.5114 | 37.7235507595459 | -122.426914413678 | (37.7235507595459, -122.426914413678) | 9 | 7 | 6 | 28861 | 5 |
121614 | 175954 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 277 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004399.47027 | 2091677.82236 | 37.7235982176724 | -122.426920167539 | (37.7235982176724, -122.426920167539) | 9 | 7 | 6 | 28861 | 5 | |||
35483 | 175955 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 73 Mansfield St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005301.14037 | 2091779.76908 | 37.7239290836463 | -122.423810494468 | (37.7239290836463, -122.423810494468) | 9 | 7 | 6 | 309 | 5 | ||||
105505 | 175952 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 275 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6004189.37547 | 2091812.49337 | 37.7239561127781 | -122.427656018922 | (37.7239561127781, -122.427656018922) | 9 | 7 | 6 | 28861 | 5 | ||||
55974 | 175956 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 73 Mansfield St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005294.63264 | 2091795.7045 | 37.7239724714498 | -122.423834123243 | (37.7239724714498, -122.423834123243) | 9 | 7 | 6 | 309 | 5 | |||
10077 | 264701 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 88 Entrada Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8x20 | 5992483 | 2092113 | 37.724112106281 | -122.468144593972 | (37.724112106281, -122.468144593972) | 9 | 8 | 4 | 59 | 40 | ||||
36312 | 175957 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 63 La Grande Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6005285.01468 | 2091850.3565 | 37.7241219909335 | -122.423871255379 | (37.7241219909335, -122.423871255379) | 9 | 7 | 6 | 309 | 5 | ||||
159547 | 175953 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 234 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6004515.40701 | 2091902.81938 | 37.7242225647993 | -122.426535407888 | (37.7242225647993, -122.426535407888) | 9 | 7 | 6 | 28861 | 5 | ||||
153475 | 175938 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 247 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 6ft | 5999991.06618 | 2092148.77849 | 37.7246411020849 | -122.442192992309 | (37.7246411020849, -122.442192992309) | 9 | 7 | 6 | 28861 | 25 | |||
61345 | 175939 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 247 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 6ft | 5999997.9944 | 2092163.58217 | 37.7246821444372 | -122.442170104576 | (37.7246821444372, -122.442170104576) | 9 | 7 | 6 | 28861 | 25 | |||
42537 | 175940 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 247 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6000005.71858 | 2092180.29816 | 37.7247284829105 | -122.442144602498 | (37.7247284829105, -122.442144602498) | 9 | 7 | 6 | 28861 | 25 | |||
78753 | 175958 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 964 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005280.1292 | 2092112.24928 | 37.7248408154316 | -122.423906757903 | (37.7248408154316, -122.423906757903) | 9 | 7 | 6 | 309 | 5 | |||
141750 | 175959 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 964 Avalon Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005287.08611 | 2092115.88723 | 37.724851197198 | -122.423882967227 | (37.724851197198, -122.423882967227) | 9 | 7 | 6 | 309 | 5 | |||
88469 | 205368 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 609 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994843.97906 | 2092372.46561 | 37.7249606078444 | -122.460001891783 | (37.7249606078444, -122.460001891783) | 9 | 8 | 4 | 28861 | 40 | |||
144353 | 175925 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 130 San Juan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 8ft | 6001374.44127 | 2092267.13124 | 37.7250448158476 | -122.437419320745 | (37.7250448158476, -122.437419320745) | 9 | 7 | 6 | 28861 | 25 | |||
65415 | 175929 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 207 San Juan Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001163.21878 | 2092286.63013 | 37.7250863447352 | -122.438150888659 | (37.7250863447352, -122.438150888659) | 9 | 7 | 6 | 28861 | 25 | |||
179462 | 175928 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 207 San Juan Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001160.91031 | 2092287.39033 | 37.7250883007811 | -122.43815892321 | (37.7250883007811, -122.43815892321) | 9 | 7 | 6 | 28861 | 25 | |||
31773 | 175927 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 207 San Juan Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001152.36448 | 2092293.44224 | 37.7251044319142 | -122.438188898514 | (37.7251044319142, -122.438188898514) | 9 | 7 | 6 | 28861 | 25 | |||
4138 | 175926 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 207 San Juan Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001151.19668 | 2092294.37303 | 37.7251069212337 | -122.438193002116 | (37.7251069212337, -122.438193002116) | 9 | 7 | 6 | 28861 | 25 | |||
3945 | 70009 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1815 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005608.75345 | 2092244.69483 | 37.725223029103 | -122.422780149308 | (37.725223029103, -122.422780149308) | 9 | 7 | 7 | 309 | 5 | |||
19348 | 72159 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 141 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000647.86105 | 2092393.26967 | 37.7253498290121 | -122.439940063787 | (37.7253498290121, -122.439940063787) | 9 | 7 | 6 | 28861 | 25 | |||
142094 | 175930 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 141 Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000656.04967 | 2092411.70557 | 37.7254009159153 | -122.43991307783 | (37.7254009159153, -122.43991307783) | 9 | 7 | 6 | 28861 | 25 | |||
63476 | 62185 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 197 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1985 12:00:00 AM | 76 | Permit Number 22303 | 6000217.71423 | 2092424.50852 | 37.7254111079318 | -122.441429277242 | (37.7254111079318, -122.441429277242) | 9 | 7 | 6 | 28861 | 25 | |
48833 | 175931 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 197 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 6ft | 6000233.97071 | 2092439.73349 | 37.7254538383106 | -122.441374172195 | (37.7254538383106, -122.441374172195) | 9 | 7 | 6 | 28861 | 25 | |||
149359 | 175932 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 197 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 51 | Width 6ft | 6000244.83517 | 2092451.17994 | 37.7254858865513 | -122.441337435778 | (37.7254858865513, -122.441337435778) | 9 | 7 | 6 | 28861 | 25 | |||
101227 | 175960 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 167 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6004570.88863 | 2092419.5104 | 37.7256444208349 | -122.426380387255 | (37.7256444208349, -122.426380387255) | 9 | 7 | 6 | 28861 | 5 | ||||
53717 | 175963 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 142 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6004819.46151 | 2092426.16355 | 37.725676737076 | -122.425521563483 | (37.725676737076, -122.425521563483) | 9 | 7 | 6 | 28861 | 5 | |||
76295 | 175962 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 142 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6004822.64165 | 2092431.45059 | 37.7256914338095 | -122.425510946082 | (37.7256914338095, -122.425510946082) | 9 | 7 | 6 | 28861 | 5 | |||
63823 | 175961 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 275 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6005728.67215 | 2092432.15133 | 37.725744509099 | -122.42237891495 | (37.725744509099, -122.42237891495) | 9 | 7 | 7 | 309 | 5 | |||
86470 | 175965 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 716 Peru Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 2ft | 6005269.22848 | 2092453.41146 | 37.7257769566283 | -122.423968689709 | (37.7257769566283, -122.423968689709) | 9 | 7 | 6 | 309 | 5 | |||
123914 | 175964 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 716 Peru Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 2ft | 6005262.51487 | 2092457.27514 | 37.7257871864131 | -122.423992172815 | (37.7257871864131, -122.423992172815) | 9 | 7 | 6 | 309 | 5 | |||
158996 | 205369 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 151 Elmwood Way | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994984.94944 | 2092707.98002 | 37.7258899564322 | -122.459538865037 | (37.7258899564322, -122.459538865037) | 9 | 7 | 4 | 28861 | 40 | |||
15067 | 57250 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 115 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 12 | Permit Number 14539 | 6004961.23317 | 2092548.97797 | 37.7260219679128 | -122.425040204062 | (37.7260219679128, -122.425040204062) | 9 | 7 | 6 | 28861 | 5 | ||
112208 | 175951 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6003639.90512 | 2092696.00259 | 37.7263509363424 | -122.429618432255 | (37.7263509363424, -122.429618432255) | 9 | 7 | 6 | 28861 | 5 | |||
804 | 175950 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6003638.04232 | 2092697.69928 | 37.7263554895976 | -122.42962499282 | (37.7263554895976, -122.42962499282) | 9 | 7 | 6 | 28861 | 5 | |||
153808 | 175949 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004492.29305 | 2092899.66081 | 37.7269583645208 | -122.426686262865 | (37.7269583645208, -122.426686262865) | 9 | 7 | 6 | 28861 | 5 | |||
54357 | 175943 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 86 Arago St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 5999607.21926 | 2093005.0564 | 37.7269703596801 | -122.443581381 | (37.7269703596801, -122.443581381) | 9 | 7 | 6 | 28861 | 25 | ||||
19369 | 62036 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1985 12:00:00 AM | 8 | Permit Number 22111 | 6004501.59533 | 2092915.26272 | 37.7270017298275 | -122.426655215587 | (37.7270017298275, -122.426655215587) | 9 | 7 | 6 | 28861 | 5 | |
77880 | 175947 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 333 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004525.60344 | 2092980.90076 | 37.7271833146404 | -122.426576891834 | (37.7271833146404, -122.426576891834) | 9 | 7 | 6 | 28861 | 5 | |||
181685 | 175948 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 333 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004505.96243 | 2092990.03512 | 37.7272072851728 | -122.426645440842 | (37.7272072851728, -122.426645440842) | 9 | 7 | 6 | 28861 | 5 | |||
57046 | 46842 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 94 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 5 | Permit Number 44913 | 6004547.7325 | 2093002.72302 | 37.7272444847441 | -122.426501945015 | (37.7272444847441, -122.426501945015) | 9 | 7 | 6 | 28861 | 5 | |
44839 | 175979 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 638 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6009368.17577 | 2092960.86405 | 37.7274008768318 | -122.409834679142 | (37.7274008768318, -122.409834679142) | 10 | 3 | 7 | 309 | 28 | |||
171353 | 175933 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 48 Santa Ysabel Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000928.87779 | 2093144.53225 | 37.7274286173327 | -122.439022434243 | (37.7274286173327, -122.439022434243) | 9 | 7 | 6 | 28861 | 25 | ||||
173425 | 175937 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 17 Paulding St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6000256.08856 | 2093171.84167 | 37.7274652988843 | -122.441350220534 | (37.7274652988843, -122.441350220534) | 9 | 7 | 6 | 28861 | 25 | |||
186501 | 175936 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 17 Paulding St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6000252.95698 | 2093172.9603 | 37.727468191987 | -122.441361126621 | (37.727468191987, -122.441361126621) | 9 | 7 | 6 | 28861 | 25 | |||
119772 | 175935 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 17 Paulding St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6000247.15278 | 2093175.46351 | 37.7274747345727 | -122.44138137125 | (37.7274747345727, -122.44138137125) | 9 | 7 | 6 | 28861 | 25 | |||
44834 | 175946 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 71 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004355.80981 | 2093105.53941 | 37.7275159442062 | -122.427172741252 | (37.7275159442062, -122.427172741252) | 9 | 7 | 6 | 28861 | 5 | |||
12456 | 205316 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 112 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998697.99683 | 2093223.72686 | 37.7275188804882 | -122.44674026046 | (37.7275188804882, -122.44674026046) | 9 | 7 | 4 | 28861 | 40 | ||||
116482 | 205320 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 116 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5998646.31985 | 2093225.39912 | 37.7275205199304 | -122.446919027692 | (37.7275205199304, -122.446919027692) | 9 | 7 | 4 | 28861 | 40 | ||||
162033 | 205318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 116 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998650.07157 | 2093225.61944 | 37.7275213392142 | -122.44690607387 | (37.7275213392142, -122.44690607387) | 9 | 7 | 4 | 28861 | 40 | ||||
111209 | 205317 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 112 Marston Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998664.93768 | 2093225.42346 | 37.7275216503894 | -122.446854667736 | (37.7275216503894, -122.446854667736) | 9 | 7 | 4 | 28861 | 40 | ||||
182988 | 205482 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 66 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998899.77098 | 2093221.03408 | 37.727523011064 | -122.446042534938 | (37.727523011064, -122.446042534938) | 9 | 7 | 4 | 28861 | 40 | ||||
108028 | 205319 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 116 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5998647.86756 | 2093227.75495 | 37.7275270769096 | -122.446913846721 | (37.7275270769096, -122.446913846721) | 9 | 7 | 4 | 28861 | 40 | ||||
159311 | 205483 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 66 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998899.55245 | 2093223.44794 | 37.7275296264809 | -122.446043463943 | (37.7275296264809, -122.446043463943) | 9 | 7 | 4 | 28861 | 40 | ||||
97564 | 205371 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Wildwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5995657.59922 | 2093291.37587 | 37.7275304763386 | -122.457255760666 | (37.7275304763386, -122.457255760666) | 9 | 7 | 4 | 28861 | 40 | |||
9201 | 205370 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Wildwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995666.31716 | 2093292.13058 | 37.7275330492907 | -122.457225677447 | (37.7275330492907, -122.457225677447) | 9 | 7 | 4 | 28861 | 40 | |||
40683 | 205484 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 66 Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998899.69714 | 2093230.40528 | 37.7275487379747 | -122.446043463958 | (37.7275487379747, -122.446043463958) | 9 | 7 | 4 | 28861 | 40 | ||||
20550 | 205485 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 66 Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998899.62113 | 2093233.2174 | 37.7275564550591 | -122.446043928906 | (37.7275564550591, -122.446043928906) | 9 | 7 | 4 | 28861 | 40 | ||||
142024 | 175942 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 40 Arago St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5999730.39889 | 2093225.41188 | 37.7275824292676 | -122.443171371963 | (37.7275824292676, -122.443171371963) | 9 | 7 | 6 | 28861 | 25 | |||
173459 | 65584 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1990 12:00:00 AM | 1 | Permit Number 28484 | 6004276.22204 | 2093135.2738 | 37.7275930871392 | -122.427449994148 | (37.7275930871392, -122.427449994148) | 9 | 7 | 6 | 28861 | 5 | ||
128117 | 253466 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98X Marston Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793 | 2093251 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | 9 | 7 | 4 | 28861 | 40 | ||
72705 | 175941 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 40 Arago St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 5999740.20574 | 2093243.78443 | 37.7276334352188 | -122.443138788645 | (37.7276334352188, -122.443138788645) | 9 | 7 | 6 | 28861 | 25 | |||
35227 | 175968 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 335 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 3ft | 6005806.06015 | 2093261.16274 | 37.7280251583258 | -122.422170260562 | (37.7280251583258, -122.422170260562) | 9 | 7 | 7 | 309 | 5 | |||
168627 | 175934 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Nantucket Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | Width 5ft | 6000306.50096 | 2093394.4782 | 37.7280794791686 | -122.441191911987 | (37.7280794791686, -122.441191911987) | 9 | 7 | 6 | 28861 | 25 | |||
124410 | 175967 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008881.00194 | 2093225.23976 | 37.7280994818849 | -122.411537516669 | (37.7280994818849, -122.411537516669) | 9 | 3 | 7 | 309 | 28 |
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) );