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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127 | 127 | 18052 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000317.799 | 2114808.7133 | 37.7868783690408 | -122.442689819484 | (37.7868783690408, -122.442689819484) | |||
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) | ||||
1187 | 1187 | 119794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1213 | 1213 | 119747 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1219 | 1219 | 119829 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
1243 | 1243 | 242621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6008442.97152 | 2099602.35151 | 37.745585061615294 | -122.413502636934 | (37.7455850616153, -122.413502636934) | |||
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) | |||
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) | |||
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) | |||
6069 | 6069 | 17933 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2418 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002186.7609 | 2115068.0006 | 37.7876966699691 | -122.43624221533301 | (37.7876966699691, -122.436242215333) | |||
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) | |||
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) | ||||
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) | |||
11249 | 11249 | 17536 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.72114791043521 | -122.431654537837 | (37.7211479104352, -122.431654537837) | |||
11325 | 11325 | 17624 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | |||
11358 | 11358 | 17550 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 600 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6003170.84982 | 2090661.1447 | 37.7207370992233 | -122.431094760237 | (37.7207370992233, -122.431094760237) | |||
11596 | 11596 | 17497 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.43491976573401 | (37.7226823390961, -122.434919765734) | |||
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) | |||
11871 | 11871 | 17518 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002537.724219999 | 2091058.53445 | 37.72179234573429 | -122.433311659211 | (37.7217923457343, -122.433311659211) | |||
12769 | 12769 | 17578 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003799.63122 | 2090323.6743700001 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | |||
13173 | 13173 | 17514 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002400.99383 | 2091189.1997099998 | 37.7221433654964 | -122.433793634664 | (37.7221433654964, -122.433793634664) | |||
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) | ||
13679 | 13679 | 100568 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | |||
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) | |||
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) | ||
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) | ||
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) | ||
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) | |||
15899 | 15899 | 22327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.39177919347401 | (37.7313174804906, -122.391779193474) | |||
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) | ||
16241 | 16241 | 91032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010616.6864 | 2111159.8673 | 37.777441210433395 | -122.40680061468099 | (37.7774412104334, -122.406800614681) | ||
16370 | 16370 | 85856 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008268.3583 | 2108979.6799 | 37.7713232557148 | -122.414769948978 | (37.7713232557148, -122.414769948978) | ||
16950 | 16950 | 25174 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.761125030928895 | -122.44266313540199 | (37.7611250309289, -122.442663135402) | |||
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) | |||
17173 | 17173 | 7598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008393.64019 | 2100437.22493 | 37.7478746680801 | -122.41373225995702 | (37.7478746680801, -122.413732259957) | |||
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) | |||
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) | |||
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) | |||
19913 | 19913 | 7629 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008486.89529 | 2099750.51965 | 37.7459943646489 | -122.413361231161 | (37.7459943646489, -122.413361231161) | |||
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) | |||
20513 | 20513 | 16674 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 244 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002862.1511 | 2106861.28307 | 37.7652014158426 | -122.43331884659099 | (37.7652014158426, -122.433318846591) | |||
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) | |||
20550 | 20550 | 7661 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3340 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008464.3828 | 2099163.3028700002 | 37.7443807335859 | -122.413397555653 | (37.7443807335859, -122.413397555653) | |||
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) | ||
21218 | 21218 | 7609 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3201X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008465.56489 | 2100101.76306 | 37.7469576033137 | -122.413459825618 | (37.7469576033137, -122.413459825618) | |||
21656 | 21656 | 7544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008318.08385 | 2101730.76273 | 37.751422189596 | -122.414085029817 | (37.751422189596, -122.414085029817) | |||
21769 | 21769 | 16666 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 221 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 6002922.68979 | 2106990.55693 | 37.765559804667795 | -122.433118695273 | (37.7655598046678, -122.433118695273) | ||
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) | |||
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) | |||
25504 | 25504 | 244422 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005691.1562 | 2109690.8797 | 37.773130897486205 | -122.423735193743 | (37.7731308974862, -122.423735193743) | |||
26126 | 26126 | 121876 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 198 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5990258.7771 | 2114125.11195 | 37.7844228334992 | -122.477441359496 | (37.7844228334992, -122.477441359496) | |||
26492 | 26492 | 242374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006546.0037 | 2109148.1970900004 | 37.771689039651896 | -122.42073962714899 | (37.7716890396519, -122.420739627149) | |||
27525 | 27525 | 215551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 212 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994048.13405 | 2096632.6874900002 | 37.7366123276804 | -122.46306197983401 | (37.7366123276804, -122.463061979834) | |||
28071 | 28071 | 198653 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6014062.16151 | 2107274.8882299997 | 37.7669661078202 | -122.39460937273701 | (37.7669661078202, -122.394609372737) | |||
28099 | 28099 | 215484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.739679229001496 | -122.46304340523001 | (37.7396792290015, -122.46304340523) | |||
28496 | 28496 | 180552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001906.70426 | 2091457.0894099998 | 37.722850869347205 | -122.435521425698 | (37.7228508693472, -122.435521425698) | |||
29756 | 29756 | 215492 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993992.82093 | 2097521.50716 | 37.7390496190449 | -122.463317697564 | (37.7390496190449, -122.463317697564) | |||
30582 | 30582 | 137004 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2009 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6000928.49211 | 2115336.76015 | 37.7883630432624 | -122.440614856585 | (37.7883630432624, -122.440614856585) | |||
31013 | 31013 | 198560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6014655.2828 | 2096153.01044 | 37.7364607478562 | -122.39178010106899 | (37.7364607478562, -122.391780101069) | |||
33083 | 33083 | 215539 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 70 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993947.30597 | 2097439.0269400002 | 37.73882052663561 | -122.463469082233 | (37.7388205266356, -122.463469082233) | |||
33088 | 33088 | 198470 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 704 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015369.36264 | 2105816.80106 | 37.7630351046092 | -122.38998606601601 | (37.7630351046092, -122.389986066016) | |||
33554 | 33554 | 242643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 952 Capp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007376.06475 | 2101722.46593 | 37.7513464531926 | -122.417342064 | (37.7513464531926, -122.417342064) | |||
33764 | 33764 | 137006 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2110 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6000413.12711 | 2115890.60929 | 37.7898544079127 | -122.44243770955299 | (37.7898544079127, -122.442437709553) | |||
34416 | 34416 | 198529 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1722 Newcomb Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 7ft | 6014569.28946 | 2096208.9031099998 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | |||
34661 | 34661 | 242376 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 112 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005382.46829 | 2102954.4101 | 37.7546167200124 | -122.424323769035 | (37.7546167200124, -122.424323769035) | |||
34813 | 34813 | 242711 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3836 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002806.04485 | 2103594.72393 | 37.756229048836396 | -122.43327947246401 | (37.7562290488364, -122.433279472464) | |||
35344 | 35344 | 242489 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2595 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008285.48052 | 2103355.64378 | 37.7558819141278 | -122.414312731857 | (37.7558819141278, -122.414312731857) | |||
35712 | 35712 | 198574 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6014815.04425 | 2114132.68239 | 37.7858379025473 | -122.39248498701099 | (37.7858379025473, -122.392484987011) | |||
35801 | 35801 | 215481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.739936758872204 | -122.462836916405 | (37.7399367588722, -122.462836916405) | |||
36165 | 36165 | 248389 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 729 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999024.6328 | 2108104.9869 | 37.7683978595253 | -122.44668134181101 | (37.7683978595253, -122.446681341811) | |||
36663 | 36663 | 180526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 701 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003462.66428 | 2090526.46403 | 37.7203838275255 | -122.43007644527701 | (37.7203838275255, -122.430076445277) | |||
37359 | 37359 | 215483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.46295396047199 | (37.7397934743851, -122.462953960472) | |||
37493 | 37493 | 242640 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 522 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007837.56106 | 2104867.39648 | 37.760007669143896 | -122.41596883880301 | (37.7600076691439, -122.415968838803) | |||
37510 | 37510 | 138572 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2704 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000865.8478 | 2114882.3373 | 37.787111748219296 | -122.440798985198 | (37.7871117482193, -122.440798985198) | |||
38137 | 38137 | 215538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993953.054409999 | 2097475.42453 | 37.7389207965449 | -122.46345184763099 | (37.7389207965449, -122.463451847631) | |||
38429 | 38429 | 138313 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2400 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002380.4443 | 2115093.9404 | 37.7877788965565 | -122.435573965464 | (37.7877788965565, -122.435573965464) | |||
39623 | 39623 | 246030 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999425.5785 | 2108530.7646 | 37.7695898327566 | -122.445325129643 | (37.7695898327566, -122.445325129643) | |||
39846 | 39846 | 215499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993991.18061 | 2097202.58443 | 37.738173842158105 | -122.463300232714 | (37.7381738421581, -122.463300232714) | |||
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) | ||||
41110 | 41110 | 137047 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Clay St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6008168.86514 | 2116916.33428 | 37.7931098080181 | -122.41567614634701 | (37.7931098080181, -122.415676146347) | |||
42722 | 42722 | 110675 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 34 Bonita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 2.5x3 | 6006170.0244 | 2118492.14329 | 37.7973240194296 | -122.422704299571 | (37.7973240194296, -122.422704299571) | |||
42797 | 42797 | 242419 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6005474.74464 | 2102041.50657 | 37.7521153087939 | -122.423939739653 | (37.7521153087939, -122.423939739653) | |||
44558 | 44558 | 242583 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4138 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002265.1078 | 2101810.52318 | 37.7512993574873 | -122.435022614924 | (37.7512993574873, -122.435022614924) | |||
44742 | 44742 | 242652 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008156.87446 | 2103306.51725 | 37.7557397987621 | -122.414754018381 | (37.7557397987621, -122.414754018381) | |||
44893 | 44893 | 242433 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 340 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004899.43089 | 2109888.25231 | 37.773628110187396 | -122.426487931787 | (37.7736281101874, -122.426487931787) | |||
45912 | 45912 | 242593 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 960 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6000277.53945 | 2101991.5509200003 | 37.751683359019395 | -122.44190882273199 | (37.7516833590194, -122.441908822732) | |||
46920 | 46920 | 242576 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2019 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008104.56596 | 2106730.31535 | 37.7651378220854 | -122.415177265415 | (37.7651378220854, -122.415177265415) | |||
47189 | 47189 | 215569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993829.85654 | 2096316.71457 | 37.735732168414 | -122.46379372579901 | (37.735732168414, -122.463793725799) |
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");