Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8758 | 8758 | 7287 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6003043.7765 | 2114538.1757 | 37.786290560678204 | -122.433239236497 | (37.7862905606782, -122.433239236497) | |||
| 25779 | 25779 | 32030 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3321 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 13 | Permit Number 35417 | 6004551.31558 | 2106568.33958 | 37.764492746462395 | -122.42745555912701 | (37.7644927464624, -122.427455559127) | ||
| 28648 | 28648 | 213960 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994774.81066 | 2091163.6355700002 | 37.7216374725616 | -122.460153459937 | (37.7216374725616, -122.460153459937) | |||
| 36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
| 63227 | 63227 | 136249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1717 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008299.50959 | 2118376.18019 | 37.797125527381894 | -122.41532749988701 | (37.7971255273819, -122.415327499887) | |||
| 67268 | 67268 | 197120 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014065.797040001 | 2105649.96536 | 37.7625046287026 | -122.394483006312 | (37.7625046287026, -122.394483006312) | |||
| 74006 | 74006 | 179305 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 226 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003843.99427 | 2092374.03152 | 37.7254784293655 | -122.42888996161899 | (37.7254784293655, -122.428889961619) | |||
| 75783 | 75783 | 213912 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1235 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995137.8838599995 | 2107141.32964 | 37.7655291179984 | -122.460055338482 | (37.7655291179984, -122.460055338482) | |||
| 93193 | 93193 | 69368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3636 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 13 | Permit Number 33462 | 6002615.01621 | 2121133.0987299997 | 37.8043741790738 | -122.43519451581999 | (37.8043741790738, -122.43519451582) | |
| 148148 | 148148 | 239334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008990.25346 | 2099948.20272 | 37.7465654071644 | -122.411634644342 | (37.7465654071644, -122.411634644342) | |||
| 148808 | 148808 | 136271 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010208.66727 | 2117064.18713 | 37.7936302286056 | -122.40862871256701 | (37.7936302286056, -122.408628712567) | |||
| 158714 | 158714 | 35136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | |
| 162611 | 162611 | 136256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006727.18618 | 2118403.8407799997 | 37.7971129818473 | -122.42077010155701 | (37.7971129818473, -122.420770101557) | |||
| 169247 | 169247 | 239359 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003915.03036 | 2100651.96891 | 37.7482117843565 | -122.42923439386699 | (37.7482117843565, -122.429234393867) | |||
| 171428 | 171428 | 197068 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 430 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010884.7435 | 2106309.51664 | 37.764138254402596 | -122.405531618298 | (37.7641382544026, -122.405531618298) | |||
| 173165 | 173165 | 239337 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1534 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009307.10914 | 2100388.95638 | 37.7477933882533 | -122.410570106037 | (37.7477933882533, -122.410570106037) | |||
| 175148 | 175148 | 136110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1725 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005929.66848 | 2117544.18385 | 37.7947075984216 | -122.423468565942 | (37.7947075984216, -122.423468565942) | |||
| 176731 | 176731 | 197101 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6012884.97292 | 2106850.1929599997 | 37.7657344728051 | -122.398651302829 | (37.7657344728051, -122.398651302829) | |||
| 178520 | 178520 | 197119 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 309 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014067.1485 | 2105627.53504 | 37.7624431150761 | -122.394476761399 | (37.7624431150761, -122.394476761399) | |||
| 180069 | 180069 | 136226 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | |||
| 184376 | 184376 | 239329 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3215 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009024.67189 | 2099961.90595 | 37.746604963844206 | -122.411516596636 | (37.7466049638442, -122.411516596636) |
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");