Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3401 | 3401 | 29754 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6009953.7417 | 2119408.8277 | 37.800053757708994 | -122.40967634888099 | (37.800053757709, -122.409676348881) | |||
5413 | 5413 | 14844 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 1327 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1987 12:00:00 AM | 6 | 3x3 | 6002796.5861 | 2111629.8173 | 37.7782909152526 | -122.43388649174999 | (37.7782909152526, -122.43388649175) | ||
5782 | 5782 | 29753 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6009968.1915 | 2119398.824 | 37.8000270997238 | -122.409625640361 | (37.8000270997238, -122.409625640361) | |||
7889 | 7889 | 29752 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6009988.1989 | 2119378.2609 | 37.7999717596155 | -122.40955495470502 | (37.7999717596155, -122.409554954705) | |||
13518 | 13518 | 106002 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015261.96303 | 2104498.62679 | 37.759409725189705 | -122.39026542781299 | (37.7594097251897, -122.390265427813) | |||
15015 | 15015 | 106001 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6015262.44728 | 2104479.57944 | 37.75935745211439 | -122.390262422266 | (37.7593574521144, -122.390262422266) | |||
16571 | 16571 | 97169 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 290 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6009519.6482 | 2110372.42586 | 37.7752176376301 | -122.410540028225 | (37.7752176376301, -122.410540028225) | |||
85211 | 85211 | 108652 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
89013 | 89013 | 108651 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
89939 | 89939 | 108657 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
91345 | 91345 | 108649 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
91941 | 91941 | 52992 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1800 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48973 | 6013995.42685531 | 2096291.44248921 | 37.7368042013217 | -122.394071207374 | (37.7368042013217, -122.394071207374) | |||
105044 | 105044 | 108650 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
114000 | 114000 | 108654 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
116186 | 116186 | 108655 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
118847 | 118847 | 108695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 511 Alvarado St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | |
120360 | 120360 | 108653 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
124448 | 124448 | 108656 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
127002 | 127002 | 29755 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6010020.30224 | 2119411.75263 | 37.800065518477 | -122.409446229453 | (37.800065518477, -122.409446229453) | |||
128611 | 128611 | 103111 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 300 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010691.0 | 2115198.3 | 37.7885339521538 | -122.40682822806002 | (37.7885339521538, -122.40682822806) | ||||
133858 | 133858 | 38495 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.2473299997 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) |
139630 | 139630 | 108490 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1198 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773696 | 6009647.20295 | 2110306.76017 | 37.7750444852375 | -122.410094148747 | (37.7750444852375, -122.410094148747) |
144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
166496 | 166496 | 51593 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.773689232881395 | -122.44856674553301 | (37.7736892328814, -122.448566745533) |
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");