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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157856 | 157856 | 197349 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 776 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008993.795609999 | 2110246.5783 | 37.7748425951336 | -122.412350180929 | (37.7748425951336, -122.412350180929) | |||
| 158949 | 158949 | 197336 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 651 Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013643.57223 | 2103811.4939599996 | 37.757433106182 | -122.39581450923201 | (37.757433106182, -122.395814509232) | ||||
| 159224 | 159224 | 38871 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1998 12:00:00 AM | 2 | Permit Number 40696 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | ||
| 166292 | 166292 | 43230 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1371 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 3 | Permit Number 43018 | 5989871.41437878 | 2106041.52738456 | 37.7622050471688 | -122.47819025383801 | (37.7622050471688, -122.478190253838) | |
| 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) | |||
| 169430 | 169430 | 42275 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1522 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 4 | Permit Number 42512 | 5987167.45157267 | 2104900.21174724 | 37.7589139779601 | -122.48745827105 | (37.7589139779601, -122.48745827105) | ||
| 169762 | 169762 | 240386 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 310 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008247.18934 | 2097121.53396 | 37.738762289236895 | -122.41400415558998 | (37.7387622892369, -122.41400415559) | |||
| 171286 | 171286 | 48668 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3362 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2002 12:00:00 AM | 2 | Permit Number 45951 | 5998735.75428 | 2115612.17598 | 37.788994153303 | -122.44822118308201 | (37.788994153303, -122.448221183082) | ||
| 173280 | 173280 | 117792 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 3801 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983744.15991 | 2111021.91382 | 37.775522188312394 | -122.499749889479 | (37.7755221883124, -122.499749889479) | |||
| 173397 | 173397 | 179371 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 479 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010448.30169 | 2092366.9553099999 | 37.7258306011814 | -122.40605884135401 | (37.7258306011814, -122.406058841354) | |||
| 173420 | 173420 | 184400 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2087 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982288.7103 | 2100911.824 | 37.747677253327 | -122.504035534429 | (37.747677253327, -122.504035534429) | |||
| 174144 | 174144 | 240381 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 98 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008070.808569999 | 2107998.41684 | 37.7686178359612 | -122.415383805538 | (37.7686178359612, -122.415383805538) | |||
| 174499 | 174499 | 48458 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | ||
| 174549 | 174549 | 179376 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 11 Cross St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000146.4091300005 | 2088205.43619 | 37.7138224314379 | -122.441373172128 | (37.7138224314379, -122.441373172128) | |||
| 175872 | 175872 | 78389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985613.90998 | 2111830.68363 | 37.77785237866 | -122.49334166667101 | (37.77785237866, -122.493341666671) | ||
| 176461 | 176461 | 103083 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 670 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012579.2635 | 2114003.58062 | 37.785359006363 | -122.40021114274599 | (37.785359006363, -122.400211142746) | |||
| 182568 | 182568 | 33177 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3245 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 4 | 3.5x5 | Permit Number 37389 | 5985988.52360796 | 2098193.06286983 | 37.740429143118206 | -122.491041921171 | (37.7404291431182, -122.491041921171) |
| 185994 | 185994 | 181319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1283 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989233.7879 | 2106609.7025 | 37.7637280687606 | -122.48043712751101 | (37.7637280687606, -122.480437127511) | |||
| 186937 | 186937 | 42675 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1097 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007843.31475 | 2118863.44983 | 37.7984377983088 | -122.416940592258 | (37.7984377983088, -122.416940592258) | ||
| 187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) | ||||
| 187730 | 187730 | 41756 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1630 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2000 12:00:00 AM | 9 | Permit Number 42184 | 6008372.67518 | 2118139.66101 | 37.7964802161469 | -122.41505757827 | (37.7964802161469, -122.41505757827) | ||
| 188758 | 188758 | 217581 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 500 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992611.7697 | 2088555.8456 | 37.714352460703104 | -122.467440914144 | (37.7143524607031, -122.467440914144) |
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");