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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2875 | 2875 | 53666 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) |
| 4449 | 4449 | 59787 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | ||
| 19551 | 19551 | 55849 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | ||
| 79022 | 79022 | 61158 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) |
| 80976 | 80976 | 41195 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1996 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 86735 | 86735 | 32649 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 87402 | 87402 | 32646 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 89861 | 89861 | 32647 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 92780 | 92780 | 41199 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 93983 | 93983 | 41198 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 94306 | 94306 | 41194 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 95819 | 95819 | 64020 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2344 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1987 12:00:00 AM | Permit Number 778144 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | ||
| 97086 | 97086 | 39773 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 112 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.745486997298705 | -122.424877067697 | (37.7454869972987, -122.424877067697) |
| 102509 | 102509 | 33718 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 25 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | 13 | Permit Number 37786 | 6004139.32588988 | 2108866.31797637 | 37.7707791293659 | -122.42904437383699 | (37.7707791293659, -122.429044373837) | |
| 102747 | 102747 | 62645 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 400 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | Permit Number 25453 | 6000705.45672766 | 2110331.40246789 | 37.7746069085927 | -122.441027287197 | (37.7746069085927, -122.441027287197) | ||
| 108815 | 108815 | 50571 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2295 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 109249 | 109249 | 50197 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3279@ DOLORES 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2003 12:00:00 AM | Permit Number 46903 | 6005006.02996154 | 2106599.52754391 | 37.764604088886706 | -122.42588504534099 | (37.7646040888867, -122.425885045341) | ||
| 118352 | 118352 | 39111 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | |
| 118500 | 118500 | 41193 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 122099 | 122099 | 41200 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 123688 | 123688 | 32641 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 124586 | 124586 | 32644 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 126809 | 126809 | 41196 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 127896 | 127896 | 32645 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 139910 | 139910 | 48952 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | |
| 140702 | 140702 | 41192 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 144088 | 144088 | 32648 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 145114 | 145114 | 66879 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.75928799185029 | -122.439106757133 | (37.7592879918503, -122.439106757133) |
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");