trees
897 rows where qSpecies_id = 160 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170678 | 28224 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
171833 | 27851 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.53901 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | 6 | 2 | 9 | 28856 | 20 | ||
172631 | 27853 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015772.90401 | 2112134.31501 | 37.7804039822192 | -122.389031454309 | (37.7804039822192, -122.389031454309) | 6 | 2 | 9 | 28856 | 20 | ||
183525 | 18555 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 19 | 6014626.04256 | 2095092.92008 | 37.7335483329791 | -122.391807096032 | (37.7335483329791, -122.391807096032) | 10 | 3 | 8 | 58 | 1 | |||
185236 | 28221 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6013667.5202917 | 2110028.9140531 | 37.7745060991794 | -122.396167417116 | (37.7745060991794, -122.396167417116) | 14 | 2 | 9 | 310 | 20 | ||||
187277 | 25150 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 6004790.11345 | 2107911.6189 | 37.7681945727608 | -122.426725288037 | (37.7681945727608, -122.426725288037) | 8 | 4 | 5 | 28862 | 3 | |||
189165 | 25631 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.62162 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | 3 | 2 | 10 | 28860 | 6 | ||
190651 | 234375 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 9ft | 6004995.06327 | 2105009.72546 | 37.7602382499206 | -122.425809806971 | (37.7602382499206, -122.425809806971) | 2 | 4 | 5 | 28859 | 19 | |||
193297 | 194313 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 12 | Width 7ft | 6015116.8381 | 2116756.98357 | 37.793060384871 | -122.391624402345 | (37.793060384871, -122.391624402345) | 12 | 2 | 9 | 28855 | 6 | |||
137161 | 210913 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1800 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5990641.45059 | 2103071.06132 | 37.7540936050568 | -122.475310139971 | (37.7540936050568, -122.475310139971) | 1 | 8 | 4 | 56 | 12 | |||
112118 | 27788 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
183143 | 27786 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
193128 | 27787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
1611 | 247638 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 360 Bradford St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6009465.98098 | 2096572.55437 | 37.7373232876386 | -122.409751390215 | (37.7373232876386, -122.409751390215) | 10 | 7 | 7 | 28859 | 2 | ||||
7512 | 234395 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X Ogden Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 4ft | 6008504 | 2096098 | 37.7359663084052 | -122.413043870385 | (37.7359663084052, -122.413043870385) | 10 | 7 | 7 | 28859 | 2 | |||
35049 | 194282 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2 Tulare St | 6 | Front Yard : Yard | Tree | Private 2 | 15 | 6016226.55416 | 2100307.94064 | 37.7479564371431 | -122.386637143603 | (37.7479564371431, -122.386637143603) | 3 | 8 | 58 | 1 | |||||
89066 | 234374 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 581 Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 9ft | 6004996.87402 | 2105008.54576 | 37.7602351130699 | -122.425803460464 | (37.7602351130699, -122.425803460464) | 2 | 4 | 5 | 28859 | 19 | |||
150556 | 234332 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6004849.34041 | 2105800.52772 | 37.7624013694379 | -122.426370099906 | (37.7624013694379, -122.426370099906) | 8 | 4 | 5 | 28859 | 3 | |||
155937 | 194323 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 15 | Width 7ft | 6014746.37404 | 2117187.87081 | 37.7942229303951 | -122.392936399892 | (37.7942229303951, -122.392936399892) | 12 | 2 | 10 | 28855 | 6 | |||
25206 | 25733 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
44069 | 25731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
87303 | 25735 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013816.07307 | 2118422.78251 | 37.7975619881486 | -122.396241959692 | (37.7975619881486, -122.396241959692) | 3 | 1 | 10 | 28860 | 6 | ||
130810 | 178085 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 210 Tocoloma Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6012726.32279 | 2087488.85731 | 37.7125634740919 | -122.397841808652 | (37.7125634740919, -122.397841808652) | 10 | 3 | 8 | 309 | 1 | |||
140966 | 25732 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
152086 | 25734 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.18586 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | 3 | 1 | 10 | 28860 | 6 | ||
193499 | 132126 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6014272.27117 | 2117547.1339 | 37.7951830367225 | -122.394602030674 | (37.7951830367225, -122.394602030674) | 4 | 2 | 10 | 28860 | 6 | |||
22376 | 194392 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 860x Jamestown Ave | 5 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6014755.05221 | 2089115.57759 | 37.7171429037943 | -122.390943451878 | (37.7171429037943, -122.390943451878) | 10 | 3 | 8 | 58 | 1 | |||
45636 | 132102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 17 | Width 10ft | 6012409.88323 | 2120572.11734 | 37.8033851982182 | -122.401258897879 | (37.8033851982182, -122.401258897879) | 3 | 1 | 10 | 28860 | 6 | |||
124776 | 132117 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 17 | Width 10ft | 6013132.77632 | 2119506.77553 | 37.800500329583 | -122.398682475136 | (37.800500329583, -122.398682475136) | 3 | 1 | 10 | 28860 | 6 | |||
1504 | 19794 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 STAIRWAY19 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
4871 | 132103 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012095.78368 | 2120981.89347 | 37.8044928149639 | -122.402374687645 | (37.8044928149639, -122.402374687645) | 3 | 1 | 10 | 28860 | 6 | |||
14706 | 118708 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4201 Balboa St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5982482.88801 | 2110969.6299 | 37.7753045397791 | -122.504108985066 | (37.7753045397791, -122.504108985066) | 11 | 6 | 2 | 55 | 26 | |||
28642 | 27958 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
39492 | 27959 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
43024 | 194324 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 18 | Width 7ft | 6014719.87282 | 2117222.06559 | 37.7943153492131 | -122.393030491457 | (37.7943153492131, -122.393030491457) | 12 | 2 | 10 | 28855 | 6 | |||
44613 | 234336 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 420 Dolores St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 3ft | 6004864.24492 | 2105581.16954 | 37.7617999064621 | -122.426302932261 | (37.7617999064621, -122.426302932261) | 8 | 4 | 5 | 28862 | 3 | |||
69730 | 132101 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 17 | Median : Yard | Tree | DPW 1 | 18 | Width 10ft | 6012520.61539 | 2120407.16114 | 37.802938445615 | -122.40086410632 | (37.802938445615, -122.40086410632) | 3 | 1 | 10 | 28860 | 6 | |||
87673 | 132123 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6014232.87879 | 2117626.20085 | 37.7953979459112 | -122.394743875326 | (37.7953979459112, -122.394743875326) | 4 | 2 | 10 | 28860 | 6 | |||
89061 | 234369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 18 | 6005339.90624 | 2098058.76544 | 37.7411720001789 | -122.424122818219 | (37.7411720001789, -122.424122818219) | 2 | 7 | 5 | 63 | 7 | ||||
90761 | 28372 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
92097 | 27960 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
97718 | 27717 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 09/11/2000 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
98735 | 234386 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004984.24145 | 2103652.12046 | 37.7565099745835 | -122.425750602809 | (37.7565099745835, -122.425750602809) | 2 | 4 | 5 | 28862 | 22 | |||
113444 | 132125 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6014258.52591 | 2117571.02815 | 37.79524788055 | -122.394651265852 | (37.79524788055, -122.394651265852) | 4 | 2 | 10 | 28860 | 6 | |||
117166 | 113319 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005986 | 2109035 | 37.7713466487942 | -122.42266867187 | (37.7713466487942, -122.42266867187) | 8 | 2 | 9 | 28853 | 19 | |||
130470 | 194393 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 860x Jamestown Ave | 9 | Median : Cutout | Tree | DPW 1 | 18 | Width 5ft | 6014647.11529 | 2089218.63866 | 37.7174198994758 | -122.391323741894 | (37.7174198994758, -122.391323741894) | 10 | 3 | 8 | 58 | 1 | |||
152465 | 27785 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 18 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
152650 | 27961 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
154796 | 132121 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 6014209.141 | 2117675.2625 | 37.7955313378499 | -122.39482945032 | (37.7955313378499, -122.39482945032) | 4 | 2 | 10 | 28860 | 6 | |||
174070 | 118707 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 4201 Balboa St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 5982546.62842 | 2110970.49419 | 37.7753106610998 | -122.503888560039 | (37.7753106610998, -122.503888560039) | 11 | 6 | 2 | 55 | 26 | |||
176830 | 233927 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 389 Webster St | 3 | : | Tree | Private 2 | 18 | Width 3ft | 6004115.83529 | 2109995.53754 | 37.7738783609231 | -122.429206159632 | (37.7738783609231, -122.429206159632) | 7 | 9 | 11 | 29492 | 10 | |||
184514 | 116529 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 745X SANCHEZ ST | 6 | Median : Yard | Tree | DPW 1 | 18 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | ||||
185888 | 27962 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
23344 | 194391 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 828x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014866.8225 | 2088973.55401 | 37.7167591360948 | -122.390547193499 | (37.7167591360948, -122.390547193499) | 10 | 3 | 8 | 58 | 1 | |||
55447 | 194394 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 920x Jamestown Ave | 4 | Median : Cutout | Tree | DPW 1 | 19 | Width 5ft | 6014490.42947 | 2089308.04208 | 37.7176566864975 | -122.391871584628 | (37.7176566864975, -122.391871584628) | 10 | 3 | 8 | 58 | 1 | |||
75350 | 178084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 210 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012735.74773 | 2087515.03594 | 37.7126358803078 | -122.397811068042 | (37.7126358803078, -122.397811068042) | 10 | 3 | 8 | 309 | 1 | |||
121091 | 132122 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 640 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6014219.48603 | 2117650.76237 | 37.7954646414426 | -122.394791937806 | (37.7954646414426, -122.394791937806) | 4 | 2 | 10 | 28860 | 6 | |||
154415 | 194319 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.7936013558627 | -122.392257538577 | (37.7936013558627, -122.392257538577) | 12 | 2 | 9 | 28855 | 6 | |||
179721 | 132104 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 19 | Width 10ft | 6012041.8343 | 2121038.82925 | 37.8046461349625 | -122.402565391602 | (37.8046461349625, -122.402565391602) | 3 | 1 | 10 | 28860 | 6 | |||
37923 | 234382 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2624 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010280.44455 | 2103423.11774 | 37.7561790447523 | -122.407418219675 | (37.7561790447523, -122.407418219675) | 10 | 4 | 7 | 28859 | 19 | |||
71795 | 132067 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 3038 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5999089.10208 | 2119262.1852 | 37.799036302553 | -122.44726145536 | (37.799036302553, -122.44726145536) | 13 | 9 | 1 | 57 | 17 | |||
81219 | 186008 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1900 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985026.892 | 2101640.0667 | 37.7498374500445 | -122.494620873169 | (37.7498374500445, -122.494620873169) | 1 | 8 | 3 | 29491 | 35 | |||
20141 | 132092 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011191.46105 | 2121714.36376 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | 3 | 1 | 10 | 308 | 23 | |||
83186 | 132087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011581.4658 | 2121414.59731 | 37.8056521894584 | -122.404185013045 | (37.8056521894584, -122.404185013045) | 3 | 1 | 10 | 28860 | 23 | |||
85425 | 132114 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6013298.81612 | 2119255.09608 | 37.7998185274531 | -122.39809024008 | (37.7998185274531, -122.39809024008) | 3 | 1 | 10 | 28860 | 6 | |||
91316 | 132112 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011208.19344 | 2121737.88602 | 37.8065189965151 | -122.405499565575 | (37.8065189965151, -122.405499565575) | 3 | 1 | 10 | 308 | 23 | |||
100339 | 247642 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 632 Banks St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 4ft | 6008490.96565 | 2095907.56445 | 37.7354426820387 | -122.413075474255 | (37.7354426820387, -122.413075474255) | 10 | 7 | 7 | 28859 | 2 | |||
101879 | 194310 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015149.43028 | 2116672.04989 | 37.7928289857212 | -122.391505690053 | (37.7928289857212, -122.391505690053) | 12 | 2 | 9 | 28855 | 6 | |||
105728 | 132074 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6013098.86351 | 2119482.52775 | 37.8004318615024 | -122.398798125256 | (37.8004318615024, -122.398798125256) | 3 | 1 | 10 | 28860 | 6 | |||
117843 | 194273 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Tennessee St | 16 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6015573.17514 | 2103426.76477 | 37.7564838780418 | -122.38911425333 | (37.7564838780418, -122.38911425333) | 10 | 3 | 8 | 28856 | 29 | |||
120033 | 132086 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011972.21269 | 2121045.33445 | 37.8046601095467 | -122.402806783124 | (37.8046601095467, -122.402806783124) | 3 | 1 | 10 | 28860 | 6 | |||
124081 | 194314 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015030.09218 | 2116803.1524 | 37.7931823383373 | -122.391927780566 | (37.7931823383373, -122.391927780566) | 12 | 2 | 9 | 28855 | 6 | |||
129767 | 132081 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 16 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6012501.69351 | 2120366.84811 | 37.802826700353 | -122.400926752172 | (37.802826700353, -122.400926752172) | 3 | 1 | 10 | 28860 | 6 | |||
138931 | 27784 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 20 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
146729 | 194315 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 20 | Width 7ft | 6015053.74343 | 2116822.79374 | 37.7932375819021 | -122.391847319118 | (37.7932375819021, -122.391847319118) | 12 | 2 | 9 | 28855 | 6 | |||
148760 | 9369 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 276 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | 6001136.50681 | 2098095.27018 | 37.7410340073111 | -122.438659251142 | (37.7410340073111, -122.438659251142) | 2 | 7 | 5 | 63 | 7 | |||
153923 | 245963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1950x Market St | 1 | Median : Cutout | Tree | DPW 1 | 20 | Width 0ft | 6005062.3371 | 2108554.2304 | 37.7699744164919 | -122.425829439833 | (37.7699744164919, -122.425829439833) | 7 | 2 | 5 | 28853 | 19 | |||
158030 | 27482 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 990X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | 2 | 4 | 5 | 28862 | 22 | ||
159594 | 132105 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6012001.46692 | 2121074.30881 | 37.8047412994387 | -122.402707584299 | (37.8047412994387, -122.402707584299) | 3 | 1 | 10 | 28860 | 6 | |||
166083 | 132106 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011673.52168 | 2121373.1691 | 37.8055435810345 | -122.403863521591 | (37.8055435810345, -122.403863521591) | 3 | 1 | 10 | 28860 | 23 | |||
185555 | 194395 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 920x Jamestown Ave | 9 | Median : Cutout | Tree | DPW 1 | 20 | Width 5ft | 6014427.53162 | 2089348.90616 | 37.7177653992236 | -122.392091851971 | (37.7177653992236, -122.392091851971) | 10 | 3 | 8 | 58 | 1 | |||
1977 | 132113 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.397977001937 | (37.7996825238869, -122.397977001937) | 3 | 1 | 10 | 28860 | 6 | |||
16115 | 194311 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 380x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 21 | Width 7ft | 6015171.22981 | 2116694.38601 | 37.7928915254696 | -122.391431824244 | (37.7928915254696, -122.391431824244) | 12 | 2 | 9 | 28855 | 6 | |||
48409 | 132091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.8063057411882 | -122.405269766312 | (37.8063057411882, -122.405269766312) | 3 | 1 | 10 | 308 | 23 | |||
52151 | 132109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011459.50109 | 2121569.1071 | 37.8060696196846 | -122.404617975463 | (37.8060696196846, -122.404617975463) | 3 | 1 | 10 | 308 | 23 | |||
75327 | 132090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011358.77785 | 2121601.92287 | 37.8061540939119 | -122.40496885854 | (37.8061540939119, -122.40496885854) | 3 | 1 | 10 | 308 | 23 | |||
83784 | 234360 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1150x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 21 | 6005142.56045 | 2101579.1271 | 37.7508269625113 | -122.425055587855 | (37.7508269625113, -122.425055587855) | 2 | 4 | 5 | 28862 | 22 | ||||
94663 | 132082 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200x The Embarcadero | 1 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012375.04896 | 2120549.19866 | 37.8033203256223 | -122.40137783234 | (37.8033203256223, -122.40137783234) | 3 | 1 | 10 | 28860 | 6 | |||
98562 | 234368 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750x Dolores St | 1 | Median : Yard | Tree | DPW 1 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | 2 | 7 | 5 | 63 | 7 | ||||
112744 | 132078 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012663.13034 | 2120132.51785 | 37.8021922897941 | -122.400351625829 | (37.8021922897941, -122.400351625829) | 3 | 1 | 10 | 28860 | 6 | |||
119144 | 132096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012742.85934 | 2120080.46122 | 37.8020538004962 | -122.400072065282 | (37.8020538004962, -122.400072065282) | 3 | 1 | 10 | 28860 | 6 | |||
167130 | 194339 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 88x King St | 15 | Median : Yard | Tree | DPW 1 | 21 | Width 8ft | 6015964.49017 | 2112481.16819 | 37.7813669814493 | -122.388392878343 | (37.7813669814493, -122.388392878343) | 6 | 2 | 9 | 28856 | 20 | |||
184689 | 132079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.400534313224 | (37.8023972264213, -122.400534313224) | 3 | 1 | 10 | 28860 | 6 | |||
187099 | 132108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011532.66827 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | 3 | 1 | 10 | 28860 | 23 | |||
22076 | 234356 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 650x Dolores St | 3 | Median : Yard | Tree | DPW 1 | 22 | 6004985.93046 | 2104422.99085 | 37.7586266989802 | -122.425799629353 | (37.7586266989802, -122.425799629353) | 2 | 4 | 5 | 28862 | 3 | ||||
32602 | 120819 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 101 20th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 5989573.42956 | 2114582.3778 | 37.7856385654779 | -122.47984587102 | (37.7856385654779, -122.47984587102) | 11 | 6 | 2 | 55 | 26 | |||
57723 | 132097 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012695.81427 | 2120154.08889 | 37.8022533411719 | -122.400240038841 | (37.8022533411719, -122.400240038841) | 3 | 1 | 10 | 28860 | 6 | |||
77982 | 194321 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 22 | Width 7ft | 6014800.62587 | 2117118.44333 | 37.7940353120341 | -122.392743821769 | (37.7940353120341, -122.392743821769) | 12 | 2 | 10 | 28855 | 6 | |||
87732 | 132088 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011509.10408 | 2121480.92062 | 37.8058302534199 | -122.404440103948 | (37.8058302534199, -122.404440103948) | 3 | 1 | 10 | 28860 | 23 | |||
105718 | 132099 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100x The Embarcadero | 14 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6012592.45443 | 2120302.68635 | 37.8026555899447 | -122.400608161041 | (37.8026555899447, -122.400608161041) | 3 | 1 | 10 | 28860 | 6 |
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) );