Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80433 | 80433 | 104262 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 87816 | 87816 | 104263 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 97396 | 97396 | 104266 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 99537 | 99537 | 104265 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 142864 | 142864 | 104264 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 199X Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008482.28692 | 2122448.56477 | 37.8083175458446 | -122.41498343065001 | (37.8083175458446, -122.41498343065) | |||||
| 149769 | 149769 | 41638 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008374.705019999 | 2122409.49865 | 37.808204234292 | -122.415352980375 | (37.808204234292, -122.415352980375) | |
| 49889 | 49889 | 41643 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008364.2633 | 2122408.61155 | 37.8082012116738 | -122.41538905396001 | (37.8082012116738, -122.41538905396) | |
| 73984 | 73984 | 41642 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 10 | 2x2 | Permit Number 42116 | 6008347.815880001 | 2122407.53263 | 37.80819732479971 | -122.415445898318 | (37.8081973247997, -122.415445898318) | |
| 53999 | 53999 | 41641 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008318.31427 | 2122401.37399 | 37.8081787565193 | -122.415547560374 | (37.8081787565193, -122.415547560374) | |
| 52303 | 52303 | 41640 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008303.89341 | 2122398.99555 | 37.808171415331294 | -122.415597299176 | (37.8081714153313, -122.415597299176) | |
| 43638 | 43638 | 41639 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 175 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2000 12:00:00 AM | 11 | 2x2 | Permit Number 42116 | 6008290.6132 | 2122398.32381 | 37.8081688244054 | -122.41564321135799 | (37.8081688244054, -122.415643211358) | |
| 159791 | 159791 | 131624 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008272.4589599995 | 2122375.57657 | 37.8081053457565 | -122.41570442733601 | (37.8081053457565, -122.415704427336) | |||
| 40275 | 40275 | 131623 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008274.82732 | 2122360.1153700002 | 37.808063026360294 | -122.41569513553101 | (37.8080630263603, -122.415695135531) | |||
| 40133 | 40133 | 131622 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008277.02166 | 2122343.87132 | 37.8080185476734 | -122.41568639051201 | (37.8080185476734, -122.415686390512) | |||
| 68484 | 68484 | 131621 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008283.03118 | 2122305.68799 | 37.807914043752 | -122.415662887656 | (37.807914043752, -122.415662887656) | |||
| 177375 | 177375 | 131620 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008285.97952 | 2122287.6984900003 | 37.807864814882706 | -122.41565140959699 | (37.8078648148827, -122.415651409597) | |||
| 168949 | 168949 | 131619 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008287.70356 | 2122271.62162 | 37.8078207687883 | -122.415644304065 | (37.8078207687883, -122.415644304065) | |||
| 126487 | 126487 | 21825 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2742 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008296.21715 | 2122224.91462 | 37.8076930017751 | -122.415611531478 | (37.8076930017751, -122.415611531478) | |||
| 81263 | 81263 | 21827 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2750X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 88253 | 88253 | 21828 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2750X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 101004 | 101004 | 21829 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2750X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 111315 | 111315 | 21822 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2734 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 111367 | 111367 | 21821 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2734 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008379.49679 | 2122189.06434 | 37.807599246877295 | -122.41532078193 | (37.8075992468773, -122.41532078193) | |||
| 45918 | 45918 | 131615 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009239.74598 | 2121887.2571900003 | 37.8068188709455 | -122.412322330711 | (37.8068188709455, -122.412322330711) | |||
| 43755 | 43755 | 131616 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008985.35955 | 2121850.7204400003 | 37.8067042721502 | -122.41320010322501 | (37.8067042721502, -122.413200103225) | |||
| 183489 | 183489 | 131617 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 North Point St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008895.38434 | 2121838.6479700003 | 37.806666072537496 | -122.413510626514 | (37.8066660725375, -122.413510626514) | |||
| 157869 | 157869 | 131618 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 North Point St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008855.31993 | 2121832.80496 | 37.8066477794276 | -122.413648864003 | (37.8066477794276, -122.413648864003) | |||
| 86887 | 86887 | 50322 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2500 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47025 | 6008839.14923896 | 2121813.47982316 | 37.806593809415496 | -122.413703458172 | (37.8065938094155, -122.413703458172) | |||
| 87353 | 87353 | 50323 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2500 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47025 | 6008839.14923896 | 2121813.47982316 | 37.806593809415496 | -122.413703458172 | (37.8065938094155, -122.413703458172) | |||
| 53439 | 53439 | 131571 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2753 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6006844.83313 | 2121827.1886299998 | 37.8065192573265 | -122.420606150667 | (37.8065192573265, -122.420606150667) | |||
| 48700 | 48700 | 87879 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 255 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50851 | 6002250.922619999 | 2121888.76212 | 37.806428348449295 | -122.436508609691 | (37.8064283484493, -122.436508609691) | |
| 148391 | 148391 | 65830 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 265 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1990 12:00:00 AM | 9 | Permit Number 28820 | 6002215.96155 | 2121885.3165 | 37.806416900995 | -122.436629351784 | (37.806416900995, -122.436629351784) | ||
| 63431 | 63431 | 131333 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 265 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6002225.92805 | 2121872.37078 | 37.806381921855 | -122.43659393376001 | (37.806381921855, -122.43659393376) | |||
| 139022 | 139022 | 11182 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2765 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006851.5978528 | 2121751.8788051005 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | |||
| 175032 | 175032 | 143160 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6010079.5079 | 2121559.6876 | 37.8059665335797 | -122.40939302307699 | (37.8059665335797, -122.409393023077) | |||
| 188581 | 188581 | 143159 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010083.8953 | 2121533.9898 | 37.805896219637496 | -122.40937602503 | (37.8058962196375, -122.40937602503) | |||
| 169676 | 169676 | 143158 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010085.1488 | 2121513.3062 | 37.8058394978516 | -122.409370226483 | (37.8058394978516, -122.409370226483) | |||
| 187798 | 187798 | 143157 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010090.163 | 2121485.1014 | 37.8057623354244 | -122.40935088231001 | (37.8057623354244, -122.40935088231) | |||
| 40598 | 40598 | 143231 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 33 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010061.227999999 | 2121465.1493 | 37.805705930727896 | -122.40944960763001 | (37.8057059307279, -122.40944960763) | |||
| 173759 | 173759 | 143156 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010093.9237 | 2121443.7342 | 37.805648962087496 | -122.409334946656 | (37.8056489620875, -122.409334946656) | |||
| 39385 | 39385 | 143232 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 33 MIDWAY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010065.2011 | 2121437.9047 | 37.8056313464495 | -122.40943393410801 | (37.8056313464495, -122.409433934108) | |||
| 29893 | 29893 | 143233 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 33 MIDWAY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010066.9039 | 2121425.9852 | 37.8055987138758 | -122.409427199568 | (37.8055987138758, -122.409427199568) | |||
| 133726 | 133726 | 143155 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 30 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6010097.0576 | 2121424.931 | 37.80559750876021 | -122.409322773525 | (37.8055975087602, -122.409322773525) | |||
| 186531 | 186531 | 143234 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 33 MIDWAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010069.7419 | 2121414.0657 | 37.8055661449061 | -122.409416536498 | (37.8055661449061, -122.409416536498) | |||
| 150192 | 150192 | 143192 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 23 MIDWAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010074.2827 | 2121384.5507 | 37.8054853584752 | -122.40939873809799 | (37.8054853584752, -122.409398738098) | |||
| 79727 | 79727 | 99261 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3099X Polk St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x6 | 6005936.6 | 2121383.7 | 37.805250324017294 | -122.42371770971 | (37.8052503240173, -122.42371770971) | ||
| 176969 | 176969 | 131330 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 731 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999450.18317 | 2121499.9333900004 | 37.805201182148 | -122.44617304995501 | (37.805201182148, -122.446173049955) | |||
| 64762 | 64762 | 131328 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3731 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6002004.9818 | 2121357.00447 | 37.804954304762504 | -122.43732163011101 | (37.8049543047625, -122.437321630111) | |||
| 185228 | 185228 | 131329 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002107.96677 | 2121266.57415 | 37.804711861029 | -122.436958761733 | (37.804711861029, -122.436958761733) | |||
| 149934 | 149934 | 131341 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1690 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002211.374419999 | 2121244.58816 | 37.8046573702031 | -122.436599335103 | (37.8046573702031, -122.436599335103) | |||
| 186383 | 186383 | 131342 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1690 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002186.399119999 | 2121242.02691 | 37.8046489183885 | -122.436685580975 | (37.8046489183885, -122.436685580975) | |||
| 23794 | 23794 | 131343 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1690 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002163.7255 | 2121238.6483299998 | 37.804638353147794 | -122.436763803111 | (37.8046383531478, -122.436763803111) | |||
| 152135 | 152135 | 98778 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700X Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003103.75462 | 2121176.6260900004 | 37.8045214349813 | -122.433506309391 | (37.8045214349813, -122.433506309391) | |||
| 178892 | 178892 | 131326 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3615 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999135.58402 | 2121250.5666099996 | 37.80449851754221 | -122.44724379626999 | (37.8044985175422, -122.44724379627) | |||
| 161350 | 161350 | 98777 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003095.78209 | 2121157.07886 | 37.8044673110903 | -122.433532501243 | (37.8044673110903, -122.433532501243) | |||
| 158519 | 158519 | 48834 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3700X Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 3 | 3x3 | 6003107.679930001 | 2121141.1795099997 | 37.804424330691795 | -122.43349019083999 | (37.8044243306918, -122.43349019084) | ||
| 42096 | 42096 | 41211 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3672 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41920 | 6002143.7473 | 2121032.61773 | 37.8040715122401 | -122.436818181531 | (37.8040715122401, -122.436818181531) | |
| 85790 | 85790 | 131272 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1921 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001028.78921 | 2120972.3722900003 | 37.8038426644651 | -122.44067223875601 | (37.8038426644651, -122.440672238756) | |||
| 61455 | 61455 | 131271 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1921 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6000975.37213 | 2120964.4094700003 | 37.8038177586317 | -122.440856519715 | (37.8038177586317, -122.440856519715) | |||
| 5962 | 5962 | 82000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50638 | 6005983.68719 | 2120729.63993 | 37.803457100839296 | -122.423508229633 | (37.8034571008393, -122.423508229633) |
| 1794 | 1794 | 81999 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005960.45556 | 2120727.0973099996 | 37.803448808170295 | -122.423588442877 | (37.8034488081703, -122.423588442877) |
| 7474 | 7474 | 81997 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005918.11487 | 2120722.35908 | 37.8034334081868 | -122.42373462766001 | (37.8034334081868, -122.42373462766) |
| 5699 | 5699 | 97727 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.3141099997 | 37.8034239311172 | -122.42380284664699 | (37.8034239311172, -122.423802846647) | |
| 8576 | 8576 | 97728 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | |
| 178310 | 178310 | 68966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2221 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 12 | Permit Number 32956 | 5999588.98891 | 2120837.10382 | 37.803389157054 | -122.445645002217 | (37.803389157054, -122.445645002217) | |
| 5294 | 5294 | 97730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | |
| 162513 | 162513 | 131612 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 747 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008181.61728 | 2120648.76076 | 37.803358839099495 | -122.41589644788701 | (37.8033588390995, -122.415896447887) | |||
| 70480 | 70480 | 131334 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3611 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003107.87441 | 2120753.09698 | 37.8033587689415 | -122.433461767746 | (37.8033587689415, -122.433461767746) | |||
| 7339 | 7339 | 97732 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | |
| 100571 | 100571 | 68967 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2235 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | Permit Number 32957 | 5999532.32981843 | 2120823.23983163 | 37.8033478553202 | -122.44584007478201 | (37.8033478553202, -122.445840074782) | ||
| 8363 | 8363 | 97734 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005715.837730001 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | |
| 98552 | 98552 | 60875 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 779 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1983 12:00:00 AM | Permit Number 20658 | 6008112.43934478 | 2120636.19828285 | 37.803320456308 | -122.416134951163 | (37.803320456308, -122.416134951163) | ||
| 106932 | 106932 | 60876 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 781 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1983 12:00:00 AM | Permit Number 20659 | 6008103.35729481 | 2120635.02630904 | 37.8033167277069 | -122.416166296957 | (37.8033167277069, -122.416166296957) | ||
| 39511 | 39511 | 131270 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2255 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999402.93097 | 2120810.14921 | 37.8033045227389 | -122.44628692029801 | (37.8033045227389, -122.446286920298) | |||
| 168759 | 168759 | 131335 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3609 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003110.15445 | 2120730.31313 | 37.803296339819 | -122.433452248448 | (37.803296339819, -122.433452248448) | |||
| 58244 | 58244 | 131336 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3605 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003111.95247 | 2120710.82669 | 37.8032429371717 | -122.433444632988 | (37.8032429371717, -122.433444632988) | |||
| 160925 | 160925 | 106658 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 256 Mallorca Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6001495.79596 | 2120724.12156 | 37.8031876171793 | -122.43903833515199 | (37.8031876171793, -122.439038335152) | ||||
| 59102 | 59102 | 59835 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 256 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1981 12:00:00 AM | 16 | Permit Number 19289 | 6001507.02699 | 2120711.1936 | 37.8031527594543 | -122.438998542875 | (37.8031527594543, -122.438998542875) | ||
| 41535 | 41535 | 131337 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003093.377730001 | 2120677.24262 | 37.803149670274294 | -122.433506509938 | (37.8031496702743, -122.433506509938) | |||
| 57001 | 57001 | 131338 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003074.10722 | 2120676.54489 | 37.803146661137 | -122.433573146108 | (37.803146661137, -122.433573146108) | |||
| 58406 | 58406 | 131339 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003059.47166 | 2120673.83402 | 37.8031383873936 | -122.433623598957 | (37.8031383873936, -122.433623598957) | |||
| 44412 | 44412 | 131340 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1600 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003038.77527 | 2120670.70076 | 37.8031286099566 | -122.43369499523199 | (37.8031286099566, -122.433694995232) | |||
| 47488 | 47488 | 131572 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2709 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006519.11799 | 2120598.54837 | 37.803127363507706 | -122.42164602953899 | (37.8031273635077, -122.421646029539) | |||
| 44013 | 44013 | 131573 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2709 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006518.42693 | 2120591.51077 | 37.8031080010843 | -122.42164792083 | (37.8031080010843, -122.42164792083) | |||
| 54213 | 54213 | 131574 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2709 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006521.2226599995 | 2120583.1811900004 | 37.8030852878264 | -122.42163765416001 | (37.8030852878264, -122.42163765416) | |||
| 186180 | 186180 | 68248 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3520 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 9 | Permit Number 32049 | 6001233.22938 | 2120683.51189 | 37.803061170692 | -122.439944038802 | (37.803061170692, -122.439944038802) | |
| 26270 | 26270 | 131575 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2707 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006523.23759 | 2120572.9476400004 | 37.8030573027236 | -122.421629954168 | (37.8030573027236, -122.421629954168) | |||
| 148280 | 148280 | 69352 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1304 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33443 | 6005047.139909999 | 2120598.91994 | 37.8030452715839 | -122.42673987774201 | (37.8030452715839, -122.426739877742) | |
| 174748 | 174748 | 131331 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1304 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005026.90435 | 2120597.50734 | 37.8030402488573 | -122.426809802731 | (37.8030402488573, -122.426809802731) | |||
| 133396 | 133396 | 131332 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1308 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004965.17921 | 2120588.41267 | 37.803011787127296 | -122.427022755916 | (37.8030117871273, -122.427022755916) | |||
| 151111 | 151111 | 131576 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2707 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006523.78465 | 2120556.24434 | 37.80301147056571 | -122.421626874003 | (37.8030114705657, -122.421626874003) | |||
| 80209 | 80209 | 112911 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3514 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6001236.25311 | 2120660.54801 | 37.80299829010921 | -122.439931927628 | (37.8029982901092, -122.439931927628) | ||||
| 168724 | 168724 | 68247 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3514 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 12 | Permit Number 32048 | 6001238.44206 | 2120645.56673 | 37.802957280102504 | -122.43992327793501 | (37.8029572801025, -122.439923277935) | |
| 150638 | 150638 | 61192 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1983 12:00:00 AM | 2 | Permit Number 21053 | 6006848.76625 | 2120510.44822 | 37.8029040456348 | -122.420499013544 | (37.8029040456348, -122.420499013544) | ||
| 186588 | 186588 | 62400 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1080 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/1985 12:00:00 AM | 7 | Permit Number 22553 | 6006735.41999 | 2120495.5767200002 | 37.802856824050394 | -122.42089019434201 | (37.8028568240504, -122.420890194342) | ||
| 103013 | 103013 | 131589 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1080 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006701.73964 | 2120491.7242799997 | 37.8028443477456 | -122.421006472176 | (37.8028443477456, -122.421006472176) | |||
| 171431 | 171431 | 62427 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1090 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1985 12:00:00 AM | 7 | Permit Number 22585 | 6006638.07712 | 2120482.29087 | 37.8028148571774 | -122.421226107292 | (37.8028148571774, -122.421226107292) | ||
| 69152 | 69152 | 131611 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2318 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6008057.20535 | 2120430.85375 | 37.8027535261241 | -122.416311538052 | (37.8027535261241, -122.416311538052) | |||
| 36407 | 36407 | 131610 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2318 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008060.076719999 | 2120410.30647 | 37.8026972699217 | -122.41630014544799 | (37.8026972699217, -122.416300145448) | |||
| 30619 | 30619 | 131609 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2318 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008062.79243 | 2120392.2211700003 | 37.802647764942705 | -122.416289466003 | (37.8026477649427, -122.416289466003) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");