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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189101 | 189101 | 208366 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 54 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991248.72719 | 2092445.9094099998 | 37.7249548323756 | -122.472435504713 | (37.7249548323756, -122.472435504713) | |||
| 189072 | 189072 | 202806 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Mission Bay Blvd North | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014148.774 | 2108691.6113400003 | 37.7708609304265 | -122.394408999271 | (37.7708609304265, -122.394408999271) | |||
| 188969 | 188969 | 202343 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 230 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014615.41959 | 2115067.39464 | 37.7883933198478 | -122.393241068635 | (37.7883933198478, -122.393241068635) | |||
| 188948 | 188948 | 84503 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 357 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50134 | 6011610.65584 | 2112713.99225 | 37.7817640420151 | -122.403471492712 | (37.7817640420151, -122.403471492712) | |
| 188940 | 188940 | 202612 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 560 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6011424.9228300005 | 2109694.3187 | 37.773462341755796 | -122.40390148738899 | (37.7734623417558, -122.403901487389) | |||
| 188927 | 188927 | 114320 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007916.32551 | 2113778.66148 | 37.7844803264499 | -122.41632761162901 | (37.7844803264499, -122.416327611629) | |||
| 188896 | 188896 | 130104 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 366 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007790.71445 | 2112722.51189 | 37.7815733308786 | -122.41668733866899 | (37.7815733308786, -122.416687338669) | |||
| 188890 | 188890 | 228688 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 15 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002680.2972800005 | 2106779.00142 | 37.764965172032205 | -122.433941952662 | (37.7649651720322, -122.433941952662) | |||
| 188873 | 188873 | 228603 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2128 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008707.82668 | 2106126.64949 | 37.7635141788588 | -122.41304803865 | (37.7635141788588, -122.41304803865) | |||
| 188854 | 188854 | 65488 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 839 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1989 12:00:00 AM | 9 | Permit Number 28372 | 6008695.768130001 | 2115475.78771 | 37.7891840235769 | -122.413751082752 | (37.7891840235769, -122.413751082752) | |
| 188799 | 188799 | 202434 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015443.85549 | 2113239.88035 | 37.7834213702426 | -122.390247059153 | (37.7834213702426, -122.390247059153) | |||
| 188780 | 188780 | 202595 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 652 King St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011941.06121 | 2108517.7472599996 | 37.77026056640361 | -122.402033349973 | (37.7702605664036, -122.402033349973) | |||
| 188699 | 188699 | 130271 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2701 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007752.167090001 | 2122258.39153 | 37.8077543241725 | -122.417496725794 | (37.8077543241725, -122.417496725794) | |||
| 188686 | 188686 | 228980 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1300 San Jose Ave | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6003436.04165 | 2095624.2228 | 37.7343796240226 | -122.430532025653 | (37.7343796240226, -122.430532025653) | ||||
| 188636 | 188636 | 202761 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 89 Long Bridge St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014311.832909999 | 2108910.6852 | 37.7714715215252 | -122.393860307621 | (37.7714715215252, -122.393860307621) | |||
| 188629 | 188629 | 208416 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 41 San Monica Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993629.2663199995 | 2097570.14805 | 37.7391622231523 | -122.46457822422701 | (37.7391622231523, -122.464578224227) | |||
| 188623 | 188623 | 192708 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 599 Keith St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017573.8071 | 2096485.0213400002 | 37.7375339664262 | -122.38171251002 | (37.7375339664262, -122.38171251002) | |||
| 188616 | 188616 | 177233 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 230 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004678.11872 | 2093875.7961099998 | 37.729649119887206 | -122.426113328193 | (37.7296491198872, -122.426113328193) | |||
| 188596 | 188596 | 130170 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 60 Fell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007043.17364 | 2110875.06742 | 37.7764586219901 | -122.419142394304 | (37.7764586219901, -122.419142394304) | |||
| 188558 | 188558 | 200438 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 801 26th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015864.190909999 | 2101595.81305 | 37.751472598384204 | -122.387980047242 | (37.7514725983842, -122.387980047242) | |||
| 188512 | 188512 | 201577 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 601 Donahue St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 6020588.137 | 2092854.48102 | 37.727731178034894 | -122.37103941895799 | (37.7277311780349, -122.371039418958) | |||
| 188421 | 188421 | 61257 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1845 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | 9 | Permit Number 30068 | 6007758.72791 | 2118741.72508 | 37.798098814159104 | -122.417224659311 | (37.7980988141591, -122.417224659311) | |
| 188413 | 188413 | 30789 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 555 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 16 | Permit Number 34660 | 6013423.92968 | 2112089.08407 | 37.7801493011857 | -122.39715453954399 | (37.7801493011857, -122.397154539544) | |
| 188397 | 188397 | 200422 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2900 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015901.68846 | 2101957.64034 | 37.7524681775821 | -122.387875619769 | (37.7524681775821, -122.387875619769) | |||
| 188384 | 188384 | 62412 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 649 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/1986 12:00:00 AM | 11 | Permit Number 22724 | 5991603.29302 | 2111002.0024200003 | 37.7759255565205 | -122.472562069305 | (37.7759255565205, -122.472562069305) | ||
| 188362 | 188362 | 202689 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 420 Mission Bay Blvd North | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015906.63546 | 2108782.48204 | 37.771208003087004 | -122.388334804615 | (37.771208003087, -122.388334804615) | |||
| 188242 | 188242 | 45071 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1028 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2001 12:00:00 AM | 18 | Permit Number 43951 | 6010361.137619999 | 2111881.87885 | 37.7794093830802 | -122.407735568851 | (37.7794093830802, -122.407735568851) | ||
| 188233 | 188233 | 229173 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 909 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006330.6496 | 2104270.0090400004 | 37.7582825455184 | -122.421138109529 | (37.7582825455184, -122.421138109529) | |||
| 188207 | 188207 | 129909 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2241 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001123.83472 | 2119658.86925 | 37.800241546058395 | -122.44024907712799 | (37.8002415460584, -122.440249077128) | |||
| 188173 | 188173 | 192552 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 668 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009252.76134 | 2111110.06232 | 37.7772280477607 | -122.411515379846 | (37.7772280477607, -122.411515379846) | |||
| 188169 | 188169 | 202581 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6012003.845430001 | 2108517.57719 | 37.7702636034108 | -122.40181616639099 | (37.7702636034108, -122.401816166391) | |||
| 188168 | 188168 | 191632 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 765 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011199.76473 | 2113970.42096 | 37.785190941053 | -122.404981482304 | (37.785190941053, -122.404981482304) | |||
| 188158 | 188158 | 202787 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 55 Long Bridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014927.60112 | 2109501.6471700002 | 37.773128373107 | -122.39177164385201 | (37.773128373107, -122.391771643852) | |||
| 188153 | 188153 | 192706 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 599 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017533.8610000005 | 2096311.71691 | 37.7370559012175 | -122.381838573416 | (37.7370559012175, -122.381838573416) | |||
| 188152 | 188152 | 247189 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1071 Haight St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 6ft | 6001018.37543 | 2108954.4053700003 | 37.770843837890794 | -122.439846093626 | (37.7708438378908, -122.439846093626) | |||
| 188112 | 188112 | 246855 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1263 Fell St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001410.29469 | 2110050.1079599997 | 37.7738746647302 | -122.43856895919501 | (37.7738746647302, -122.438568959195) | |||
| 188099 | 188099 | 246836 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1377 Fell St | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6001045.691790001 | 2109998.49138 | 37.7737121913922 | -122.439826475826 | (37.7737121913922, -122.439826475826) | |||
| 188095 | 188095 | 202693 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 420 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015802.740119999 | 2108775.67437 | 37.771183553209205 | -122.388693710565 | (37.7711835532092, -122.388693710565) | |||
| 188047 | 188047 | 202396 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 428 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6015513.02928 | 2114865.56628 | 37.787888971046705 | -122.390121351035 | (37.7878889710467, -122.390121351035) | |||
| 188038 | 188038 | 130246 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2638 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006610.28866 | 2120310.8084 | 37.8023424433035 | -122.421310085112 | (37.8023424433035, -122.421310085112) | |||
| 187975 | 187975 | 228138 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 266 Rivoli St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997642.73778 | 2105913.08582 | 37.7623004214351 | -122.451303064403 | (37.7623004214351, -122.451303064403) | |||
| 187973 | 187973 | 123856 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 300 Lake St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994491.43556 | 2114927.45493 | 37.786870542077 | -122.462856159835 | (37.786870542077, -122.462856159835) | |||
| 187942 | 187942 | 202696 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 420 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015720.16418 | 2108774.0718400003 | 37.771174576169294 | -122.388979234507 | (37.7711745761693, -122.388979234507) | |||
| 187915 | 187915 | 71780 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1080 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1995 12:00:00 AM | 3 | Permit Number 768726 | 6007445.70481 | 2115106.99549 | 37.7881011319113 | -122.41805000311199 | (37.7881011319113, -122.418050003112) | |
| 187899 | 187899 | 192681 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017422.38921 | 2095533.8250400003 | 37.7349138087107 | -122.382169886355 | (37.7349138087107, -122.382169886355) | |||
| 187855 | 187855 | 43414 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 246 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2000 12:00:00 AM | 9 | Permit Number 43159 | 6013391.0866 | 2114213.64892 | 37.785981038638894 | -122.397417197364 | (37.7859810386389, -122.397417197364) | ||
| 187839 | 187839 | 202481 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Bryant St | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6015568.22944 | 2114180.97701 | 37.7860123062744 | -122.389882528859 | (37.7860123062744, -122.389882528859) | |||
| 187765 | 187765 | 202553 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 529 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013347.974769999 | 2111146.0668900004 | 37.7775557625245 | -122.397351153844 | (37.7775557625245, -122.397351153844) | |||
| 187752 | 187752 | 228711 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 76 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002175.4688099995 | 2107822.99441 | 37.7678030591931 | -122.43576272549 | (37.7678030591931, -122.43576272549) | |||
| 187719 | 187719 | 202665 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 218 De Haro St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011927.8681 | 2107676.6948599997 | 37.7679504904442 | -122.402019850248 | (37.7679504904442, -122.402019850248) | |||
| 187702 | 187702 | 202643 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1735 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6011199.51389 | 2107886.54091 | 37.768486001658104 | -122.404553932921 | (37.7684860016581, -122.404553932921) | |||
| 187650 | 187650 | 202744 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 90 Long Bridge St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014302.2921400005 | 2108973.66793 | 37.7716439278664 | -122.39389771941002 | (37.7716439278664, -122.39389771941) | |||
| 187592 | 187592 | 229088 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 291 Putnam St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009105.76853 | 2096334.59005 | 37.736649696312206 | -122.410980013421 | (37.7366496963122, -122.410980013421) | |||
| 187563 | 187563 | 202797 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 700 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014330.71417 | 2108701.66965 | 37.77089866057229 | -122.39378036326599 | (37.7708986605723, -122.393780363266) | |||
| 187554 | 187554 | 229178 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 751 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006277.088280001 | 2105223.13742 | 37.7608965941143 | -122.42139103487601 | (37.7608965941143, -122.421391034876) | |||
| 187474 | 187474 | 75968 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 539 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 13 | 6013460.77935 | 2112129.46261 | 37.7802622227699 | -122.397029890811 | (37.7802622227699, -122.397029890811) | ||
| 187406 | 187406 | 123771 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 837 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992993.0971800005 | 2110675.39021 | 37.775109114386 | -122.46773065840901 | (37.775109114386, -122.467730658409) | |||
| 187379 | 187379 | 228653 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3921 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002795.25875 | 2105886.8535599997 | 37.762522073757296 | -122.433480569872 | (37.7625220737573, -122.433480569872) | |||
| 187314 | 187314 | 191647 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 151 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6012350.85941 | 2114083.24662 | 37.785565012248505 | -122.401006956427 | (37.7855650122485, -122.401006956427) | |||
| 187300 | 187300 | 130021 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 400 Leavenworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008468.56325 | 2113970.6067 | 37.7850383998431 | -122.41443063838899 | (37.7850383998431, -122.414430638389) | |||
| 187285 | 187285 | 130016 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 488 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008533.42032 | 2113864.50944 | 37.784750725602606 | -122.414198743695 | (37.7847507256026, -122.414198743695) | |||
| 187263 | 187263 | 47468 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1903 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 12 | Permit Number 45369 | 6000460.76384 | 2115231.99782 | 37.7880487472944 | -122.442225592756 | (37.7880487472944, -122.442225592756) | |
| 187255 | 187255 | 208245 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 75 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993707.19975 | 2097432.52506 | 37.7387888372376 | -122.464298778791 | (37.7387888372376, -122.464298778791) | |||
| 187251 | 187251 | 202809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 560 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6014970.20087 | 2108735.66646 | 37.7710275244243 | -122.391570721814 | (37.7710275244243, -122.391570721814) | |||
| 187242 | 187242 | 201042 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2192 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015692.41935 | 2105405.31146 | 37.7619231540633 | -122.38883998437099 | (37.7619231540633, -122.388839984371) | |||
| 187230 | 187230 | 192695 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017336.50043 | 2095596.17365 | 37.735080261541796 | -122.382471173631 | (37.7350802615418, -122.382471173631) | |||
| 187178 | 187178 | 177156 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 459 Somerset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010152.122830001 | 2092308.27359 | 37.7256529032409 | -122.407078580817 | (37.7256529032409, -122.407078580817) | |||
| 187087 | 187087 | 177194 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 288 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012182.30571 | 2087931.5707200002 | 37.713748765261705 | -122.399753179179 | (37.7137487652617, -122.399753179179) | |||
| 187027 | 187027 | 228655 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 4318 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001591.79351 | 2104697.13686 | 37.7591870485498 | -122.437557705735 | (37.7591870485498, -122.437557705735) | |||
| 187014 | 187014 | 201032 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2225 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6015787.99479 | 2105210.14499 | 37.7613925657335 | -122.388495800348 | (37.7613925657335, -122.388495800348) | |||
| 186988 | 186988 | 250606 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998755.1093 | 2111407.10323 | 37.777449227027795 | -122.447851356665 | (37.7774492270278, -122.447851356665) | ||||
| 186915 | 186915 | 228934 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 350 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008892.47988 | 2106576.2377299997 | 37.7647590087491 | -122.41244116085 | (37.7647590087491, -122.41244116085) | |||
| 186866 | 186866 | 130090 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 740 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005788.3808 | 2112311.44565 | 37.7803318231011 | -122.42358523047 | (37.7803318231011, -122.42358523047) | |||
| 186832 | 186832 | 40935 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2600 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | 11 | Permit Number 41797 | 6010020.017999999 | 2105517.6881 | 37.7619156833713 | -122.40846660886801 | (37.7619156833713, -122.408466608868) | ||
| 186806 | 186806 | 228967 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Woodward St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006485.81484 | 2108449.38296 | 37.7697668700666 | -122.420898201914 | (37.7697668700666, -122.420898201914) | |||
| 186691 | 186691 | 229142 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 976 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007554.34586 | 2103988.2335099997 | 37.7575777630208 | -122.41688605736601 | (37.7575777630208, -122.416886057366) | |||
| 186643 | 186643 | 208293 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 800 Portola Dr | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5996422.34348 | 2099012.7052 | 37.743283752248296 | -122.455025290894 | (37.7432837522483, -122.455025290894) | |||
| 186626 | 186626 | 228089 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 831 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6001929.225459999 | 2101601.78088 | 37.7507071233375 | -122.43616919566601 | (37.7507071233375, -122.436169195666) | |||
| 186569 | 186569 | 202433 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6015464.892080001 | 2113260.18049 | 37.783478276652396 | -122.390175698853 | (37.7834782766524, -122.390175698853) | |||
| 186529 | 186529 | 130370 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1401 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011756.98576 | 2121020.0608599996 | 37.8045786948161 | -122.403549821892 | (37.8045786948161, -122.403549821892) | |||
| 186505 | 186505 | 202732 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 20 Long Bridge St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6014654.14045 | 2109304.03805 | 37.772570598294394 | -122.392703760581 | (37.7725705982944, -122.392703760581) | |||
| 186440 | 186440 | 191640 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 90 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6012248.86147 | 2114085.5069999998 | 37.7855655284629 | -122.401360000581 | (37.7855655284629, -122.401360000581) | |||
| 186427 | 186427 | 246834 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 200 Baker St | 6 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6000783.10255 | 2109861.5861299997 | 37.773321333458 | -122.440724988475 | (37.773321333458, -122.440724988475) | |||
| 186412 | 186412 | 249402 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 245 Hyde St | 2 | : 4 | Tree 1 | Private 1 | 19 | Width 3ft | 6008037.185190001 | 2113270.57505 | 37.7830920394007 | -122.415873486381 | (37.7830920394007, -122.415873486381) | |||
| 186384 | 186384 | 192641 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 301 Cashmere St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016153.541730001 | 2096145.18497 | 37.736522319047 | -122.38659939367399 | (37.736522319047, -122.386599393674) | |||
| 186326 | 186326 | 130033 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 890 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006685.698530001 | 2113607.2066200003 | 37.7839402754749 | -122.42057299265801 | (37.7839402754749, -122.420572992658) | |||
| 186313 | 186313 | 202782 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 55 Long Bridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014826.57464 | 2109404.11575 | 37.7728549648036 | -122.392114288247 | (37.7728549648036, -122.392114288247) | |||
| 186294 | 186294 | 228060 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1567 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005952.308230001 | 2099822.77481 | 37.746050128910106 | -122.42213063914 | (37.7460501289101, -122.42213063914) | |||
| 186293 | 186293 | 208310 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 700x Bosworth St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6001987.84098 | 2095447.80908 | 37.733813086200705 | -122.43552630359301 | (37.7338130862007, -122.435526303593) | |||
| 186154 | 186154 | 228704 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Castro St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002216.55507 | 2108083.06654 | 37.7685194870101 | -122.43563922159201 | (37.7685194870101, -122.435639221592) | |||
| 186112 | 186112 | 123773 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 899 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5992928.4701 | 2110671.7107700002 | 37.775095279817705 | -122.46795394815399 | (37.7750952798177, -122.467953948154) | |||
| 186009 | 186009 | 44352 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 451 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2001 12:00:00 AM | 5 | Permit Number 43731 | 6008017.89414 | 2122013.61694 | 37.8070971832479 | -122.416559759923 | (37.8070971832479, -122.416559759923) | ||
| 185955 | 185955 | 229018 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2900 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6009490.92161 | 2104547.71471 | 37.7592227120755 | -122.410228066873 | (37.7592227120755, -122.410228066873) | |||
| 185930 | 185930 | 250609 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2201 Golden Gate Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998802.7301 | 2111413.8391299997 | 37.7774704438335 | -122.447687106294 | (37.7774704438335, -122.447687106294) | ||||
| 185917 | 185917 | 202357 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 80 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6015870.82638 | 2115403.90042 | 37.7893869519949 | -122.388921026793 | (37.7893869519949, -122.388921026793) | |||
| 185880 | 185880 | 208323 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 551 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5991430.84556 | 2093247.3093599998 | 37.7271658165305 | -122.471864328186 | (37.7271658165305, -122.471864328186) | |||
| 185863 | 185863 | 228750 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 27 Hattie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6000626.40275 | 2105491.96589 | 37.761314518968895 | -122.44095350171699 | (37.7613145189689, -122.440953501717) | |||
| 185829 | 185829 | 95192 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 723 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2012 12:00:00 AM | 2 | 3x3 | Permit Number 769100 | 6009186.21224 | 2115482.95364 | 37.7892312289946 | -122.41205470685699 | (37.7892312289946, -122.412054706857) | |
| 185805 | 185805 | 228736 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3700 17th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003754.40351 | 2105987.78559 | 37.7628535800617 | -122.430170439739 | (37.7628535800617, -122.430170439739) | |||
| 185777 | 185777 | 202589 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 625 King St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6012146.02673 | 2108653.71558 | 37.7706453422429 | -122.401333927439 | (37.7706453422429, -122.401333927439) |
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");