Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 229 | 229 | 138803 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.787719421164496 | -122.434937251329 | (37.7877194211645, -122.434937251329) | |||
| 583 | 583 | 7548 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5x5 | 6008321.80095 | 2101666.80438 | 37.751246783135 | -122.414067651319 | (37.751246783135, -122.414067651319) | |||
| 3363 | 3363 | 7526 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2004 12:00:00 AM | 3 | 3x3 | 6008303.39209 | 2102027.1918 | 37.7522352918412 | -122.414156805597 | (37.7522352918412, -122.414156805597) | ||
| 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) | |||
| 3612 | 3612 | 18039 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2813 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000314.1463 | 2114749.1203 | 37.7867145338964 | -122.442698176369 | (37.7867145338964, -122.442698176369) | |||
| 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) | |||
| 6355 | 6355 | 12261 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2000 12:00:00 AM | 3 | 3X3 | 6004982.9117 | 2111116.4652 | 37.7770052022278 | -122.426286620749 | (37.7770052022278, -122.426286620749) | ||
| 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) | |||
| 6994 | 6994 | 18053 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2852 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000250.2377 | 2114802.0314 | 37.7868561706627 | -122.442923085267 | (37.7868561706627, -122.442923085267) | |||
| 7539 | 7539 | 18051 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1999 12:00:00 AM | 6 | 3X3PL | 6000336.3598 | 2114811.683 | 37.786887581121704 | -122.442625816895 | (37.7868875811217, -122.442625816895) | ||
| 7771 | 7771 | 96366 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1326 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6006664.3237 | 2118739.81484 | 37.7980319387709 | -122.421011488604 | (37.7980319387709, -122.421011488604) | |||
| 8302 | 8302 | 18045 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2821 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000216.4327 | 2114739.0872 | 37.786681414860894 | -122.44303552029801 | (37.7866814148609, -122.443035520298) | |||
| 9119 | 9119 | 18034 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2806 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000470.7399 | 2114833.2135 | 37.7869543575665 | -122.44216244014099 | (37.7869543575665, -122.442162440141) | |||
| 9245 | 9245 | 18044 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2819 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000236.9351 | 2114743.0132 | 37.7866933635797 | -122.442964869171 | (37.7866933635797, -122.442964869171) | |||
| 9284 | 9284 | 18024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2726 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000724.7507 | 2114865.5018 | 37.787057485761 | -122.441285940418 | (37.787057485761, -122.441285940418) | |||
| 9407 | 9407 | 18054 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2866 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6000216.8283 | 2114794.6071 | 37.7868338806489 | -122.443038140312 | (37.7868338806489, -122.443038140312) | |||
| 9589 | 9589 | 9765 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.778263187688296 | -122.440226567073 | (37.7782631876883, -122.440226567073) | ||
| 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) | |||
| 10288 | 10288 | 17565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.720429991522295 | -122.43015957951599 | (37.7204299915223, -122.430159579516) | |||
| 10346 | 10346 | 7524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2804 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008300.9450199995 | 2102065.01518 | 37.7523390088635 | -122.414167943693 | (37.7523390088635, -122.414167943693) | |||
| 10375 | 10375 | 17615 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004156.70512 | 2090037.9094200002 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | |||
| 10763 | 10763 | 17492 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 43 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 6001974.03166 | 2091459.77916 | 37.722862078497705 | -122.435288881679 | (37.7228620784977, -122.435288881679) | |||
| 10792 | 10792 | 17605 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 937 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003999.6997 | 2090190.6100400002 | 37.7194920472054 | -122.428196165219 | (37.7194920472054, -122.428196165219) | |||
| 11027 | 11027 | 17557 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 631 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003296.79143 | 2090629.3686 | 37.7206569849073 | -122.430657152829 | (37.7206569849073, -122.430657152829) | |||
| 11202 | 11202 | 17556 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003246.79786 | 2090613.7194400001 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | |||
| 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) | |||
| 11491 | 11491 | 17552 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 611 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003214.50174 | 2090682.11363 | 37.72079714875721 | -122.430945364856 | (37.7207971487572, -122.430945364856) | |||
| 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) | |||
| 12028 | 12028 | 17573 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6003469.3677199995 | 2090473.15538 | 37.720237833385404 | -122.430049472832 | (37.7202378333854, -122.430049472832) | |||
| 12044 | 12044 | 17598 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003858.866640001 | 2090228.3157 | 37.719587609170006 | -122.42868565992399 | (37.71958760917, -122.428685659924) | |||
| 12168 | 12168 | 17555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 625 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6003276.00472 | 2090644.70105 | 37.7206979067656 | -122.430730099534 | (37.7206979067656, -122.430730099534) | |||
| 12233 | 12233 | 17490 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 11 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 6001895.26392 | 2091509.73666 | 37.7229947770751 | -122.435564737019 | (37.7229947770751, -122.435564737019) | |||
| 12237 | 12237 | 17610 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6004083.7901099995 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | |||
| 12453 | 12453 | 17491 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001944.766 | 2091477.8994200001 | 37.722910170637896 | -122.435391342346 | (37.7229101706379, -122.435391342346) | |||
| 12659 | 12659 | 17567 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2x2 | 6003448.03192 | 2090486.73855 | 37.7202739213865 | -122.430124192087 | (37.7202739213865, -122.430124192087) | |||
| 12788 | 12788 | 17558 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 632 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6003270.54295 | 2090597.85658 | 37.7205689727677 | -122.430745637999 | (37.7205689727677, -122.430745637999) | |||
| 12801 | 12801 | 17521 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 301X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6002512.93657 | 2091121.04264 | 37.7219625730029 | -122.433401808174 | (37.7219625730029, -122.433401808174) | |||
| 12833 | 12833 | 17553 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.720753626054204 | -122.430852753549 | (37.7207536260542, -122.430852753549) | |||
| 13109 | 13109 | 17606 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 945X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004029.89293 | 2090169.1541 | 37.7194348422149 | -122.428090270065 | (37.7194348422149, -122.428090270065) | |||
| 13550 | 13550 | 85763 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1316 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009115.2013 | 2109815.2438 | 37.7736650638278 | -122.411899724934 | (37.7736650638278, -122.411899724934) | ||
| 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) | ||
| 13831 | 13831 | 85785 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 5 | 3x3 | 6009541.3755 | 2110133.2543 | 37.7745621465765 | -122.41044797634198 | (37.7745621465765, -122.410447976342) | ||
| 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) | ||
| 14198 | 14198 | 85789 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | ||
| 14226 | 14226 | 85788 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1161 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009943.5141 | 2110517.0093 | 37.775638383908 | -122.409083977926 | (37.775638383908, -122.409083977926) | ||
| 14279 | 14279 | 85795 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 985 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 12 | 3x3 | 6011121.9774 | 2111644.9134 | 37.7788012938106 | -122.405086799447 | (37.7788012938106, -122.405086799447) | ||
| 14624 | 14624 | 85764 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008969.0729 | 2109678.3998 | 37.7732811230446 | -122.412395532912 | (37.7732811230446, -122.412395532912) | ||
| 14682 | 14682 | 85769 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008582.3574 | 2109309.4458 | 37.7722463531305 | -122.413707137147 | (37.7722463531305, -122.413707137147) | ||
| 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) | ||
| 15327 | 15327 | 85762 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | ||
| 15965 | 15965 | 103752 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1631 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008153.3379999995 | 2108655.6685 | 37.7704271332463 | -122.41514487163099 | (37.7704271332463, -122.415144871631) | ||
| 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) | ||
| 16705 | 16705 | 85783 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1265 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009394.3077 | 2109993.0802 | 37.7741690156078 | -122.41094681212299 | (37.7741690156078, -122.410946812123) | ||
| 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) | |||
| 17137 | 17137 | 608 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008346.158869999 | 2102213.06871 | 37.7527480699909 | -122.41402205928101 | (37.7527480699909, -122.414022059281) | |||
| 17226 | 17226 | 7461 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2590 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008225.965890001 | 2103367.55132 | 37.7559112662001 | -122.41451939607599 | (37.7559112662001, -122.414519396076) | |||
| 17234 | 17234 | 7547 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2880 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008318.28918 | 2101705.8135599997 | 37.7513536963225 | -122.414082554892 | (37.7513536963225, -122.414082554892) | |||
| 17345 | 17345 | 7572 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2966 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6008349.712309999 | 2101178.7554599997 | 37.7499082780476 | -122.413936609292 | (37.7499082780476, -122.413936609292) | |||
| 17364 | 17364 | 7595 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3079 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008433.91036 | 2100662.40633 | 37.7484952272826 | -122.413608931409 | (37.7484952272826, -122.413608931409) | |||
| 17373 | 17373 | 4565 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106X Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006455.63138 | 2098554.07674 | 37.742594946206296 | -122.420300179707 | (37.7425949462063, -122.420300179707) | |||
| 17419 | 17419 | 7534 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2834 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008307.18508 | 2101915.21999 | 37.7519280555366 | -122.41413576777398 | (37.7519280555366, -122.414135767774) | |||
| 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) | |||
| 17485 | 17485 | 7545 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2873 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6008374.1374 | 2101703.06598 | 37.7513492887427 | -122.41388923032301 | (37.7513492887427, -122.413889230323) | |||
| 17526 | 17526 | 16671 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 235 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002921.57558 | 2106902.8692900003 | 37.7653189725275 | -122.43311628331399 | (37.7653189725275, -122.433116283314) | |||
| 17624 | 17624 | 4231 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3992 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2003 12:00:00 AM | 3 | 3X3 | 6003972.48487 | 2100441.01893 | 37.7476358171535 | -122.429020679863 | (37.7476358171535, -122.429020679863) | ||
| 17627 | 17627 | 7541 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2862 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008316.9211099995 | 2101778.89436 | 37.7515542829106 | -122.414092455501 | (37.7515542829106, -122.414092455501) | |||
| 17647 | 17647 | 7645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3299 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2008 12:00:00 AM | 3 | 4x4 | 6008510.32989 | 2099428.74367 | 37.74511215491329 | -122.41325744669201 | (37.7451121549133, -122.413257446692) | ||
| 17684 | 17684 | 7603 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3143 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1997 12:00:00 AM | 20 | 5x5 | 6008454.26481 | 2100356.41026 | 37.7476561733017 | -122.413516907381 | (37.7476561733017, -122.413516907381) | ||
| 17713 | 17713 | 7452 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2567 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008279.6651800005 | 2103491.16877 | 37.756253708264104 | -122.414342431978 | (37.7562537082641, -122.414342431978) | |||
| 17768 | 17768 | 16670 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 229 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002921.54578 | 2106923.92985 | 37.7653767980145 | -122.433117891273 | (37.7653767980145, -122.433117891273) | |||
| 17777 | 17777 | 7574 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2970 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008349.21001 | 2101154.19809 | 37.749840820806 | -122.413936609291 | (37.749840820806, -122.413936609291) | |||
| 17816 | 17816 | 7436 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2521 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008264.24768 | 2103717.0411400003 | 37.756873036289605 | -122.414411732822 | (37.7568730362896, -122.414411732822) | |||
| 17934 | 17934 | 7468 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2612 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008237.96607 | 2103167.04597 | 37.7553613982341 | -122.41446370825899 | (37.7553613982341, -122.414463708259) | |||
| 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) | |||
| 18040 | 18040 | 7529 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2819 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008358.68667 | 2102000.1305400003 | 37.752164093403294 | -122.413963673484 | (37.7521640934033, -122.413963673484) | |||
| 18068 | 18068 | 7513 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2756 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008281.04145 | 2102369.03072 | 37.7531726489075 | -122.414258281518 | (37.7531726489075, -122.414258281518) | |||
| 18174 | 18174 | 7503 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2721 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008331.5003 | 2102528.18533 | 37.753612485742295 | -122.41409504285 | (37.7536124857423, -122.41409504285) | |||
| 18255 | 18255 | 7469 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2623 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008298.43979 | 2103140.4111200003 | 37.7552916620849 | -122.414252686824 | (37.7552916620849, -122.414252686824) | |||
| 18329 | 18329 | 7501 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2004 12:00:00 AM | 6 | 3X3 | 6008270.89385 | 2102590.17173 | 37.7537792820952 | -122.414309019468 | (37.7537792820952, -122.414309019468) | ||
| 18353 | 18353 | 7435 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2520 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1999 12:00:00 AM | 18 | 3X3 | 6008207.33227 | 2103733.52781 | 37.756915107460706 | -122.414609734768 | (37.7569151074607, -122.414609734768) | ||
| 18443 | 18443 | 7462 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2595 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008288.941269999 | 2103332.41139 | 37.7558183176666 | -122.414299119707 | (37.7558183176666, -122.414299119707) | |||
| 18470 | 18470 | 7438 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2525 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008265.55566 | 2103676.03648 | 37.7567605203109 | -122.41440430801599 | (37.7567605203109, -122.414404308016) | |||
| 18529 | 18529 | 14595 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1237 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5999420.8847 | 2108569.3753 | 37.769695580046296 | -122.445344141815 | (37.7696955800463, -122.445344141815) | ||
| 18904 | 18904 | 7466 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2601 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008295.31777 | 2103224.31145 | 37.7555218579731 | -122.41426941961001 | (37.7555218579731, -122.41426941961) | |||
| 18924 | 18924 | 7460 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2585 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008283.172069999 | 2103400.23243 | 37.7560042147509 | -122.414323869978 | (37.7560042147509, -122.414323869978) | |||
| 18939 | 18939 | 7554 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2906 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008330.04331 | 2101493.18506 | 37.7507705264571 | -122.414026867047 | (37.7507705264571, -122.414026867047) | |||
| 19037 | 19037 | 7013 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1031 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1997 12:00:00 AM | 8 | 3X3 | 6002426.7807 | 2110189.6116 | 37.774315477420295 | -122.435062751747 | (37.7743154774203, -122.435062751747) | ||
| 19189 | 19189 | 7510 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2740 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008277.62193 | 2102459.7127 | 37.7534214490446 | -122.41427652245001 | (37.7534214490446, -122.41427652245) | |||
| 19287 | 19287 | 7488 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2675X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6008316.60225 | 2102810.93946 | 37.7543880278024 | -122.41416656683501 | (37.7543880278024, -122.414166566835) | |||
| 19327 | 19327 | 7658 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3335 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | 3 | 3x3 | 6008522.8365 | 2099251.39925 | 37.7446259085611 | -122.41320166263 | (37.7446259085611, -122.41320166263) | ||
| 19328 | 19328 | 7470 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2629 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6008300.06862 | 2103096.2458 | 37.755170485633 | -122.41424392921002 | (37.755170485633, -122.41424392921) | |||
| 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) | |||
| 19588 | 19588 | 7552 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2894 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008324.51175 | 2101611.42037 | 37.751094863355895 | -122.414054359326 | (37.7510948633559, -122.414054359326) | ||
| 19591 | 19591 | 7508 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2733 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008332.697980001 | 2102504.20303 | 37.753546703038296 | -122.41408920446699 | (37.7535467030383, -122.414089204467) | |||
| 19628 | 19628 | 7471 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2637 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6008304.34072 | 2103057.49026 | 37.755064311682 | -122.414226413135 | (37.755064311682, -122.414226413135) | |||
| 19630 | 19630 | 7453 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2570 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008223.86046 | 2103457.0339200003 | 37.7561568467812 | -122.414533009104 | (37.7561568467812, -122.414533009104) | |||
| 19718 | 19718 | 23643 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6006665.3047400005 | 2098482.5639400003 | 37.742410400808296 | -122.419570116381 | (37.7424104008083, -122.419570116381) | ||
| 19814 | 19814 | 7557 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2909 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2011 12:00:00 AM | 3 | 4x4 | 6008393.46054 | 2101471.49038 | 37.7507145193727 | -122.413806029524 | (37.7507145193727, -122.413806029524) |
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");