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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2748 | 2748 | 30802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.8302099998 | 37.733802178321 | -122.43669510478998 | (37.733802178321, -122.43669510479) |
| 8472 | 8472 | 46875 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) |
| 17976 | 17976 | 46914 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 19273 | 19273 | 48943 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901001 | (37.7524811515419, -122.40536498901) | ||
| 19810 | 19810 | 47528 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 2 | 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) | ||
| 28795 | 28795 | 33125 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 13 | 6x7 | Permit Number 37358 | 6001538.52427 | 2119069.35252 | 37.7986464896046 | -122.43877182467699 | (37.7986464896046, -122.438771824677) |
| 35199 | 35199 | 32994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.849280001 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | |
| 39927 | 39927 | 32998 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.784654089848296 | -122.398013908317 | (37.7846540898483, -122.398013908317) | |
| 40339 | 40339 | 48429 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 10 | Permit Number 45807 | 6001230.18864 | 2118334.23878 | 37.7966105144187 | -122.439786028808 | (37.7966105144187, -122.439786028808) | |
| 40344 | 40344 | 31076 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.3894700003 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | |
| 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) | |
| 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) | |
| 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) |
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 101498 | 101498 | 36930 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | Permit Number 45859 | 6001519.66406839 | 2103540.62826183 | 37.756007454894096 | -122.437724334797 | (37.7560074548941, -122.437724334797) | ||
| 102344 | 102344 | 115732 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 ORD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 22 | 3x3 | 6000874.0 | 2105811.0 | 37.7622046070719 | -122.44012004716801 | (37.7622046070719, -122.440120047168) | ||
| 103920 | 103920 | 117152 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.72855094559029 | -122.389513905896 | (37.7285509455903, -122.389513905896) | |||
| 106640 | 106640 | 98271 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 109027 | 109027 | 47022 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 340 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769670 | 6004925.00265887 | 2109895.52879881 | 37.7736495352098 | -122.426399993288 | (37.7736495352098, -122.426399993288) |
| 109285 | 109285 | 98270 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 110663 | 110663 | 43563 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 511 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | ||
| 111376 | 111376 | 43394 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 625 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43137 | 6002354.2327444 | 2102058.9743147 | 37.751986605483395 | -122.434732175811 | (37.7519866054834, -122.434732175811) | ||
| 113790 | 113790 | 44268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 115214 | 115214 | 48645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | ||
| 115943 | 115943 | 41185 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3440 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 2 | Permit Number 41903 | 6001280.224090001 | 2120345.1134900004 | 37.8021346936235 | -122.439757137177 | (37.8021346936235, -122.439757137177) | |
| 116270 | 116270 | 31072 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 7 | 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) | ||
| 116642 | 116642 | 34293 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 7 | Permit Number 45961 | 6010202.37211243 | 2101668.36098933 | 37.7513565026505 | -122.407564507802 | (37.7513565026505, -122.407564507802) | |
| 118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 118928 | 118928 | 32532 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 1 | 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) | ||
| 119017 | 119017 | 36147 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 3 | 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) | ||
| 120457 | 120457 | 35492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | ||
| 120581 | 120581 | 46913 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 120654 | 120654 | 102761 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.40821818771099 | (37.7785759102049, -122.408218187711) |
| 121291 | 121291 | 47711 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.73697948454021 | -122.435360375218 | (37.7369794845402, -122.435360375218) | ||
| 121897 | 121897 | 43393 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | ||
| 124491 | 124491 | 50045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | |
| 125148 | 125148 | 44267 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | ||
| 127445 | 127445 | 66565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702438996 | -122.426754065425 | (37.725220702439, -122.426754065425) | ||
| 128211 | 128211 | 41906 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.43245531412902 | (37.7682150777502, -122.432455314129) | ||
| 128748 | 128748 | 32533 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 70 Porter St | 2 | 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) | ||
| 132509 | 132509 | 46780 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.43357175935301 | (37.7283552769641, -122.433571759353) | |
| 135957 | 135957 | 51918 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.924319999 | 2091688.24542 | 37.72335998726889 | -122.443166369055 | (37.7233599872689, -122.443166369055) | |
| 140165 | 140165 | 63730 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | |
| 141515 | 141515 | 68693 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 600 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 12 | 3x3 | Permit Number 32603 | 5993650.82821 | 2113525.7859099996 | 37.7829734883164 | -122.46566257132 | (37.7829734883164, -122.46566257132) |
| 142125 | 142125 | 37290 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 12 | 3x3 | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) |
| 144361 | 144361 | 43363 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.751161655763894 | -122.435122856595 | (37.7511616557639, -122.435122856595) | ||
| 144802 | 144802 | 46912 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 147738 | 147738 | 33318 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2604 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37462 | 6004913.93801 | 2118560.0081599997 | 37.7974394114518 | -122.42705551819401 | (37.7974394114518, -122.427055518194) | |
| 149318 | 149318 | 36939 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.78649992768511 | -122.461372345087 | (37.7864999276851, -122.461372345087) | |
| 150713 | 150713 | 32996 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.022469999 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | |
| 151074 | 151074 | 61321 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1493 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1984 12:00:00 AM | 2 | Permit Number 21224 | 6011782.729590001 | 2101393.64443 | 37.750690525464 | -122.40208010571999 | (37.750690525464, -122.40208010572) | |
| 153324 | 153324 | 67600 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 555 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 10 | Permit Number 31170 | 6013571.5238 | 2104494.52261 | 37.7593045458768 | -122.39611154992599 | (37.7593045458768, -122.396111549926) | |
| 159168 | 159168 | 36885 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2914 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 9 | Permit Number 39542 | 6000200.3438800005 | 2116470.40485 | 37.79143424424 | -122.443215577236 | (37.79143424424, -122.443215577236) | |
| 159272 | 159272 | 69124 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.42567920498301 | (37.7760283687547, -122.425679204983) | |
| 160075 | 160075 | 31075 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 7 | Permit Number 34816 | 6005979.98097 | 2107292.47987 | 37.76656176455071 | -122.422565649286 | (37.7665617645507, -122.422565649286) | |
| 162741 | 162741 | 33151 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.741869787152204 | -122.487350256926 | (37.7418697871522, -122.487350256926) | |
| 166094 | 166094 | 32995 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.2659299998 | 37.7844388182424 | -122.39828029921499 | (37.7844388182424, -122.398280299215) | |
| 172702 | 172702 | 36148 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 7 | Permit Number 39234 | 6010838.36126 | 2106450.88886 | 37.764523836941294 | -122.40570200024099 | (37.7645238369413, -122.405702000241) | |
| 181708 | 181708 | 33124 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2380 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 12 | 6x6 | Permit Number 37358 | 6001499.40758 | 2119065.9057400003 | 37.7986348002003 | -122.438906933417 | (37.7986348002003, -122.438906933417) |
| 188652 | 188652 | 32989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.3325900002 | 37.784324082736795 | -122.398422883105 | (37.7843240827368, -122.398422883105) | |
| 30589 | 30589 | 80188 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2002 12:00:00 AM | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.41326474488501 | (37.7723172927739, -122.413264744885) | ||
| 33611 | 33611 | 72449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.45334848155899 | (37.7873175292136, -122.453348481559) | ||
| 47159 | 47159 | 74944 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010701.03805 | 2106443.01503 | 37.7644945370101 | -122.40617641152201 | (37.7644945370101, -122.406176411522) | ||
| 63175 | 63175 | 74494 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.40595773775699 | (37.7645082103165, -122.405957737757) | ||
| 69807 | 69807 | 72412 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3485 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 10 | 5997617.1015 | 2116066.53919 | 37.7901776988858 | -122.452124350462 | (37.7901776988858, -122.452124350462) | ||
| 70239 | 70239 | 74649 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010746.42629 | 2106444.22464 | 37.76450039699821 | -122.406019510419 | (37.7645003969982, -122.406019510419) | ||
| 71159 | 71159 | 84446 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000457.5617 | 2112125.7689 | 37.77951966026271 | -122.442013625663 | (37.7795196602627, -122.442013625663) | |||
| 130811 | 130811 | 81238 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2003 12:00:00 AM | 4 | 6008758.1555 | 2109381.0971 | 37.772452961277295 | -122.41310410127 | (37.7724529612773, -122.41310410127) | ||
| 150080 | 150080 | 93910 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 16 | 3x3 | 6001101.2138 | 2114914.769 | 37.7872141986511 | -122.439986998855 | (37.7872141986511, -122.439986998855) | ||
| 151038 | 151038 | 72448 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3681 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 11 | 5997285.67318 | 2115040.09705 | 37.7873403720155 | -122.45319692960899 | (37.7873403720155, -122.453196929609) | ||
| 152569 | 152569 | 74234 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 13 | 5997222.04614 | 2115031.5317599997 | 37.787313207081795 | -122.45341644603 | (37.7873132070818, -122.45341644603) | ||
| 156352 | 156352 | 83476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 674-680 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 7 | 6015406.08252 | 2105913.749 | 37.763303339101 | -122.38986583564301 | (37.763303339101, -122.389865835643) | ||
| 160503 | 160503 | 73760 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3485 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 10 | 5997597.70095 | 2116065.74811 | 37.7901744154595 | -122.452191417426 | (37.7901744154595, -122.452191417426) | ||
| 163680 | 163680 | 76181 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) |
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");