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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92283 | 92283 | 95319 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 92315 | 92315 | 52824 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 301FERNWOOD Brentwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48849 | 5994767.16572707 | 2095140.66542727 | 37.732556994280706 | -122.46046791665701 | (37.7325569942807, -122.460467916657) | ||||
| 92318 | 92318 | 99764 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4300x 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 1192 Diamond St | 6001940.4 | 2100620.7 | 37.748013943002704 | -122.436060356931 | (37.7480139430027, -122.436060356931) | |||
| 92705 | 92705 | 98350 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002759.0 | 2109307.0 | 37.7719109027838 | -122.43385044639999 | (37.7719109027838, -122.4338504464) | ||||
| 92740 | 92740 | 35414 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1496 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38868 | 6003922.18786228 | 2099560.28460641 | 37.7452146776724 | -122.429131815599 | (37.7452146776724, -122.429131815599) | ||
| 93536 | 93536 | 119890 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 520 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003249.18885376 | 2096183.56473871 | 37.735904862626 | -122.431217948328 | (37.735904862626, -122.431217948328) | ||||
| 93582 | 93582 | 93724 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 415 Belvedere St | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998488.0 | 2106798.0 | 37.7647785355325 | -122.44844336243601 | (37.7647785355325, -122.448443362436) | ||||||
| 93583 | 93583 | 58647 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 840 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17869 | 5997188.31162677 | 2107608.64597093 | 37.7669299671715 | -122.45299714312 | (37.7669299671715, -122.45299714312) | ||
| 93679 | 93679 | 52264 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 323 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48429 | 6004810.64378821 | 2101860.96102729 | 37.7515820578763 | -122.426223449326 | (37.7515820578763, -122.426223449326) | ||
| 93960 | 93960 | 32930 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 94029 | 94029 | 50463 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
| 94541 | 94541 | 33990 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50801 | 6001127.244268401 | 2105008.45413058 | 37.760015426682 | -122.43918664961201 | (37.760015426682, -122.439186649612) | ||
| 94901 | 94901 | 53018 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 210@ SOLA AVE Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 48998 | 5994944.05105454 | 2100605.63053534 | 37.747572608877 | -122.460252192206 | (37.747572608877, -122.460252192206) | |||
| 95543 | 95543 | 99780 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 409 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002495.0 | 2101491.0 | 37.750435073410394 | -122.434204782525 | (37.7504350734104, -122.434204782525) | ||||
| 95842 | 95842 | 68127 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31877 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||
| 96178 | 96178 | 97500 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 96700 | 96700 | 45695 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 97080 | 97080 | 46078 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1380 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2001 12:00:00 AM | Permit Number 44459 | 6016168.14280668 | 2094664.01192279 | 37.7324561236274 | -122.38644566841499 | (37.7324561236274, -122.386445668415) | |||
| 97101 | 97101 | 58441 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 930 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17590 | 5999238.33920715 | 2106913.89639282 | 37.765139629896204 | -122.445856479597 | (37.7651396298962, -122.445856479597) | |||
| 97143 | 97143 | 41197 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | Permit Number 41907 | 6015636.41824938 | 2107244.95796966 | 37.7669713213554 | -122.38916212984199 | (37.7669713213554, -122.389162129842) | ||
| 97436 | 97436 | 62351 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 87 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22494 | 6005350.50245062 | 2099593.00770081 | 37.7453852789219 | -122.424195268575 | (37.7453852789219, -122.424195268575) | ||
| 97451 | 97451 | 32933 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 97453 | 97453 | 46531 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 881PERMIT) Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44684 | 5998680.49722421 | 2107051.08092489 | 37.765484436098 | -122.44779578842699 | (37.765484436098, -122.447795788427) | ||||
| 97490 | 97490 | 100180 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997991.0 | 2108152.0 | 37.768467847026294 | -122.450259955793 | (37.7684678470263, -122.450259955793) | ||||
| 98450 | 98450 | 39211 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3320 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 40855 | 6006915.83116682 | 2102071.77265415 | 37.7522796651602 | -122.41895838053999 | (37.7522796651602, -122.41895838054) | ||||
| 98548 | 98548 | 43240 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 702 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43028 | 6002763.80049912 | 2109247.75150774 | 37.771748493450204 | -122.43382960559299 | (37.7717484934502, -122.433829605593) | ||
| 99106 | 99106 | 111065 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | ||||
| 99373 | 99373 | 45698 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 99593 | 99593 | 45699 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 99811 | 99811 | 104936 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 837 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 99998 | 99998 | 99808 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4143 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002228.0 | 2102353.0 | 37.7527867625939 | -122.435189734753 | (37.7527867625939, -122.435189734753) | ||||
| 100219 | 100219 | 39625 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1516 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41023 | 5997885.89044429 | 2105542.94174539 | 37.761298018687896 | -122.450435409974 | (37.7612980186879, -122.450435409974) | ||
| 100290 | 100290 | 39116 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 3x3 | Permit Number 40802 | 6009834.44503837 | 2101335.31973877 | 37.750421443407 | -122.408813353776 | (37.750421443407, -122.408813353776) | |
| 100463 | 100463 | 45697 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 100610 | 100610 | 96125 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767775 | 6008080.0 | 2096981.0 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | |
| 100691 | 100691 | 96126 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Ellsworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767775 | 6008080.0 | 2096981.0 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | |
| 100988 | 100988 | 106661 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x7 | 5993905.48812 | 2112097.55644 | 37.7790666413385 | -122.464677814993 | (37.7790666413385, -122.464677814993) | ||||
| 101973 | 101973 | 32666 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 102146 | 102146 | 97502 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 103098 | 103098 | 39262 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2641 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2002 12:00:00 AM | Permit Number 45224 | 6010322.84721614 | 2104547.72177646 | 37.7592693288078 | -122.407350854298 | (37.7592693288078, -122.407350854298) | |||
| 103752 | 103752 | 88795 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51707 | 6003948.0 | 2099953.0 | 37.7462944444026 | -122.429070556888 | (37.7462944444026, -122.429070556888) | ||
| 103874 | 103874 | 37997 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 103965 | 103965 | 45702 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
| 104470 | 104470 | 94209 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 465 Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013657.9 | 2104935.9 | 37.760521277448504 | -122.395843745126 | (37.7605212774485, -122.395843745126) | ||
| 104554 | 104554 | 38282 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 104879 | 104879 | 94466 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4128 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 104946 | 104946 | 116764 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 598X EUREKA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001504.0 | 2102368.0 | 37.7527868092986 | -122.43769452795601 | (37.7527868092986, -122.437694527956) | ||||
| 105013 | 105013 | 38283 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 106035 | 106035 | 94207 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 465 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013657.9 | 2104935.9 | 37.760521277448504 | -122.395843745126 | (37.7605212774485, -122.395843745126) | ||
| 106126 | 106126 | 32932 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 106212 | 106212 | 34996 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40965 | 6004109.16234729 | 2102931.20405913 | 37.7544810193688 | -122.42872554735001 | (37.7544810193688, -122.42872554735) | ||
| 106233 | 106233 | 58432 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 826 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17579 | 5999154.89175324 | 2107511.77145677 | 37.7667764794344 | -122.44618811299601 | (37.7667764794344, -122.446188112996) | |||
| 106315 | 106315 | 94208 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 465 Missouri St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53589 | 6013657.9 | 2104935.9 | 37.760521277448504 | -122.395843745126 | (37.7605212774485, -122.395843745126) | ||
| 106400 | 106400 | 95318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2870 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2011 12:00:00 AM | 3x3 | Permit Number 54638 | 6000976.2 | 2116269.7 | 37.7909273706115 | -122.440516734748 | (37.7909273706115, -122.440516734748) | ||
| 106403 | 106403 | 102105 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2104 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | Permit Number 769122 | 6002645.0 | 2099438.0 | 37.7448065304391 | -122.43353937189501 | (37.7448065304391, -122.433539371895) | |||
| 107189 | 107189 | 39075 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2280X Alameda St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40778 | 6010277.76687759 | 2108009.04739866 | 37.7687708195348 | -122.40775082962 | (37.7687708195348, -122.40775082962) | ||
| 108069 | 108069 | 53167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 108837 | 108837 | 37996 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 108928 | 108928 | 37989 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 108957 | 108957 | 88796 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2008 12:00:00 AM | 3x3 | Permit Number 51707 | 6003948.0 | 2099953.0 | 37.7462944444026 | -122.429070556888 | (37.7462944444026, -122.429070556888) | ||
| 109086 | 109086 | 33481 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 11 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37592 | 6007052.40604971 | 2099676.37615129 | 37.7457101385308 | -122.418316258344 | (37.7457101385308, -122.418316258344) | ||
| 109347 | 109347 | 104937 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 839 Gonzalez Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 109505 | 109505 | 111134 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 109586 | 109586 | 92904 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 109644 | 109644 | 37048 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39654 | 6004964.24246187 | 2098693.46332425 | 37.742893518466396 | -122.42546688829701 | (37.7428935184664, -122.425466888297) | ||
| 110021 | 110021 | 88360 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4969 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51338 | 5997573.8 | 2105584.6 | 37.761394534839894 | -122.451517798676 | (37.7613945348399, -122.451517798676) | |||
| 111067 | 111067 | 97499 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||||
| 111153 | 111153 | 108936 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001019.9 | 2101294.0 | 37.749810325724 | -122.439291655065 | (37.749810325724, -122.439291655065) | ||||
| 111161 | 111161 | 60915 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 354 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1983 12:00:00 AM | 3x3 | Permit Number 20712 | 6010590.61276424 | 2106675.77296786 | 37.7651274602752 | -122.40657474758301 | (37.7651274602752, -122.406574747583) | ||
| 111573 | 111573 | 38271 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
| 111642 | 111642 | 37994 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
| 111821 | 111821 | 92059 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 18 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767461 | 6000842.0 | 2103210.0 | 37.7550610743794 | -122.44004420959999 | (37.7550610743794, -122.4400442096) | |
| 111969 | 111969 | 116766 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 598X EUREKA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001504.0 | 2102368.0 | 37.7527868092986 | -122.43769452795601 | (37.7527868092986, -122.437694527956) | ||||
| 111983 | 111983 | 53171 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 112317 | 112317 | 85318 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1278 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2007 12:00:00 AM | Permit Number 49596 | 5989890.9 | 2106671.2 | 37.76393508945571 | -122.478168901115 | (37.7639350894557, -122.478168901115) | |||
| 113028 | 113028 | 110257 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 114133 | 114133 | 113561 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 4048x 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002743.0 | 2104796.0 | 37.759523888095 | -122.433583350579 | (37.759523888095, -122.433583350579) | ||||
| 114209 | 114209 | 104934 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 62 | 805 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990419.0 | 2090610.0 | 37.7198658237335 | -122.475169782631 | (37.7198658237335, -122.475169782631) | |||||
| 114893 | 114893 | 112001 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1230x STANYAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997480.0 | 2105522.0 | 37.7612172791461 | -122.451837695923 | (37.7612172791461, -122.451837695923) | ||||
| 115162 | 115162 | 112277 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 100x BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998324.0 | 2108210.0 | 37.7686461515867 | -122.449112322085 | (37.7686461515867, -122.449112322085) | ||||
| 115193 | 115193 | 44217 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43664 | 6000710.69184788 | 2110000.79371699 | 37.7736994385051 | -122.440985455094 | (37.7736994385051, -122.440985455094) | ||||
| 115764 | 115764 | 53165 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
| 116383 | 116383 | 121705 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 116518 | 116518 | 112002 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1230x STANYAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997480.0 | 2105522.0 | 37.7612172791461 | -122.451837695923 | (37.7612172791461, -122.451837695923) | ||||
| 116718 | 116718 | 32665 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
| 116771 | 116771 | 110256 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1199x 22ND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6014477.0 | 2103943.0 | 37.7578405224149 | -122.39294136189501 | (37.7578405224149, -122.392941361895) | ||||
| 118334 | 118334 | 111131 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2030x HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5x5.5 | 5998060.0 | 2109954.0 | 37.773419625938295 | -122.450151194281 | (37.7734196259383, -122.450151194281) | |||
| 118676 | 118676 | 36673 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1647 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39478 | 6006478.405230001 | 2107274.55540736 | 37.76654065447671 | -122.420840412073 | (37.7665406544767, -122.420840412073) | ||
| 119042 | 119042 | 92906 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 119786 | 119786 | 60800 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 150 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1983 12:00:00 AM | Permit Number 20475 | 6001683.44318293 | 2107946.37738027 | 37.768113877675 | -122.43747341695801 | (37.768113877675, -122.437473416958) | |||
| 120300 | 120300 | 92902 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 5300 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 6014342.0 | 2093555.0 | 37.7293097445839 | -122.39268157233101 | (37.7293097445839, -122.392681572331) | ||||
| 121012 | 121012 | 116266 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2340 SUTTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001385.0 | 2114274.0 | 37.7854709624663 | -122.438959223563 | (37.7854709624663, -122.438959223563) | ||||
| 121023 | 121023 | 121709 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014452.0 | 2103050.0 | 37.7553871476328 | -122.39296534494 | (37.7553871476328, -122.39296534494) | |||||
| 121033 | 121033 | 38222 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2291 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40349 | 5991678.28674141 | 2099849.72262287 | 37.745308688082396 | -122.471489828106 | (37.7453086880824, -122.471489828106) | |||
| 121450 | 121450 | 112003 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1230x STANYAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997480.0 | 2105522.0 | 37.7612172791461 | -122.451837695923 | (37.7612172791461, -122.451837695923) | ||||
| 121451 | 121451 | 104586 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1402-1404 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769723 | 6007895.0 | 2107427.3 | 37.767039799886795 | -122.415951466126 | (37.7670397998868, -122.415951466126) | |||
| 121761 | 121761 | 33593 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 221 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37700 | 6006820.21311038 | 2097865.60877622 | 37.7407251042318 | -122.418990739568 | (37.7407251042318, -122.418990739568) | |||
| 122007 | 122007 | 39514 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 10 Vicksburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40964 | 6004053.55723632 | 2102994.83081039 | 37.7546525762409 | -122.428922380275 | (37.7546525762409, -122.428922380275) | |||
| 122115 | 122115 | 30568 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2681 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34545 | 6008703.52928477 | 2122408.3500681 | 37.8082195561589 | -122.41421491247101 | (37.8082195561589, -122.414214912471) | ||||
| 122400 | 122400 | 38006 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2555 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40217 | 5992035.60667724 | 2098055.00516972 | 37.740401516958705 | -122.47012362496099 | (37.7404015169587, -122.470123624961) |
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");