Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31616 | 31616 | 191508 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 55 Sherman St | 25 | : 4 | Tree 1 | Private 1 | 3 | Width 10ft | 6010631.502780001 | 2111081.40715 | 37.777226606154706 | -122.406743828871 | (37.7772266061547, -122.406743828871) | |||
180465 | 180465 | 191444 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 2ft | 6013146.00458 | 2106079.844 | 37.763633804867 | -122.397694407074 | (37.763633804867, -122.397694407074) | |||
36586 | 36586 | 207860 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 88 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992206.435269999 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | |||
45797 | 45797 | 207862 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 50 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5992461.4298 | 2088225.8604700002 | 37.7134377203567 | -122.467936556254 | (37.7134377203567, -122.467936556254) | |||
46570 | 46570 | 226667 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6004704.0947199995 | 2109267.38309 | 37.7719123098365 | -122.42711939795 | (37.7719123098365, -122.42711939795) | |||
62524 | 62524 | 207864 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2545 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5991142.22279 | 2094819.8771799998 | 37.731466988790395 | -122.47297671042801 | (37.7314669887904, -122.472976710428) | |||
63748 | 63748 | 207859 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 88 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992207.50569 | 2088392.37957 | 37.713880274943 | -122.468826309486 | (37.713880274943, -122.468826309486) | |||
64260 | 64260 | 226666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004707.88321 | 2109244.5049400004 | 37.771849706222504 | -122.42710466345899 | (37.7718497062225, -122.427104663459) | |||
67169 | 67169 | 207858 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 143 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993571.00568 | 2090460.55199 | 37.7196376600192 | -122.46426364137699 | (37.7196376600192, -122.464263641377) | |||
69576 | 69576 | 226665 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004711.01966 | 2109215.80754 | 37.7717710874854 | -122.42709176988701 | (37.7717710874854, -122.427091769887) | |||
70640 | 70640 | 191448 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1375 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016804.06254 | 2097268.13995 | 37.7396417192015 | -122.384428434726 | (37.7396417192015, -122.384428434726) | |||
147022 | 147022 | 207861 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.46882426804702 | (37.7137470322778, -122.468824268047) | |||
153647 | 153647 | 191443 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 19th St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6013161.12259 | 2105230.3834700002 | 37.7613022153415 | -122.397582536801 | (37.7613022153415, -122.397582536801) | |||
165759 | 165759 | 226664 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6004714.2759300005 | 2109192.94036 | 37.771708483891395 | -122.42707887721201 | (37.7717084838914, -122.427078877212) | |||
167236 | 167236 | 191450 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Fairfax Ave | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017131.85969 | 2097105.51243 | 37.73921329744729 | -122.383283724566 | (37.7392132974473, -122.383283724566) | |||
170780 | 170780 | 249329 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 814 Post St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008232.68347 | 2114867.71891 | 37.7874883986038 | -122.415310240102 | (37.7874883986038, -122.415310240102) | |||
182691 | 182691 | 246495 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 359 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004220.129819999 | 2099827.66275 | 37.7459656978564 | -122.428120633885 | (37.7459656978564, -122.428120633885) | |||
183784 | 183784 | 226662 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Buchanan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004759.3932300005 | 2108882.7963099997 | 37.7708594546408 | -122.42690072149901 | (37.7708594546408, -122.426900721499) | |||
132468 | 132468 | 191449 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1224 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | |||
163117 | 163117 | 191445 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 19th St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013335.759880001 | 2105192.0474900003 | 37.761206675862205 | -122.396975847857 | (37.7612066758622, -122.396975847857) | |||
187511 | 187511 | 226663 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 109 Buchanan St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004754.99125 | 2108900.4446099997 | 37.77090766370029 | -122.426917205171 | (37.7709076637003, -122.426917205171) | |||
177365 | 177365 | 191447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1300 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) |
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");