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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5190 | 5190 | 253817 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001018.0 | 2098627.0 | 37.742487269754704 | -122.43910710368601 | (37.7424872697547, -122.439107103686) | ||||
18331 | 18331 | 34 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 759 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003742.09963 | 2107707.8799900003 | 37.767575847275204 | -122.430335723414 | (37.7675758472752, -122.430335723414) | |||
46584 | 46584 | 112541 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | |||
83025 | 83025 | 7243 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.43351002509701 | (37.7850277993699, -122.433510025097) | |||
95726 | 95726 | 23598 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
102926 | 102926 | 112527 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
116556 | 116556 | 23599 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 200X Vasquez Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
124635 | 124635 | 1772 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 2000X Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
128753 | 128753 | 29219 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1902X 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
135504 | 135504 | 136328 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6011327.03299 | 2118633.79421 | 37.7980025633245 | -122.40486961294201 | (37.7980025633245, -122.404869612942) | |||
143705 | 143705 | 13408 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 364 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
169354 | 169354 | 117837 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 660x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5983820.01458 | 2111273.2343900003 | 37.776216692790705 | -122.49950607144899 | (37.7762166927907, -122.499506071449) | |||
21370 | 21370 | 22 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 725 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2017 08:22:00 AM | 3 | 3X3 | 6003898.66598 | 2107719.95316 | 37.7676178644975 | -122.429795042015 | (37.7676178644975, -122.429795042015) | ||
20666 | 20666 | 33 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 755 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6003762.7674 | 2107707.98129 | 37.7675772960935 | -122.43026424352199 | (37.7675772960935, -122.430264243522) | ||
576 | 576 | 240412 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 1 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.059769999 | 2103920.2632400002 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | ||
596 | 596 | 240413 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3420 Market St | 2 | : 4 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 8 | Width 3ft | 6000107.95046 | 2103900.11575 | 37.756914147893795 | -122.442632304847 | (37.7569141478938, -122.442632304847) | ||
111533 | 111533 | 25183 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
120958 | 120958 | 25184 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 25 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
98390 | 98390 | 11347 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1300X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/1997 12:00:00 AM | 18 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | ||
19634 | 19634 | 31 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:04:00 AM | 3 | 3X3 | 6003785.60824 | 2107710.67637 | 37.7675859898405 | -122.430185432325 | (37.7675859898405, -122.430185432325) | ||
97182 | 97182 | 32 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:10:00 AM | 3 | 3X3 | 6003820.6216400005 | 2107707.01694 | 37.7675779249973 | -122.43006406443999 | (37.7675779249973, -122.43006406444) | ||
126995 | 126995 | 9330 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 159 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 03:37:00 AM | 3 | 3x3 | 6000991.502255901 | 2098643.2192577 | 37.7425302962209 | -122.439199887043 | (37.7425302962209, -122.439199887043) | ||
113563 | 113563 | 18603 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | ||
18385 | 18385 | 25468 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 437 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992774.4094 | 2088493.0908 | 37.7141895393891 | -122.466874212626 | (37.7141895393891, -122.466874212626) |
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");