Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10000 | 10000 | 173780 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 99X Cleveland St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x6 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 31792 | 31792 | 247877 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 388 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009910.50595 | 2098381.82666 | 37.7423160592417 | -122.408342032063 | (37.7423160592417, -122.408342032063) | ||||
| 35045 | 35045 | 247843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009097.48489 | 2098216.36998 | 37.7418161899782 | -122.411141537049 | (37.7418161899782, -122.411141537049) | ||||
| 47461 | 47461 | 247844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009115.842759999 | 2098211.0441099997 | 37.7418025958075 | -122.41107768521002 | (37.7418025958075, -122.41107768521) | ||||
| 49010 | 49010 | 227460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | |||
| 53472 | 53472 | 207987 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999466.174219999 | 2095456.6543299998 | 37.7336938298041 | -122.444245066271 | (37.7336938298041, -122.444245066271) | ||||
| 54173 | 54173 | 248064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010656.53215 | 2099389.02438 | 37.7451233541731 | -122.40583342000099 | (37.7451233541731, -122.405833420001) | ||||
| 56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
| 68436 | 68436 | 227459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 6000082.87905 | 2105698.79506 | 37.761851449312 | -122.442848168232 | (37.761851449312, -122.442848168232) | |||
| 75256 | 75256 | 227503 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 31 Poppy Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6002189.282000001 | 2096805.2578 | 37.7375517667019 | -122.43492690907499 | (37.7375517667019, -122.434926909075) | |||
| 147117 | 147117 | 129641 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 943 Green St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.41406679246201 | (37.7987948111981, -122.414066792462) | ||||
| 147949 | 147949 | 247848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 149 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6009193.51112 | 2098205.9216299998 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | ||||
| 151939 | 151939 | 247878 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 388 Mayflower St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009913.73125 | 2098387.19098 | 37.7423309691095 | -122.408331258187 | (37.7423309691095, -122.408331258187) | ||||
| 166825 | 166825 | 248057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 17 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010678.5248 | 2099352.93022 | 37.7450254773569 | -122.405754830944 | (37.7450254773569, -122.405754830944) |
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");