Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31159 | 31159 | 242866 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006095.439119999 | 2109158.70233 | 37.7716924795429 | -122.422298906788 | (37.7716924795429, -122.422298906788) | |||
33902 | 33902 | 201660 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009127.89234 | 2109540.91695 | 37.7729125385177 | -122.411836435997 | (37.7729125385177, -122.411836435997) | |||
35858 | 35858 | 246494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 365 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004182.0093 | 2099825.58993 | 37.745957849487795 | -122.428252301803 | (37.7459578494878, -122.428252301803) | |||
36650 | 36650 | 242863 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006168.47171 | 2109163.73568 | 37.7717104192431 | -122.422046639762 | (37.7717104192431, -122.422046639762) | |||
39506 | 39506 | 198280 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 951 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014735.9327300005 | 2097232.0415 | 37.739428022289204 | -122.39157667443001 | (37.7394280222892, -122.39157667443) | |||
50074 | 50074 | 198300 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011874.28273 | 2093380.6999 | 37.7286937889864 | -122.40120050131 | (37.7286937889864, -122.40120050131) | |||
50950 | 50950 | 246860 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6001322.98115 | 2109744.38173 | 37.773030249875795 | -122.43884907734301 | (37.7730302498758, -122.438849077343) | |||
54906 | 54906 | 249573 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006042.707780001 | 2113571.74375 | 37.7838066452086 | -122.422794986325 | (37.7838066452086, -122.422794986325) | |||
61287 | 61287 | 242864 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006148.77092 | 2109162.88394 | 37.771706969419796 | -122.422114725619 | (37.7717069694198, -122.422114725619) | |||
63163 | 63163 | 242865 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 98 McCoppin St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6006113.4001 | 2109160.84618 | 37.7716993791617 | -122.422236930889 | (37.7716993791617, -122.422236930889) | |||
64622 | 64622 | 198302 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6011892.6623 | 2093405.69149 | 37.7287634360827 | -122.40113871700301 | (37.7287634360827, -122.401138717003) | |||
71676 | 71676 | 198301 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2651 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011883.57095 | 2093392.9889900002 | 37.728728050461 | -122.401169254354 | (37.728728050461, -122.401169254354) | |||
74858 | 74858 | 198278 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 55 Elmira St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011181.32508 | 2096617.93728 | 37.7375438778404 | -122.403823812042 | (37.7375438778404, -122.403823812042) | |||
77046 | 77046 | 198277 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1850 23rd St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012861.27204 | 2102882.9116700003 | 37.754839870590104 | -122.39845487738899 | (37.7548398705901, -122.398454877389) | |||
118176 | 118176 | 247757 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 64 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001625.44981 | 2108428.3343599997 | 37.769433914972794 | -122.437708531026 | (37.7694339149728, -122.437708531026) | |||
121794 | 121794 | 242867 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1346 Stevenson St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6006264.314669999 | 2108835.25141 | 37.7708138850713 | -122.421691777169 | (37.7708138850713, -122.421691777169) | |||
129509 | 129509 | 198279 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 951 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014707.30065 | 2097191.0938 | 37.7393139990344 | -122.391672810175 | (37.7393139990344, -122.391672810175) | |||
138221 | 138221 | 247570 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 398 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008218.8093 | 2095126.8275400002 | 37.7332836661113 | -122.41396121114401 | (37.7332836661113, -122.413961211144) | |||
147492 | 147492 | 198303 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1745 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011202.29515 | 2095200.2516700001 | 37.7336523845568 | -122.403651588276 | (37.7336523845568, -122.403651588276) | |||
152310 | 152310 | 242870 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 498 Oak St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004648.6662099995 | 2110205.3941200003 | 37.7744847252106 | -122.42737796202 | (37.7744847252106, -122.42737796202) | |||
160244 | 160244 | 201659 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009071.000519999 | 2109601.78003 | 37.7730764624533 | -122.41203753431299 | (37.7730764624533, -122.412037534313) | |||
165104 | 165104 | 242868 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 388 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005479.97294 | 2106783.54072 | 37.7651361178728 | -122.42425889015301 | (37.7651361178728, -122.424258890153) | |||
170628 | 170628 | 242871 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009441.4286 | 2106739.88678 | 37.765239142394 | -122.410554039658 | (37.765239142394, -122.410554039658) | |||
172207 | 172207 | 202299 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 136 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6012821.534580001 | 2093069.43077 | 37.7278919084741 | -122.397903945525 | (37.7278919084741, -122.397903945525) | |||
174349 | 174349 | 247046 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 555 Valley St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6002319.09845 | 2099130.9656 | 37.7439449895856 | -122.434644325878 | (37.7439449895856, -122.434644325878) | |||
175810 | 175810 | 246512 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Laguna St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005254.0996199995 | 2109149.02764 | 37.7716184212706 | -122.425208466318 | (37.7716184212706, -122.425208466318) | |||
176200 | 176200 | 242869 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 348 Church St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004153.4659400005 | 2106885.51591 | 37.7653411264215 | -122.428854226135 | (37.7653411264215, -122.428854226135) | |||
176463 | 176463 | 201658 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Dore St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6009046.738390001 | 2109625.79413 | 37.773141038252604 | -122.412123157881 | (37.7731410382526, -122.412123157881) | |||
179692 | 179692 | 246859 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1198 Oak St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001348.19607 | 2109746.2469900004 | 37.7730368059387 | -122.43876198966998 | (37.7730368059387, -122.43876198967) |
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");