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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43368 | 43368 | 66634 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 963 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2000 12:00:00 AM | 5 | 3x3 | Permit Number 29842 | 6010240.69544356 | 2103618.46143652 | 37.756713189996795 | -122.407569458435 | (37.7567131899968, -122.407569458435) |
| 45247 | 45247 | 32993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | |
| 46651 | 46651 | 55949 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2814 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1989 12:00:00 AM | 3 | Permit Number 28156 | 5999490.08281 | 2118090.45953 | 37.7958419601055 | -122.44578961952101 | (37.7958419601055, -122.445789619521) | ||
| 47292 | 47292 | 54971 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 558 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1974 12:00:00 AM | 14 | Permit Number 14440 | 5993167.14361 | 2111676.4715400003 | 37.7778678620954 | -122.467201401573 | (37.7778678620954, -122.467201401573) | ||
| 47772 | 47772 | 69334 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2059 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1994 12:00:00 AM | 12 | Permit Number 33419 | 6003702.41325 | 2117935.1422599996 | 37.795655107937705 | -122.43120308357 | (37.7956551079377, -122.43120308357) | ||
| 48424 | 48424 | 91161 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007091.03056 | 2112582.20177 | 37.7811486961969 | -122.41909796060101 | (37.7811486961969, -122.419097960601) | |
| 48967 | 48967 | 47103 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.777158358184295 | -122.45799622921801 | (37.7771583581843, -122.457996229218) | ||
| 50325 | 50325 | 32022 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 3 | Permit Number 35413 | 6001178.71293 | 2116932.64189 | 37.7927591659501 | -122.43986360254499 | (37.7927591659501, -122.439863602545) | ||
| 51305 | 51305 | 30285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 8 | Permit Number 132 | 6008895.30173 | 2117592.00623 | 37.7950058459972 | -122.41321042471901 | (37.7950058459972, -122.413210424719) | ||
| 51546 | 51546 | 49734 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 52546 | 52546 | 68218 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 233 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/2010 12:00:00 AM | 4 | Permit Number 53885 | 5990842.3093 | 2113821.7941400004 | 37.7836238495535 | -122.475400406913 | (37.7836238495535, -122.475400406913) | |
| 52918 | 52918 | 41547 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | |||
| 55580 | 55580 | 41342 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 965 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | 4 | 3x3 | Permit Number 45442 | 6011232.3538 | 2111749.1886 | 37.77909377896079 | -122.40471230492099 | (37.7790937789608, -122.404712304921) |
| 56384 | 56384 | 83010 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 507 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52387 | 6011806.26016 | 2105993.89934 | 37.763323124185 | -122.402322147448 | (37.763323124185, -122.402322147448) | |
| 59286 | 59286 | 46632 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.728578532365496 | -122.389527911332 | (37.7285785323655, -122.389527911332) |
| 61149 | 61149 | 96876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 61499 | 61499 | 97836 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 61732 | 61732 | 55989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 653 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1973 12:00:00 AM | 11 | Permit Number 12064 | 6013032.801630001 | 2104035.48043 | 37.7580141275685 | -122.397942523747 | (37.7580141275685, -122.397942523747) | ||
| 62540 | 62540 | 32997 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.39805475731501 | (37.784617751847, -122.398054757315) | |
| 62594 | 62594 | 30619 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.41516782897499 | (37.7703758225592, -122.415167828975) | |
| 62973 | 62973 | 88990 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6012998.85994 | 2113529.8478599996 | 37.7840816336096 | -122.39872619837601 | (37.7840816336096, -122.398726198376) | |||
| 63412 | 63412 | 66733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1133 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/1991 12:00:00 AM | Permit Number 29980 | 6008997.0 | 2116859.0 | 37.7929988993441 | -122.41280668476999 | (37.7929988993441, -122.41280668477) | |||
| 64971 | 64971 | 94464 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 894 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53682 | 6011686.524 | 2112270.5705 | 37.780550746456896 | -122.403177821901 | (37.7805507464569, -122.403177821901) | |
| 65548 | 65548 | 100582 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 66017 | 66017 | 52720 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 710@ 20th ST Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2006 12:00:00 AM | Permit Number 48773 | 6002386.64959974 | 2104032.25895211 | 37.757406613771 | -122.43476116987699 | (37.757406613771, -122.434761169877) | |||
| 66171 | 66171 | 31077 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.766563649504704 | -122.422496504935 | (37.7665636495047, -122.422496504935) | |
| 69045 | 69045 | 30575 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.932680001 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | |
| 70270 | 70270 | 48869 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 375 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 23 | Permit Number 46077 | 6013801.17849 | 2105352.33133 | 37.7616726766835 | -122.39537738027501 | (37.7616726766835, -122.395377380275) | ||
| 71363 | 71363 | 32451 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4444 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 14 | Permit Number 36969 | 5999681.89649 | 2105763.6737900004 | 37.7620067217593 | -122.444239665821 | (37.7620067217593, -122.444239665821) | |
| 72202 | 72202 | 91162 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.347019999 | 2112584.78934 | 37.781157001421704 | -122.41902439967801 | (37.7811570014217, -122.419024399678) | |
| 74746 | 74746 | 61926 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1985 12:00:00 AM | 6 | Permit Number 21980 | 6011757.5002 | 2112339.2572 | 37.78074330769329 | -122.402937112534 | (37.7807433076933, -122.402937112534) | ||
| 74871 | 74871 | 97841 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6015209.75012 | 2104419.2004 | 37.7591887410927 | -122.390440457463 | (37.7591887410927, -122.390440457463) | ||||
| 75118 | 75118 | 53259 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 210 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 15 | Permit Number 6149 | 5997600.12702 | 2115607.0052799997 | 37.7889149689082 | -122.452149910107 | (37.7889149689082, -122.452149910107) | ||
| 77382 | 77382 | 22315 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
| 78368 | 78368 | 55226 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1973 12:00:00 AM | 3x3 | Permit Number 51714 | 6015214.86332087 | 2104389.48828919 | 37.7591074416555 | -122.390420697382 | (37.7591074416555, -122.390420697382) | ||
| 78604 | 78604 | 17574 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 752X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 16 | 3x3 | 6003494.26805 | 2090459.52433 | 37.7202018157394 | -122.429962428847 | (37.7202018157394, -122.429962428847) | ||
| 78899 | 78899 | 100580 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 79112 | 79112 | 98464 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1999X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005154.5 | 2116787.4 | 37.7925858789052 | -122.426096853469 | (37.7925858789052, -122.426096853469) | ||||
| 79538 | 79538 | 52664 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1328C. CHAVEZ Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50454 | 6003228.63897895 | 2100503.21297012 | 37.747764453898604 | -122.431597294154 | (37.7477644538986, -122.431597294154) | ||
| 80370 | 80370 | 102181 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1800X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 37814 | 6003496.6 | 2114956.8 | 37.7874656747779 | -122.431702484378 | (37.7874656747779, -122.431702484378) | ||
| 80552 | 80552 | 46874 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.793556898770795 | -122.416132380604 | (37.7935568987708, -122.416132380604) | ||
| 80992 | 80992 | 93040 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4076 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001828.0 | 2105877.0 | 37.762440092603505 | -122.43682525386002 | (37.7624400926035, -122.43682525386) | |||
| 81162 | 81162 | 89025 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2724 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774819 | 6000906.5 | 2116912.2 | 37.792687538981205 | -122.440804001611 | (37.7926875389812, -122.440804001611) | |
| 81200 | 81200 | 88338 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541.0 | 2091742.0 | 37.723669175153205 | -122.43334915015801 | (37.7236691751532, -122.433349150158) | |||
| 81495 | 81495 | 31073 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | ||
| 81580 | 81580 | 97846 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2015 12:00:00 AM | 3 | Permit Number 775024 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | ||
| 81725 | 81725 | 87967 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51002 | 6000425.8 | 2112036.7 | 37.779273289788605 | -122.442117107328 | (37.7792732897886, -122.442117107328) | ||
| 82060 | 82060 | 97851 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 82092 | 82092 | 94046 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 42 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53454 | 5998445.0 | 2106022.0 | 37.7626453762737 | -122.44853619655001 | (37.7626453762737, -122.44853619655) | ||||
| 82532 | 82532 | 35613 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2839 Pacific Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2011 12:00:00 AM | 6 | 3x3 | Permit Number 768494 | 6000560.21131744 | 2116797.97814823 | 37.7923541883271 | -122.44199396863998 | (37.7923541883271, -122.44199396864) | |
| 82543 | 82543 | 107991 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 82805 | 82805 | 44113 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 83623 | 83623 | 33935 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1932 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1997 12:00:00 AM | Permit Number 43529 | 6003424.24641356 | 2115332.27843331 | 37.7884925418667 | -122.43197963503201 | (37.7884925418667, -122.431979635032) | |||
| 83765 | 83765 | 97839 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 83814 | 83814 | 2633 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1884 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004452.48891 | 2115034.49338 | 37.7877331379393 | -122.428400842266 | (37.7877331379393, -122.428400842266) | |||
| 83953 | 83953 | 50808 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 499 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2006 12:00:00 AM | Permit Number 47332 | 6008981.38895406 | 2105919.05287132 | 37.762959519157704 | -122.412087198232 | (37.7629595191577, -122.412087198232) | ||
| 84105 | 84105 | 103418 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015432.6 | 2105817.0 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | ||||
| 84600 | 84600 | 114012 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 952 CAPP ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6007364.0 | 2101732.0 | 37.7513719527851 | -122.417384460989 | (37.7513719527851, -122.417384460989) | ||||
| 84660 | 84660 | 64129 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 662 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52075 | 6002246.83688253 | 2098888.05007266 | 37.7432738978208 | -122.43487682109199 | (37.7432738978208, -122.434876821092) | ||
| 84727 | 84727 | 35673 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 84762 | 84762 | 40174 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 801 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2006 12:00:00 AM | 8 | Permit Number 48884 | 6002465.36284573 | 2103545.36770604 | 37.756074195699206 | -122.43445413726101 | (37.7560741956992, -122.434454137261) | |
| 84787 | 84787 | 17611 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 84805 | 84805 | 45714 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4096 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Permit Number 44384 | 6001696.66920871 | 2105876.07387076 | 37.7624300847566 | -122.437279411511 | (37.7624300847566, -122.437279411511) | ||
| 85357 | 85357 | 97840 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 85459 | 85459 | 97850 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 85712 | 85712 | 7527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008275.78702 | 2102017.83073 | 37.7522080378675 | -122.41425160630101 | (37.7522080378675, -122.414251606301) | |||
| 85923 | 85923 | 53738 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 660-662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/1972 12:00:00 AM | 4x4 | Permit Number 9418 | 6002127.0 | 2102089.0 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | ||
| 86647 | 86647 | 46504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 87102 | 87102 | 17494 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 98X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001936.09269 | 2091434.7408900002 | 37.722791174441106 | -122.43541823832199 | (37.7227911744411, -122.435418238322) | |||
| 87124 | 87124 | 45652 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 87420 | 87420 | 51550 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1247 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2005 12:00:00 AM | Permit Number 47849 | 5999742.39026173 | 2108428.18336747 | 37.7693262500826 | -122.444221920277 | (37.7693262500826, -122.444221920277) | |||
| 87640 | 87640 | 54877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 317 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1972 12:00:00 AM | 4x3 | Permit Number 10739 | 6005042.77490786 | 2109859.41873684 | 37.7735570424684 | -122.425990029724 | (37.7735570424684, -122.425990029724) | ||
| 87858 | 87858 | 45651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 88211 | 88211 | 51850 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4000 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.43267780892599 | (37.7594924661239, -122.432677808926) | |||
| 88397 | 88397 | 48676 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | ||
| 88731 | 88731 | 7571 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2961 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008420.23555 | 2101188.1699900003 | 37.749938088747605 | -122.41369340153601 | (37.7499380887476, -122.413693401536) | |||
| 88823 | 88823 | 45650 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 88869 | 88869 | 32534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632005 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | ||
| 88936 | 88936 | 87143 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50131 | 6008226.0 | 2104427.0 | 37.7588202724984 | -122.414594246502 | (37.7588202724984, -122.414594246502) | |
| 89302 | 89302 | 31777 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.74110093693479 | -122.47907928432699 | (37.7411009369348, -122.479079284327) | ||
| 89612 | 89612 | 59005 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3709 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1997 12:00:00 AM | 8 | 3x3 | Permit Number 18296 | 6005582.97907977 | 2104283.94686981 | 37.7582786381985 | -122.423724875571 | (37.7582786381985, -122.423724875571) | |
| 90128 | 90128 | 49733 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 90349 | 90349 | 23649 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 213 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1998 12:00:00 AM | 12 | 3X3 | 6006799.15969 | 2098412.34568 | 37.7422251360414 | -122.41910230566002 | (37.7422251360414, -122.41910230566) | ||
| 90355 | 90355 | 98463 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1999X Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6005166.0 | 2116743.0 | 37.7924646176623 | -122.42605390085501 | (37.7924646176623, -122.426053900855) | |||
| 90615 | 90615 | 41880 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 126 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42256 | 6004087.67177215 | 2108230.12497736 | 37.7690293739028 | -122.429177676408 | (37.7690293739028, -122.429177676408) | |
| 91804 | 91804 | 63541 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2405 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50131 | 6008226.96496954 | 2104416.66761012 | 37.758791956333795 | -122.414590178015 | (37.7587919563338, -122.414590178015) | |
| 91822 | 91822 | 44116 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 92031 | 92031 | 7591 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3025 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | |||
| 92068 | 92068 | 22316 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | |||
| 92745 | 92745 | 95635 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 111X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777379 | 6007972.0 | 2107962.0 | 37.76851228983521 | -122.415722998498 | (37.7685122898352, -122.415722998498) | |
| 92898 | 92898 | 47527 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 93037 | 93037 | 87305 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 93066 | 93066 | 51562 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4083 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | 18 | Permit Number 47860 | 6001768.0 | 2105813.0 | 37.7622609540043 | -122.43702818916701 | (37.7622609540043, -122.437028189167) | ||
| 93203 | 93203 | 50430 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 53REVISED Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2004 12:00:00 AM | Permit Number 47083 | 5998656.22086914 | 2105364.79387751 | 37.76085292760639 | -122.447758347691 | (37.7608529276064, -122.447758347691) | ||
| 94108 | 94108 | 88329 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 120 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940.0 | 2092960.0 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | |||
| 95162 | 95162 | 18010 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2706 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6000978.8550569 | 2114898.1888313 | 37.787161707579 | -122.440409143182 | (37.787161707579, -122.440409143182) | |||
| 95172 | 95172 | 100581 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 95763 | 95763 | 33602 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 200X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | 9 | Permit Number 37716 | 6006727.64769195 | 2098397.31693347 | 37.7421798430719 | -122.419348506645 | (37.7421798430719, -122.419348506645) | ||
| 95800 | 95800 | 87308 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 95821 | 95821 | 36145 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) |
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");