Street_Tree_List

Data source: data.sfgov.org

2,323 rows where qSpecies = 46 sorted by qLegalStatus

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
141737 97434   Ulmus parvifolia :: Chinese Elm 46 1380x Newcomb Ave 5 Median : Cutout 11 Tree 1 DPW 2   09/30/2011 12:00:00 AM 3     6016360.63733 2094893.94179 37.7330981190079 -122.38579618360501 (37.7330981190079, -122.385796183605)
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 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)
459 35612 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2839 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/11/2012 12:00:00 AM 5 3x3 Permit Number 768882 6000549.03074 2116799.12347 37.792356695946005 -122.442032735847 (37.792356695946, -122.442032735847)
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)
849 93578 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 401X Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/2010 12:00:00 AM 1 3x3 Permit Number 53401 6009309.6837 2121148.6264 37.8047947000965 -122.41202806393 (37.8047947000965, -122.41202806393)
2504 55970 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1246 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2017 12:00:00 AM 3   Permit Number 12041 6008815.91632 2116679.9939099997 37.7924972267216 -122.413420580993 (37.7924972267216, -122.413420580993)
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)
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 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 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)
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 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)
5219 242740 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 4081 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/04/2005 12:00:00 AM 5 Width 2ft Permit Number 47860 6001797.68474 2105832.52045 37.7623162396305 -122.43692691855 (37.7623162396305, -122.43692691855)
5267 62038 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2015 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2015 12:00:00 AM 3   Permit Number 773957 6000922.27992 2115385.7995599997 37.788497339028204 -122.440639868553 (37.7884973390282, -122.440639868553)
6092 46303 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
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 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 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)
7478 46291 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
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)
7586 48883 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 1515 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/21/2002 12:00:00 AM 4 5x4 Permit Number 46089 6000106.0163 2114246.8974 37.7853236932557 -122.44338216691901 (37.7853236932557, -122.443382166919)
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 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)
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)
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)
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 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 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 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 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 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 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 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)
10371 46304 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
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 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 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 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)
11102 56779 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 118 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/1974 12:00:00 AM 10 3x3 Permit Number 14000 6004445.70809 2092827.36067 37.726757210476606 -122.42684215943899 (37.7267572104766, -122.426842159439)
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 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 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 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)
11759 46302 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46   5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/31/2002 12:00:00 AM     Permit Number 44564          
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 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 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 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 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 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 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 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 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 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 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 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 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 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)
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 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 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 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 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 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 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 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 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)
15335 57068 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 918 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/1974 12:00:00 AM 15 6x7 Permit Number 14334 6015212.77238 2104346.7451400002 37.7589899621477 -122.390424942382 (37.7589899621477, -122.390424942382)
15589 30641 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 80x 13th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/1995 12:00:00 AM 6 3x3 Permit Number 34584 6008099.08967 2108395.87431 37.7697107505788 -122.41531412336201 (37.7697107505788, -122.415314123362)
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 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)
16004 30372 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 498x Arkansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/1956 12:00:00 AM 10 3x3 Permit Number 60 6012938.59384 2104777.04886 37.760045064747295 -122.39832036668999 (37.7600450647473, -122.39832036669)
16040 57074 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 966 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/22/1974 12:00:00 AM 24 9x7.5 Permit Number 14341 6015226.17172 2104099.64367 37.7583122177548 -122.39036133601101 (37.7583122177548, -122.390361336011)
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)
17037 54753 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 4140-4142 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/31/1972 12:00:00 AM     Permit Number 10601 6002268.53854801 2101815.27696084 37.7513126050411 -122.435011090977 (37.7513126050411, -122.435011090977)
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)
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)
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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 699.756ms · Data source: data.sfgov.org