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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51641 | 51641 | 191459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014515.877119999 | 2115897.3284299998 | 37.790666595532606 | -122.393643582697 | (37.7906665955326, -122.393643582697) | |||
| 65316 | 65316 | 191478 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 33 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014500.76851 | 2112629.04154 | 37.781691790478796 | -122.39346703317499 | (37.7816917904788, -122.393467033175) | |||
| 72169 | 72169 | 191477 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 33 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6014491.1655 | 2112621.09872 | 37.781669447736796 | -122.393499699264 | (37.7816694477368, -122.393499699264) | |||
| 179227 | 179227 | 191458 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6014482.2077 | 2115927.0882900003 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | |||
| 50671 | 50671 | 60028 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 33 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | Permit Number 19516 | 6014481.96574 | 2112615.13715 | 37.7816525674538 | -122.393531108971 | (37.7816525674538, -122.393531108971) | |
| 134273 | 134273 | 191457 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6014474.3471099995 | 2115936.1277 | 37.7907708215543 | -122.393789992334 | (37.7907708215543, -122.393789992334) | |||
| 187456 | 187456 | 191461 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 26 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6014466.473259999 | 2112793.29077 | 37.782140875944 | -122.393597178563 | (37.782140875944, -122.393597178563) | |||
| 149263 | 149263 | 191456 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6014463.08258 | 2115949.76346 | 37.7908076361998 | -122.393829922227 | (37.7908076361998, -122.393829922227) | |||
| 131852 | 131852 | 191476 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 45 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014442.93612 | 2112579.76279 | 37.7815532688034 | -122.39366365735201 | (37.7815532688034, -122.393663657352) | |||
| 185760 | 185760 | 191462 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 44 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014434.11551 | 2112764.95464 | 37.7820612733549 | -122.393707138698 | (37.7820612733549, -122.393707138698) | |||
| 38703 | 38703 | 191455 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014431.23151 | 2115982.96922 | 37.7908970414242 | -122.393942451705 | (37.7908970414242, -122.393942451705) | |||
| 154413 | 154413 | 191475 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 45 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014428.205569999 | 2112560.71307 | 37.7815001440537 | -122.393713284646 | (37.7815001440537, -122.393713284646) | |||
| 155067 | 155067 | 191463 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 54 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014423.52986 | 2112756.14838 | 37.782036505133206 | -122.393743143935 | (37.7820365051332, -122.393743143935) | |||
| 32112 | 32112 | 191454 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.790927639935205 | -122.39397451700701 | (37.7909276399352, -122.393974517007) | |||
| 179685 | 179685 | 191464 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 54 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6014410.7663900005 | 2112744.50721 | 37.7820038318593 | -122.393786484975 | (37.7820038318593, -122.393786484975) | |||
| 156782 | 156782 | 191453 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6014408.51358 | 2116009.54729 | 37.790968756046794 | -122.39402291674 | (37.7909687560468, -122.39402291674) | |||
| 182407 | 182407 | 191465 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014398.12583 | 2112729.40877 | 37.781961672523295 | -122.393829158687 | (37.7819616725233, -122.393829158687) | |||
| 162552 | 162552 | 191452 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6014395.4165199995 | 2116019.0408900003 | 37.790994095352296 | -122.39406889728501 | (37.7909940953523, -122.394068897285) | |||
| 169859 | 169859 | 60021 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 76 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 14 | Permit Number 19508 | 6014385.60562 | 2112720.25781 | 37.781935850286004 | -122.393871832437 | (37.781935850286, -122.393871832437) | |
| 159114 | 159114 | 191451 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6014385.345480001 | 2116032.04037 | 37.7910292291593 | -122.39410465341001 | (37.7910292291593, -122.39410465341) | |||
| 58120 | 58120 | 40227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 101 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1999 12:00:00 AM | 12 | Permit Number 41410 | 6014381.3439 | 2112518.0178400003 | 37.78138030849961 | -122.39387241520001 | (37.7813803084996, -122.3938724152) | ||
| 129943 | 129943 | 60037 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 84 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 13 | Permit Number 19526 | 6014370.64542 | 2112704.82281 | 37.7818926378878 | -122.393922507437 | (37.7818926378878, -122.393922507437) | |
| 132410 | 132410 | 191466 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 86 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6014334.8442400005 | 2112669.08128 | 37.781792510068996 | -122.394043861033 | (37.781792510069, -122.394043861033) | |||
| 39043 | 39043 | 191474 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6014326.7569699995 | 2112466.04784 | 37.781234576959896 | -122.39405762156 | (37.7812345769599, -122.39405762156) | |||
| 62477 | 62477 | 191473 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6014315.40863 | 2112455.42682 | 37.7812047833188 | -122.39409613774599 | (37.7812047833188, -122.394096137746) | |||
| 166395 | 166395 | 191467 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6014304.88923 | 2112665.08125 | 37.781779861995794 | -122.394147212029 | (37.7817798619958, -122.394147212029) | |||
| 171205 | 171205 | 60035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 135 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 15 | Permit Number 19524 | 6014295.81848 | 2112435.53684 | 37.7811490811156 | -122.39416251758101 | (37.7811490811156, -122.394162517581) | |
| 31932 | 31932 | 191468 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014292.29593 | 2112680.8823700002 | 37.7818225483087 | -122.394191885869 | (37.7818225483087, -122.394191885869) | |||
| 29762 | 29762 | 191469 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014280.37989 | 2112692.06341 | 37.7818525865622 | -122.39423389317699 | (37.7818525865622, -122.394233893177) | |||
| 40077 | 40077 | 191470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014270.7643099995 | 2112702.62209 | 37.7818810438134 | -122.39426789834499 | (37.7818810438134, -122.394267898345) | |||
| 75453 | 75453 | 60026 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 104 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19514 | 6014265.094769999 | 2112604.60863 | 37.781611606035 | -122.394280648053 | (37.781611606035, -122.394280648053) | |
| 24070 | 24070 | 60036 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 147 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 12 | Permit Number 19525 | 6014255.98068 | 2112398.36524 | 37.781044802010705 | -122.394297734267 | (37.7810448020107, -122.394297734267) | |
| 57357 | 57357 | 60034 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 108 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 7 | Permit Number 19523 | 6014255.56955 | 2112594.8494700002 | 37.7815842801353 | -122.39431291753401 | (37.7815842801353, -122.394312917534) | |
| 27045 | 27045 | 72016 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 10 | 6014238.82874 | 2112579.70736 | 37.7815417727734 | -122.394369772655 | (37.7815417727734, -122.394369772655) | ||
| 145562 | 145562 | 60025 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 155 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | Permit Number 19512 | 6014214.21813778 | 2112495.49732401 | 37.7813091831039 | -122.39444901599899 | (37.7813091831039, -122.394449015999) | ||
| 69567 | 69567 | 191472 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 171 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014194.16653 | 2112375.55603 | 37.7809787369144 | -122.39450998415701 | (37.7809787369144, -122.394509984157) | |||
| 26846 | 26846 | 60031 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 16 | Permit Number 19519 | 6014189.65421 | 2112531.72054 | 37.7814072782548 | -122.394536533027 | (37.7814072782548, -122.394536533027) | |
| 95774 | 95774 | 39881 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 21 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1999 12:00:00 AM | Permit Number 41174 | 6014188.8231878 | 2113135.05532668 | 37.783063851701705 | -122.39458166928499 | (37.7830638517017, -122.394581669285) | ||
| 167774 | 167774 | 191471 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 171 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014161.57896 | 2112368.90341 | 37.780958658664105 | -122.394622255529 | (37.7809586586641, -122.394622255529) | |||
| 72931 | 72931 | 72136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 535 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1990 12:00:00 AM | 9 | 6014127.25361 | 2104594.96459 | 37.759611242589706 | -122.39419658392099 | (37.7596112425897, -122.394196583921) | ||
| 27190 | 27190 | 60024 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 181 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1982 12:00:00 AM | 14 | Permit Number 19511 | 6014126.74175 | 2112333.046 | 37.7808582655241 | -122.394740263669 | (37.7808582655241, -122.394740263669) | |
| 73946 | 73946 | 67716 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 560 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 18 | 4x9 | Permit Number 31329 | 6014049.2852300005 | 2112210.3700599996 | 37.7805171185161 | -122.394999630825 | (37.7805171185161, -122.394999630825) |
| 177365 | 177365 | 191447 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1300 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 15 | Width 5ft | 6014017.68905 | 2096332.11237 | 37.7369171097253 | -122.393997082801 | (37.7369171097253, -122.393997082801) | |||
| 42572 | 42572 | 67593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 357 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31160 | 6013799.73337 | 2105430.83352 | 37.7618881461485 | -122.395387878055 | (37.7618881461485, -122.395387878055) | |
| 164660 | 164660 | 67592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 355 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 8 | Permit Number 31159 | 6013796.23882 | 2105471.52113 | 37.7619996710595 | -122.39540281491199 | (37.7619996710595, -122.395402814912) | |
| 163117 | 163117 | 191445 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 19th St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013335.759880001 | 2105192.0474900003 | 37.761206675862205 | -122.396975847857 | (37.7612066758622, -122.396975847857) | |||
| 45665 | 45665 | 57616 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 455 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 11 | Permit Number 22179 | 6013266.46923 | 2104945.7243 | 37.7605264691381 | -122.397198223232 | (37.7605264691381, -122.397198223232) | |
| 37738 | 37738 | 62093 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 421 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 12 | Permit Number 22182 | 6013256.61588 | 2105083.54347 | 37.760904341792 | -122.397241966241 | (37.760904341792, -122.397241966241) | |
| 143161 | 143161 | 62092 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 427 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | Permit Number 22181 | 6013254.84660542 | 2105078.89675682 | 37.7608914844372 | -122.397247759573 | (37.7608914844372, -122.397247759573) | ||
| 135754 | 135754 | 62094 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 415 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 10 | Permit Number 22183 | 6013254.03052 | 2105108.1707 | 37.7609718188263 | -122.39725263492399 | (37.7609718188263, -122.397252634924) | |
| 75355 | 75355 | 57997 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 407 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | 10 | Permit Number 22184 | 6013252.809230001 | 2105139.22095 | 37.761057008003796 | -122.397259036287 | (37.7610570080038, -122.397259036287) | |
| 179036 | 179036 | 62083 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 11 | Permit Number 22167 | 6013240.89819 | 2104321.43892 | 37.758810894525794 | -122.397242884449 | (37.7588108945258, -122.397242884449) | |
| 179397 | 179397 | 101144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 2x2 | 6013206.1129 | 2104955.38983 | 37.7605496482619 | -122.397407647447 | (37.7605496482619, -122.397407647447) | |||
| 67888 | 67888 | 101143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6013205.5803 | 2104971.74956 | 37.760594538837296 | -122.397410636805 | (37.7605945388373, -122.397410636805) | |||
| 155356 | 155356 | 101145 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 6013204.93498 | 2104939.92488 | 37.7605071193183 | -122.397410636789 | (37.7605071193183, -122.397410636789) | |||
| 140523 | 140523 | 62091 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1401 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1985 12:00:00 AM | Permit Number 22178 | 6013163.83149517 | 2106111.21456306 | 37.763720934190395 | -122.397634949335 | (37.7637209341904, -122.397634949335) | ||
| 153647 | 153647 | 191443 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 394 19th St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6013161.12259 | 2105230.3834700002 | 37.7613022153415 | -122.397582536801 | (37.7613022153415, -122.397582536801) | |||
| 37951 | 37951 | 177075 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013151.428830001 | 2086913.1361599998 | 37.711006322265 | -122.396332172488 | (37.711006322265, -122.396332172488) | |||
| 180465 | 180465 | 191444 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 2ft | 6013146.00458 | 2106079.844 | 37.763633804867 | -122.397694407074 | (37.763633804867, -122.397694407074) | |||
| 125956 | 125956 | 40954 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 117 Gillette Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41809 | 6013102.88048258 | 2086808.22702407 | 37.7107155607107 | -122.396492619427 | (37.7107155607107, -122.396492619427) | ||||
| 64520 | 64520 | 191436 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1401 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013098.64542 | 2106113.56036 | 37.7637237451866 | -122.397860573921 | (37.7637237451866, -122.397860573921) | |||
| 55233 | 55233 | 177086 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 114 Gillette Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6013074.44499 | 2086867.89295 | 37.7108778091238 | -122.39659507942301 | (37.7108778091238, -122.396595079423) | |||
| 10409 | 10409 | 104687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | |||
| 86603 | 86603 | 114790 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100x GILLETTE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013060.0 | 2086881.0 | 37.7109129945759 | -122.39664592325 | (37.7109129945759, -122.39664592325) | ||||
| 65681 | 65681 | 54939 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 537 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 7 | Permit Number 10817 | 6013054.91789 | 2086947.83958 | 37.7110962400835 | -122.396668170907 | (37.7110962400835, -122.396668170907) | ||
| 11719 | 11719 | 54938 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 540 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 14 | 4x3 | Permit Number 10816 | 6013051.4266099995 | 2086907.8440900003 | 37.7109862260136 | -122.39667743572599 | (37.7109862260136, -122.396677435726) | |
| 156751 | 156751 | 54754 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 525 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 16 | Permit Number 10602 | 6013004.6612 | 2086964.21665 | 37.7111384110727 | -122.396843018889 | (37.7111384110727, -122.396843018889) | ||
| 159795 | 159795 | 177087 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012854.2238300005 | 2086908.7049900002 | 37.710977612288794 | -122.397359080471 | (37.7109776122888, -122.397359080471) | |||
| 36952 | 36952 | 177076 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012816.17748 | 2087024.5576799999 | 37.711293602592896 | -122.397498698426 | (37.7112936025929, -122.397498698426) | |||
| 151424 | 151424 | 177077 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012777.255059999 | 2087037.0196900002 | 37.7113256535156 | -122.39763409854099 | (37.7113256535156, -122.397634098541) | |||
| 173389 | 173389 | 177078 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012757.34984 | 2087044.1812200001 | 37.71134420923121 | -122.397703398489 | (37.7113442092312, -122.397703398489) | |||
| 156887 | 156887 | 177079 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 411 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012724.51952 | 2087052.8334599999 | 37.7113661383121 | -122.397817475721 | (37.7113661383121, -122.397817475721) | |||
| 55331 | 55331 | 177080 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 411 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012673.3507900005 | 2087069.8441 | 37.7114099964555 | -122.397995521673 | (37.7114099964555, -122.397995521673) | |||
| 76192 | 76192 | 191481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 526 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012554.15249 | 2111142.6647900003 | 37.777502192597495 | -122.40009702957799 | (37.7775021925975, -122.400097029578) | |||
| 169584 | 169584 | 191480 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 526 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012537.84104 | 2111160.5359 | 37.7775503530914 | -122.400154712085 | (37.7775503530914, -122.400154712085) | |||
| 161895 | 161895 | 191479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 526 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6012522.42576 | 2111176.28412 | 37.7775927345574 | -122.400209145359 | (37.7775927345574, -122.400209145359) | |||
| 133724 | 133724 | 191484 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6012469.2774 | 2111178.20326 | 37.7775950404069 | -122.400393139428 | (37.7775950404069, -122.400393139428) | |||
| 45322 | 45322 | 191483 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6012443.09783 | 2111154.5350900004 | 37.7775285931066 | -122.40048204100701 | (37.7775285931066, -122.400482041007) | |||
| 131905 | 131905 | 191482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6012422.29694 | 2111134.3733 | 37.7774720734215 | -122.40055258204599 | (37.7774720734215, -122.400552582046) | |||
| 45077 | 45077 | 177085 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 466 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012392.66028 | 2086405.7608400001 | 37.7095709179289 | -122.39891908764099 | (37.7095709179289, -122.398919087641) | |||
| 186625 | 186625 | 61561 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2018 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 13 | Permit Number 21521 | 6012372.92464 | 2102851.20002 | 37.754725580248 | -122.40014150193399 | (37.754725580248, -122.400141501934) | |
| 74977 | 74977 | 74222 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 10 | 6012358.62681 | 2102848.31202 | 37.7547168532055 | -122.400190745215 | (37.7547168532055, -122.400190745215) | ||
| 186971 | 186971 | 72130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | ||
| 30331 | 30331 | 177074 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 250 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012293.95082 | 2087148.96015 | 37.711606095404704 | -122.399312384552 | (37.7116060954047, -122.399312384552) | |||
| 136150 | 136150 | 191437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300x De Haro St | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012282.34359 | 2102012.29375 | 37.7524170754114 | -122.400395836501 | (37.7524170754114, -122.400395836501) | ||||
| 36975 | 36975 | 177081 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 299 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012270.95689 | 2087199.0340099998 | 37.711742306725995 | -122.39939537131 | (37.711742306726, -122.39939537131) | |||
| 37287 | 37287 | 177073 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 250 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012250.9341 | 2087164.6168900002 | 37.7116466881279 | -122.399462161252 | (37.7116466881279, -122.399462161252) | |||
| 54890 | 54890 | 106128 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6012212.28641 | 2101900.78254 | 37.75210698286921 | -122.400630274471 | (37.7521069828692, -122.400630274471) | ||||
| 181991 | 181991 | 191439 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2205 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.751993394903295 | -122.40070234973801 | (37.7519933949033, -122.400702349738) | |||
| 187508 | 187508 | 191440 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2212 25th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6012152.298359999 | 2101896.5627900003 | 37.75209205051161 | -122.40083742701401 | (37.7520920505116, -122.400837427014) | |||
| 42209 | 42209 | 191438 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2209 25th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012142.94506 | 2101858.42279 | 37.7519868046503 | -122.400867092959 | (37.7519868046503, -122.400867092959) | ||||
| 106974 | 106974 | 25707 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 582 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6012142.68592 | 2110270.08873 | 37.7750833484994 | -122.401459098675 | (37.7750833484994, -122.401459098675) | |||
| 144898 | 144898 | 31669 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 301 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1995 12:00:00 AM | Permit Number 35177 | 6012138.91947495 | 2087210.17556421 | 37.7117655390688 | -122.399852513423 | (37.7117655390688, -122.399852513423) | |||
| 78027 | 78027 | 107959 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 108302 | 108302 | 107956 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 23037 | 23037 | 25706 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 582 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6012130.73474 | 2110269.98363 | 37.7750823930813 | -122.401500433298 | (37.7750823930813, -122.401500433298) | |||
| 155845 | 155845 | 129674 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012104.09602 | 2116801.48556 | 37.793014886365796 | -122.402051854416 | (37.7930148863658, -122.402051854416) | |||
| 16260 | 16260 | 25705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X2 | 6012100.37031 | 2110300.97089 | 37.7751657827012 | -122.40160764957399 | (37.7751657827012, -122.401607649574) | |||
| 166593 | 166593 | 191441 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2250 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012095.50182 | 2101892.00289 | 37.7520763618475 | -122.40103351879101 | (37.7520763618475, -122.401033518791) | |||
| 51625 | 51625 | 129675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012092.09526 | 2116799.4138599997 | 37.79300852816029 | -122.402093232241 | (37.7930085281603, -122.402093232241) |
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");