Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
81101 | 81101 | 103747 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008106.2 | 2108469.9 | 37.769914407380796 | -122.415294769944 | (37.7699144073808, -122.415294769944) | ||
81230 | 81230 | 103729 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2331 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008229.6 | 2104850.4 | 37.759983034143296 | -122.414611757947 | (37.7599830341433, -122.414611757947) | ||
86085 | 86085 | 103749 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1675 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008074.4 | 2108475.6 | 37.76992827096289 | -122.415405169405 | (37.7699282709629, -122.415405169405) | ||
86289 | 86289 | 103751 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1645 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008157.3 | 2108615.0 | 37.7703156897445 | -122.41512828788099 | (37.7703156897445, -122.415128287881) | ||
87880 | 87880 | 103725 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2899X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008379.2 | 2101559.4 | 37.7509550985774 | -122.41386156167499 | (37.7509550985774, -122.413861561675) | ||
90081 | 90081 | 103734 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2121 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 8 | 3x3 | 6008239.0 | 2106082.0 | 37.7633652523205 | -122.414666405954 | (37.7633652523205, -122.414666405954) | ||
93196 | 93196 | 103735 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2101 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 8 | 3x3 | 6008250.5 | 2106082.2 | 37.7633664475813 | -122.41462664522601 | (37.7633664475813, -122.414626645226) | ||
94006 | 94006 | 103728 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2335 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008231.0 | 2104824.3 | 37.75991144818521 | -122.41460506901501 | (37.7599114481852, -122.414605069015) | ||
95105 | 95105 | 103740 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
100388 | 100388 | 103748 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1675 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008074.4 | 2108475.6 | 37.76992827096289 | -122.415405169405 | (37.7699282709629, -122.415405169405) | ||
102314 | 102314 | 103731 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2225 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008315.8 | 2105284.4 | 37.761179541063704 | -122.414344341073 | (37.7611795410637, -122.414344341073) | ||
108220 | 108220 | 103754 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1601X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008223.7 | 2108752.2 | 37.7706961400308 | -122.41490832168002 | (37.7706961400308, -122.41490832168) | ||
111015 | 111015 | 103733 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2225 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008315.8 | 2105284.4 | 37.761179541063704 | -122.414344341073 | (37.7611795410637, -122.414344341073) | ||
112710 | 112710 | 103727 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2485 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008277.2 | 2103979.5 | 37.7575944160951 | -122.414385508985 | (37.7575944160951, -122.414385508985) | ||
113503 | 113503 | 103739 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
114773 | 114773 | 103736 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2101 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 8 | 3x3 | 6008250.5 | 2106082.2 | 37.7633664475813 | -122.41462664522601 | (37.7633664475813, -122.414626645226) | ||
116171 | 116171 | 103730 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2315 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008264.6 | 2104925.3 | 37.7601906586786 | -122.41449600953501 | (37.7601906586786, -122.414496009535) | ||
118874 | 118874 | 103742 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2021 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008130.3 | 2106612.8 | 37.7648165983937 | -122.415079938624 | (37.7648165983937, -122.415079938624) | ||
123237 | 123237 | 103726 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2843 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008392.8 | 2101883.1 | 37.7518446697515 | -122.41383742638399 | (37.7518446697515, -122.413837426384) | ||
127189 | 127189 | 103737 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 9 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) | ||
127384 | 127384 | 103750 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1665 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008126.9 | 2108535.0 | 37.770094320073596 | -122.41522777783301 | (37.7700943200736, -122.415227777833) | ||
142209 | 142209 | 103732 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2225 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008315.8 | 2105284.4 | 37.761179541063704 | -122.414344341073 | (37.7611795410637, -122.414344341073) | ||
144526 | 144526 | 103738 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2075 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008144.6 | 2106350.8 | 37.7640980107115 | -122.415011932629 | (37.7640980107115, -122.415011932629) |
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");