Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantType, PlantDate, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
79489 | 79489 | 103710 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
80726 | 80726 | 112691 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
82217 | 82217 | 93894 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
85497 | 85497 | 103713 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | |||
88742 | 88742 | 93897 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
90332 | 90332 | 100684 | Undocumented 2 | Tree(s) :: 17 | 400 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6012367.0 | 2116823.0 | 37.7930886299645 | -122.40114369902099 | (37.7930886299645, -122.401143699021) | |||||
93837 | 93837 | 112695 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
94511 | 94511 | 112694 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
98016 | 98016 | 93915 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
98599 | 98599 | 93896 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
99763 | 99763 | 112693 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
99800 | 99800 | 93888 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
99815 | 99815 | 93895 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
106682 | 106682 | 96543 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
107198 | 107198 | 93898 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
107881 | 107881 | 93889 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
109802 | 109802 | 93893 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
112434 | 112434 | 98536 | Permitted Site 1 | Tree(s) :: 17 | 637A Capp St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | 3x3 | Permit Number 768694 | 6007346.4 | 2103619.4 | 37.756553332027 | -122.41757907963002 | (37.756553332027, -122.41757907963) | ||
113559 | 113559 | 112692 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
114639 | 114639 | 103722 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
121768 | 121768 | 93914 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
122175 | 122175 | 93892 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
126060 | 126060 | 103712 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
127599 | 127599 | 93891 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
138268 | 138268 | 93890 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
140350 | 140350 | 103723 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
141907 | 141907 | 103711 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
142312 | 142312 | 103724 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
143626 | 143626 | 96540 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
161000 | 161000 | 244932 | Undocumented 2 | Tree(s) :: 17 | 276 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005259.2596 | 2109945.2207 | 37.7738048663185 | -122.425247283021 | (37.7738048663185, -122.425247283021) |
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");