Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371 | 371 | 8188 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1272 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1997 12:00:00 AM | 10 | 3X4 | 6001679.2828 | 2111174.9406 | 37.7769784708042 | -122.437719062833 | (37.7769784708042, -122.437719062833) | ||
| 2515 | 2515 | 124752 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2478 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 9 | Width 5ft | 6002956.6534 | 2115870.86114 | 37.7899448329366 | -122.433635939447 | (37.7899448329366, -122.433635939447) | ||
| 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) | ||||
| 8578 | 8578 | 10632 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1990 12:00:00 AM | 12 | 3X3 | 6003878.786 | 2110787.057 | 37.7760382564385 | -122.43008262774599 | (37.7760382564385, -122.430082627746) | ||
| 8838 | 8838 | 10631 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1990 12:00:00 AM | 18 | 3X3 | 6003873.4823 | 2110738.4269 | 37.7759044297862 | -122.430097504694 | (37.7759044297862, -122.430097504694) | ||
| 9300 | 9300 | 1913 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 8 Bell Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 3 | 3X3 | 6016615.0158522995 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | ||
| 19047 | 19047 | 23032 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2003 12:00:00 AM | 8 | 3X3 | 6006338.92475 | 2104110.62405 | 37.757845377874204 | -122.42109817336599 | (37.7578453778742, -122.421098173366) | ||
| 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) | ||
| 20126 | 20126 | 22809 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/1998 12:00:00 AM | 3 | 3x3 | 5998930.058209999 | 2099793.7189700003 | 37.745571771416294 | -122.446410473673 | (37.7455717714163, -122.446410473673) | ||
| 21499 | 21499 | 24820 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 400X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/22/2008 12:00:00 AM | 12 | 3x3 | 6007910.58435 | 2094958.48618 | 37.732804121515606 | -122.415014921609 | (37.7328041215156, -122.415014921609) | ||
| 21718 | 21718 | 22808 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 19 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1991 12:00:00 AM | 3 | 2X2 | 5998906.136630001 | 2099819.83871 | 37.745642123584105 | -122.446495069307 | (37.7456421235841, -122.446495069307) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 24164 | 24164 | 54840 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 236 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 6 | 3x3 | Permit Number 10695 | 5998822.5685 | 2109866.5256 | 37.77322305193879 | -122.447507074191 | (37.7732230519388, -122.447507074191) |
| 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) | ||
| 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) | ||
| 108511 | 108511 | 57975 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2602 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | Permit Number 20908 | 5999705.92548521 | 2113681.4260983 | 37.783748232079894 | -122.444725695659 | (37.7837482320799, -122.444725695659) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 107386 | 107386 | 61743 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3818 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21749 | 6005051.92893884 | 2100797.64178313 | 37.748676064316605 | -122.425313395129 | (37.7486760643166, -122.425313395129) | ||
| 100685 | 100685 | 61745 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 16 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21751 | 6005058.850293 | 2101091.32092731 | 37.7494828305195 | -122.42531035662901 | (37.7494828305195, -122.425310356629) | ||
| 100643 | 100643 | 61746 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3873 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1984 12:00:00 AM | Permit Number 21752 | 6004713.22212882 | 2100726.95185307 | 37.7484628246013 | -122.426479608106 | (37.7484628246013, -122.426479608106) | ||
| 85980 | 85980 | 61747 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3834 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2016 12:00:00 AM | 3 | Permit Number 21753 | 6004950.72602956 | 2100792.08081868 | 37.7486550770793 | -122.425662958373 | (37.7486550770793, -122.425662958373) | |
| 144457 | 144457 | 61341 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1985 12:00:00 AM | Permit Number 22558 | 6004883.03697194 | 2110411.47227967 | 37.775063818048295 | -122.426581905478 | (37.7750638180483, -122.426581905478) | ||
| 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) | ||
| 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) | ||
| 108180 | 108180 | 63547 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1316 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | Permit Number 24163 | 6001453.76739224 | 2111146.48373237 | 37.7768875100239 | -122.43849714915399 | (37.7768875100239, -122.438497149154) | ||
| 95514 | 95514 | 63606 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 717 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1987 12:00:00 AM | Permit Number 24243 | 5999597.4131629 | 2110926.64814812 | 37.7761781281102 | -122.444903013727 | (37.7761781281102, -122.444903013727) | ||
| 82846 | 82846 | 63850 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1259 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24547 | 6001845.15733033 | 2110454.5773622 | 37.7750099641834 | -122.437093665021 | (37.7750099641834, -122.437093665021) | ||
| 77854 | 77854 | 63851 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1233 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24548 | 6001965.88884277 | 2110471.51360831 | 37.775063328726 | -122.43667724183999 | (37.775063328726, -122.43667724184) | ||
| 103463 | 103463 | 61742 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 33 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24596 | 6004949.79749465 | 2101033.09819364 | 37.7493168026727 | -122.425683321129 | (37.7493168026727, -122.425683321129) | ||
| 106159 | 106159 | 64173 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 30 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1987 12:00:00 AM | Permit Number 24955 | 5992735.52734942 | 2093091.96966529 | 37.7268146975842 | -122.467342804105 | (37.7268146975842, -122.467342804105) | ||
| 104133 | 104133 | 64176 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 7 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2000 12:00:00 AM | Permit Number 24959 | 5992913.91992547 | 2093156.51419592 | 37.727002217924706 | -122.466730800624 | (37.7270022179247, -122.466730800624) | ||
| 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) | ||
| 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) | ||
| 137659 | 137659 | 64510 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 838 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 12 | Permit Number 25391 | 6000497.2416 | 2111874.2369 | 37.778831278686496 | -122.441858298358 | (37.7788312786865, -122.441858298358) | |
| 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) | |
| 94027 | 94027 | 64512 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25393 | 6000501.90082075 | 2111793.8331913003 | 37.7786107760856 | -122.441836408094 | (37.7786107760856, -122.441836408094) | ||
| 115605 | 115605 | 62376 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3548 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 25477 | 6005956.95420215 | 2104942.96708739 | 37.7601092573287 | -122.422478330945 | (37.7601092573287, -122.422478330945) | ||
| 113450 | 113450 | 64600 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 937 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1988 12:00:00 AM | Permit Number 25502 | 6006331.29758425 | 2104145.47167682 | 37.7579406313954 | -122.42112702568998 | (37.7579406313954, -122.42112702569) | ||
| 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) | ||
| 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) | ||
| 112524 | 112524 | 65155 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 819 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27134 | 6001092.45713826 | 2102576.67307125 | 37.7533363665416 | -122.439132669576 | (37.7533363665416, -122.439132669576) | ||
| 121196 | 121196 | 65158 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 873 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27138 | 6000770.17128477 | 2102558.89498752 | 37.7532692083278 | -122.440245923397 | (37.7532692083278, -122.440245923397) | ||
| 81874 | 81874 | 65160 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 878 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27140 | 6000731.49768107 | 2102608.84071127 | 37.7534041452721 | -122.440383246008 | (37.7534041452721, -122.440383246008) | ||
| 141216 | 141216 | 65182 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 49 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27166 | 6000612.59181755 | 2102724.86163023 | 37.7537159395855 | -122.44080276840201 | (37.7537159395855, -122.440802768402) | ||
| 122894 | 122894 | 66111 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 830 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29166 | 6003876.46719342 | 2110790.67622638 | 37.776048062614 | -122.43009090735501 | (37.776048062614, -122.430090907355) | ||
| 88842 | 88842 | 66113 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 818 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29168 | 6003931.34560658 | 2110798.34494674 | 37.7760722269843 | -122.429901615557 | (37.7760722269843, -122.429901615557) | ||
| 106606 | 106606 | 66114 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 829 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29169 | 6003892.81016511 | 2110740.45474073 | 37.775911092379495 | -122.43003078932101 | (37.7759110923795, -122.430030789321) | ||
| 92979 | 92979 | 66117 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 840 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29176 | 6003830.73518673 | 2110784.28562667 | 37.77602792540829 | -122.430248650411 | (37.7760279254083, -122.430248650411) | ||
| 103358 | 103358 | 66155 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1741 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29226 | 6013929.0546693 | 2095023.1611058 | 37.7333180723286 | -122.394211919223 | (37.7333180723286, -122.394211919223) | ||
| 126007 | 126007 | 66174 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 70 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29247 | 6009314.15806324 | 2097044.09702117 | 37.738609532336504 | -122.41030959858699 | (37.7386095323365, -122.410309598587) | ||
| 101869 | 101869 | 66237 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 422 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29335 | 5995558.06563814 | 2090587.62307484 | 37.72010089980329 | -122.45740432201 | (37.7201008998033, -122.45740432201) | ||
| 87509 | 87509 | 66256 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 198 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29359 | 5996422.28373213 | 2098491.67117902 | 37.7418531174549 | -122.454987856884 | (37.7418531174549, -122.454987856884) | ||
| 103637 | 103637 | 66324 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 88 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1995 12:00:00 AM | Permit Number 29443 | 6000832.40008628 | 2095235.41670142 | 37.733164213776796 | -122.439505779041 | (37.7331642137768, -122.439505779041) | ||
| 104349 | 104349 | 66522 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 655 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1991 12:00:00 AM | Permit Number 29693 | 6002138.34041494 | 2102625.09065905 | 37.7535287667473 | -122.43551925665301 | (37.7535287667473, -122.435519256653) | ||
| 112247 | 112247 | 66784 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 20 Culebra Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1992 12:00:00 AM | Permit Number 30056 | 6006381.97640479 | 2120210.98917161 | 37.8020554906142 | -122.422093063103 | (37.8020554906142, -122.422093063103) | ||
| 19744 | 19744 | 66789 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1405 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30063 | 6006130.65101914 | 2119658.78326709 | 37.80052509557579 | -122.42292350049 | (37.8005250955758, -122.42292350049) |
| 51120 | 51120 | 66858 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 103 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1991 12:00:00 AM | 9 | Permit Number 30164 | 5998644.5770000005 | 2110362.2819 | 37.774574098301294 | -122.448158471707 | (37.7745740983013, -122.448158471707) | ||
| 119291 | 119291 | 66874 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 315 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30184 | 6001156.85774168 | 2104547.18862288 | 37.7587505891563 | -122.43905117245501 | (37.7587505891563, -122.439051172455) | ||
| 100570 | 100570 | 66876 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30186 | 6001155.37730733 | 2104574.8455135 | 37.7588264440048 | -122.439058274593 | (37.7588264440048, -122.439058274593) | ||
| 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) | ||
| 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) | ||
| 94760 | 94760 | 67088 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30490 | 6010217.49465897 | 2100245.63061 | 37.7474508447186 | -122.407411920985 | (37.7474508447186, -122.407411920985) | ||
| 124519 | 124519 | 67143 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 303 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 30573 | 6006940.4062177 | 2097313.36453869 | 37.7392155318486 | -122.418536006241 | (37.7392155318486, -122.418536006241) | ||
| 94117 | 94117 | 67164 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1550 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30604 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 123798 | 123798 | 67185 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 154 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | 12 | Permit Number 30632 | 5998076.31886872 | 2105384.33640813 | 37.76087342528071 | -122.44976537124599 | (37.7608734252807, -122.449765371246) | |
| 114669 | 114669 | 53682 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 879 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | Permit Number 30735 | 5984157.5341821 | 2109855.55736393 | 37.7723439568609 | -122.49823378959 | (37.7723439568609, -122.49823378959) | ||
| 97815 | 97815 | 67367 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 622 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30860 | 5991947.66141854 | 2111184.68459598 | 37.7764470789457 | -122.47138413483101 | (37.7764470789457, -122.471384134831) | ||
| 145457 | 145457 | 67397 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 615 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | Permit Number 30894 | 5990626.25534689 | 2111189.00376145 | 37.776382409214705 | -122.47595552081499 | (37.7763824092147, -122.475955520815) | ||
| 137076 | 137076 | 67483 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 556 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 7 | Permit Number 31006 | 6002164.8912 | 2110413.7271 | 37.7749159685838 | -122.43598471432301 | (37.7749159685838, -122.435984714323) | |
| 53161 | 53161 | 67491 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1053 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | 11 | Permit Number 31016 | 6011662.712180001 | 2103457.28078 | 37.7563501191849 | -122.402640243074 | (37.7563501191849, -122.402640243074) | |
| 43560 | 43560 | 67530 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 12 | Permit Number 31068 | 6013998.45944 | 2106956.61768 | 37.766088665392296 | -122.394807417822 | (37.7660886653923, -122.394807417822) | |
| 81201 | 81201 | 67531 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31069 | 6014000.26557437 | 2106870.40644282 | 37.765852048761104 | -122.394795132512 | (37.7658520487611, -122.394795132512) | ||
| 130712 | 130712 | 67547 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1125 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 9 | Permit Number 31093 | 6011962.71401 | 2103154.98207 | 37.75553681818771 | -122.40158148021798 | (37.7555368181877, -122.401581480218) | |
| 110343 | 110343 | 67563 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1067 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31115 | 6011664.16143038 | 2103412.99241656 | 37.7562285940169 | -122.40263211667299 | (37.7562285940169, -122.402632116673) | ||
| 44560 | 44560 | 54500 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 475 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 8 | Permit Number 31133 | 6013270.33865 | 2104862.70543 | 37.760298732933 | -122.39717901909599 | (37.760298732933, -122.397179019096) |
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");