Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188761 | 188761 | 220670 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | |||
| 188143 | 188143 | 220086 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 77 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001721.7342 | 2105412.03314 | 37.761157366929204 | -122.43715949493601 | (37.7611573669292, -122.437159494936) | |||
| 188075 | 188075 | 220035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.34581 | 2100467.82106 | 37.7476336866458 | -122.433642882219 | (37.7476336866458, -122.433642882219) | |||
| 186973 | 186973 | 220091 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3076 Merritt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000057.55788 | 2105416.72092 | 37.7610754998513 | -122.442915486985 | (37.7610754998513, -122.442915486985) | |||
| 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) | ||
| 186555 | 186555 | 203630 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1400 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 5993843.17005 | 2094826.47883 | 37.731641116434496 | -122.46363957301 | (37.7316411164345, -122.46363957301) | |||
| 185639 | 185639 | 40169 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1901 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1999 12:00:00 AM | 0 | Permit Number 41362 | 6000480.4385885 | 2111652.95524414 | 37.7782227381789 | -122.44190053998399 | (37.7782227381789, -122.441900539984) | |
| 185361 | 185361 | 220004 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1142 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008637.13035 | 2101883.29537 | 37.751858924657796 | -122.412992509104 | (37.7518589246578, -122.412992509104) | |||
| 185230 | 185230 | 219990 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 151 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999384.54447 | 2107324.60583 | 37.766275682101 | -122.445380326357 | (37.766275682101, -122.445380326357) | |||
| 185029 | 185029 | 220006 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 887 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007588.24314 | 2104555.6978700003 | 37.75913779629921 | -122.41680902861602 | (37.7591377962992, -122.416809028616) | |||
| 184798 | 184798 | 248081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.40662106962799 | (37.7472540585408, -122.406621069628) | |||
| 184246 | 184246 | 51499 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1518 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | 1 | Permit Number 47812 | 5983133.1181 | 2104773.3328 | 37.758329497976 | -122.501401269082 | (37.758329497976, -122.501401269082) | ||
| 184019 | 184019 | 245165 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000037.7937 | 2109212.4329 | 37.7714964504984 | -122.443256472847 | (37.7714964504984, -122.443256472847) | |||
| 183876 | 183876 | 246998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 33 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004927.947919999 | 2101037.11705 | 37.7493266028416 | -122.42575916347602 | (37.7493266028416, -122.425759163476) | |||
| 183611 | 183611 | 220078 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003547.22001 | 2104169.9563599997 | 37.7578505193113 | -122.430757284236 | (37.7578505193113, -122.430757284236) | |||
| 183501 | 183501 | 203636 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 418 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997970.50252 | 2094115.71728 | 37.7299264906074 | -122.449319440552 | (37.7299264906074, -122.449319440552) | |||
| 182704 | 182704 | 32332 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 12 | Permit Number 36896 | 6006735.75103 | 2098040.81049 | 37.741201412511295 | -122.419295203505 | (37.7412014125113, -122.419295203505) | ||
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 180724 | 180724 | 220669 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007464.462180001 | 2105680.20341 | 37.7622184653282 | -122.41731681192199 | (37.7622184653282, -122.417316811922) | |||
| 180377 | 180377 | 31436 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4336 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 12 | Permit Number 35011 | 6000994.34179 | 2103320.5787299997 | 37.7553733681958 | -122.439525295576 | (37.7553733681958, -122.439525295576) | |
| 179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
| 178755 | 178755 | 220034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 622 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002480.9934 | 2100067.1600599997 | 37.7465247497217 | -122.43415144344699 | (37.7465247497217, -122.434151443447) | |||
| 178540 | 178540 | 220003 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6009365.07591 | 2096886.4272 | 37.738179459299296 | -122.410122419925 | (37.7381794592993, -122.410122419925) | |||
| 178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
| 178198 | 178198 | 220092 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 24 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006394.365680001 | 2110096.52086 | 37.774284361671 | -122.42133150875601 | (37.774284361671, -122.421331508756) | |||
| 177746 | 177746 | 67583 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1081 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31148 | 6011670.3331699995 | 2103332.09659 | 37.756006816477104 | -122.40260508405198 | (37.7560068164771, -122.402605084052) | |
| 177028 | 177028 | 220692 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.986740001 | 2100702.91409 | 37.7483660981244 | -122.42835639293999 | (37.7483660981244, -122.42835639294) | |||
| 176862 | 176862 | 38050 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47797 | 6000529.6397 | 2114492.1859 | 37.786021340576205 | -122.441934174319 | (37.7860213405762, -122.441934174319) | |
| 175791 | 175791 | 220665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 215 Webster St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004174.507619999 | 2109590.46036 | 37.7727694393 | -122.42897431622801 | (37.7727694393, -122.428974316228) | |||
| 175760 | 175760 | 220061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 496 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006778.4719 | 2100919.5429 | 37.749108169217294 | -122.41935165935101 | (37.7491081692173, -122.419351659351) | |||
| 174318 | 174318 | 220076 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4512 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6001006.90228 | 2104666.0365299997 | 37.7590683830131 | -122.43957830609 | (37.7590683830131, -122.43957830609) | |||
| 174105 | 174105 | 220030 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6002251.88877 | 2102392.9278 | 37.752897751333705 | -122.435109978657 | (37.7528977513337, -122.435109978657) | |||
| 173732 | 173732 | 34626 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1474 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 0 | Permit Number 38308 | 5988706.220433701 | 2105294.39494794 | 37.760085918568 | -122.48216543102 | (37.760085918568, -122.48216543102) | |
| 173679 | 173679 | 30757 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1553 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 11 | Permit Number 34638 | 6014989.6074 | 2093734.2507 | 37.729837877239795 | -122.390455236274 | (37.7298378772398, -122.390455236274) | |
| 173012 | 173012 | 220020 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001963.20475 | 2100104.97494 | 37.7465991794258 | -122.435944602583 | (37.7465991794258, -122.435944602583) | |||
| 172135 | 172135 | 220019 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4326 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001759.60763 | 2100322.6693 | 37.747185348536895 | -122.436664198694 | (37.7471853485369, -122.436664198694) | |||
| 171472 | 171472 | 219996 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 80 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007954.3059 | 2099409.5241799997 | 37.7450281501379 | -122.415178725923 | (37.7450281501379, -122.415178725923) | |||
| 170961 | 170961 | 219988 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998797.49873 | 2106712.69483 | 37.7645619996538 | -122.447366750686 | (37.7645619996538, -122.447366750686) | |||
| 170817 | 170817 | 220681 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3223 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009028.25622 | 2099907.20942 | 37.74645498032329 | -122.41150033867201 | (37.7464549803233, -122.411500338672) | |||
| 170794 | 170794 | 220080 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002959.284990001 | 2103850.36087 | 37.756939658960206 | -122.432767777111 | (37.7569396589602, -122.432767777111) | |||
| 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) | |||
| 170022 | 170022 | 220032 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4496 24th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6000063.08667 | 2101692.20447 | 37.7508492036437 | -122.442628935085 | (37.7508492036437, -122.442628935085) | |||
| 169675 | 169675 | 203643 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.47245922253201 | (37.7417056300124, -122.472459222532) | |||
| 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) | ||
| 168115 | 168115 | 34234 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1997 12:00:00 AM | 9 | Permit Number 38047 | 6009059.1086 | 2121116.8197 | 37.8046933049163 | -122.41289295806801 | (37.8046933049163, -122.412892958068) | ||
| 167841 | 167841 | 43170 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 364 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 2 | Permit Number 42979 | 6005800.19112 | 2092023.1560099998 | 37.724625531232796 | -122.42210263603701 | (37.7246255312328, -122.422102636037) | |
| 166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
| 165790 | 165790 | 55817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1479 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50161 | 5982146.8936 | 2105055.9033 | 37.759047387316706 | -122.50483294742399 | (37.7590473873167, -122.504832947424) | |
| 165659 | 165659 | 203641 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 608 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992400.09934 | 2090515.7050700001 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | |||
| 163609 | 163609 | 43173 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 382 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42982 | 6005820.96717 | 2091946.15603 | 37.7244152778362 | -122.42202534828999 | (37.7244152778362, -122.42202534829) | |
| 162807 | 162807 | 220072 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002632.838880001 | 2105513.14285 | 37.7614867382526 | -122.434015605341 | (37.7614867382526, -122.434015605341) | |||
| 162456 | 162456 | 220024 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4273 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002125.33793 | 2101175.24323 | 37.749547092337 | -122.435460513693 | (37.749547092337, -122.435460513693) | |||
| 162381 | 162381 | 40685 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 114 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41668 | 6004151.556609999 | 2094012.13266 | 37.7299936942445 | -122.42794342066001 | (37.7299936942445, -122.42794342066) | |
| 162001 | 162001 | 220694 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4054 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003525.2287099995 | 2100710.43544 | 37.74835024488029 | -122.430586486796 | (37.7483502448803, -122.430586486796) | |||
| 161989 | 161989 | 219992 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007124.70017 | 2098812.5831299997 | 37.7433424258272 | -122.41800505138501 | (37.7433424258272, -122.418005051385) | |||
| 161597 | 161597 | 220697 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | |||
| 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) | ||
| 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) | |||
| 160608 | 160608 | 220073 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 147 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002697.135559999 | 2105044.08938 | 37.7602024793668 | -122.433759704173 | (37.7602024793668, -122.433759704173) | |||
| 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) | |||
| 158356 | 158356 | 220012 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006012.224219999 | 2102309.19405 | 37.7528806462302 | -122.42210006667601 | (37.7528806462302, -122.422100066676) | |||
| 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) | |||
| 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) | |||
| 157511 | 157511 | 44744 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1520 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2001 12:00:00 AM | 6 | Permit Number 43862 | 6006848.33301 | 2117722.6808 | 37.7952495146165 | -122.420302532344 | (37.7952495146165, -122.420302532344) | ||
| 157166 | 157166 | 220088 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 18 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001975.9163 | 2107746.07495 | 37.767580520153 | -122.43644744680701 | (37.767580520153, -122.436447446807) | |||
| 157007 | 157007 | 220696 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 407 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998482.20862 | 2106820.01065 | 37.764838640103505 | -122.44846497847799 | (37.7648386401035, -122.448464978478) | |||
| 156715 | 156715 | 220671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009657.24605 | 2096276.1729599999 | 37.7365202047272 | -122.409069188799 | (37.7365202047272, -122.409069188799) | |||
| 156125 | 156125 | 38044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1523 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 11 | Permit Number 40245 | 6000092.6356 | 2114341.0582 | 37.785581471348706 | -122.443435225951 | (37.7855814713487, -122.443435225951) | |
| 155839 | 155839 | 220013 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005865.660759999 | 2102301.94093 | 37.7528524632741 | -122.42260639578998 | (37.7528524632741, -122.42260639579) | |||
| 155339 | 155339 | 31136 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 371 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34851 | 5998968.1475599995 | 2094360.3261099998 | 37.730655144717105 | -122.445888061981 | (37.7306551447171, -122.445888061981) | |
| 154995 | 154995 | 32348 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1201 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37068 | 5985188.5725 | 2106987.4184 | 37.764529258945 | -122.49445591941799 | (37.764529258945, -122.494455919418) | |
| 154694 | 154694 | 220683 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004832.893569999 | 2109879.94078 | 37.7736015271323 | -122.426717502624 | (37.7736015271323, -122.426717502624) | |||
| 154249 | 154249 | 34233 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1690 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 8 | Permit Number 38046 | 5989683.0382 | 2103856.1412 | 37.7561936262155 | -122.47868193754299 | (37.7561936262155, -122.478681937543) | ||
| 153681 | 153681 | 44451 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 81 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 10 | Permit Number 48336 | 6002602.78622 | 2086898.2858 | 37.710372910849706 | -122.43278970978001 | (37.7103729108497, -122.43278970978) | |
| 153405 | 153405 | 50382 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1330 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2003 12:00:00 AM | 4 | Permit Number 47040 | 6006491.715 | 2119759.4717 | 37.8008219271374 | -122.421681226333 | (37.8008219271374, -122.421681226333) | ||
| 153239 | 153239 | 220071 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3854 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003950.57262 | 2104825.46317 | 37.7596732292507 | -122.429409067394 | (37.7596732292507, -122.429409067394) | |||
| 152749 | 152749 | 203644 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.76282 | 2098712.81343 | 37.742153485208796 | -122.47341079698799 | (37.7421534852088, -122.473410796988) | |||
| 152597 | 152597 | 220675 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005766.61271 | 2104299.30973 | 37.758331185361 | -122.423090881238 | (37.758331185361, -122.423090881238) | |||
| 152367 | 152367 | 219998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005981.24616 | 2097649.7003900004 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | |||
| 152179 | 152179 | 220084 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3580 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004538.52309 | 2103691.84305 | 37.7565938462521 | -122.427294885373 | (37.7565938462521, -122.427294885373) | |||
| 151645 | 151645 | 38575 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1511 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40535 | 6015329.8173 | 2094876.8945 | 37.732994214171704 | -122.389358843431 | (37.7329942141717, -122.389358843431) | |
| 151042 | 151042 | 203622 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997339.998380001 | 2099579.33016 | 37.7448921672303 | -122.45189316446002 | (37.7448921672303, -122.45189316446) | |||
| 150848 | 150848 | 42651 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1924 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 9 | Permit Number 42691 | 6004339.89147 | 2118073.8812599997 | 37.7960721541703 | -122.42900719184799 | (37.7960721541703, -122.429007191848) | |
| 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) | ||
| 150176 | 150176 | 38055 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1999 12:00:00 AM | 5 | Permit Number 40250 | 6000228.6146 | 2114392.8852 | 37.78573152849079 | -122.442968502827 | (37.7857315284908, -122.442968502827) | |
| 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) | |||
| 149284 | 149284 | 64511 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 833 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 11 | Permit Number 25392 | 6000435.9873 | 2111865.4379 | 37.7788036283278 | -122.442069568781 | (37.7788036283278, -122.442069568781) | |
| 149197 | 149197 | 203647 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993596.72892 | 2093377.0999599998 | 37.7276472749004 | -122.46438636913099 | (37.7276472749004, -122.464386369131) | |||
| 148872 | 148872 | 31585 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1894 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49864 | 5988492.0785 | 2102440.4028 | 37.7522371668693 | -122.482696889121 | (37.7522371668693, -122.482696889121) | |
| 148631 | 148631 | 60312 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 545 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1982 12:00:00 AM | 10 | Permit Number 19882 | 5999669.64 | 2110412.2941 | 37.774769964844 | -122.444616185093 | (37.774769964844, -122.444616185093) | ||
| 148365 | 148365 | 203637 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 270 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998290.1238 | 2093810.02027 | 37.7291053960882 | -122.448192473116 | (37.7291053960882, -122.448192473116) | |||
| 148095 | 148095 | 220085 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 223 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004732.04309 | 2103949.70152 | 37.757312807464 | -122.42664398483299 | (37.757312807464, -122.426643984833) | |||
| 147911 | 147911 | 220060 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006048.59787 | 2101976.73727 | 37.751969847944295 | -122.42195066499599 | (37.7519698479443, -122.421950664996) | |||
| 147832 | 147832 | 42896 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2016 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 6 | Permit Number 42813 | 5986675.0189 | 2096952.6028 | 37.737063252741706 | -122.488577172427 | (37.7370632527417, -122.488577172427) | |
| 146931 | 146931 | 220695 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3706 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004965.60953 | 2102543.32238 | 37.7534644213631 | -122.425736121051 | (37.7534644213631, -122.425736121051) | |||
| 146049 | 146049 | 67801 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 881 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31447 | 6000722.425257199 | 2102556.2611987 | 37.753259258073705 | -122.44041084963301 | (37.7532592580737, -122.440410849633) | ||
| 146004 | 146004 | 203662 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 337 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5999398.70847 | 2094267.55477 | 37.7304249920009 | -122.44439288782301 | (37.7304249920009, -122.444392887823) | |||
| 145931 | 145931 | 49975 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1337@ 14th Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/2003 12:00:00 AM | Permit Number 46726 | 6007190.27597203 | 2107705.69793456 | 37.7677645693117 | -122.418408745471 | (37.7677645693117, -122.418408745471) | ||
| 145889 | 145889 | 49841 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622@ CASTRO 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2003 12:00:00 AM | Permit Number 46624 | 6002475.85227317 | 2100073.54426279 | 37.746541987453604 | -122.434169677199 | (37.7465419874536, -122.434169677199) | |||
| 145627 | 145627 | 38582 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1565 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | Permit Number 40542 | 6015429.1390942 | 2094459.97574961 | 37.7318549452945 | -122.388986360684 | (37.7318549452945, -122.388986360684) |
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");