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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5792 | 5792 | 10690 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001959.267000001 | 2110474.8139 | 37.7750720141838 | -122.43670038449801 | (37.7750720141838, -122.436700384498) | |||
| 7598 | 7598 | 103885 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999418.3529 | 2110865.7399 | 37.7760006689038 | -122.445518048679 | (37.7760006689038, -122.445518048679) | ||||
| 19697 | 19697 | 85509 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 38222 | 38222 | 103892 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999308.7043 | 2110849.4957 | 37.7759498061666 | -122.44589618201 | (37.7759498061666, -122.44589618201) | |||
| 49836 | 49836 | 103888 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5999371.6507 | 2110859.3099 | 37.775980347483504 | -122.44567914075701 | (37.7759803474835, -122.445679140757) | |||
| 50236 | 50236 | 103891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5999322.5796 | 2110851.5262 | 37.7759561736689 | -122.445848329979 | (37.7759561736689, -122.445848329979) | |||
| 55462 | 55462 | 113717 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991400.52029 | 2110673.00421 | 37.775010478076794 | -122.47323950591299 | (37.7750104780768, -122.473239505913) | |||
| 64612 | 64612 | 103889 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5999356.4217 | 2110857.6178 | 37.7759748319201 | -122.44573169994499 | (37.7759748319201, -122.445731699945) | |||
| 77508 | 77508 | 85510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 84999 | 84999 | 87024 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 650 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49965 | 6001199.0 | 2102605.0 | 37.753420207362296 | -122.438766252724 | (37.7534202073623, -122.438766252724) | |||
| 88925 | 88925 | 50661 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 92174 | 92174 | 50672 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3305 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.789855679639295 | -122.447431022041 | (37.7898556796393, -122.447431022041) | ||||
| 98056 | 98056 | 111844 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||||
| 98067 | 98067 | 98339 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3434 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992637.0 | 2110058.2 | 37.77339390860929 | -122.468917542393 | (37.7733939086093, -122.468917542393) | ||||
| 98941 | 98941 | 117044 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2297 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001629.48989293 | 2114242.74964382 | 37.785399064529294 | -122.438111123258 | (37.7853990645293, -122.438111123258) | |||
| 99995 | 99995 | 103895 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999354.6 | 2110868.3 | 37.7760040584969 | -122.44573877005101 | (37.7760040584969, -122.445738770051) | ||||
| 103976 | 103976 | 98341 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 790X 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | |||
| 108074 | 108074 | 103894 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999354.6 | 2110868.3 | 37.7760040584969 | -122.44573877005101 | (37.7760040584969, -122.445738770051) | ||||
| 108504 | 108504 | 85500 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 110784 | 110784 | 50673 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3305 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47252 | 5998970.56266258 | 2115921.05690667 | 37.789855679639295 | -122.447431022041 | (37.7898556796393, -122.447431022041) | ||||
| 117346 | 117346 | 85502 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 118346 | 118346 | 85501 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Nebraska St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 125783 | 125783 | 50663 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 125899 | 125899 | 98340 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 790X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5992573.13535 | 2110349.8527 | 37.7741910183852 | -122.469159688197 | (37.7741910183852, -122.469159688197) | |||
| 140001 | 140001 | 50664 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 145318 | 145318 | 50662 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Santa Ynez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47244 | 6000978.87890111 | 2091807.60057831 | 37.723760552916296 | -122.43875382021002 | (37.7237605529163, -122.43875382021) | ||||
| 154629 | 154629 | 113718 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991385.6612 | 2110673.31757 | 37.7750104780928 | -122.473290929077 | (37.7750104780928, -122.473290929077) | |||
| 167511 | 167511 | 103887 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5999387.5565 | 2110861.3404 | 37.7759868308232 | -122.44562426468201 | (37.7759868308232, -122.445624264682) | |||
| 175370 | 175370 | 103893 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5999294.1521 | 2110847.1267 | 37.7759424705585 | -122.445946351246 | (37.7759424705585, -122.445946351246) | |||
| 188390 | 188390 | 103890 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1750 Fulton St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999343.5617 | 2110855.9257 | 37.7759694515949 | -122.445776064165 | (37.7759694515949, -122.445776064165) | |||
| 69451 | 69451 | 38054 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2779 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/01/1999 12:00:00 AM | 7 | Permit Number 40250 | 6000242.4339 | 2114393.9483 | 37.7857352353713 | -122.442920768491 | (37.7857352353713, -122.442920768491) | |
| 96037 | 96037 | 67840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3848 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31508 | 6004878.46361538 | 2100495.10573235 | 37.7478355684339 | -122.425891704855 | (37.7478355684339, -122.425891704855) | ||
| 107539 | 107539 | 67849 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 418 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31518 | 6003175.81702239 | 2098647.04119394 | 37.74266484418929 | -122.43164744857701 | (37.7426648441893, -122.431647448577) | ||
| 90373 | 90373 | 64794 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 700 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25792 | 6001971.04512503 | 2100046.68918075 | 37.7464395858784 | -122.435913321642 | (37.7464395858784, -122.435913321642) | ||
| 103932 | 103932 | 56190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 769105 | 6003484.93305407 | 2101537.01707568 | 37.750617561594204 | -122.43078480700399 | (37.7506175615942, -122.430784807004) | ||
| 18568 | 18568 | 39703 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41088 | 5998596.64163755 | 2094795.02743762 | 37.7318275120035 | -122.44720368280001 | (37.7318275120035, -122.4472036828) | ||
| 127159 | 127159 | 39701 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 625 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41086 | 5998544.21434681 | 2094768.39031032 | 37.7317513769747 | -122.447383017512 | (37.7317513769747, -122.447383017512) | ||
| 168067 | 168067 | 38049 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2700 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2005 12:00:00 AM | 9 | Permit Number 47797 | 6000509.1373 | 2114490.0048 | 37.78601418351771 | -122.44200495026199 | (37.7860141835177, -122.442004950262) | |
| 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) | |
| 81411 | 81411 | 24833 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 200X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 25 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 104227 | 104227 | 63235 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | Permit Number 23783 | 6006128.1084232 | 2104314.19244631 | 37.7583924427757 | -122.42184172513399 | (37.7583924427757, -122.421841725134) | ||
| 88651 | 88651 | 51518 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47821 | 5998596.12110377 | 2094762.07724114 | 37.731737008800394 | -122.44720311183701 | (37.7317370088004, -122.447203111837) | |||
| 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) | ||
| 123265 | 123265 | 63243 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3655 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1987 12:00:00 AM | Permit Number 23794 | 6005943.45223383 | 2104303.94711278 | 37.75835389618079 | -122.422479620966 | (37.7583538961808, -122.422479620966) | ||
| 79707 | 79707 | 46270 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/2002 12:00:00 AM | Permit Number 44554 | 6001971.15717323 | 2094954.12044598 | 37.732456582979495 | -122.435548678389 | (37.7324565829795, -122.435548678389) | ||
| 32571 | 32571 | 69145 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2419 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 6 | Permit Number 33179 | 5983608.7607 | 2098659.5816 | 37.741570751884 | -122.499304541285 | (37.741570751884, -122.499304541285) | |
| 99774 | 99774 | 69125 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 447 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33148 | 6005264.64007943 | 2110758.08466494 | 37.7760370972093 | -122.425286525812 | (37.7760370972093, -122.425286525812) | ||
| 19290 | 19290 | 24816 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1996 12:00:00 AM | 12 | 2x3 | 6008197.49032 | 2095113.0796700001 | 37.733244720069706 | -122.414033944713 | (37.7332447200697, -122.414033944713) | ||
| 99215 | 99215 | 64665 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 933 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/1991 12:00:00 AM | Permit Number 25595 | 6006330.05327332 | 2104167.32767008 | 37.7580005727281 | -122.42113288094 | (37.7580005727281, -122.42113288094) | ||
| 108915 | 108915 | 66907 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 541 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/1992 12:00:00 AM | Permit Number 30285 | 5999680.75570363 | 2110323.09068481 | 37.7745256692579 | -122.44457132109301 | (37.7745256692579, -122.444571321093) | ||
| 139750 | 139750 | 39894 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1999 12:00:00 AM | Permit Number 41176 | 5999001.16721708 | 2108236.78492637 | 37.7687584031098 | -122.44677199136801 | (37.7687584031098, -122.446771991368) | |||
| 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) | |
| 5340 | 5340 | 30595 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 265 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34562 | ||||||||
| 15314 | 15314 | 30594 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 265 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34562 | ||||||||
| 15615 | 15615 | 30591 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 253 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34560 | ||||||||
| 47279 | 47279 | 35103 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 786 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38645 | 6001885.65115289 | 2089265.94057695 | 37.7168332689419 | -122.43543753433399 | (37.7168332689419, -122.435437534334) | ||
| 104807 | 104807 | 35134 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 849 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38664 | 6001545.25839951 | 2089134.40240899 | 37.716452756426 | -122.43660469328 | (37.716452756426, -122.43660469328) | ||
| 95639 | 95639 | 69196 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1463 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33243 | 6009335.03931842 | 2100741.36404906 | 37.7487625875096 | -122.410498405401 | (37.7487625875096, -122.410498405401) | ||
| 117911 | 117911 | 69194 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1455 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33240 | 6009333.22604202 | 2100774.20133137 | 37.748852649751704 | -122.410506994166 | (37.7488526497517, -122.410506994166) | ||
| 144860 | 144860 | 69216 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1144 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33267 | 6008630.78048604 | 2101877.2067938 | 37.751841850344704 | -122.41301403743401 | (37.7518418503447, -122.413014037434) | ||
| 97186 | 97186 | 30761 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1575 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34642 | 6014875.77973499 | 2093824.0033781002 | 37.7300780049156 | -122.39085502491999 | (37.7300780049156, -122.39085502492) | ||
| 98266 | 98266 | 30758 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1557 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34639 | 6014967.84012217 | 2093755.65118605 | 37.7298954311335 | -122.390531983655 | (37.7298954311335, -122.390531983655) | ||
| 110661 | 110661 | 30763 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1542 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34644 | 6014903.15895955 | 2093519.78776627 | 37.729244209154295 | -122.39073911946801 | (37.7292442091543, -122.390739119468) | ||
| 138983 | 138983 | 30760 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1571 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34641 | 6014896.23757332 | 2093808.81402101 | 37.7300374330916 | -122.390783237924 | (37.7300374330916, -122.390783237924) | ||
| 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) | |
| 47710 | 47710 | 44248 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1960 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2001 12:00:00 AM | 8 | Permit Number 43683 | 5999863.264769999 | 2121264.87303 | 37.8045793513217 | -122.44472662894199 | (37.8045793513217, -122.444726628942) | ||
| 96566 | 96566 | 52598 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 423@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | Permit Number 48692 | 6005028.51137557 | 2110420.01312959 | 37.7750954922138 | -122.426079285457 | (37.7750954922138, -122.426079285457) | |||
| 124588 | 124588 | 52597 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 421@ FELL Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2006 12:00:00 AM | Permit Number 48691 | 6005029.01915461 | 2110416.12997637 | 37.775084858719794 | -122.42607725243799 | (37.7750848587198, -122.426077252438) | ||
| 126511 | 126511 | 49185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 220 Palo Alto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46291 | 5997532.34805472 | 2103898.27952644 | 37.7567619489163 | -122.451539524782 | (37.7567619489163, -122.451539524782) | |||
| 32980 | 32980 | 30799 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 131 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34665 | 6002107.114019999 | 2095231.84638 | 37.733226875715296 | -122.43509850062 | (37.7332268757153, -122.43509850062) | |
| 79886 | 79886 | 67804 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 215 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1994 12:00:00 AM | Permit Number 31453 | 6003763.62243652 | 2100965.95054031 | 37.7490653321175 | -122.429780349464 | (37.7490653321175, -122.429780349464) | ||
| 122870 | 122870 | 61325 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 750 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/1984 12:00:00 AM | Permit Number 21228 | 5999633.66350661 | 2111045.76132591 | 37.77650725122871 | -122.44478617828301 | (37.7765072512287, -122.444786178283) | ||
| 4165 | 4165 | 253615 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221.0 | 2118816.0 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | ||
| 27440 | 27440 | 35252 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38738 | 6006246.10083 | 2119680.0646 | 37.8005900423666 | -122.42252550983801 | (37.8005900423666, -122.422525509838) | |
| 50358 | 50358 | 35258 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1304 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 11 | Permit Number 38744 | 6006066.5782 | 2120048.78389 | 37.8015923223752 | -122.42317295609199 | (37.8015923223752, -122.423172956092) | |
| 56697 | 56697 | 35266 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2323 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | 3x3 | Permit Number 38750 | 6006292.04033 | 2118835.34945 | 37.798273260158 | -122.42230648984699 | (37.798273260158, -122.422306489847) |
| 70350 | 70350 | 35250 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1385 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38738 | 6006287.30636 | 2119683.41372 | 37.800601562682296 | -122.42238315976999 | (37.8006015626823, -122.42238315977) | |
| 110851 | 110851 | 35265 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006296.38753209 | 2118756.6266107 | 37.79805735235279 | -122.422285851072 | (37.7980573523528, -122.422285851072) | |
| 105335 | 105335 | 40071 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1459 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41297 | 6015490.41779177 | 2093366.98866113 | 37.728857218184295 | -122.388698234625 | (37.7288572181843, -122.388698234625) | ||
| 81838 | 81838 | 35367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 619 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38827 | 6011631.49743277 | 2091601.49478662 | 37.723794911059606 | -122.401914809778 | (37.7237949110596, -122.401914809778) | ||
| 135271 | 135271 | 35351 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1274 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 11 | 5x5 | Permit Number 38813 | 6012220.8536 | 2102461.75759 | 37.7536477760478 | -122.400640051912 | (37.7536477760478, -122.400640051912) |
| 144903 | 144903 | 35368 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 627 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | Permit Number 38828 | 6011631.82829511 | 2091600.41039567 | 37.72379195201 | -122.401913589843 | (37.72379195201, -122.401913589843) | ||
| 102320 | 102320 | 35681 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4521 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2000 12:00:00 AM | Permit Number 41986 | 6000920.86314017 | 2101102.84545022 | 37.749279824800794 | -122.43962042595899 | (37.7492798248008, -122.439620425959) | |||
| 37323 | 37323 | 44456 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 95 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 43779 | 6002571.72829 | 2086874.98861 | 37.710307180311105 | -122.432895389109 | (37.7103071803111, -122.432895389109) | |
| 110886 | 110886 | 62618 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1988 12:00:00 AM | Permit Number 25075 | 6010492.04482679 | 2099848.37661279 | 37.7463754350507 | -122.40643455260201 | (37.7463754350507, -122.406434552602) | ||
| 88327 | 88327 | 64256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 191 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25057 | 6004710.43221145 | 2098679.48425343 | 37.7428407913605 | -122.426343498945 | (37.7428407913605, -122.426343498945) | ||
| 107642 | 107642 | 24822 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2006 12:00:00 AM | 3 | 3x3 | 6007873.98451 | 2094939.34624 | 37.732749510625 | -122.41514010253701 | (37.732749510625, -122.415140102537) | ||
| 99304 | 99304 | 44327 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1586 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2001 12:00:00 AM | 8 | 2x3 | Permit Number 43713 | 5997934.27114243 | 2105194.99069947 | 37.7603454014574 | -122.45024300053001 | (37.7603454014574, -122.45024300053) | |
| 114054 | 114054 | 44335 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 416 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2001 12:00:00 AM | Permit Number 43720 | 6002101.70420966 | 2103412.24536884 | 37.7556880241476 | -122.435702264997 | (37.7556880241476, -122.435702264997) | |||
| 138476 | 138476 | 59636 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3565 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1981 12:00:00 AM | 24 | Permit Number 19044 | 6000486.79146337 | 2103768.98827421 | 37.7565756921574 | -122.44131272607001 | (37.7565756921574, -122.44131272607) | ||
| 144008 | 144008 | 53298 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 4136 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30418 | 6002261.36449756 | 2102398.30282758 | 37.7529130479403 | -122.43507759426001 | (37.7529130479403, -122.43507759426) | ||
| 84092 | 84092 | 30931 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 407 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34744 | 5995614.80249177 | 2091194.83311768 | 37.7217714131354 | -122.457252106382 | (37.7217714131354, -122.457252106382) | ||
| 113751 | 113751 | 31059 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 301 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34810 | 6001654.06728241 | 2086489.02532865 | 37.7091953182451 | -122.43603940951598 | (37.7091953182451, -122.436039409516) |
| 118633 | 118633 | 69308 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1994 12:00:00 AM | Permit Number 33387 | 5986864.5682116 | 2104707.11140573 | 37.7583661086574 | -122.488491577304 | (37.7583661086574, -122.488491577304) | ||
| 90541 | 90541 | 61342 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21247 | 6004909.43277367 | 2110408.16939621 | 37.7750562413416 | -122.426490361334 | (37.7750562413416, -122.426490361334) | ||
| 90603 | 90603 | 61344 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 477 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21249 | 6004697.33191231 | 2110333.09347915 | 37.7748381087345 | -122.42721871600901 | (37.7748381087345, -122.427218716009) | ||
| 107484 | 107484 | 61125 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 476 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 20976 | 6004690.15549132 | 2110384.59589639 | 37.774979115952604 | -122.42724721017099 | (37.7749791159526, -122.427247210171) | ||
| 145456 | 145456 | 61340 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 441 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/1984 12:00:00 AM | Permit Number 21245 | 6004862.65889815 | 2110356.13037945 | 37.7749107106258 | -122.42664845598301 | (37.7749107106258, -122.426648455983) | ||
| 89405 | 89405 | 31180 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 344 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34878 | 5993129.55455829 | 2089868.58886975 | 37.717986817508 | -122.465746580217 | (37.717986817508, -122.465746580217) | ||
| 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) |
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");