Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9551 | 9551 | 59160 | Permitted Site 1 | Betula spp :: Birch 95 | 3961 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 770967 | 6004101.77882738 | 2101279.18641822 | 37.7499445479885 | -122.42863332711599 | (37.7499445479885, -122.428633327116) | ||
| 27961 | 27961 | 175569 | Undocumented 2 | Betula spp :: Birch 95 | 639 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998680.87315 | 2086652.8571 | 37.7094758038379 | -122.44632696623998 | (37.7094758038379, -122.44632696624) | |||
| 28299 | 28299 | 221260 | Undocumented 2 | Betula spp :: Birch 95 | 100 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998087.26041 | 2104928.39629 | 37.75962215406221 | -122.44969467277001 | (37.7596221540622, -122.44969467277) | |||
| 34427 | 34427 | 34517 | Permitted Site 1 | Betula spp :: Birch 95 | 1640 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | 7 | Permit Number 38228 | 6005490.1304 | 2118232.7207400003 | 37.7965733283445 | -122.425038441378 | (37.7965733283445, -122.425038441378) | ||
| 38153 | 38153 | 221203 | Undocumented 2 | Betula spp :: Birch 95 | 822 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001261.98607 | 2101410.13099 | 37.7501429669369 | -122.43846283201401 | (37.7501429669369, -122.438462832014) | |||
| 42372 | 42372 | 221263 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6004132.36771 | 2108477.00924 | 37.769709788311296 | -122.429040680782 | (37.7697097883113, -122.429040680782) | |||
| 43788 | 43788 | 221262 | Undocumented 2 | Betula spp :: Birch 95 | 114 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998017.167669999 | 2104924.0208900003 | 37.75960612994621 | -122.449936772062 | (37.7596061299462, -122.449936772062) | |||
| 50312 | 50312 | 81192 | Undocumented 2 | Betula spp :: Birch 95 | 1190 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 2 | 3x3 | 6017151.2328 | 2092548.3474 | 37.7267012956658 | -122.382899676448 | (37.7267012956658, -122.382899676448) | |
| 57097 | 57097 | 199979 | Undocumented 2 | Betula spp :: Birch 95 | 1180 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017182.0803 | 2092524.1101 | 37.726636449110295 | -122.38279135061501 | (37.7266364491103, -122.382791350615) | |||
| 58152 | 58152 | 221222 | Undocumented 2 | Betula spp :: Birch 95 | 263 Upper Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5999326.533919999 | 2105947.62074 | 37.7624915138827 | -122.445481949759 | (37.7624915138827, -122.445481949759) | |||
| 63592 | 63592 | 199976 | Undocumented 2 | Betula spp :: Birch 95 | 1176 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017220.6398 | 2092498.2202 | 37.7265674907894 | -122.38265624966299 | (37.7265674907894, -122.382656249663) | |||
| 64419 | 64419 | 221221 | Undocumented 2 | Betula spp :: Birch 95 | 568 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002627.37644 | 2103877.09879 | 37.756994245114 | -122.433917551359 | (37.756994245114, -122.433917551359) | |||
| 64465 | 64465 | 221206 | Undocumented 2 | Betula spp :: Birch 95 | 144 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006807.09402 | 2098682.83773 | 37.7429682934411 | -122.419094053065 | (37.7429682934411, -122.419094053065) | |||
| 67115 | 67115 | 221225 | Undocumented 2 | Betula spp :: Birch 95 | 233 Hermann St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6004131.6241 | 2108689.19753 | 37.7702923637227 | -122.42905838393601 | (37.7702923637227, -122.429058383936) | |||
| 68279 | 68279 | 221220 | Undocumented 2 | Betula spp :: Birch 95 | 270 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003890.13554 | 2104532.5709 | 37.7588655949011 | -122.429597200168 | (37.7588655949011, -122.429597200168) | |||
| 76150 | 76150 | 221261 | Undocumented 2 | Betula spp :: Birch 95 | 110 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998034.78247 | 2104925.5990299997 | 37.7596114710027 | -122.44987596530198 | (37.7596114710027, -122.449875965302) | |||
| 103209 | 103209 | 122566 | Permitted Site 1 | Betula spp :: Birch 95 | 378 Sweeny St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779091 | 6008597.7357 | 2094518.65936 | 37.731635041845706 | -122.412608176508 | (37.7316350418457, -122.412608176508) | |
| 129647 | 129647 | 221212 | Undocumented 2 | Betula spp :: Birch 95 | 328 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6007777.4121199995 | 2105974.0918 | 37.7630430168564 | -122.41625524948 | (37.7630430168564, -122.41625524948) | |||
| 130362 | 130362 | 221210 | Undocumented 2 | Betula spp :: Birch 95 | 239 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007933.08994 | 2100297.9588900004 | 37.7474664010656 | -122.415314968738 | (37.7474664010656, -122.415314968738) | |||
| 133349 | 133349 | 221208 | Undocumented 2 | Betula spp :: Birch 95 | 53 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007634.82349 | 2099989.12367 | 37.746601640864206 | -122.41632448648599 | (37.7466016408642, -122.416324486486) | |||
| 152410 | 152410 | 91524 | Permitted Site 1 | Betula spp :: Birch 95 | 350 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52129 | 6011423.59595 | 2106768.9844 | 37.7654299650425 | -122.403700204704 | (37.7654299650425, -122.403700204704) | |
| 155755 | 155755 | 221219 | Undocumented 2 | Betula spp :: Birch 95 | 274 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002058.8805 | 2104265.20711 | 37.7580276192018 | -122.4359113915 | (37.7580276192018, -122.4359113915) | |||
| 156103 | 156103 | 221205 | Undocumented 2 | Betula spp :: Birch 95 | 4206 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6001130.271430001 | 2102915.9336 | 37.75427004574011 | -122.439026212304 | (37.7542700457401, -122.439026212304) | |||
| 158266 | 158266 | 221214 | Undocumented 2 | Betula spp :: Birch 95 | 367 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004009.66703 | 2102145.13724 | 37.752317033024894 | -122.42901358691601 | (37.7523170330249, -122.429013586916) | |||
| 166253 | 166253 | 31452 | Permitted Site 1 | Betula spp :: Birch 95 | 622 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2006 12:00:00 AM | 5 | Permit Number 35025 | 6001186.852580001 | 2102758.41703 | 37.753840762463 | -122.438819254003 | (37.753840762463, -122.438819254003) | |
| 170183 | 170183 | 221204 | Undocumented 2 | Betula spp :: Birch 95 | 37 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000608.65808 | 2102668.8310700003 | 37.753561869210294 | -122.440812353132 | (37.7535618692103, -122.440812353132) | |||
| 171846 | 171846 | 55829 | Permitted Site 1 | Betula spp :: Birch 95 | 166 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 10 | Permit Number 11878 | 5992451.319519999 | 2114354.5721299998 | 37.7851798471539 | -122.469872700187 | (37.7851798471539, -122.469872700187) | ||
| 180067 | 180067 | 175561 | Undocumented 2 | Betula spp :: Birch 95 | 280 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003661.86049 | 2092085.64478 | 37.7246762727695 | -122.42949902477301 | (37.7246762727695, -122.429499024773) | |||
| 183174 | 183174 | 221211 | Undocumented 2 | Betula spp :: Birch 95 | 522 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007835.28715 | 2104887.50229 | 37.7600627472247 | -122.41597812701299 | (37.7600627472247, -122.415978127013) | |||
| 184849 | 184849 | 221215 | Undocumented 2 | Betula spp :: Birch 95 | 350 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004049.2112 | 2102175.65559 | 37.7524030675729 | -122.428879012372 | (37.7524030675729, -122.428879012372) |
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");