Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117 | 117 | 220007 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.4311599997 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | |
| 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) | ||
| 1362 | 1362 | 36186 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 133 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1998 12:00:00 AM | 8 | Permit Number 39255 | 5995881.41756 | 2113499.8369 | 37.783030646722004 | -122.45794382331002 | (37.783030646722, -122.45794382331) | |
| 1536 | 1536 | 251472 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589.0 | 2096875.0 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | |
| 1815 | 1815 | 71427 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1852 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2017 12:00:00 AM | 3 | 4x4 | 6009993.7542 | 2120480.0499 | 37.802997311571104 | -122.409613538987 | (37.8029973115711, -122.409613538987) | |
| 2164 | 2164 | 10688 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1221 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1991 12:00:00 AM | 6 | 3X3 | 6002001.6656 | 2110480.73 | 37.7750906677438 | -122.43655414222 | (37.7750906677438, -122.43655414222) | ||
| 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) | ||
| 2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
| 3716 | 3716 | 20054 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 100 STAIRWAY54 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15ST | ||||||||
| 3793 | 3793 | 39226 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 9 | Permit Number 40869 | 5984798.64138 | 2110605.0729799997 | 37.774439483359 | -122.49607147975 | (37.774439483359, -122.49607147975) | ||
| 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) | ||
| 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) | |||
| 5920 | 5920 | 139500 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 5999620.0523 | 2111133.4316 | 37.776747194618395 | -122.44483956661199 | (37.7767471946184, -122.444839566612) | ||||
| 6724 | 6724 | 102771 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.42313363592501 | (37.7996844799161, -122.423133635925) | |||
| 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) | ||
| 10290 | 10290 | 37814 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) |
| 10474 | 10474 | 34625 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38307 | 5988697.9248 | 2105373.4338 | 37.76030245534 | -122.482199912019 | (37.76030245534, -122.482199912019) |
| 12141 | 12141 | 17224 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1880X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001029.5778 | 2091188.70927 | 37.72206410195621 | -122.43853424087601 | (37.7220641019562, -122.438534240876) | |||
| 12540 | 12540 | 108677 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 11 Otsego Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | Permit Number 773206 | 6000966.57436 | 2092971.8241299998 | 37.7269565451936 | -122.438879746024 | (37.7269565451936, -122.438879746024) | |
| 13900 | 13900 | 102846 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 29 Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 1x1 | 6014262.35987 | 2114356.78408 | 37.786422526635604 | -122.394412832193 | (37.7864225266356, -122.394412832193) | |||
| 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 | ||||||||
| 18171 | 18171 | 1377 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 65 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1998 12:00:00 AM | 3 | 1X1 | 5998937.99517 | 2100006.33795 | 37.746156024995706 | -122.44639832203 | (37.7461560249957, -122.44639832203) | ||
| 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) | ||
| 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) | ||
| 20390 | 20390 | 66640 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32335 | 6010387.14006944 | 2103433.53881978 | 37.756213630012496 | -122.407049963033 | (37.7562136300125, -122.407049963033) | ||
| 21207 | 21207 | 10209 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1301 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/1994 12:00:00 AM | 12 | 3X3PL | 6005849.39823 | 2101351.62015 | 37.7502421837319 | -122.4225951102 | (37.7502421837319, -122.4225951102) | ||
| 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) | ||
| 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) |
| 24187 | 24187 | 142264 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 575 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004642.0376 | 2110688.0426 | 37.775809585078896 | -122.427435282317 | (37.7758095850789, -122.427435282317) | |||
| 25432 | 25432 | 220094 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 436 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003910.2005900005 | 2096060.2503799999 | 37.735603706528394 | -122.42892377971 | (37.7356037065284, -122.42892377971) | |||
| 26281 | 26281 | 220668 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007462.21417 | 2105696.0479 | 37.762261844143296 | -122.417325709834 | (37.7622618441433, -122.417325709834) | |||
| 26472 | 26472 | 220689 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 119 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004994.550369999 | 2099284.37518 | 37.744517739909 | -122.42540413451401 | (37.744517739909, -122.425404134514) | |||
| 26644 | 26644 | 48033 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 61 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2002 12:00:00 AM | Permit Number 45754 | 6001724.06677399 | 2105480.90222389 | 37.761346597247794 | -122.437156358638 | (37.7613465972478, -122.437156358638) | |||
| 27343 | 27343 | 203223 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994463.96401 | 2093754.2883099997 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | |||
| 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) | |
| 28541 | 28541 | 220690 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003721.786040001 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | |||
| 29829 | 29829 | 115807 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | |||
| 30888 | 30888 | 42696 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1751 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42713 | 6007796.58473 | 2118447.48214 | 37.7972930261196 | -122.417072803384 | (37.7972930261196, -122.417072803384) | |
| 31248 | 31248 | 220041 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 890 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000667.40596 | 2102598.56375 | 37.7533722777334 | -122.440604151054 | (37.7533722777334, -122.440604151054) | |||
| 31368 | 31368 | 40190 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 600 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41375 | 6008992.69015 | 2093809.01989 | 37.729708681998 | -122.411192625738 | (37.729708681998, -122.411192625738) | ||
| 31678 | 31678 | 137728 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1989 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999638.3271 | 2111189.9480000003 | 37.77690341710429 | -122.444780412241 | (37.7769034171043, -122.444780412241) | |||
| 31819 | 31819 | 220062 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.5701 | 2095055.5296099999 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | |||
| 32234 | 32234 | 220023 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 89 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001002.01011 | 2101166.3716 | 37.749458870636396 | -122.439344371761 | (37.7494588706364, -122.439344371761) | |||
| 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) | |
| 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) | |
| 33112 | 33112 | 220001 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | |||
| 33288 | 33288 | 220075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001146.06945 | 2104525.9934099996 | 37.758691778412704 | -122.43908696419201 | (37.7586917784127, -122.439086964192) | |||
| 33499 | 33499 | 174962 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 114 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000450.3974 | 2092235.26707 | 37.724904747337106 | -122.440611347459 | (37.7249047473371, -122.440611347459) | |||
| 33878 | 33878 | 220678 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3607 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006149.55219 | 2104320.61277 | 37.758411280773394 | -122.421768019002 | (37.7584112807734, -122.421768019002) | |||
| 33978 | 33978 | 203629 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 138 Encline Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998295.84832 | 2098462.32087 | 37.7418798313816 | -122.448507597342 | (37.7418798313816, -122.448507597342) | |||
| 34367 | 34367 | 220083 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4133 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002828.79114 | 2104135.9049299997 | 37.7577162927799 | -122.43323947601401 | (37.7577162927799, -122.433239476014) | |||
| 34582 | 34582 | 174966 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009006.884330001 | 2093841.0199900002 | 37.729797343475596 | -122.411145814235 | (37.7297973434756, -122.411145814235) | |||
| 34587 | 34587 | 78000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2804 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2000 12:00:00 AM | 7 | 5985608.4149 | 2096224.5025 | 37.735001786065 | -122.492211254352 | (37.735001786065, -122.492211254352) | ||
| 34898 | 34898 | 40295 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 48 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41439 | 6005981.28847445 | 2102313.08870522 | 37.7528895951686 | -122.42220732508801 | (37.7528895951686, -122.422207325088) | ||
| 34993 | 34993 | 188525 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 10 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6016572.5482 | 2095212.67149 | 37.7339850114017 | -122.38508574382799 | (37.7339850114017, -122.385085743828) | |||
| 35427 | 35427 | 203633 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 458 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997727.849830001 | 2094119.15999 | 37.7299220605503 | -122.45015856377199 | (37.7299220605503, -122.450158563772) | |||
| 36367 | 36367 | 203642 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1700 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 5ft | 5993150.97673 | 2103877.75625 | 37.7564537210662 | -122.466690296437 | (37.7564537210662, -122.466690296437) | |||
| 37273 | 37273 | 37949 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 530 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 8 | Permit Number 40189 | 6013245.07108 | 2104267.20859 | 37.7586622221997 | -122.39722464979602 | (37.7586622221997, -122.397224649796) | |
| 37289 | 37289 | 220029 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4107 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6002428.99773 | 2102359.29201 | 37.7528154507744 | -122.434495098689 | (37.7528154507744, -122.434495098689) | |||
| 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) | |
| 37452 | 37452 | 140100 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 785 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999576.3959 | 2111131.7395 | 37.7767400570235 | -122.44499046488501 | (37.7767400570235, -122.444990464885) | |||
| 38263 | 38263 | 68132 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1526 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 0 | Permit Number 31884 | 6000696.86081651 | 2113890.04393367 | 37.7843775414062 | -122.44131241543998 | (37.7843775414062, -122.44131241544) | |
| 38287 | 38287 | 220026 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | |||
| 38437 | 38437 | 142346 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 505 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999691.4094 | 2110243.208 | 37.7743069396367 | -122.44452872557699 | (37.7743069396367, -122.444528725577) | |||
| 38639 | 38639 | 174959 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 103 De Long St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 10ft | 5994397.11424 | 2086788.06602 | 37.709601466104104 | -122.461142043293 | (37.7096014661041, -122.461142043293) | |||
| 38771 | 38771 | 174961 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 54 Santa Ynez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000769.59798 | 2092028.9930200002 | 37.7243565377 | -122.43949313040899 | (37.7243565377, -122.439493130409) | ||||
| 38779 | 38779 | 68329 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 12 | Permit Number 32144 | 5991421.402000001 | 2110674.853 | 37.7750167634254 | -122.47316740712401 | (37.7750167634254, -122.473167407124) | |
| 40035 | 40035 | 220081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.756446152387795 | -122.432443698342 | (37.7564461523878, -122.432443698342) | |||
| 40082 | 40082 | 38526 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3031 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/1998 12:00:00 AM | 9 | Permit Number 40508 | 6001945.50794 | 2118614.30712 | 37.797420199240996 | -122.437330933595 | (37.797420199241, -122.437330933595) | ||
| 40232 | 40232 | 50534 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1853 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2003 12:00:00 AM | 9 | Permit Number 47173 | 6004174.32371 | 2118346.10209 | 37.7968102295769 | -122.42959951321899 | (37.7968102295769, -122.429599513219) | ||
| 41668 | 41668 | 203664 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 123 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999403.203369999 | 2093610.5277599997 | 37.7286212055976 | -122.444330150233 | (37.7286212055976, -122.444330150233) | |||
| 41964 | 41964 | 246075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 635 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998492.5621 | 2108432.0423 | 37.7692654626532 | -122.44854527514299 | (37.7692654626532, -122.448545275143) | |||
| 42523 | 42523 | 220064 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002590.76073 | 2102413.7777400003 | 37.7529742368948 | -122.43393958746701 | (37.7529742368948, -122.433939587467) | |||
| 42992 | 42992 | 32891 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1515 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37234 | 5994269.30013039 | 2105266.22888454 | 37.760330583946796 | -122.462923499947 | (37.7603305839468, -122.462923499947) | ||
| 43321 | 43321 | 220677 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006108.91147 | 2104316.6789599997 | 37.758398187543996 | -122.42190829343399 | (37.758398187544, -122.421908293434) | |||
| 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) | |
| 44083 | 44083 | 32557 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 3822 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | Permit Number 770192 | 6002956.41958884 | 2103022.59282687 | 37.7546666427143 | -122.43271855723499 | (37.7546666427143, -122.432718557235) | |||
| 44341 | 44341 | 220066 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002537.114630001 | 2102291.1496200003 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | |||
| 44369 | 44369 | 42898 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2060 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/2002 12:00:00 AM | 7 | Permit Number 45580 | 5986523.9754 | 2097068.6969 | 37.737373201510295 | -122.489107923346 | (37.7373732015103, -122.489107923346) | |
| 44479 | 44479 | 220686 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004903.16789 | 2110400.7033700002 | 37.775035387294295 | -122.426511501216 | (37.7750353872943, -122.426511501216) | |||
| 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) | |
| 44833 | 44833 | 34144 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39666 | 6003955.69985192 | 2098004.27278913 | 37.740944124338895 | -122.428905023889 | (37.7409441243389, -122.428905023889) | ||
| 44871 | 44871 | 36124 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1324 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | 10 | Permit Number 39220 | 5988358.7841 | 2106301.1655 | 37.7628300220311 | -122.483440838848 | (37.7628300220311, -122.483440838848) | |
| 45030 | 45030 | 220037 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4263 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6002187.26734 | 2100592.3557700003 | 37.74795013829029 | -122.43520467366301 | (37.7479501382903, -122.435204673663) | |||
| 45041 | 45041 | 188518 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | |||
| 45189 | 45189 | 220002 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6009383.355930001 | 2096884.0702099998 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | |||
| 45254 | 45254 | 220074 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 148 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002660.22221 | 2105037.36162 | 37.7601819118789 | -122.43388688897 | (37.7601819118789, -122.43388688897) | |||
| 45390 | 45390 | 220087 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | |||
| 46001 | 46001 | 41430 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 514 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43060 | 6013229.56642 | 2104526.4373 | 37.7593731443828 | -122.39729645077699 | (37.7593731443828, -122.397296450777) | |
| 47055 | 47055 | 40817 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1770 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1999 12:00:00 AM | 10 | Permit Number 41760 | 6001600.476 | 2114446.9395 | 37.785958067470204 | -122.43822613537901 | (37.7859580674702, -122.438226135379) | |
| 47068 | 47068 | 220057 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.41527371052099 | (37.752790875909, -122.415273710521) | |||
| 47075 | 47075 | 220067 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003185.70208 | 2103572.60316 | 37.756189841101296 | -122.431964909158 | (37.7561898411013, -122.431964909158) | |||
| 47147 | 47147 | 73391 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 237 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1994 12:00:00 AM | 10 | 6001816.88591 | 2094039.23102 | 37.72993574283429 | -122.43601658701999 | (37.7299357428343, -122.43601658702) | ||
| 47237 | 47237 | 220016 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.74555562500829 | -122.44628649854201 | (37.7455556250083, -122.446286498542) | |||
| 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) | ||
| 47618 | 47618 | 220674 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3548 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005923.11971 | 2104936.6524900002 | 37.760090010159104 | -122.42259489975201 | (37.7600900101591, -122.422594899752) | |||
| 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) |
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");