Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77299 | 77299 | 40914 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
80140 | 80140 | 40926 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
81144 | 81144 | 40906 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
81327 | 81327 | 40901 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
86268 | 86268 | 40900 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
89001 | 89001 | 40898 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
90458 | 90458 | 40931 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
91510 | 91510 | 40928 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
92034 | 92034 | 40909 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
94416 | 94416 | 40930 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
96397 | 96397 | 40897 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
97935 | 97935 | 40907 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
98948 | 98948 | 40902 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
100666 | 100666 | 40923 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
101537 | 101537 | 40911 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
102138 | 102138 | 40925 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
102891 | 102891 | 40920 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
105681 | 105681 | 40912 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
105741 | 105741 | 40908 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
109898 | 109898 | 40905 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
111717 | 111717 | 40904 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
112705 | 112705 | 40903 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
112884 | 112884 | 40924 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
114703 | 114703 | 40922 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
116059 | 116059 | 40899 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
119170 | 119170 | 40910 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
121944 | 121944 | 40916 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
122464 | 122464 | 40917 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
124391 | 124391 | 40913 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
126624 | 126624 | 40918 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
126945 | 126945 | 40927 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
138296 | 138296 | 40919 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
140613 | 140613 | 40929 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
143179 | 143179 | 40921 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) | |||
143451 | 143451 | 40915 | Permitted Site 1 | Tree(s) :: 17 | 720 Howard St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.784687974361894 | -122.401028836502 | (37.7846879743619, -122.401028836502) |
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");