Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29482 | 29482 | 128425 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 California St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6011770.64614 | 2116698.01908 | 37.7927121754866 | -122.403198334431 | (37.7927121754866, -122.403198334431) | |||
41170 | 41170 | 126717 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2350 Green St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6001632.11762 | 2118051.74254 | 37.7958577234076 | -122.438375018588 | (37.7958577234076, -122.438375018588) | |||
54585 | 54585 | 192117 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 367 Tehama St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011557.32481 | 2112660.98946 | 37.781615529763705 | -122.403652263664 | (37.7816155297637, -122.403652263664) | |||
56712 | 56712 | 190216 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 121 Main St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013858.93345 | 2116683.31017 | 37.792788191571 | -122.395971690938 | (37.792788191571, -122.395971690938) | |||
60628 | 60628 | 112709 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 North Point St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6009982.61169 | 2121986.87678 | 37.8071340590486 | -122.409758521838 | (37.8071340590486, -122.409758521838) | |||
62530 | 62530 | 189709 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 500 Wisconsin St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 6012645.7874300005 | 2105024.7394 | 37.760708853455704 | -122.399350438495 | (37.7607088534557, -122.399350438495) | |||
64432 | 64432 | 189622 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1022 Harrison St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 0ft | 6010815.005059999 | 2110468.41734 | 37.7755537439388 | -122.406065837194 | (37.7755537439388, -122.406065837194) | |||
64470 | 64470 | 128677 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 250 Washington St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6013274.45075 | 2117959.00066 | 37.7962584010691 | -122.39808357702 | (37.7962584010691, -122.39808357702) | |||
71225 | 71225 | 192131 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 807 Mission St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6011287.52807 | 2113553.9917200003 | 37.784052429914496 | -122.404648520918 | (37.7840524299145, -122.404648520918) | |||
73532 | 73532 | 224419 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Treat Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6008550.92068 | 2106134.213 | 37.7635261371397 | -122.41359126333 | (37.7635261371397, -122.41359126333) | |||
74429 | 74429 | 117416 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010137.827269999 | 2122299.49705 | 37.8080011332052 | -122.409243437841 | (37.8080011332052, -122.409243437841) | |||
86980 | 86980 | 454 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 740X 23rd Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988822.540159999 | 2110230.27386 | 37.7736452554339 | -122.482124750469 | (37.7736452554339, -122.482124750469) | |||
91225 | 91225 | 102347 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401X Shotwell St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007842.0 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | |||
135473 | 135473 | 128139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2600 Jones St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007843.1671400005 | 2121954.12395 | 37.8069240026131 | -122.417160222869 | (37.8069240026131, -122.417160222869) | |||
137461 | 137461 | 128179 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 211 Beach St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009178.9677099995 | 2122171.51863 | 37.8075959706319 | -122.41255277389601 | (37.8075959706319, -122.412552773896) | |||
150764 | 150764 | 190185 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 91 Spear St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014134.54859 | 2116822.4237599997 | 37.793185494956205 | -122.395027791311 | (37.7931854949562, -122.395027791311) | |||
162083 | 162083 | 190252 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 60 New Montgomery St | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012311.13686 | 2114949.13545 | 37.787940324123895 | -122.40120525333201 | (37.7879403241239, -122.401205253332) | |||
164217 | 164217 | 128281 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011166.44271 | 2121400.19755 | 37.8055894527535 | -122.405620252789 | (37.8055894527535, -122.405620252789) | |||
174903 | 174903 | 247035 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6002263.72164 | 2099154.77603 | 37.7440072235471 | -122.434837508343 | (37.7440072235471, -122.434837508343) | ||||
178329 | 178329 | 128582 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Washington St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013142.92236 | 2117888.29945 | 37.7960569457318 | -122.39853373176001 | (37.7960569457318, -122.39853373176) | |||
178819 | 178819 | 128701 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 300 Washington St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012701.41446 | 2117879.31888 | 37.796007680862495 | -122.400060814761 | (37.7960076808625, -122.400060814761) | |||
179345 | 179345 | 190165 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 70 Steuart St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6014495.0412099995 | 2116963.1449599997 | 37.7935919219713 | -122.393790308884 | (37.7935919219713, -122.393790308884) |
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");