Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3384 | 3384 | 242759 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 99 Ord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000876.8584 | 2105865.2464 | 37.7623537170769 | -122.440114051125 | (37.7623537170769, -122.440114051125) | |||
| 3831 | 3831 | 30286 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 10 | Permit Number 132 | 6008896.76565 | 2117570.49119 | 37.794946853168604 | -122.41320383718599 | (37.7949468531686, -122.413203837186) | ||
| 5180 | 5180 | 17545 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6003118.2023599995 | 2090743.3942599997 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | |||
| 6566 | 6566 | 2631 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1884 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004489.1648 | 2115039.2121 | 37.787748169652204 | -122.428274287097 | (37.7877481696522, -122.428274287097) | |||
| 8667 | 8667 | 6037 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1822 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51912 | 6001625.9468 | 2112554.8978 | 37.7807644518495 | -122.43800243798 | (37.7807644518495, -122.43800243798) | |
| 10250 | 10250 | 7523 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6008355.713819999 | 2102061.13803 | 37.752331439255705 | -122.413978269475 | (37.7523314392557, -122.413978269475) | |||
| 11239 | 11239 | 17609 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004106.27078 | 2090068.65464 | 37.7191632136975 | -122.42781910286999 | (37.7191632136975, -122.42781910287) | |||
| 11718 | 11718 | 17568 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 3x3 | 6003419.6169300005 | 2090505.6702299998 | 37.720324294201 | -122.430223763218 | (37.720324294201, -122.430223763218) | |||
| 13651 | 13651 | 85765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008925.8803 | 2109636.8219 | 37.773164535944794 | -122.412542002878 | (37.7731645359448, -122.412542002878) | ||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 14196 | 14196 | 85787 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1211 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6009621.8032 | 2110211.384 | 37.7747811809083 | -122.410175277249 | (37.7747811809083, -122.410175277249) | ||
| 15022 | 15022 | 85767 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008747.4583 | 2109466.0696 | 37.7726856753072 | -122.41314711365 | (37.7726856753072, -122.41314711365) | ||
| 15993 | 15993 | 85779 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009155.5683 | 2109764.3815 | 37.7735276724734 | -122.411756494108 | (37.7735276724734, -122.411756494108) | ||
| 17046 | 17046 | 7442 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2533 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008266.30803 | 2103660.34256 | 37.7567174706459 | -122.414400595608 | (37.7567174706459, -122.414400595608) | |||
| 17428 | 17428 | 7555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2906 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.30695 | 2101471.08552 | 37.750709860893394 | -122.41402439212601 | (37.7507098608934, -122.414024392126) | |||
| 17997 | 17997 | 7485 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2676 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008262.291898999 | 2102845.0627354 | 37.754478671863495 | -122.414356800841 | (37.7544786718635, -122.414356800841) | |||
| 18635 | 18635 | 102526 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 312 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769739 | 5998624.0 | 2115422.5 | 37.7884669637257 | -122.448594170268 | (37.7884669637257, -122.448594170268) | |||
| 19439 | 19439 | 28789 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2948 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6008341.65854 | 2101291.24867 | 37.7502167068411 | -122.413972416691 | (37.7502167068411, -122.413972416691) | ||
| 19576 | 19576 | 7525 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2804 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008301.92426 | 2102042.90132 | 37.7522783441942 | -122.41416299292601 | (37.7522783441942, -122.414162992926) | |||
| 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) | ||
| 20069 | 20069 | 7575 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2970 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4x4 | 6008351.10034 | 2101124.2510900004 | 37.749758699223705 | -122.413927954233 | (37.7497586992237, -122.413927954233) | |||
| 20521 | 20521 | 7487 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008318.247830001 | 2102788.20898 | 37.7543257074831 | -122.41415926793002 | (37.7543257074831, -122.41415926793) | |||
| 20891 | 20891 | 607 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008349.31996 | 2102181.9005400003 | 37.7526626667701 | -122.414008922882 | (37.7526626667701, -122.414008922882) | |||
| 20914 | 20914 | 4566 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106X Virginia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2016 12:00:00 AM | 12 | 3X3 | 6006479.71302 | 2098542.22808 | 37.742563769401606 | -122.42021607152901 | (37.7425637694016, -122.420216071529) | ||
| 21798 | 21798 | 7504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.67294 | 2102549.63808 | 37.75367134367279 | -122.414099421647 | (37.7536713436728, -122.414099421647) | |||
| 21975 | 21975 | 7428 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2507 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008259.11324 | 2103798.38895 | 37.757096110403 | -122.414435245589 | (37.757096110403, -122.414435245589) | |||
| 22148 | 22148 | 7498 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008269.84083 | 2102643.6447900003 | 37.7539260478636 | -122.414316444251 | (37.7539260478636, -122.414316444251) | |||
| 27973 | 27973 | 97268 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 769192 | 5999910.90621 | 2116024.41622 | 37.7901931681384 | -122.44418496098 | (37.7901931681384, -122.44418496098) | ||
| 39204 | 39204 | 32023 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 18 | Permit Number 35413 | 6001158.18036 | 2116931.31755 | 37.792754360865295 | -122.43993455095699 | (37.7927543608653, -122.439934550957) | ||
| 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) | |
| 40396 | 40396 | 97985 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6015230.10587 | 2104016.74085 | 37.7580848025885 | -122.39034193764499 | (37.7580848025885, -122.390341937645) | ||||
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | ||
| 97241 | 97241 | 102280 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4400X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 23102 | 6000531.3 | 2102322.2 | 37.7526056983006 | -122.441055007173 | (37.7526056983006, -122.441055007173) | ||
| 97919 | 97919 | 11876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 98136 | 98136 | 101139 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 169 Buena Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001425.0 | 2107346.2 | 37.7664512423305 | -122.438324340152 | (37.7664512423305, -122.438324340152) | ||||
| 99456 | 99456 | 7551 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2889 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6008375.88429 | 2101615.45305 | 37.7511088214431 | -122.41387699241899 | (37.7511088214431, -122.413876992419) | |||
| 101393 | 101393 | 82620 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.41622669003401 | (37.7626615773847, -122.416226690034) | ||
| 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) | ||
| 104368 | 104368 | 115739 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4077 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6001800.02048091 | 2105829.59496805 | 37.76230833972689 | -122.436918630667 | (37.7623083397269, -122.436918630667) | ||||
| 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) | |
| 106821 | 106821 | 87287 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
| 110843 | 110843 | 46502 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 2 | 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) | |||
| 113352 | 113352 | 107992 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 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) | |
| 119628 | 119628 | 7596 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3085 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | |||
| 119921 | 119921 | 92522 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005.0 | 2109688.0 | 37.773309499001996 | -122.412271934387 | (37.773309499002, -122.412271934387) | ||
| 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) | ||
| 120965 | 120965 | 97833 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 124040 | 124040 | 17622 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004279.363726401 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | |||
| 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) | ||
| 126297 | 126297 | 39478 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2856 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 777203 | 5999897.32915775 | 2117456.37972289 | 37.7941241886563 | -122.44433488583 | (37.7941241886563, -122.44433488583) | |||
| 127512 | 127512 | 93041 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4076 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001828.0 | 2105877.0 | 37.762440092603505 | -122.43682525386002 | (37.7624400926035, -122.43682525386) | |||
| 127611 | 127611 | 33762 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1800X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37814 | 6003491.84820405 | 2114902.28438826 | 37.7873157193536 | -122.431715030855 | (37.7873157193536, -122.431715030855) | |
| 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) | ||
| 132309 | 132309 | 89024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2724 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51769 | 6000900.18903 | 2116892.91159 | 37.7926342186313 | -122.440824453501 | (37.7926342186313, -122.440824453501) | |
| 142180 | 142180 | 102452 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 546 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 16394 | 6007849.0 | 2104746.0 | 37.7596749854601 | -122.41592068026199 | (37.7596749854601, -122.415920680262) | |||
| 142590 | 142590 | 17612 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 142917 | 142917 | 35675 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 2 | 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) | |
| 144247 | 144247 | 113083 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009864.0 | 2093047.0 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | ||||
| 146136 | 146136 | 37289 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.756122133683704 | -122.43445869367399 | (37.7561221336837, -122.434458693674) | |||
| 146705 | 146705 | 91339 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 829 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52060 | 6012087.196 | 2112565.923 | 37.7813840839391 | -122.401812466037 | (37.7813840839391, -122.401812466037) | |
| 166749 | 166749 | 81876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1209 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52375 | 6013966.08986 | 2105691.70822 | 37.762613702073004 | -122.394830783137 | (37.762613702073, -122.394830783137) | |
| 167125 | 167125 | 97272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768129 | 5999961.63318 | 2116061.04996 | 37.790296648615495 | -122.444012083414 | (37.7902966486155, -122.444012083414) | |
| 173944 | 173944 | 102277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 316 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 1 | 3x3 | Permit Number 776676 | 5998600.56179 | 2115376.04421 | 37.7883380681833 | -122.448671915192 | (37.7883380681833, -122.448671915192) | |
| 176776 | 176776 | 105953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | ||
| 180765 | 180765 | 88994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 680 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51742 | 6013026.737980001 | 2113549.67814 | 37.784137636178 | -122.39863114183201 | (37.784137636178, -122.398631141832) | |
| 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) |
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 2753 | 2753 | 198672 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 193 Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2017 12:00:00 AM | 3 | Width 4ft | 6010593.523440001 | 2111314.08538 | 37.777863361242105 | -122.406891615375 | (37.7778633612421, -122.406891615375) | ||
| 3378 | 3378 | 242510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008305.34942 | 2102000.42568 | 37.75216190805129 | -122.41414814334 | (37.7521619080513, -122.41414814334) | |||
| 8832 | 8832 | 101524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | |||
| 10054 | 10054 | 173830 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000494.0 | 2114864.0 | 37.7870402148899 | -122.442084176412 | (37.7870402148899, -122.442084176412) | ||||
| 13721 | 13721 | 98856 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008586.80061 | 2110533.83683 | 37.7756084919722 | -122.413778389761 | (37.7756084919722, -122.413778389761) | |||
| 14834 | 14834 | 74054 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 194X Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1998 12:00:00 AM | 5 | 5x5 | 6010549.99954 | 2111279.17691 | 37.7777650752333 | -122.407039719318 | (37.7777650752333, -122.407039719318) | ||
| 15420 | 15420 | 98859 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008542.44899 | 2110581.95524 | 37.775738122962295 | -122.413935218038 | (37.7757381229623, -122.413935218038) | |||
| 18487 | 18487 | 115018 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4311 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6000722.0 | 2105756.0 | 37.7620449359843 | -122.440641810954 | (37.7620449359843, -122.440641810954) | |||
| 23752 | 23752 | 242656 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 502 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001805.42394 | 2102865.73386 | 37.75417060141171 | -122.436687776224 | (37.7541706014117, -122.436687776224) | |||
| 24472 | 24472 | 242424 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 209 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005453.21466 | 2102408.07888 | 37.7531206159404 | -122.424040259559 | (37.7531206159404, -122.424040259559) | |||
| 25132 | 25132 | 242416 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3652 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.79468 | 2101978.6432 | 37.7519371701822 | -122.424273995163 | (37.7519371701822, -122.424273995163) | |||
| 25433 | 25433 | 137020 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6002995.15639 | 2117477.21245 | 37.7943576461387 | -122.433617572612 | (37.7943576461387, -122.433617572612) |
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");