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");