Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13900 | 13900 | 102846 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.786422526635604 | -122.394412832193 | (37.7864225266356, -122.394412832193) | |||
| 27343 | 27343 | 203223 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994463.96401 | 2093754.2883099997 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | |||
| 33499 | 33499 | 174962 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.724904747337106 | -122.440611347459 | (37.7249047473371, -122.440611347459) | |||
| 37452 | 37452 | 140100 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 785 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999576.3959 | 2111131.7395 | 37.7767400570235 | -122.44499046488501 | (37.7767400570235, -122.444990464885) | |||
| 38771 | 38771 | 174961 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000769.59798 | 2092028.9930200002 | 37.7243565377 | -122.43949313040899 | (37.7243565377, -122.439493130409) | ||||
| 47237 | 47237 | 220016 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.74555562500829 | -122.44628649854201 | (37.7455556250083, -122.446286498542) | |||
| 58356 | 58356 | 71805 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5987333.5642 | 2098599.3879 | 37.741623296224205 | -122.486421183565 | (37.7416232962242, -122.486421183565) | ||
| 62430 | 62430 | 246034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 618 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998524.9649 | 2108501.9958 | 37.7694593898353 | -122.44843823441002 | (37.7694593898353, -122.44843823441) | |||
| 67963 | 67963 | 220015 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.44626024553601 | (37.745576384946, -122.446260245536) | |||
| 69465 | 69465 | 188516 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1506 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6014137.77003 | 2102020.8067900003 | 37.7525437439982 | -122.39398001279301 | (37.7525437439982, -122.393980012793) | |||
| 150574 | 150574 | 138352 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.78639413258121 | -122.437839612353 | (37.7863941325812, -122.437839612353) | |||
| 150580 | 150580 | 81675 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 499 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 4 | 6013273.41999 | 2104786.46043 | 37.760089552406605 | -122.397163015682 | (37.7600895524066, -122.397163015682) | ||
| 153405 | 153405 | 50382 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1330 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 4 | Permit Number 47040 | 6006491.715 | 2119759.4717 | 37.8008219271374 | -122.421681226333 | (37.8008219271374, -122.421681226333) | ||
| 159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) | |||
| 167945 | 167945 | 220049 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1401 Rivoli St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 5997764.73117 | 2105899.6107 | 37.7622704065882 | -122.450880165397 | (37.7622704065882, -122.450880165397) | |||
| 168971 | 168971 | 220018 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1129 Douglass St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6001364.34858 | 2100418.37342 | 37.7474256590636 | -122.43803782498999 | (37.7474256590636, -122.43803782499) | |||
| 170961 | 170961 | 219988 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | |||
| 173012 | 173012 | 220020 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001963.20475 | 2100104.97494 | 37.7465991794258 | -122.435944602583 | (37.7465991794258, -122.435944602583) |
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");