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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10220 | 10220 | 173929 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 95 High St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999870.0 | 2100717.0 | 37.7481605193068 | -122.443226610241 | (37.7481605193068, -122.443226610241) | |||||
| 20297 | 20297 | 87411 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.783884515657896 | -122.42096977598499 | (37.7838845156579, -122.420969775985) | |||
| 54776 | 54776 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 89803 | 89803 | 97171 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008094.3658 | 2110608.1258900003 | 37.7757848058124 | -122.415487107901 | (37.7757848058124, -122.415487107901) | ||||||
| 90965 | 90965 | 52995 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1810 PINE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2006 12:00:00 AM | 3x3 | Permit Number 48976 | 6005259.0 | 2115487.0 | 37.7890212126999 | -122.425642684361 | (37.7890212126999, -122.425642684361) | |||
| 99057 | 99057 | 88425 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 999 Bush St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51391 | 6001075.0 | 2114514.0 | 37.7861122979784 | -122.44004894455799 | (37.7861122979784, -122.440048944558) | |||
| 109196 | 109196 | 86719 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.782053156364604 | -122.392834816441 | (37.7820531563646, -122.392834816441) | ||||
| 111883 | 111883 | 86720 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.782053156364604 | -122.392834816441 | (37.7820531563646, -122.392834816441) | ||||
| 113676 | 113676 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | |||
| 113989 | 113989 | 88135 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 184 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51163 | 5998299.0 | 2096312.0 | 37.7359757467102 | -122.448341887106 | (37.7359757467102, -122.448341887106) | |||
| 127941 | 127941 | 86819 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1010 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49755 | 5995086.4 | 2090661.6 | 37.7202769199461 | -122.45904005327 | (37.7202769199461, -122.45904005327) | ||||
| 128903 | 128903 | 97172 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1360 Mission St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008094.3658 | 2110608.1258900003 | 37.7757848058124 | -122.415487107901 | (37.7757848058124, -122.415487107901) | ||||||
| 129372 | 129372 | 86721 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 South Park | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49703 | 6014686.1 | 2112756.9 | 37.782053156364604 | -122.392834816441 | (37.7820531563646, -122.392834816441) | ||||
| 142089 | 142089 | 89241 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 608 Webster St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 3x3 | Permit Number 51878 | 6004068.2 | 2110881.6 | 37.776308574074505 | -122.429434138372 | (37.7763085740745, -122.429434138372) | |||
| 142250 | 142250 | 106332 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1160 MISSION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 778325 | 6009057.1 | 2111529.8 | 37.7783695713182 | -122.412221910581 | (37.7783695713182, -122.412221910581) | |||
| 71132 | 71132 | 192728 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1485 Innes Ave | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6016125.1130099995 | 2096726.19867 | 37.738116091292206 | -122.38673818960899 | (37.7381160912922, -122.386738189609) | |||
| 18 | 18 | 96369 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 168 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2011 12:00:00 AM | 24 | 3x3 | Permit Number 767919 | 6001162.44444 | 2121276.45677 | 37.8046852096195 | -122.44023153767799 | (37.8046852096195, -122.440231537678) | |
| 24 | 24 | 22346 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 5280 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2014 12:00:00 AM | 3 | 3x3 | 6014341.487000001 | 2093641.8617 | 37.7295482207565 | -122.39268941982701 | (37.7295482207565, -122.392689419827) | ||
| 32 | 32 | 10933 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1359 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016893.48466 | 2096461.5108299998 | 37.7374318223223 | -122.384063092353 | (37.7374318223223, -122.384063092353) | |||
| 38 | 38 | 192589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1390 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008004.0 | 2110521.0 | 37.775540499151 | -122.415793536261 | (37.775540499151, -122.415793536261) | |||
| 137 | 137 | 228561 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6006199.77605 | 2105468.2728 | 37.7615653191939 | -122.42167583577299 | (37.7615653191939, -122.421675835773) | |||
| 170 | 170 | 48827 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2002 12:00:00 AM | 5 | 3x3 | Permit Number 46051 | 6011929.23024 | 2118387.60951 | 37.79736024144329 | -122.402768502565 | (37.7973602414433, -122.402768502565) | |
| 176 | 176 | 24515 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 07:40:00 AM | 3 | 3X3 | 5997710.2902 | 2109583.0289 | 37.772381016672895 | -122.45133412385 | (37.7723810166729, -122.45133412385) | ||
| 292 | 292 | 9421 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 701X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767203 | 6006076.0707 | 2112433.28351 | 37.7806825946662 | -122.42259863641199 | (37.7806825946662, -122.422598636412) | |
| 317 | 317 | 7957 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1800 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2016 03:18:00 PM | 3 | 3X3 | 6005720.43568 | 2116275.48789 | 37.791212266380896 | -122.424102272302 | (37.7912122663809, -122.424102272302) | ||
| 348 | 348 | 229175 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 795 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 3ft | 6006285.87907 | 2104987.97511 | 37.7602513890079 | -122.421343931093 | (37.7602513890079, -122.421343931093) | |||
| 359 | 359 | 22941 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 413 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2017 12:00:00 AM | 6 | 3X3 | 6006166.67617 | 2107189.14794 | 37.766288570288204 | -122.421912561635 | (37.7662885702882, -122.421912561635) | ||
| 369 | 369 | 192563 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 33 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 771124 | 6008747.97709 | 2111280.89227 | 37.777668779422896 | -122.413273679445 | (37.7776687794229, -122.413273679445) | |
| 376 | 376 | 229176 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 793 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6006285.11873 | 2105008.6290700003 | 37.7603080570896 | -122.42134802750601 | (37.7603080570896, -122.421348027506) | |||
| 379 | 379 | 122497 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 31X 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008445.21835 | 2111601.2724900004 | 37.7785314648928 | -122.414343702699 | (37.7785314648928, -122.414343702699) | |||
| 382 | 382 | 228870 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 132 Church St | 1 | : 4 | Tree 1 | Private 1 | 11/03/2006 12:00:00 AM | 2 | Width 4ft | Permit Number 49185 | 6004081.45763 | 2108139.41942 | 37.768779966653106 | -122.42919270218599 | (37.7687799666531, -122.429192702186) | |
| 404 | 404 | 249555 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1450 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770925 | 6005893.0868 | 2115064.96247 | 37.787898211588704 | -122.423418809148 | (37.7878982115887, -122.423418809148) | |
| 411 | 411 | 154366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6006164.37856 | 2107202.76015 | 37.7663258166161 | -122.42192147568899 | (37.7663258166161, -122.421921475689) | |||
| 417 | 417 | 229177 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 789 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | Width 3ft | 6006284.79968 | 2105036.34994 | 37.7603841541343 | -122.42135109956699 | (37.7603841541343, -122.421351099567) | |||
| 456 | 456 | 23112 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1448 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/1992 12:00:00 AM | 20 | 3X3 | Permit Number 779902 | 6006436.396269999 | 2101132.22455 | 37.74967287242389 | -122.42054965793899 | (37.7496728724239, -122.420549657939) | |
| 471 | 471 | 10470 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1614 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2015 08:11:00 AM | 3 | 3x3 | 5998358.4613 | 2108632.1531 | 37.76980724742621 | -122.449023538308 | (37.7698072474262, -122.449023538308) | ||
| 506 | 506 | 4706 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 950 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 09:29:00 PM | 3 | 4x4 | 6008667.8262 | 2120581.3066 | 37.8032009492885 | -122.414209123056 | (37.8032009492885, -122.414209123056) | ||
| 520 | 520 | 4707 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 968 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 09:15:00 PM | 3 | 5x5 | 6008654.9315 | 2120594.2013 | 37.8032356306012 | -122.414254658567 | (37.8032356306012, -122.414254658567) | ||
| 600 | 600 | 229041 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1398 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1990 12:00:00 AM | 10 | Width 3ft | 6004493.077930001 | 2100786.6559900003 | 37.7486143110022 | -122.427245115077 | (37.7486143110022, -122.427245115077) | ||
| 609 | 609 | 13247 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2372X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 40 | 4x4 | 6001031.9779 | 2119351.2951 | 37.7993917986357 | -122.44054486433201 | (37.7993917986357, -122.440544864332) | ||
| 650 | 650 | 11111 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2015 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | 5 | 3x3 | 6007199.704059999 | 2119289.07559 | 37.7995702354477 | -122.419197895967 | (37.7995702354477, -122.419197895967) | ||
| 876 | 876 | 192614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2016 12:00:00 AM | 4 | Width 3ft | 6007548.67256 | 2110072.64933 | 37.774283827466896 | -122.417336847918 | (37.7742838274669, -122.417336847918) | ||
| 959 | 959 | 83601 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2008 12:00:00 AM | 5 | 6009088.96788 | 2112689.1650900003 | 37.7815547005346 | -122.41219362785499 | (37.7815547005346, -122.412193627855) | ||
| 960 | 960 | 229022 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 383 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 10 | Width 3ft | 6006155.35301 | 2107408.62146 | 37.7668905539726 | -122.421967318656 | (37.7668905539726, -122.421967318656) | ||
| 1036 | 1036 | 200488 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 4ft | 6015927.44102 | 2103090.66004 | 37.7555806376415 | -122.38786561392901 | (37.7555806376415, -122.387865613929) | |||
| 1078 | 1078 | 2333 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2321 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/1990 12:00:00 AM | 18 | 5X5 | 6009703.8951 | 2103811.21237 | 37.7572123783538 | -122.40943952063299 | (37.7572123783538, -122.409439520633) | ||
| 1149 | 1149 | 19194 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150 Sanchez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 3X3 | 6003510.8594 | 2107438.4604 | 37.7668229855288 | -122.43111632094801 | (37.7668229855288, -122.431116320948) | |||
| 1205 | 1205 | 200814 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 4706 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6014979.4823 | 2095765.9955 | 37.7354160755771 | -122.390632161008 | (37.7354160755771, -122.390632161008) | |||
| 1224 | 1224 | 59196 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 272 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/1980 12:00:00 AM | 8 | Permit Number 779761 | 6009046.37885 | 2109959.18695 | 37.7740564365968 | -122.41214796834998 | (37.7740564365968, -122.41214796835) | ||
| 1405 | 1405 | 228661 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 13 | Width 3ft | 6001838.07707 | 2104669.16217 | 37.7591242363206 | -122.436703937943 | (37.7591242363206, -122.436703937943) | ||
| 1413 | 1413 | 246406 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 173 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | |||
| 1565 | 1565 | 29772 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1329 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2006 12:00:00 AM | 8 | 3x3 | 6007229.90871 | 2121805.15578 | 37.8064804551638 | -122.419271958731 | (37.8064804551638, -122.419271958731) | ||
| 1569 | 1569 | 29756 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 990 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008576.3352 | 2120666.0433 | 37.8034284755503 | -122.414531731143 | (37.8034284755503, -122.414531731143) | |||
| 1587 | 1587 | 4703 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 930 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/1984 12:00:00 AM | 36 | 5x6 | 6008724.3173 | 2120532.798 | 37.8030709297568 | -122.41401019958 | (37.8030709297568, -122.41401019958) | ||
| 1610 | 1610 | 7740 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 12 | 3X3 | 6006360.17596 | 2111335.26582 | 37.777683728843996 | -122.42153777275101 | (37.777683728844, -122.421537772751) | ||
| 1690 | 1690 | 6935 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 528 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004882.44233 | 2110586.3122400003 | 37.775543852304004 | -122.426596415205 | (37.775543852304, -122.426596415205) | |||
| 1730 | 1730 | 26216 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 847 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X6 | 6005539.1347199995 | 2098169.79344 | 37.741488104692 | -122.42344184796002 | (37.741488104692, -122.42344184796) | |||
| 1739 | 1739 | 26215 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 851 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X6 | 6005528.08782 | 2098148.15105 | 37.7414280560726 | -122.423478506131 | (37.7414280560726, -122.423478506131) | |||
| 1780 | 1780 | 7055 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1380 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000908.235 | 2110033.3424 | 37.773800058267604 | -122.440304458977 | (37.7738000582676, -122.440304458977) | |||
| 1788 | 1788 | 108703 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2436 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772910 | 6001246.11089 | 2119029.77225 | 37.798521172675294 | -122.439780826226 | (37.7985211726753, -122.439780826226) |
| 1812 | 1812 | 172746 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1230 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2017 12:00:00 AM | 3 | 4x3 | Permit Number 778360 | 6006038.86692 | 2120389.38612 | 37.8025259652646 | -122.423293075825 | (37.8025259652646, -122.423293075825) |
| 2082 | 2082 | 192574 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 218 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2013 12:00:00 AM | 4 | Width 2ft | 6009240.4524300005 | 2110671.27988 | 37.776022564117206 | -122.411526952315 | (37.7760225641172, -122.411526952315) | ||
| 2085 | 2085 | 252880 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001313.0 | 2088154.0 | 37.7137475882422 | -122.43733732943001 | (37.7137475882422, -122.43733732943) | ||||
| 2156 | 2156 | 252915 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1924 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/2012 12:00:00 AM | 3x3 | 6007321.0 | 2118975.0 | 37.79871469295279 | -122.418755881393 | (37.7987146929528, -122.418755881393) | |||
| 2183 | 2183 | 29147 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 345 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008932.73484 | 2113804.5252400003 | 37.7846084447553 | -122.412812999913 | (37.7846084447553, -122.412812999913) | ||
| 2206 | 2206 | 252954 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 50 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5998847.0 | 2112431.0 | 37.7802658347108 | -122.44760720084999 | (37.7802658347108, -122.44760720085) | ||||
| 2280 | 2280 | 7050 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1342 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/2015 07:17:00 AM | 3 | 3X3 | 6000990.1707 | 2110044.7638 | 37.773836083303706 | -122.440021850073 | (37.7738360833037, -122.440021850073) | ||
| 2318 | 2318 | 253034 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 545 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013839.0 | 2114264.0 | 37.786144219590796 | -122.395871057304 | (37.7861442195908, -122.395871057304) | ||||
| 2325 | 2325 | 47569 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 345 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 6 | 3x4 | Permit Number 778941 | 6014634.6306 | 2115001.8072 | 37.788214299095294 | -122.39317000993499 | (37.7882142990953, -122.393170009935) | |
| 2341 | 2341 | 138904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 743 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004092.4052 | 2110770.0131 | 37.7760035542999 | -122.429342446805 | (37.7760035542999, -122.429342446805) | |||
| 2345 | 2345 | 138905 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 739 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004125.2186 | 2110775.3704 | 37.776020121780206 | -122.42922931872499 | (37.7760201217802, -122.429229318725) | |||
| 2372 | 2372 | 201583 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020706.31037 | 2093011.12913 | 37.7281677917075 | -122.370641712658 | (37.7281677917075, -122.370641712658) | |
| 2413 | 2413 | 253048 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | 3x3 | 6020868.84401 | 2093226.3884400001 | 37.728767773737104 | -122.3700946933 | (37.7287677737371, -122.3700946933) | ||
| 2422 | 2422 | 201585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Donahue St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 770566 | 6020918.10936 | 2093291.5638700002 | 37.728949436562 | -122.36992888032302 | (37.728949436562, -122.369928880323) | |
| 2530 | 2530 | 116163 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1900 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777879 | 6004429.67016 | 2118081.86477 | 37.7960991562926 | -122.428697109201 | (37.7960991562926, -122.428697109201) | |
| 2543 | 2543 | 141333 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1205 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 14 | Width 0ft | 6002078.0816 | 2110492.0692 | 37.7751261444639 | -122.43629061453998 | (37.7751261444639, -122.43629061454) | ||
| 2677 | 2677 | 23213 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 602X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 3X3 | 6006690.71989 | 2112642.67217 | 37.7812921821228 | -122.42048713258998 | (37.7812921821228, -122.42048713259) | ||
| 2688 | 2688 | 1096 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2310 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1990 12:00:00 AM | 19 | 3X3 | 5999487.90061 | 2089338.3878900001 | 37.71689572423529 | -122.443730556927 | (37.7168957242353, -122.443730556927) | ||
| 2695 | 2695 | 13149 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1840 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2014 12:00:00 AM | 3 | 7x5 | 6003547.2086 | 2119700.6621 | 37.800493972655296 | -122.431866244519 | (37.8004939726553, -122.431866244519) | ||
| 2758 | 2758 | 177160 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 221 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | Permit Number 780274 | 6007458.52227 | 2087256.96391 | 37.7116319689192 | -122.416032606129 | (37.7116319689192, -122.416032606129) | ||
| 2781 | 2781 | 6959 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 653 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2017 12:00:00 AM | 3 | 3X3 | Permit Number 774555 | 6004285.9375 | 2110448.2406 | 37.775131000756396 | -122.428650025136 | (37.7751310007564, -122.428650025136) | |
| 2782 | 2782 | 29111 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 677 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 6 | 3x3 | 6007649.20664 | 2113690.31388 | 37.7842227210524 | -122.417245491187 | (37.7842227210524, -122.417245491187) | ||
| 2801 | 2801 | 142460 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 536 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6004827.4421 | 2110579.0189 | 37.775520717053205 | -122.426786154864 | (37.7755207170532, -122.426786154864) | |||
| 2948 | 2948 | 7081 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1766X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2016 07:37:00 AM | 3 | 3x3 | 5998953.6759 | 2109754.0736 | 37.7729217790125 | -122.447045463978 | (37.7729217790125, -122.447045463978) | ||
| 2954 | 2954 | 137579 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1095 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 18 | Width 0ft | 6002363.4281 | 2112169.1125 | 37.7797470942537 | -122.435423531353 | (37.7797470942537, -122.435423531353) | ||
| 2956 | 2956 | 248424 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1775 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997237.9413 | 2108083.6374 | 37.768237016007 | -122.452859770858 | (37.768237016007, -122.452859770858) | |||
| 3292 | 3292 | 253409 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 4x12 | Permit Number 775218 | 6008256.52806819 | 2110680.03106396 | 37.775991353803896 | -122.414931236288 | (37.7759913538039, -122.414931236288) | |
| 3300 | 3300 | 192597 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 104 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 775218 | 6008360.61035 | 2110669.96624 | 37.775969566167795 | -122.414570474841 | (37.7759695661678, -122.414570474841) | |
| 3302 | 3302 | 192594 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 1321 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2015 12:00:00 AM | 2 | Width 4ft | Permit Number 770747 | 6008274.3646 | 2110675.08431 | 37.775978773435504 | -122.414869184668 | (37.7759787734355, -122.414869184668) | |
| 3366 | 3366 | 29093 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 440 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008736.13849 | 2113890.72765 | 37.7848340990621 | -122.413499258178 | (37.7848340990621, -122.413499258178) | ||
| 3451 | 3451 | 29123 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 10 | 3x6 | 6008481.012069999 | 2113894.3048 | 37.784829592567895 | -122.41438216849899 | (37.7848295925679, -122.414382168499) | ||
| 3484 | 3484 | 29773 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1323 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007274.40422 | 2121764.0348900002 | 37.8063700535072 | -122.41911505491001 | (37.8063700535072, -122.41911505491) | ||
| 3518 | 3518 | 201693 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 342 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009930.218780001 | 2109950.89592 | 37.774083223805206 | -122.409090015305 | (37.7740832238052, -122.409090015305) | |
| 3539 | 3539 | 46147 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 3583 | 3583 | 201688 | Planning Code 138.1 required 4 | Lophostemon confertus :: Brisbane Box 11 | 324 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x6 | Permit Number 772214 | 6009806.99553 | 2110077.79875 | 37.7744247656342 | -122.409525226004 | (37.7744247656342, -122.409525226004) | |
| 3595 | 3595 | 229132 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 869 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1983 12:00:00 AM | 19 | Width 3ft | Permit Number 21019 | 6007588.0617 | 2104611.24937 | 37.759290317716 | -122.41681359176901 | (37.759290317716, -122.416813591769) | |
| 3602 | 3602 | 202609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 913 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | Permit Number 779780 | 6011126.85654 | 2109894.99849 | 37.773996705425795 | -122.40494667944799 | (37.7739967054258, -122.404946679448) | ||
| 3615 | 3615 | 23181 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 520X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 3 | 3X3 | 6006739.72815 | 2112299.86395 | 37.7803536757274 | -122.420293249536 | (37.7803536757274, -122.420293249536) | ||
| 3718 | 3718 | 13282 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2532 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 0 | 3x3 | 6000258.0 | 2119239.0 | 37.7990393633551 | -122.443215022549 | (37.7990393633551, -122.443215022549) | ||
| 3873 | 3873 | 228872 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | : 4 | Tree 1 | Private 1 | 10/02/2017 12:00:00 AM | 3 | 4x7 | Permit Number 780415 | 6004066.01114 | 2108522.69035 | 37.7698314611737 | -122.42927346400101 | (37.7698314611737, -122.429273464001) |
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");