Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13371 | 13371 | 24145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | |||
| 14845 | 14845 | 30632 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008058.1142 | 2108604.0472 | 37.770280041456104 | -122.415470596847 | (37.7702800414561, -122.415470596847) | |
| 16955 | 16955 | 15610 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1995 12:00:00 AM | 3 | 3x3 | 6006029.1794 | 2098644.8095 | 37.742820038399 | -122.421781171739 | (37.742820038399, -122.421781171739) | ||
| 39609 | 39609 | 42172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | ||
| 85628 | 85628 | 49615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 95499 | 95499 | 111870 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3399x 16TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004303.0 | 2106535.0 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | ||||
| 106341 | 106341 | 93816 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 106361 | 106361 | 8086 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2001 12:00:00 AM | 6 | 3X3 | 6004351.32927 | 2111504.25977 | 37.7780342704524 | -122.428499108252 | (37.7780342704524, -122.428499108252) | ||
| 107726 | 107726 | 100414 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | ||||
| 108008 | 108008 | 14770 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1000X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 02/06/2016 08:42:00 AM | 3 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 113337 | 113337 | 121097 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
| 114125 | 114125 | 41237 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 122919 | 122919 | 49987 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 300@ GOUGH Linden St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2003 12:00:00 AM | Permit Number 46733 | 6005944.16269933 | 2110905.42089734 | 37.7764800131905 | -122.42294634828801 | (37.7764800131905, -122.422946348288) | |||
| 123067 | 123067 | 34975 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38557 | 6012788.97638306 | 2118225.73375032 | 37.79696373512979 | -122.399782167941 | (37.7969637351298, -122.399782167941) | |||
| 129013 | 129013 | 96719 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008320.0 | 2116937.0 | 37.7931750456071 | -122.41515467261601 | (37.7931750456071, -122.415154672616) | |||||
| 141172 | 141172 | 47636 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 145425 | 145425 | 88491 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 161197 | 161197 | 48810 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014469.89088 | 2102291.4479400003 | 37.753305319601495 | -122.392850405821 | (37.7533053196015, -122.392850405821) |
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");