Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16 | 16 | 122649 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3x3 | |||||||
| 396 | 396 | 251212 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 11114 | 11114 | 24872 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2675 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2015 12:00:00 AM | 5 | 3x3 | 6011136.5589 | 2093211.8894 | 37.728189086016705 | -122.40373899855601 | (37.7281890860167, -122.403738998556) | ||
| 14382 | 14382 | 115352 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | |
| 16605 | 16605 | 52850 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014308.484180001 | 2114166.94411 | 37.7859038336441 | -122.39423995641701 | (37.7859038336441, -122.394239956417) | |
| 24244 | 24244 | 187915 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013761.85881 | 2115378.38602 | 37.7891997734024 | -122.396216078116 | (37.7891997734024, -122.396216078116) | |||
| 29792 | 29792 | 112595 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.781176707308504 | -122.43904854399099 | (37.7811767073085, -122.439048543991) | |||
| 31078 | 31078 | 141345 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001662.4769 | 2110310.1497 | 37.7746030164406 | -122.437715248986 | (37.7746030164406, -122.437715248986) | |||
| 38415 | 38415 | 187922 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013074.697930001 | 2115022.06537 | 37.7881831410762 | -122.398568572402 | (37.7881831410762, -122.398568572402) | |||
| 40227 | 40227 | 203406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994466.0383 | 2096440.3744299999 | 37.736108347605295 | -122.461603176966 | (37.7361083476053, -122.461603176966) | |||
| 42234 | 42234 | 187869 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6015103.96021 | 2100930.78351 | 37.749604420516896 | -122.390562573713 | (37.7496044205169, -122.390562573713) | |||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 46595 | 46595 | 203410 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993793.04129 | 2102233.18002 | 37.7519751701323 | -122.464350430425 | (37.7519751701323, -122.464350430425) | |||
| 49996 | 49996 | 187944 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015109.7038 | 2115276.55289 | 37.7889950679055 | -122.391545539018 | (37.7889950679055, -122.391545539018) | ||||
| 50549 | 50549 | 141324 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001611.1632 | 2110665.9521 | 37.7755770427913 | -122.43791824313499 | (37.7755770427913, -122.437918243135) | |||
| 51610 | 51610 | 247891 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001766.9155 | 2109631.5958 | 37.7727458146843 | -122.43730537854401 | (37.7727458146843, -122.437305378544) | |||
| 54872 | 54872 | 189096 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016030.46802 | 2097581.7763799997 | 37.74046009325421 | -122.38712508694599 | (37.7404600932542, -122.387125086946) | |||
| 55733 | 55733 | 247512 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001707.9488 | 2109975.7789 | 37.773687503260604 | -122.437534002868 | (37.7736875032606, -122.437534002868) | |||
| 58878 | 58878 | 187907 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012037.39416 | 2114599.46395 | 37.7869649329299 | -122.40212776620501 | (37.7869649329299, -122.402127766205) | |||
| 60719 | 60719 | 187894 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1701 Indiana St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6015203.0238 | 2100485.5663 | 37.748387442638396 | -122.390188905397 | (37.7483874426384, -122.390188905397) | |||
| 64406 | 64406 | 137743 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1100x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001371.9774 | 2112372.8168 | 37.780250057585505 | -122.438867987251 | (37.7802500575855, -122.438867987251) | |||
| 67216 | 67216 | 140746 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001281.788 | 2113047.9683 | 37.7820987201541 | -122.439228398563 | (37.7820987201541, -122.439228398563) | |||
| 69702 | 69702 | 175144 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6009113.082 | 2093674.9083599998 | 37.7293471914122 | -122.41076694875 | (37.7293471914122, -122.41076694875) | |||
| 69865 | 69865 | 137769 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001467.7508 | 2111695.2964 | 37.7783952065367 | -122.43848810700199 | (37.7783952065367, -122.438488107002) | |||
| 70980 | 70980 | 138254 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1400x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001237.1163 | 2113367.4385 | 37.7829733616541 | -122.43940584928998 | (37.7829733616541, -122.43940584929) | |||
| 71721 | 71721 | 187928 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 11 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013614.18616 | 2115234.9562 | 37.788797730571396 | -122.396716951919 | (37.7887977305714, -122.396716951919) | |||
| 76766 | 76766 | 50680 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 2 | Permit Number 47253 | 6011881.28809 | 2112735.18958 | 37.7818373574415 | -122.40253671761002 | (37.7818373574415, -122.40253671761) | ||
| 78053 | 78053 | 28122 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1640 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2005 12:00:00 AM | 6 | 3X3 | 6006494.4461 | 2099888.88551 | 37.746262217205896 | -122.42026068535601 | (37.7462622172059, -122.420260685356) | ||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 107872 | 107872 | 107156 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 275 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015276.38031 | 2115978.63581 | 37.79093207618371 | -122.39101794626801 | (37.7909320761837, -122.391017946268) | ||||
| 108943 | 108943 | 88154 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 111076 | 111076 | 84891 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1699X Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2007 12:00:00 AM | 3 | 3x3 | Permit No. 49257 | 6006643.0 | 2099756.0 | 37.7459057132351 | -122.41973757574301 | (37.7459057132351, -122.419737575743) | |
| 113637 | 113637 | 86681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1099X Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 3x3 | 6010093.920773 | 2108925.272404 | 37.771276268637706 | -122.408451379419 | (37.7712762686377, -122.408451379419) | ||
| 114525 | 114525 | 101994 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 117985 | 117985 | 100777 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 125440 | 125440 | 28681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3125X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X3 | 6011481.7390123 | 2092091.2460015 | 37.7251313079457 | -122.40246692394899 | (37.7251313079457, -122.402466923949) | |||
| 126027 | 126027 | 121544 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 128007 | 128007 | 122701 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 129159 | 129159 | 116468 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 130108 | 130108 | 199670 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1907 Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015203.4065 | 2093411.0787 | 37.7289623696233 | -122.389693539093 | (37.7289623696233, -122.389693539093) | |||
| 132291 | 132291 | 141589 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001563.1807 | 2110994.9752 | 37.7764777288536 | -122.438107800298 | (37.7764777288536, -122.438107800298) | |||
| 136152 | 136152 | 220418 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009481.19591 | 2107096.90885 | 37.7662216724125 | -122.410441705317 | (37.7662216724125, -122.410441705317) | |||
| 141528 | 141528 | 244919 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 250x Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6001806.9408 | 2109318.1774 | 37.7718875210524 | -122.437144482547 | (37.7718875210524, -122.437144482547) | |||
| 150427 | 150427 | 220500 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003126.35036 | 2108201.25772 | 37.7688956446503 | -122.43250076301001 | (37.7688956446503, -122.43250076301) | |||
| 150548 | 150548 | 140191 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 282 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997398.2687 | 2109611.1769 | 37.772440432665604 | -122.452415461613 | (37.7724404326656, -122.452415461613) | |||
| 152412 | 152412 | 189068 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6013786.48532 | 2112440.07138 | 37.781133208981295 | -122.39592488753401 | (37.7811332089813, -122.395924887534) | |||
| 152710 | 152710 | 189080 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6010237.11859 | 2109048.60365 | 37.7716229259945 | -122.407964748472 | (37.7716229259945, -122.407964748472) | |||
| 154554 | 154554 | 137759 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001427.817000001 | 2112000.5528 | 37.7792310917629 | -122.438648131089 | (37.7792310917629, -122.438648131089) | |||
| 165831 | 165831 | 139861 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 710 McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005666.4072 | 2112084.3112 | 37.779701281894205 | -122.42399103767299 | (37.7797012818942, -122.423991037673) | |||
| 168192 | 168192 | 137721 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001519.5293 | 2111318.2945 | 37.7773629996088 | -122.438281970677 | (37.7773629996088, -122.438281970677) | |||
| 169888 | 169888 | 88172 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011709.51547 | 2112571.62711 | 37.7813786618321 | -122.403119465684 | (37.7813786618321, -122.403119465684) | |
| 176685 | 176685 | 187934 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6015195.69866 | 2115800.94411 | 37.7904396983948 | -122.391284677144 | (37.7904396983948, -122.391284677144) | |||
| 188605 | 188605 | 220425 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009445.91202 | 2107658.57784 | 37.767761908016205 | -122.41060341331399 | (37.7677619080162, -122.410603413314) |
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");