trees
8,758 rows where qSpecies_id = 16 sorted by YCoord descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47604 | 104262 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
| 66899 | 104263 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
| 94320 | 104266 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
| 108485 | 104265 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
| 178487 | 104264 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 199X Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065 | (37.8083175458446, -122.41498343065) | 3 | 1 | 10 | 308 | 23 | |||||
| 19851 | 41638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 175 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008374.70502 | 2122409.49865 | 37.808204234292 | -122.415352980375 | (37.808204234292, -122.415352980375) | 3 | 1 | 10 | 308 | 23 | |
| 136789 | 41643 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 175 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008364.2633 | 2122408.61155 | 37.8082012116738 | -122.41538905396 | (37.8082012116738, -122.41538905396) | 3 | 1 | 10 | 308 | 23 | |
| 66482 | 41642 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 175 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008347.81588 | 2122407.53263 | 37.8081973247997 | -122.415445898318 | (37.8081973247997, -122.415445898318) | 3 | 1 | 10 | 308 | 23 | |
| 153087 | 41641 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 175 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008318.31427 | 2122401.37399 | 37.8081787565193 | -122.415547560374 | (37.8081787565193, -122.415547560374) | 3 | 1 | 10 | 308 | 23 | |
| 173503 | 41640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 175 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008303.89341 | 2122398.99555 | 37.8081714153313 | -122.415597299176 | (37.8081714153313, -122.415597299176) | 3 | 1 | 10 | 308 | 23 | |
| 42839 | 41639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 175 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008290.6132 | 2122398.32381 | 37.8081688244054 | -122.415643211358 | (37.8081688244054, -122.415643211358) | 3 | 1 | 10 | 308 | 23 | |
| 89963 | 131624 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2740 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008272.45896 | 2122375.57657 | 37.8081053457565 | -122.415704427336 | (37.8081053457565, -122.415704427336) | 5 | 1 | 10 | 308 | 23 | |||
| 139003 | 131623 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2740 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008274.82732 | 2122360.11537 | 37.8080630263603 | -122.415695135531 | (37.8080630263603, -122.415695135531) | 5 | 1 | 10 | 308 | 23 | |||
| 61911 | 131622 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2740 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008277.02166 | 2122343.87132 | 37.8080185476734 | -122.415686390512 | (37.8080185476734, -122.415686390512) | 5 | 1 | 10 | 308 | 23 | |||
| 174014 | 131621 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2740 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008283.03118 | 2122305.68799 | 37.807914043752 | -122.415662887656 | (37.807914043752, -122.415662887656) | 5 | 1 | 10 | 308 | 23 | |||
| 152412 | 131620 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2740 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008285.97952 | 2122287.69849 | 37.8078648148827 | -122.415651409597 | (37.8078648148827, -122.415651409597) | 5 | 1 | 10 | 308 | 23 | |||
| 117891 | 131619 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2740 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008287.70356 | 2122271.62162 | 37.8078207687883 | -122.415644304065 | (37.8078207687883, -122.415644304065) | 5 | 1 | 10 | 308 | 23 | |||
| 33374 | 21825 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2742 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008296.21715 | 2122224.91462 | 37.8076930017751 | -122.415611531478 | (37.8076930017751, -122.415611531478) | 5 | 1 | 10 | 308 | 23 | |||
| 42282 | 21827 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
| 64479 | 21828 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
| 102016 | 21829 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2750X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
| 142587 | 21821 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2734 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
| 147020 | 21822 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2734 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.8075992468773 | -122.41532078193 | (37.8075992468773, -122.41532078193) | 3 | 1 | 10 | 308 | 23 | |||
| 19990 | 87879 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50851 | 6002250.92262 | 2121888.76212 | 37.8064283484493 | -122.436508609691 | (37.8064283484493, -122.436508609691) | 13 | 9 | 1 | 57 | 17 | |
| 112024 | 131615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6009239.74598 | 2121887.25719 | 37.8068188709455 | -122.412322330711 | (37.8068188709455, -122.412322330711) | 3 | 1 | 10 | 308 | 23 | |||
| 160690 | 65830 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 265 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/1990 12:00:00 AM | 9 | Permit Number 28820 | 6002215.96155 | 2121885.3165 | 37.806416900995 | -122.436629351784 | (37.806416900995, -122.436629351784) | 13 | 9 | 1 | 57 | 17 | ||
| 65485 | 131333 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 265 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6002225.92805 | 2121872.37078 | 37.806381921855 | -122.43659393376 | (37.806381921855, -122.43659393376) | 13 | 9 | 1 | 57 | 17 | |||
| 173664 | 131616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 North Point St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008985.35955 | 2121850.72044 | 37.8067042721502 | -122.413200103225 | (37.8067042721502, -122.413200103225) | 3 | 1 | 10 | 308 | 23 | |||
| 66413 | 131617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 North Point St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008895.38434 | 2121838.64797 | 37.8066660725375 | -122.413510626514 | (37.8066660725375, -122.413510626514) | 3 | 1 | 10 | 308 | 23 | |||
| 59947 | 131618 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 North Point St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008855.31993 | 2121832.80496 | 37.8066477794276 | -122.413648864003 | (37.8066477794276, -122.413648864003) | 3 | 1 | 10 | 308 | 23 | |||
| 76919 | 131571 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2753 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 3ft | 6006844.83313 | 2121827.18863 | 37.8065192573265 | -122.420606150667 | (37.8065192573265, -122.420606150667) | 5 | 1 | 1 | 28858 | 32 | |||
| 57750 | 50322 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47025 | 6008839.14923896 | 2121813.47982316 | 37.8065938094155 | -122.413703458172 | (37.8065938094155, -122.413703458172) | 3 | 1 | 10 | 308 | 23 | |||
| 65081 | 50323 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2500 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | Permit Number 47025 | 6008839.14923896 | 2121813.47982316 | 37.8065938094155 | -122.413703458172 | (37.8065938094155, -122.413703458172) | 3 | 1 | 10 | 308 | 23 | |||
| 176773 | 11182 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2765 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | |||
| 60597 | 143160 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 MIDWAY ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6010079.5079 | 2121559.6876 | 37.8059665335797 | -122.409393023077 | (37.8059665335797, -122.409393023077) | 3 | 1 | 10 | 308 | 23 | |||
| 112824 | 143159 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 MIDWAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010083.8953 | 2121533.9898 | 37.8058962196375 | -122.40937602503 | (37.8058962196375, -122.40937602503) | 3 | 1 | 10 | 308 | 23 | |||
| 23600 | 143158 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 MIDWAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010085.1488 | 2121513.3062 | 37.8058394978516 | -122.409370226483 | (37.8058394978516, -122.409370226483) | 3 | 1 | 10 | 308 | 23 | |||
| 90753 | 131330 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999450.18317 | 2121499.93339 | 37.805201182148 | -122.446173049955 | (37.805201182148, -122.446173049955) | 13 | 9 | 1 | 57 | 17 | |||
| 171530 | 143157 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 MIDWAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010090.163 | 2121485.1014 | 37.8057623354244 | -122.40935088231 | (37.8057623354244, -122.40935088231) | 3 | 1 | 10 | 308 | 23 | |||
| 144892 | 143231 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 33 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6010061.228 | 2121465.1493 | 37.8057059307279 | -122.40944960763 | (37.8057059307279, -122.40944960763) | 3 | 1 | 10 | 308 | 23 | |||
| 99081 | 143156 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010093.9237 | 2121443.7342 | 37.8056489620875 | -122.409334946656 | (37.8056489620875, -122.409334946656) | 3 | 1 | 10 | 308 | 23 | |||
| 128192 | 143232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 33 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6010065.2011 | 2121437.9047 | 37.8056313464495 | -122.409433934108 | (37.8056313464495, -122.409433934108) | 3 | 1 | 10 | 308 | 23 | |||
| 51072 | 143233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 33 MIDWAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010066.9039 | 2121425.9852 | 37.8055987138758 | -122.409427199568 | (37.8055987138758, -122.409427199568) | 3 | 1 | 10 | 308 | 23 | |||
| 89122 | 143155 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6010097.0576 | 2121424.931 | 37.8055975087602 | -122.409322773525 | (37.8055975087602, -122.409322773525) | 3 | 1 | 10 | 308 | 23 | |||
| 134180 | 143234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 33 MIDWAY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010069.7419 | 2121414.0657 | 37.8055661449061 | -122.409416536498 | (37.8055661449061, -122.409416536498) | 3 | 1 | 10 | 308 | 23 | |||
| 26766 | 143192 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 23 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6010074.2827 | 2121384.5507 | 37.8054853584752 | -122.409398738098 | (37.8054853584752, -122.409398738098) | 3 | 1 | 10 | 308 | 23 | |||
| 44945 | 99261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.8052503240173 | -122.42371770971 | (37.8052503240173, -122.42371770971) | 5 | 1 | 1 | 28858 | 32 | ||
| 181954 | 131328 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3731 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002004.9818 | 2121357.00447 | 37.8049543047625 | -122.437321630111 | (37.8049543047625, -122.437321630111) | 13 | 9 | 1 | 57 | 17 | |||
| 95664 | 131329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002107.96677 | 2121266.57415 | 37.804711861029 | -122.436958761733 | (37.804711861029, -122.436958761733) | 13 | 9 | 1 | 57 | 17 | |||
| 69823 | 131326 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3615 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999135.58402 | 2121250.56661 | 37.8044985175422 | -122.44724379627 | (37.8044985175422, -122.44724379627) | 13 | 9 | 1 | 57 | 17 | |||
| 137076 | 131341 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1690 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002211.37442 | 2121244.58816 | 37.8046573702031 | -122.436599335103 | (37.8046573702031, -122.436599335103) | 13 | 9 | 1 | 57 | 17 | |||
| 103429 | 131342 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1690 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002186.39912 | 2121242.02691 | 37.8046489183885 | -122.436685580975 | (37.8046489183885, -122.436685580975) | 13 | 9 | 1 | 57 | 17 | |||
| 173790 | 131343 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1690 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002163.7255 | 2121238.64833 | 37.8046383531478 | -122.436763803111 | (37.8046383531478, -122.436763803111) | 13 | 9 | 1 | 57 | 17 | |||
| 119567 | 98778 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003103.75462 | 2121176.62609 | 37.8045214349813 | -122.433506309391 | (37.8045214349813, -122.433506309391) | 13 | 9 | 1 | 57 | 17 | |||
| 49708 | 98777 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003095.78209 | 2121157.07886 | 37.8044673110903 | -122.433532501243 | (37.8044673110903, -122.433532501243) | 13 | 9 | 1 | 57 | 17 | |||
| 40464 | 48834 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3700X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | 3 | 3x3 | 6003107.67993 | 2121141.17951 | 37.8044243306918 | -122.43349019084 | (37.8044243306918, -122.43349019084) | 13 | 9 | 1 | 57 | 17 | ||
| 96503 | 41211 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3672 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 7 | Permit Number 41920 | 6002143.7473 | 2121032.61773 | 37.8040715122401 | -122.436818181531 | (37.8040715122401, -122.436818181531) | 13 | 9 | 1 | 57 | 17 | |
| 124038 | 131272 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1921 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001028.78921 | 2120972.37229 | 37.8038426644651 | -122.440672238756 | (37.8038426644651, -122.440672238756) | 13 | 9 | 1 | 57 | 17 | |||
| 110508 | 131271 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1921 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6000975.37213 | 2120964.40947 | 37.8038177586317 | -122.440856519715 | (37.8038177586317, -122.440856519715) | 13 | 9 | 1 | 57 | 17 | |||
| 54875 | 68966 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2221 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 12 | Permit Number 32956 | 5999588.98891 | 2120837.10382 | 37.803389157054 | -122.445645002217 | (37.803389157054, -122.445645002217) | 13 | 9 | 1 | 57 | 17 | |
| 105572 | 68967 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2235 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | Permit Number 32957 | 5999532.32981843 | 2120823.23983163 | 37.8033478553202 | -122.445840074782 | (37.8033478553202, -122.445840074782) | 13 | 9 | 1 | 57 | 17 | ||
| 106299 | 131270 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2255 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999402.93097 | 2120810.14921 | 37.8033045227389 | -122.446286920298 | (37.8033045227389, -122.446286920298) | 13 | 9 | 1 | 57 | 17 | |||
| 57666 | 131334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3611 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003107.87441 | 2120753.09698 | 37.8033587689415 | -122.433461767746 | (37.8033587689415, -122.433461767746) | 13 | 9 | 1 | 57 | 17 | |||
| 153382 | 131335 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3609 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003110.15445 | 2120730.31313 | 37.803296339819 | -122.433452248448 | (37.803296339819, -122.433452248448) | 13 | 9 | 1 | 57 | 17 | |||
| 76994 | 82000 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50638 | 6005983.68719 | 2120729.63993 | 37.8034571008393 | -122.423508229633 | (37.8034571008393, -122.423508229633) | 5 | 9 | 1 | 28858 | 32 |
| 37719 | 81999 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005960.45556 | 2120727.09731 | 37.8034488081703 | -122.423588442877 | (37.8034488081703, -122.423588442877) | 5 | 9 | 1 | 28858 | 32 |
| 131888 | 106658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 256 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6001495.79596 | 2120724.12156 | 37.8031876171793 | -122.439038335152 | (37.8031876171793, -122.439038335152) | 13 | 9 | 1 | 57 | 17 | ||||
| 147715 | 81997 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005918.11487 | 2120722.35908 | 37.8034334081868 | -122.42373462766 | (37.8034334081868, -122.42373462766) | 5 | 9 | 1 | 28858 | 32 |
| 175602 | 97728 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | 5 | 9 | 1 | 28858 | 32 | |
| 175853 | 59835 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 256 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1981 12:00:00 AM | 16 | Permit Number 19289 | 6001507.02699 | 2120711.1936 | 37.8031527594543 | -122.438998542875 | (37.8031527594543, -122.438998542875) | 13 | 9 | 1 | 57 | 17 | ||
| 190986 | 131336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3605 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003111.95247 | 2120710.82669 | 37.8032429371717 | -122.433444632988 | (37.8032429371717, -122.433444632988) | 13 | 9 | 1 | 57 | 17 | |||
| 65139 | 97730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | 5 | 9 | 1 | 28858 | 32 | |
| 156701 | 97732 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | 5 | 9 | 1 | 28858 | 32 | |
| 184931 | 97734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | Permit Number 50638 | 6005715.83773 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | 5 | 9 | 1 | 28858 | 32 | |
| 62181 | 68248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3520 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 9 | Permit Number 32049 | 6001233.22938 | 2120683.51189 | 37.803061170692 | -122.439944038802 | (37.803061170692, -122.439944038802) | 13 | 9 | 1 | 57 | 17 | |
| 63723 | 131337 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6003093.37773 | 2120677.24262 | 37.8031496702743 | -122.433506509938 | (37.8031496702743, -122.433506509938) | 13 | 9 | 1 | 57 | 17 | |||
| 91933 | 131338 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003074.10722 | 2120676.54489 | 37.803146661137 | -122.433573146108 | (37.803146661137, -122.433573146108) | 13 | 9 | 1 | 57 | 17 | |||
| 24562 | 131339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003059.47166 | 2120673.83402 | 37.8031383873936 | -122.433623598957 | (37.8031383873936, -122.433623598957) | 13 | 9 | 1 | 57 | 17 | |||
| 100519 | 131340 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.77527 | 2120670.70076 | 37.8031286099566 | -122.433694995232 | (37.8031286099566, -122.433694995232) | 13 | 9 | 1 | 57 | 17 | |||
| 142810 | 112911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3514 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6001236.25311 | 2120660.54801 | 37.8029982901092 | -122.439931927628 | (37.8029982901092, -122.439931927628) | 13 | 9 | 1 | 57 | 17 | ||||
| 22507 | 131612 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 747 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008181.61728 | 2120648.76076 | 37.8033588390995 | -122.415896447887 | (37.8033588390995, -122.415896447887) | 5 | 1 | 10 | 308 | 32 | |||
| 161338 | 68247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3514 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 12 | Permit Number 32048 | 6001238.44206 | 2120645.56673 | 37.8029572801025 | -122.439923277935 | (37.8029572801025, -122.439923277935) | 13 | 9 | 1 | 57 | 17 | |
| 112113 | 60875 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 779 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1983 12:00:00 AM | Permit Number 20658 | 6008112.43934478 | 2120636.19828285 | 37.803320456308 | -122.416134951163 | (37.803320456308, -122.416134951163) | 5 | 1 | 10 | 308 | 32 | ||
| 129095 | 60876 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 781 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1983 12:00:00 AM | Permit Number 20659 | 6008103.35729481 | 2120635.02630904 | 37.8033167277069 | -122.416166296957 | (37.8033167277069, -122.416166296957) | 5 | 1 | 10 | 308 | 32 | ||
| 182561 | 69352 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1304 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 8 | Permit Number 33443 | 6005047.13991 | 2120598.91994 | 37.8030452715839 | -122.426739877742 | (37.8030452715839, -122.426739877742) | 13 | 9 | 1 | 28858 | 17 | |
| 174329 | 131572 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2709 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006519.11799 | 2120598.54837 | 37.8031273635077 | -122.421646029539 | (37.8031273635077, -122.421646029539) | 5 | 9 | 1 | 28858 | 32 | |||
| 59919 | 131331 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1304 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005026.90435 | 2120597.50734 | 37.8030402488573 | -122.426809802731 | (37.8030402488573, -122.426809802731) | 13 | 9 | 1 | 28858 | 17 | |||
| 180350 | 131573 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2709 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006518.42693 | 2120591.51077 | 37.8031080010843 | -122.42164792083 | (37.8031080010843, -122.42164792083) | 5 | 9 | 1 | 28858 | 32 | |||
| 134161 | 131332 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1308 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004965.17921 | 2120588.41267 | 37.8030117871273 | -122.427022755916 | (37.8030117871273, -122.427022755916) | 13 | 9 | 1 | 57 | 17 | |||
| 175596 | 131574 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2709 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006521.22266 | 2120583.18119 | 37.8030852878264 | -122.42163765416 | (37.8030852878264, -122.42163765416) | 5 | 9 | 1 | 28858 | 32 | |||
| 60019 | 131575 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2707 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006523.23759 | 2120572.94764 | 37.8030573027236 | -122.421629954168 | (37.8030573027236, -122.421629954168) | 5 | 9 | 1 | 28858 | 32 | |||
| 185960 | 131576 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2707 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006523.78465 | 2120556.24434 | 37.8030114705657 | -122.421626874003 | (37.8030114705657, -122.421626874003) | 5 | 9 | 1 | 28858 | 32 | |||
| 127153 | 61192 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1040 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1983 12:00:00 AM | 2 | Permit Number 21053 | 6006848.76625 | 2120510.44822 | 37.8029040456348 | -122.420499013544 | (37.8029040456348, -122.420499013544) | 5 | 1 | 1 | 28858 | 32 | ||
| 106202 | 62400 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1080 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/1985 12:00:00 AM | 7 | Permit Number 22553 | 6006735.41999 | 2120495.57672 | 37.8028568240504 | -122.420890194342 | (37.8028568240504, -122.420890194342) | 5 | 1 | 1 | 28858 | 32 | ||
| 32897 | 131589 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1080 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006701.73964 | 2120491.72428 | 37.8028443477456 | -122.421006472176 | (37.8028443477456, -122.421006472176) | 5 | 1 | 1 | 28858 | 32 | |||
| 152674 | 62427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1090 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/1985 12:00:00 AM | 7 | Permit Number 22585 | 6006638.07712 | 2120482.29087 | 37.8028148571774 | -122.421226107292 | (37.8028148571774, -122.421226107292) | 5 | 1 | 1 | 28858 | 32 | ||
| 163374 | 68972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3444 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 10 | Permit Number 32962 | 5999781.0936 | 2120437.57627 | 37.8023031276514 | -122.444951481035 | (37.8023031276514, -122.444951481035) | 13 | 9 | 1 | 57 | 17 | |
| 96571 | 131611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008057.20535 | 2120430.85375 | 37.8027535261241 | -122.416311538052 | (37.8027535261241, -122.416311538052) | 5 | 1 | 10 | 308 | 32 | |||
| 154429 | 131610 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008060.07672 | 2120410.30647 | 37.8026972699217 | -122.416300145448 | (37.8026972699217, -122.416300145448) | 5 | 1 | 10 | 308 | 32 | |||
| 114686 | 131596 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2350 Hyde St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 6007094.87882 | 2120403.74203 | 37.80262492397 | -122.419639759879 | (37.80262492397, -122.419639759879) | 5 | 1 | 1 | 28858 | 32 |
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) );