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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149037 | 149037 | 70299 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 9 | 6001826.3531599995 | 2094025.88285 | 37.7298996296434 | -122.435982902906 | (37.7298996296434, -122.435982902906) | ||
| 137990 | 137990 | 70572 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 421 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1994 12:00:00 AM | 10 | 5999717.91 | 2110099.0732 | 37.773912694204 | -122.44442669475401 | (37.773912694204, -122.444426694754) | ||
| 64628 | 64628 | 71308 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1949 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 8 | 6000243.5 | 2111616.6716 | 37.7781096083019 | -122.44271758887699 | (37.7781096083019, -122.442717588877) | ||
| 1815 | 1815 | 71427 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.802997311571104 | -122.409613538987 | (37.8029973115711, -122.409613538987) | |
| 58356 | 58356 | 71805 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2451 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 4 | 5987333.5642 | 2098599.3879 | 37.741623296224205 | -122.486421183565 | (37.7416232962242, -122.486421183565) | ||
| 47147 | 47147 | 73391 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 10 | 6001816.88591 | 2094039.23102 | 37.72993574283429 | -122.43601658701999 | (37.7299357428343, -122.43601658702) | ||
| 186671 | 186671 | 73754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1815 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 6 | 6009969.6946 | 2120303.1237 | 37.8025101678048 | -122.40968430266199 | (37.8025101678048, -122.409684302662) | ||
| 149098 | 149098 | 75250 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994476.95751 | 2086787.3271700002 | 37.7096040318843 | -122.460866039547 | (37.7096040318843, -122.460866039547) | ||
| 176496 | 176496 | 75331 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994458.53323 | 2086786.7483599999 | 37.709601382461294 | -122.460929674682 | (37.7096013824613, -122.460929674682) | ||
| 135030 | 135030 | 75408 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994441.08765 | 2086786.6315099997 | 37.7096000577555 | -122.460989960739 | (37.7096000577555, -122.460989960739) | ||
| 103765 | 103765 | 75790 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2080 FOLSOM ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/1997 12:00:00 AM | 3x3 | 6008075.0 | 2106289.0 | 37.763924410887206 | -122.41524828442499 | (37.7639244108872, -122.415248284425) | |||
| 34587 | 34587 | 78000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2000 12:00:00 AM | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | ||
| 161456 | 161456 | 78061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 107 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 8 | 6006671.077740001 | 2094291.78297 | 37.730903769473706 | -122.41925294078699 | (37.7309037694737, -122.419252940787) | ||
| 150580 | 150580 | 81675 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 499 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 4 | 6013273.41999 | 2104786.46043 | 37.760089552406605 | -122.397163015682 | (37.7600895524066, -122.397163015682) | ||
| 60100 | 60100 | 83227 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 10 | 6013273.66902 | 2104798.74295 | 37.7601232913798 | -122.39716301566901 | (37.7601232913798, -122.397163015669) | ||
| 168792 | 168792 | 83538 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 243 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 5 | 6004140.213830001 | 2089715.70651 | 37.7181960153187 | -122.427676641269 | (37.7181960153187, -122.427676641269) | ||
| 93774 | 93774 | 98707 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | ||||
| 124870 | 124870 | 98708 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | |||||
| 109113 | 109113 | 99760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4247 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Most likely planted/permitted with tree no. 1 on same day/permit. | 6002269.0 | 2101186.0 | 37.7495847859814 | -122.434964495609 | (37.7495847859814, -122.434964495609) | |||
| 6724 | 6724 | 102771 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.42313363592501 | (37.7996844799161, -122.423133635925) | |||
| 13900 | 13900 | 102846 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.786422526635604 | -122.394412832193 | (37.7864225266356, -122.394412832193) | |||
| 120934 | 120934 | 102849 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 31 Guy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 1x1 | 6014185.0 | 2114270.0 | 37.786179936848505 | -122.394674400267 | (37.7861799368485, -122.394674400267) | |||
| 96893 | 96893 | 105172 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 16814 | 16814 | 105175 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.735287354242395 | -122.390027366589 | (37.7352873542424, -122.390027366589) | |||
| 124400 | 124400 | 105235 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 182X LOWER TER | 27 | Median : Cutout 11 | Tree 1 | Private 1 | 24 | 200x30 | 6000081.0 | 2106216.0 | 37.763271458828704 | -122.442891809215 | (37.7632714588287, -122.442891809215) | |||
| 112074 | 112074 | 109502 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2604 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999699.0 | 2113674.0 | 37.7837274467295 | -122.444749121189 | (37.7837274467295, -122.444749121189) | ||||
| 97305 | 97305 | 109671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 77653 | 77653 | 109672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 90165 | 90165 | 111781 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 399x EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6006811.0 | 2098022.0 | 37.7411540008274 | -122.419033684979 | (37.7411540008274, -122.419033684979) | |||
| 89457 | 89457 | 113028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 WINFIELD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5x5 | 6007142.0 | 2098801.0 | 37.7433115947954 | -122.417944411944 | (37.7433115947954, -122.417944411944) | |||
| 141333 | 141333 | 113369 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x9 | 6009304.0 | 2096928.0 | 37.7382901856605 | -122.41033652541401 | (37.7382901856605, -122.410336525414) | |||
| 29829 | 29829 | 115807 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | |||
| 118711 | 118711 | 116614 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 299X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | |||
| 86884 | 86884 | 117033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 94988 | 94988 | 117034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 129296 | 129296 | 117035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 143492 | 143492 | 117038 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 48563 | 48563 | 117040 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 128352 | 128352 | 117042 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 82180 | 82180 | 120111 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6004952.0 | 2108176.0 | 37.7689296510264 | -122.426184162815 | (37.7689296510264, -122.426184162815) | |||
| 108628 | 108628 | 120548 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
| 92933 | 92933 | 120549 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
| 88150 | 88150 | 121723 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 199 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6001086.0 | 2095247.0 | 37.7332104486713 | -122.438629847451 | (37.7332104486713, -122.438629847451) | ||||
| 56688 | 56688 | 122010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991362.52356 | 2110673.50037 | 37.775009640229605 | -122.473370979732 | (37.7750096402296, -122.473370979732) | |||
| 136845 | 136845 | 124750 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.775808163060205 | -122.42740756863 | (37.7758081630602, -122.42740756863) | |||
| 152034 | 152034 | 124751 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004689.62752 | 2110692.77739 | 37.775825277144705 | -122.427270993988 | (37.7758252771447, -122.427270993988) | |||
| 160495 | 160495 | 124753 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2109 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999833.99614 | 2116225.74938 | 37.79074158819461 | -122.444465538654 | (37.7907415881946, -122.444465538654) | |||
| 157540 | 157540 | 124754 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2077 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003727.74275 | 2117577.1894400003 | 37.794673696686104 | -122.431089877801 | (37.7946736966861, -122.431089877801) | |||
| 65145 | 65145 | 124758 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.79427026621129 | -122.419903713582 | (37.7942702662113, -122.419903713582) | |||
| 171409 | 171409 | 124759 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2534 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006240.40404 | 2119512.60207 | 37.800129911416704 | -122.42253331686199 | (37.8001299114167, -122.422533316862) | |||
| 34990 | 34990 | 124760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007817.3795 | 2119902.3991900003 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | |||
| 74967 | 74967 | 124761 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.41696742351101 | (37.8013029241584, -122.416967423511) | |||
| 185661 | 185661 | 124762 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007906.12641 | 2119914.20021 | 37.8013264288216 | -122.416797725058 | (37.8013264288216, -122.416797725058) | |||
| 65413 | 65413 | 137613 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1502 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001914.7987 | 2111556.8609 | 37.778040516588604 | -122.436931690487 | (37.7780405165886, -122.436931690487) | |||
| 54226 | 54226 | 137665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000382.7272 | 2111637.7254 | 37.778175352566 | -122.44223746490101 | (37.778175352566, -122.442237464901) | |||
| 33547 | 33547 | 137666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000398.0082 | 2111639.7629 | 37.7781818179135 | -122.442184748811 | (37.7781818179135, -122.442184748811) | |||
| 180907 | 180907 | 137667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1901 GOLDEN GATE AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000415.6663 | 2111642.14 | 37.7781893511619 | -122.442123833863 | (37.7781893511619, -122.442123833863) | |||
| 31678 | 31678 | 137728 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999638.3271 | 2111189.9480000003 | 37.77690341710429 | -122.444780412241 | (37.7769034171043, -122.444780412241) | |||
| 149751 | 149751 | 138140 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1942 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999833.7647 | 2111267.0068 | 37.7771261520231 | -122.444109874692 | (37.7771261520231, -122.444109874692) | |||
| 158299 | 158299 | 138337 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001955.802999999 | 2114338.6797 | 37.7856810164636 | -122.436989049911 | (37.7856810164636, -122.436989049911) | |||
| 159913 | 159913 | 138338 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001931.2408 | 2114335.4048 | 37.7856706283151 | -122.437073793387 | (37.7856706283151, -122.437073793387) | |||
| 42359 | 42359 | 138339 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001909.1348 | 2114331.7204 | 37.7856592553419 | -122.437150009777 | (37.7856592553419, -122.437150009777) | |||
| 45939 | 45939 | 138342 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001808.8392 | 2114319.4393 | 37.7856198329437 | -122.437496123305 | (37.7856198329437, -122.437496123305) | |||
| 187692 | 187692 | 138344 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001758.896000001 | 2114311.2519 | 37.785594512870205 | -122.43766832543301 | (37.7855945128702, -122.437668325433) | |||
| 61827 | 61827 | 138346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6001590.3534 | 2114514.4235 | 37.7861427855089 | -122.438265993007 | (37.7861427855089, -122.438265993007) | |||
| 70197 | 70197 | 138347 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1770 SCOTT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001586.1357 | 2114554.9139 | 37.786253721877706 | -122.438283486898 | (37.7862537218777, -122.438283486898) | |||
| 63850 | 63850 | 138348 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001613.9728 | 2114589.4995 | 37.786350268304 | -122.43818965646001 | (37.786350268304, -122.43818965646) | |||
| 174353 | 174353 | 138350 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6001659.5245 | 2114595.4043 | 37.786369071961104 | -122.438032482637 | (37.7863690719611, -122.438032482637) | |||
| 70529 | 70529 | 138351 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001690.7359 | 2114600.4656 | 37.786384743909295 | -122.437924862001 | (37.7863847439093, -122.437924862001) | |||
| 150574 | 150574 | 138352 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001715.4366 | 2114603.3734 | 37.78639413258121 | -122.437839612353 | (37.7863941325812, -122.437839612353) | |||
| 188012 | 188012 | 138353 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001742.4732 | 2114607.6747 | 37.786407480206705 | -122.43774638091499 | (37.7864074802067, -122.437746380915) | |||
| 55440 | 55440 | 138357 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2499 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001830.9567 | 2114618.7351 | 37.7864428800724 | -122.437441043234 | (37.7864428800724, -122.437441043234) | |||
| 164961 | 164961 | 138533 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2299 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001645.5525 | 2114240.3384 | 37.7853933573613 | -122.438055378776 | (37.7853933573613, -122.438055378776) | |||
| 41788 | 41788 | 138778 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2250 Sutter St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001713.8653 | 2114306.3395 | 37.785578464198 | -122.437823766308 | (37.785578464198, -122.437823766308) | |||
| 157543 | 157543 | 139098 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2600 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999639.9141 | 2113670.3506 | 37.7837140544374 | -122.44495327295601 | (37.7837140544374, -122.444953272956) | |||
| 5920 | 5920 | 139500 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5999620.0523 | 2111133.4316 | 37.776747194618395 | -122.44483956661199 | (37.7767471946184, -122.444839566612) | ||||
| 75193 | 75193 | 139501 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999619.0371 | 2111147.3069 | 37.7767852347068 | -122.444844076108 | (37.7767852347068, -122.444844076108) | |||
| 42577 | 42577 | 139655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 848 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000491.15 | 2111934.8144 | 37.7789972619427 | -122.441883720544 | (37.7789972619427, -122.441883720544) | |||
| 37452 | 37452 | 140100 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 785 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999576.3959 | 2111131.7395 | 37.7767400570235 | -122.44499046488501 | (37.7767400570235, -122.444990464885) | |||
| 35471 | 35471 | 140101 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 771 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999584.517999999 | 2111094.1746 | 37.7766373769699 | -122.44495966716002 | (37.7766373769699, -122.44495966716) | |||
| 134727 | 134727 | 140102 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999455.5793 | 2110868.7857 | 37.7760111570338 | -122.445389492297 | (37.7760111570338, -122.445389492297) | |||
| 156262 | 156262 | 140103 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1720 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999438.9967 | 2110868.4473 | 37.776009281241 | -122.44544683133002 | (37.776009281241, -122.44544683133) | |||
| 170339 | 170339 | 140104 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1750 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999428.844 | 2110866.7552 | 37.776004055577204 | -122.44548183036301 | (37.7760040555772, -122.445481830363) | |||
| 45153 | 45153 | 140717 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002162.097 | 2110427.6982 | 37.774954171002 | -122.43599537996201 | (37.774954171002, -122.435995379962) | |||
| 61990 | 61990 | 140718 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002160.0013 | 2110449.3533 | 37.7750135114472 | -122.436004179308 | (37.7750135114472, -122.436004179308) | |||
| 157995 | 157995 | 140719 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 556 SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002157.9056 | 2110466.8172 | 37.775061343901896 | -122.436012678697 | (37.7750613439019, -122.436012678697) | |||
| 25501 | 25501 | 141630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999025.3732 | 2110414.9246 | 37.774740403045996 | -122.446845016858 | (37.774740403046, -122.446845016858) | |||
| 175294 | 175294 | 141632 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1801 GROVE ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999054.1432 | 2110418.5587 | 37.7747520248793 | -122.446745757486 | (37.7747520248793, -122.446745757486) | |||
| 74240 | 74240 | 141691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996753.535 | 2112367.4021 | 37.7799713474759 | -122.45484482437 | (37.7799713474759, -122.45484482437) | |||
| 132605 | 132605 | 142261 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004683.1776 | 2110693.6136 | 37.775827208405104 | -122.427293365492 | (37.7758272084051, -122.427293365492) | |||
| 24187 | 24187 | 142264 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.775809585078896 | -122.427435282317 | (37.7758095850789, -122.427435282317) | |||
| 187109 | 187109 | 142298 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1501 GROVE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000546.8174 | 2110627.5355 | 37.775410978082 | -122.44159730622299 | (37.775410978082, -122.441597306223) | |||
| 38437 | 38437 | 142346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 505 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999691.4094 | 2110243.208 | 37.7743069396367 | -122.44452872557699 | (37.7743069396367, -122.444528725577) | |||
| 148974 | 148974 | 174958 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | |||
| 38639 | 38639 | 174959 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.709601466104104 | -122.461142043293 | (37.7096014661041, -122.461142043293) | |||
| 156503 | 156503 | 174960 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994409.5991400005 | 2086788.1181299998 | 37.709602327657706 | -122.461098897396 | (37.7096023276577, -122.461098897396) | |||
| 38771 | 38771 | 174961 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000769.59798 | 2092028.9930200002 | 37.7243565377 | -122.43949313040899 | (37.7243565377, -122.439493130409) | ||||
| 33499 | 33499 | 174962 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.724904747337106 | -122.440611347459 | (37.7249047473371, -122.440611347459) | |||
| 161439 | 161439 | 174963 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 27 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005106.809719999 | 2093312.6606400001 | 37.7281270946664 | -122.424591254394 | (37.7281270946664, -122.424591254394) | |||
| 58569 | 58569 | 174964 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1645 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006075.21093 | 2092385.5914900003 | 37.7256362082245 | -122.421177650028 | (37.7256362082245, -122.421177650028) |
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");