Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188181 | 188181 | 222860 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 2 Webster St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004313.25978 | 2108595.11318 | 37.7700443109166 | -122.42842339963998 | (37.7700443109166, -122.42842339964) | |||
| 187802 | 187802 | 188464 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011863.90983 | 2109727.01208 | 37.7735766257899 | -122.40238525827499 | (37.7735766257899, -122.402385258275) | |||
| 187532 | 187532 | 222870 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 25 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007227.82526 | 2099384.75669 | 37.744919289898604 | -122.417689017034 | (37.7449192898986, -122.417689017034) | |||
| 186968 | 186968 | 188443 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011515.17164 | 2106121.75692 | 37.763657939085704 | -122.40333792809601 | (37.7636579390857, -122.403337928096) | |||
| 186635 | 186635 | 222873 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000914.513259999 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | |||
| 185225 | 185225 | 46860 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 96 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44930 | 6005007.55179 | 2092712.98729 | 37.726474917775896 | -122.424891746668 | (37.7264749177759, -122.424891746668) | ||
| 181880 | 181880 | 222876 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6003060.85114 | 2095475.7145 | 37.7339505925395 | -122.431818580457 | (37.7339505925395, -122.431818580457) | |||
| 180911 | 180911 | 222881 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3844 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004001.37732 | 2104831.96458 | 37.759693956822204 | -122.429233822808 | (37.7596939568222, -122.429233822808) | |||
| 180660 | 180660 | 222861 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 77 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008184.4457 | 2107955.63736 | 37.7685067598049 | -122.414987714411 | (37.7685067598049, -122.414987714411) | |||
| 180652 | 180652 | 42252 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 151 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50766 | 6010454.20711 | 2111454.0742900004 | 37.778239941556 | -122.407383433006 | (37.778239941556, -122.407383433006) | |
| 180493 | 180493 | 102667 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3026 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2013 12:00:00 AM | 5 | Permit Number 769905 | 6003415.56335 | 2118865.49284 | 37.7981933509083 | -122.432262110832 | (37.7981933509083, -122.432262110832) | ||
| 179819 | 179819 | 175826 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6003554.6564 | 2087615.13702 | 37.712395169585704 | -122.429550938144 | (37.7123951695857, -122.429550938144) | |||
| 178818 | 178818 | 205977 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1624 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5993106.31442 | 2104408.61975 | 37.7579087567066 | -122.466883344019 | (37.7579087567066, -122.466883344019) | |||
| 177839 | 177839 | 125956 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1047 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009450.24252 | 2117026.36812 | 37.793483881020705 | -122.41125026328899 | (37.7934838810207, -122.411250263289) | |||
| 177603 | 177603 | 59249 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 948 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 10 | Permit Number 18581 | 6007857.82328 | 2120305.56138 | 37.80239829122 | -122.416992620734 | (37.80239829122, -122.416992620734) | ||
| 176430 | 176430 | 59254 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 985 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 16 | Permit Number 18586 | 6007686.6975 | 2120231.45266 | 37.802185179755604 | -122.41757954618299 | (37.8021851797556, -122.417579546183) | ||
| 175884 | 175884 | 125955 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999006.9985 | 2115714.87548 | 37.789291641844 | -122.447290112255 | (37.789291641844, -122.447290112255) | |||
| 174401 | 174401 | 175830 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | |||
| 173876 | 173876 | 188454 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6011500.01929 | 2106398.96501 | 37.764418243941606 | -122.403409838819 | (37.7644182439416, -122.403409838819) | |||
| 172727 | 172727 | 175831 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994675.09306 | 2086785.5883900002 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | |||
| 172355 | 172355 | 188466 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 445 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6011029.5684 | 2112160.37935 | 37.7802114767035 | -122.405442792276 | (37.7802114767035, -122.405442792276) | |||
| 171801 | 171801 | 188451 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011503.70347 | 2106326.77104 | 37.7642202212997 | -122.403392016924 | (37.7642202212997, -122.403392016924) | |||
| 171391 | 171391 | 32659 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 55 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 14 | Permit Number 37092 | 6011762.8277199995 | 2110068.09254 | 37.7745075113438 | -122.402758910415 | (37.7745075113438, -122.402758910415) | |
| 171265 | 171265 | 175835 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | |||
| 170113 | 170113 | 222875 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.43182793522301 | (37.7340120027534, -122.431827935223) | |||
| 168802 | 168802 | 188456 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011496.96392 | 2106445.7760799997 | 37.764546605960795 | -122.403423700042 | (37.7645466059608, -122.403423700042) | |||
| 168575 | 168575 | 222862 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008204.356240001 | 2107957.35065 | 37.7685125829154 | -122.414918966632 | (37.7685125829154, -122.414918966632) | |||
| 166599 | 166599 | 33139 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3122 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | 14 | Permit Number 37366 | 6001955.19491 | 2118883.5060400004 | 37.798159899724396 | -122.437316700005 | (37.7981598997244, -122.437316700005) | ||
| 166330 | 166330 | 175839 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009068.666680001 | 2092869.3876 | 37.7271329121485 | -122.41086362855101 | (37.7271329121485, -122.410863628551) | |||
| 166100 | 166100 | 71685 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994260.16312 | 2086694.7455400003 | 37.7093373478025 | -122.461608605251 | (37.7093373478025, -122.461608605251) | ||
| 165372 | 165372 | 32639 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 787 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 11 | Permit Number 37084 | 6011743.68261 | 2109609.56566 | 37.7732474325671 | -122.402792883183 | (37.7732474325671, -122.402792883183) | |
| 164926 | 164926 | 188446 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011512.27704 | 2106186.3574200002 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) | |||
| 164782 | 164782 | 125963 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 954 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007766.23356 | 2120291.4942799998 | 37.8023545140073 | -122.41730856964399 | (37.8023545140073, -122.417308569644) | |||
| 164317 | 164317 | 222874 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 462 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001154.00187 | 2103552.8212599996 | 37.7560201354351 | -122.43898978706999 | (37.7560201354351, -122.43898978707) | |||
| 164186 | 164186 | 182455 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1500 31st Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5986551.2997 | 2104640.4864 | 37.7581648905277 | -122.48957008427 | (37.7581648905277, -122.48957008427) | |||
| 163850 | 163850 | 106234 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 785 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6011757.19214 | 2109625.51022 | 37.7732919669825 | -122.40274727317801 | (37.7732919669825, -122.402747273178) | ||||
| 162578 | 162578 | 205979 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.743715225367104 | -122.46489100842301 | (37.7437152253671, -122.464891008423) | |||
| 162239 | 162239 | 125954 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999004.62741 | 2115731.3369 | 37.7893367050801 | -122.447299501178 | (37.7893367050801, -122.447299501178) | |||
| 161840 | 161840 | 188445 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011511.3367099995 | 2106160.81157 | 37.7637649602022 | -122.403353939635 | (37.7637649602022, -122.403353939635) | |||
| 159956 | 159956 | 188461 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011834.924330001 | 2109696.1650799997 | 37.7734903088701 | -122.40248335455 | (37.7734903088701, -122.40248335455) | |||
| 159807 | 159807 | 188449 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011506.747280001 | 2106279.38998 | 37.7640902935593 | -122.403378155697 | (37.7640902935593, -122.403378155697) | |||
| 158361 | 158361 | 184174 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1655 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985601.1485 | 2103943.8243 | 37.7561965316146 | -122.492804758993 | (37.7561965316146, -122.492804758993) | |||
| 157528 | 157528 | 175827 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6003539.767469999 | 2087618.6367900001 | 37.7124039361582 | -122.42960264823999 | (37.7124039361582, -122.42960264824) | |||
| 155799 | 155799 | 222877 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003276.24685 | 2105959.7003900004 | 37.7627493711059 | -122.43182221013001 | (37.7627493711059, -122.43182221013) | |||
| 155727 | 155727 | 42253 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 439 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 9 | Permit Number 42498 | 6011074.3833099995 | 2112201.77293 | 37.7803276394387 | -122.405290671934 | (37.7803276394387, -122.405290671934) | |
| 155668 | 155668 | 247476 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 856 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | |||
| 154453 | 154453 | 222872 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 4250 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002245.78823 | 2100636.8852 | 37.7480757286172 | -122.435005495434 | (37.7480757286172, -122.435005495434) | |||
| 154306 | 154306 | 49782 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 327 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 11 | Permit Number 46567 | 6012093.71999 | 2087090.7414400002 | 37.711435076735 | -122.40000035424801 | (37.711435076735, -122.400000354248) | |
| 152099 | 152099 | 188457 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017980.56674 | 2096851.4508 | 37.738562560606105 | -122.38033159384199 | (37.7385625606061, -122.380331593842) | |||
| 151433 | 151433 | 125953 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 251 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999000.411280001 | 2115755.88881 | 37.7894038772406 | -122.44731585625799 | (37.7894038772406, -122.447315856258) | |||
| 151386 | 151386 | 125962 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 952 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007785.23718 | 2120295.4388099997 | 37.802366413836204 | -122.41724308731001 | (37.8023664138362, -122.41724308731) | |||
| 150703 | 150703 | 222868 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005340.76956 | 2101936.5260900003 | 37.7518194920941 | -122.42439557991699 | (37.7518194920941, -122.424395579917) | |||
| 149597 | 149597 | 175837 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | |||
| 148126 | 148126 | 188447 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011509.63905 | 2106201.49872 | 37.7638765831644 | -122.40336267386002 | (37.7638765831644, -122.40336267386) | |||
| 147749 | 147749 | 188458 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017965.45294 | 2096866.00027 | 37.7386016766138 | -122.38038486158001 | (37.7386016766138, -122.38038486158) | |||
| 143939 | 143939 | 115864 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 143104 | 143104 | 1547 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 501 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5995572.6443300005 | 2112729.1538400003 | 37.7808968119003 | -122.458956226418 | (37.7808968119003, -122.458956226418) | |||
| 142898 | 142898 | 115856 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 142687 | 142687 | 115857 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 142465 | 142465 | 34577 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 295X Presidio Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | ||
| 141839 | 141839 | 115853 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401x KANSAS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011620.0 | 2106285.0 | 37.764112022223394 | -122.402986839965 | (37.7641120222234, -122.402986839965) | |||||
| 141667 | 141667 | 34617 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3299 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38300 | 5999016.0246967 | 2115927.38259794 | 37.789875646134895 | -122.44727418368 | (37.7898756461349, -122.44727418368) | ||
| 141550 | 141550 | 28505 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.77880883239779 | -122.406117215604 | (37.7788088323978, -122.406117215604) | |||
| 141184 | 141184 | 45193 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2001 12:00:00 AM | Permit Number 44037 | 5997793.88507772 | 2107168.4294301 | 37.765755930379704 | -122.45087082602 | (37.7657559303797, -122.45087082602) | ||
| 140635 | 140635 | 32637 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 778 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37083 | 6011766.14443501 | 2109713.24584796 | 37.773533368787106 | -122.402722477064 | (37.7735333687871, -122.402722477064) | ||
| 140537 | 140537 | 41705 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.733954758005794 | -122.431850206764 | (37.7339547580058, -122.431850206764) | ||
| 140209 | 140209 | 37586 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 2775 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40017 | 6001162.31345404 | 2105517.18376133 | 37.7614142693336 | -122.439101823773 | (37.7614142693336, -122.439101823773) | ||
| 140149 | 140149 | 38809 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 202 Townsend St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963120995 | 2111590.96099347 | 37.7788497186051 | -122.39287985258801 | (37.7788497186051, -122.392879852588) | ||
| 139388 | 139388 | 115867 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 139079 | 139079 | 50085 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46817 | 5992373.11163098 | 2098031.46456186 | 37.7403563861764 | -122.468954963559 | (37.7403563861764, -122.468954963559) | ||
| 138867 | 138867 | 38247 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.41515711380501 | (37.7684933273993, -122.415157113805) | |
| 138719 | 138719 | 46864 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | ||
| 138414 | 138414 | 42255 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 449 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42499 | 6011032.58907867 | 2112142.29283942 | 37.7801619842664 | -122.405431068184 | (37.7801619842664, -122.405431068184) | ||
| 137261 | 137261 | 222859 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 100 Church St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004077.69446 | 2108250.00646 | 37.76908339881629 | -122.429213605151 | (37.7690833988163, -122.429213605151) | |||
| 136942 | 136942 | 188460 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6011827.042669999 | 2109686.99498 | 37.7734646898654 | -122.40250997357 | (37.7734646898654, -122.40250997357) | |||
| 136116 | 136116 | 222865 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005579.30004 | 2102535.69949 | 37.7534781504092 | -122.423613303727 | (37.7534781504092, -122.423613303727) | |||
| 133142 | 133142 | 125957 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1047 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009453.06953 | 2117007.5192299997 | 37.7934322851104 | -122.41123914946199 | (37.7934322851104, -122.411239149462) | |||
| 132484 | 132484 | 59252 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 961 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 11 | Permit Number 18584 | 6007751.14837 | 2120241.22842 | 37.8022156478981 | -122.41735720767599 | (37.8022156478981, -122.417357207676) | ||
| 132217 | 132217 | 247474 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 850 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002489.937999999 | 2109552.4307 | 37.772569522732795 | -122.43479870425301 | (37.7725695227328, -122.434798704253) | |||
| 132154 | 132154 | 59247 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1987 12:00:00 AM | 10 | Permit Number 24729 | 6008002.901330001 | 2120325.62134 | 37.8024615306389 | -122.41649199961701 | (37.8024615306389, -122.416491999617) | |
| 132028 | 132028 | 32658 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 18 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 12 | Permit Number 37091 | 6011613.66818 | 2110190.11377 | 37.7748342242639 | -122.40328347056999 | (37.7748342242639, -122.40328347057) | |
| 131526 | 131526 | 78188 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 61 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 5 | 6007814.1581 | 2093767.18412 | 37.7295276448871 | -122.415263990666 | (37.7295276448871, -122.415263990666) | ||
| 131181 | 131181 | 125965 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 960 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007714.843640001 | 2120286.14045 | 37.8023369223605 | -122.41748602476801 | (37.8023369223605, -122.417486024768) | |||
| 130681 | 130681 | 175825 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6003581.23003 | 2087608.2042099999 | 37.7123776381814 | -122.429458597533 | (37.7123776381814, -122.429458597533) | |||
| 130456 | 130456 | 205978 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 26 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993683.84565 | 2099240.9868799997 | 37.7437530733501 | -122.464510801149 | (37.7437530733501, -122.464510801149) | |||
| 129865 | 129865 | 222882 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004605.27602 | 2097916.14759 | 37.740738898373706 | -122.42665275413201 | (37.7407388983737, -122.426652754132) | |||
| 129589 | 129589 | 188453 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011500.6075 | 2106371.58763 | 37.764343104663894 | -122.40340587818001 | (37.7643431046639, -122.40340587818) | |||
| 129275 | 129275 | 68712 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32625 | 6003279.54613576 | 2105963.01747728 | 37.762758666054395 | -122.43181103593099 | (37.7627586660544, -122.431811035931) | ||
| 129164 | 129164 | 35972 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 323 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39130 | 6006883.86528874 | 2096321.14092587 | 37.7364879223661 | -122.41866115506399 | (37.7364879223661, -122.418661155064) | ||
| 127524 | 127524 | 37556 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 4528 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1998 12:00:00 AM | Permit Number 39995 | 6000974.70295267 | 2104668.04462068 | 37.7590720640705 | -122.439689810342 | (37.7590720640705, -122.439689810342) | ||
| 126665 | 126665 | 52212 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | |||
| 126483 | 126483 | 49776 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 110 Talbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46562 | 6010272.64518115 | 2086887.71649918 | 37.710775910974704 | -122.406280195673 | (37.7107759109747, -122.406280195673) | ||
| 125202 | 125202 | 1546 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 501 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5995568.83899 | 2112743.54668 | 37.7809361120605 | -122.458970433284 | (37.7809361120605, -122.458970433284) | |||
| 124465 | 124465 | 115859 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 124458 | 124458 | 35063 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1600 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38619 | 5993105.16308773 | 2104567.76843585 | 37.7583456711152 | -122.46689889533 | (37.7583456711152, -122.46689889533) | ||
| 123628 | 123628 | 37175 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39748 | 6005894.17436162 | 2099270.44010947 | 37.7445302641925 | -122.42229242265101 | (37.7445302641925, -122.422292422651) | ||
| 123596 | 123596 | 50666 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 132 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | Permit Number 47245 | 5997808.46990271 | 2107170.46182714 | 37.7657623457378 | -122.450820527035 | (37.7657623457378, -122.450820527035) | |||
| 122479 | 122479 | 115863 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 120629 | 120629 | 52213 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | |||
| 120051 | 120051 | 175838 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994346.0156 | 2086520.6232200002 | 37.708864190212296 | -122.461299273568 | (37.7088641902123, -122.461299273568) |
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");