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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1153 | 1153 | 17806 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1881 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6004903.5356 | 2115394.9801 | 37.7887484569995 | -122.42686598915199 | (37.7887484569995, -122.426865989152) | |||
5348 | 5348 | 26872 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003227.2163 | 2110650.5623 | 37.7756265519671 | -122.432326827371 | (37.7756265519671, -122.432326827371) | |||
7223 | 7223 | 10658 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 957 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6003278.1745 | 2110658.3168 | 37.7756507331964 | -122.43215110447599 | (37.7756507331964, -122.432151104476) | ||
7523 | 7523 | 87408 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2400X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 6005843.02152 | 2118712.53051 | 37.7979106921903 | -122.42385149366501 | (37.7979106921903, -122.423851493665) | ||
7779 | 7779 | 10661 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 958 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6003257.9574 | 2110699.3049 | 37.7757621301077 | -122.432223968227 | (37.7757621301077, -122.432223968227) | |||
13610 | 13610 | 11963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015687.60896 | 2096283.0567700001 | 37.736875081728705 | -122.38821995489599 | (37.7368750817287, -122.388219954896) | |||
17352 | 17352 | 16120 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 303 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000032.3049 | 2094633.40383 | 37.7314656586952 | -122.44222871430401 | (37.7314656586952, -122.442228714304) | |||
18348 | 18348 | 16020 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 107 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001336.16248 | 2094611.17288 | 37.731478841871706 | -122.437719447913 | (37.7314788418717, -122.437719447913) | |||
19295 | 19295 | 5760 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 398 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6003950.51884 | 2108401.53413 | 37.7694922566853 | -122.42966430666999 | (37.7694922566853, -122.42966430667) | |||
19540 | 19540 | 4835 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 115 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6006362.63783 | 2097667.32197 | 37.7401548759573 | -122.420558792379 | (37.7401548759573, -122.420558792379) | |||
20001 | 20001 | 4839 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 135 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006426.94909 | 2097635.5595299997 | 37.7400712875725 | -122.42033417588699 | (37.7400712875725, -122.420334175887) | |||
20112 | 20112 | 29963 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 500X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3x3 | 5991394.8537099995 | 2093447.95886 | 37.7277146673841 | -122.47200336878099 | (37.7277146673841, -122.472003368781) | ||
21443 | 21443 | 4396 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1005 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004431.4266800005 | 2103008.65854 | 37.754711924921295 | -122.427616590837 | (37.7547119249213, -122.427616590837) | |||
21637 | 21637 | 4817 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 51 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005995.99863 | 2097868.77885 | 37.7406873618291 | -122.42184079032499 | (37.7406873618291, -122.421840790325) | |||
21650 | 21650 | 1996 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 175 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6007331.5108 | 2098053.7261799998 | 37.741270411207296 | -122.41723618861201 | (37.7412704112073, -122.417236188612) | |||
21993 | 21993 | 16119 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 301 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000050.07874 | 2094632.71852 | 37.7314647899581 | -122.442167217764 | (37.7314647899581, -122.442167217764) | |||
22519 | 22519 | 17782 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1791 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005428.2033400005 | 2115468.32597 | 37.788979497959296 | -122.425055933202 | (37.7889794979593, -122.425055933202) | |||
37403 | 37403 | 11269 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1176X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1990 12:00:00 AM | 3 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
91987 | 91987 | 11505 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
97379 | 97379 | 15039 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6015648.596419999 | 2096190.1744099997 | 37.736617883929604 | -122.388348358907 | (37.7366178839296, -122.388348358907) | |||
101721 | 101721 | 18107 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3067 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 5999321.271546599 | 2114616.8679369 | 37.7862947536085 | -122.446123757059 | (37.7862947536085, -122.446123757059) | |||
109749 | 109749 | 5761 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400 DUBOCE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003934.4 | 2108512.1 | 37.7697949309592 | -122.429727948184 | (37.7697949309592, -122.429727948184) | |||
109965 | 109965 | 6122 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 199X Elk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000815.0314327 | 2096222.3312360002 | 37.7358730629277 | -122.439636554407 | (37.7358730629277, -122.439636554407) | |||
123191 | 123191 | 11510 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | |||
123575 | 123575 | 11966 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015728.77645 | 2096327.58352 | 37.736999624078 | -122.38808072579599 | (37.736999624078, -122.388080725796) | |||
140133 | 140133 | 12381 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1435 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6004345.46385 | 2113763.0093400003 | 37.7842359045501 | -122.42868045552099 | (37.7842359045501, -122.428680455521) |
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");