Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32359 | 32359 | 191816 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300x De Haro St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012277.20441 | 2102232.55885 | 37.7530215888816 | -122.40042907904899 | (37.7530215888816, -122.400429079049) | ||||
33183 | 33183 | 209132 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | Width 10ft | 6001073.50305 | 2095703.1639599998 | 37.7344622582302 | -122.438705728106 | (37.7344622582302, -122.438705728106) | |||
35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) | ||||
37159 | 37159 | 249463 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6006539.42856 | 2113694.50869 | 37.7841717411666 | -122.421085234814 | (37.7841717411666, -122.421085234814) | ||||
41196 | 41196 | 209133 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6001054.84945 | 2095714.1457200001 | 37.734491350384005 | -122.43877100628 | (37.734491350384, -122.43877100628) | ||||
44401 | 44401 | 126600 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1820x Van Ness Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6006102.71241 | 2116870.57968 | 37.7928678157445 | -122.42282191472201 | (37.7928678157445, -122.422821914722) | ||||
50215 | 50215 | 209138 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000918.34106 | 2095790.55513 | 37.7346933857729 | -122.439248434772 | (37.7346933857729, -122.439248434772) | ||||
50311 | 50311 | 209137 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000977.0463 | 2095762.1119400002 | 37.734618627848796 | -122.43904343343 | (37.7346186278488, -122.43904343343) | ||||
58168 | 58168 | 209136 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6000997.1554 | 2095746.93377 | 37.7345780962937 | -122.438972822257 | (37.7345780962937, -122.438972822257) | ||||
59293 | 59293 | 209131 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 10ft | 6001087.056530001 | 2095697.8346 | 37.734448396084396 | -122.43865848761699 | (37.7344483960844, -122.438658487617) | |||
73439 | 73439 | 249465 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6006528.896380001 | 2113762.4002 | 37.78435756088879 | -122.421126494805 | (37.7843575608888, -122.421126494805) | ||||
106027 | 106027 | 111425 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200x SAN MARCOS AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 16 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
111907 | 111907 | 111427 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200x SAN MARCOS AVE | 12 | Median : Yard 3 | Tree 1 | Private 1 | 20 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
148876 | 148876 | 209172 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600x Faxon Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5994902.7257 | 2092594.45065 | 37.725573503888 | -122.45981488494199 | (37.725573503888, -122.459814884942) | ||||
165633 | 165633 | 223977 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2x Gough St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6006660.75895 | 2109243.9943 | 37.7719585430967 | -122.42034948146002 | (37.7719585430967, -122.42034948146) | ||||
167812 | 167812 | 126605 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2900x Van Ness Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6005587.24482 | 2120569.72976 | 37.8029956442888 | -122.424868752794 | (37.8029956442888, -122.424868752794) | |||
167933 | 167933 | 209105 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600x Faxon Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5994942.183230001 | 2092612.57817 | 37.7256255467665 | -122.459679796903 | (37.7256255467665, -122.459679796903) | ||||
176176 | 176176 | 209134 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6001014.7051099995 | 2095735.41705 | 37.7345474725699 | -122.438911322111 | (37.7345474725699, -122.438911322111) | ||||
181686 | 181686 | 246870 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 3090x Market St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5999943.44665 | 2105326.58667 | 37.7608215070397 | -122.443303673043 | (37.7608215070397, -122.443303673043) | ||||
187536 | 187536 | 209135 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6001010.142969999 | 2095737.8079 | 37.7345537777227 | -122.438927266197 | (37.7345537777227, -122.438927266197) |
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");