Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172370 | 172370 | 137040 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1034 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009716.374480001 | 2116806.1167599997 | 37.7928940462749 | -122.410313864011 | (37.7928940462749, -122.410313864011) | |||
| 187118 | 187118 | 137037 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1034 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009816.75031 | 2116820.89237 | 37.792940242650296 | -122.409967600744 | (37.7929402426503, -122.409967600744) | |||
| 11164 | 11164 | 17617 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | |||
| 18738 | 18738 | 17618 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6004182.578886599 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | |||
| 96728 | 96728 | 17620 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1049X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6004182.578886599 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | |||
| 117397 | 117397 | 17619 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1049X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6004182.578886599 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | |||
| 61812 | 61812 | 198600 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013090.52825 | 2107110.01033 | 37.7664593236741 | -122.397958554166 | (37.7664593236741, -122.397958554166) | |||
| 63083 | 63083 | 198599 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013108.22745 | 2107111.70363 | 37.7664649588148 | -122.397897454223 | (37.7664649588148, -122.397897454223) | |||
| 159859 | 159859 | 198598 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013134.44315 | 2107112.3448 | 37.766468179289 | -122.397806823228 | (37.766468179289, -122.397806823228) | |||
| 120690 | 120690 | 110630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991857.0 | 2101850.0 | 37.7508112705894 | -122.47101756601101 | (37.7508112705894, -122.471017566011) | |||||
| 13722 | 13722 | 91035 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.40663324749599 | (37.7775764693736, -122.406633247496) | ||
| 14760 | 14760 | 91037 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.40649877417499 | (37.7776845332645, -122.406498774175) | ||
| 15087 | 15087 | 91034 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010653.2937 | 2111194.8106 | 37.7775392048064 | -122.406676440472 | (37.7775392048064, -122.406676440472) | ||
| 15203 | 15203 | 91033 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.777476921213605 | -122.40675930128401 | (37.7774769212136, -122.406759301284) | ||
| 15284 | 15284 | 91036 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | ||
| 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) | ||
| 32202 | 32202 | 91031 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.147999999 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | ||
| 149318 | 149318 | 36939 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.78649992768511 | -122.461372345087 | (37.7864999276851, -122.461372345087) | |
| 12439 | 12439 | 17499 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002048.76612 | 2091365.2856599998 | 37.722606864403296 | -122.435023785838 | (37.7226068644033, -122.435023785838) | ||
| 15989 | 15989 | 7405 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1065 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6010535.4473 | 2111084.5056 | 37.7772297388865 | -122.407076335552 | (37.7772297388865, -122.407076335552) | ||
| 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) | |||
| 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) | ||
| 99951 | 99951 | 119755 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106x Octavia St Frontage West | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 17228 | 17228 | 23635 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | |||
| 2748 | 2748 | 30802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.8302099998 | 37.733802178321 | -122.43669510478998 | (37.733802178321, -122.43669510479) |
| 16759 | 16759 | 26628 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | ||
| 35154 | 35154 | 123692 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 11 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995433.731430001 | 2113533.85695 | 37.7830983254289 | -122.45949508803699 | (37.7830983254289, -122.459495088037) | |||
| 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) | |||
| 160840 | 160840 | 140522 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1100 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003844.9407 | 2111829.9916 | 37.7788999800677 | -122.43027413185499 | (37.7788999800677, -122.430274131855) | |||
| 11929 | 11929 | 17621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004336.281690001 | 2089926.3148400001 | 37.7187853887157 | -122.42701391015899 | (37.7187853887157, -122.427013910159) | |||
| 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) | |||
| 141469 | 141469 | 28264 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1100X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003899.2367 | 2111834.49982 | 37.7789154337837 | -122.43008662212601 | (37.7789154337837, -122.430086622126) | |||
| 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) | |||
| 13231 | 13231 | 17623 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6004371.84322 | 2089954.8563599999 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | |||
| 48146 | 48146 | 180566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 111 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004117.41747 | 2094047.5610599997 | 37.730089041271206 | -122.42806396757099 | (37.7300890412712, -122.428063967571) | |||
| 62701 | 62701 | 242666 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1110 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003798.0893 | 2101733.84258 | 37.7511757357942 | -122.429715924165 | (37.7511757357942, -122.429715924165) | |||
| 177354 | 177354 | 242665 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1110 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003796.20784 | 2101754.26295 | 37.7512316988054 | -122.42972388675899 | (37.7512316988054, -122.429723886759) | |||
| 61326 | 61326 | 140553 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1111 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003847.0209 | 2111777.1269 | 37.778754944533794 | -122.43026316304501 | (37.7787549445338, -122.430263163045) | |||
| 127520 | 127520 | 23744 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1111X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003857.72301 | 2111778.219 | 37.7787585493448 | -122.430226218205 | (37.7787585493448, -122.430226218205) | |||
| 76983 | 76983 | 201851 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1119 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010210.791 | 2110772.6508 | 37.7763552850367 | -122.40817743097799 | (37.7763552850367, -122.408177430978) | |||
| 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) | |
| 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) | |||
| 85473 | 85473 | 98928 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 112 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005385.0 | 2103055.0 | 37.7548930594212 | -122.42432216764401 | (37.7548930594212, -122.424322167644) | ||||
| 20233 | 20233 | 23636 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 112 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006546.53068 | 2098501.4948299997 | 37.742455689777294 | -122.419982145278 | (37.7424556897773, -122.419982145278) | |||
| 13417 | 13417 | 85790 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | ||
| 12432 | 12432 | 17625 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6004425.094930001 | 2089870.4961599999 | 37.7186371444562 | -122.426702945308 | (37.7186371444562, -122.426702945308) | |||
| 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) | |||
| 150445 | 150445 | 180561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.712917038962495 | -122.437192888562 | (37.7129170389625, -122.437192888562) | |||
| 165192 | 165192 | 180560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1134 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 6001363.50733 | 2087875.35573 | 37.7129853640648 | -122.437142819708 | (37.7129853640648, -122.437142819708) | |||
| 13153 | 13153 | 17626 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004454.014359999 | 2089904.4684 | 37.718732059816205 | -122.42660540034099 | (37.7187320598162, -122.426605400341) | |||
| 96603 | 96603 | 17627 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2005 12:00:00 AM | 3 | 3X3 | 6004380.712681401 | 2089954.6929998002 | 37.718865821274 | -122.42686234984801 | (37.718865821274, -122.426862349848) | ||
| 104545 | 104545 | 51892 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48104 | 6004381.23162594 | 2089955.54800101 | 37.7188681982632 | -122.42686061692 | (37.7188681982632, -122.42686061692) | |||
| 133150 | 133150 | 137046 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1149 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008987.23365 | 2116902.13898 | 37.79311680025621 | -122.412843528313 | (37.7931168002562, -122.412843528313) | |||
| 48729 | 48729 | 242737 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 115 Corbett Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6000767.45695 | 2105648.39413 | 37.7617520652142 | -122.44047687542201 | (37.7617520652142, -122.440476875422) | |||
| 70517 | 70517 | 242735 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 115 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000736.15625 | 2105646.04373 | 37.7617438292481 | -122.440584963137 | (37.7617438292481, -122.440584963137) | |||
| 158525 | 158525 | 242736 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 115 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6000751.24207 | 2105647.23063 | 37.761747947223 | -122.440532872599 | (37.761747947223, -122.440532872599) | |||
| 187500 | 187500 | 242738 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 115 Corbett Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000793.83368 | 2105649.34692 | 37.7617561832258 | -122.440385717444 | (37.7617561832258, -122.440385717444) | |||
| 3289 | 3289 | 253392 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3293 | 3293 | 253393 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 3316 | 3316 | 253394 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.163380001 | 2116767.09226 | 37.793068003154104 | -122.392879995147 | (37.7930680031541, -122.392879995147) | |
| 149264 | 149264 | 242637 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1155 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009490.58468 | 2102465.6938 | 37.7535059322676 | -122.410082245404 | (37.7535059322676, -122.410082245404) | |||
| 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) | ||
| 42458 | 42458 | 242448 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1157 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997336.0067 | 2106240.14847 | 37.7631808847241 | -122.452387528971 | (37.7631808847241, -122.452387528971) | |||
| 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) | ||
| 146841 | 146841 | 83229 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1169 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52333 | 6005183.33361 | 2120915.83626 | 37.8039231412044 | -122.426291152916 | (37.8039231412044, -122.426291152916) | |
| 11102 | 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) | |
| 143378 | 143378 | 23638 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 VIRGINIA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 12 | 4x4 | Permit Number 776560 | 6006594.0 | 2098480.0 | 37.7423993441016 | -122.41981648533199 | (37.7423993441016, -122.419816485332) | |
| 20985 | 20985 | 87685 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 118 Virginia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | |||
| 16092 | 16092 | 85760 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1196 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009690.0521 | 2110363.0901 | 37.7752015556324 | -122.40994990092399 | (37.7752015556324, -122.409949900924) | ||
| 174653 | 174653 | 64959 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 12 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1989 12:00:00 AM | 11 | Permit Number 25993 | 6001806.8392 | 2121193.6655099997 | 37.804494553342096 | -122.437995616222 | (37.8044945533421, -122.437995616222) | ||
| 94108 | 94108 | 88329 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 120 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940.0 | 2092960.0 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | |||
| 163680 | 163680 | 76181 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 3 | 6009574.6956 | 2110252.7468 | 37.7748921128949 | -122.410341153951 | (37.7748921128949, -122.410341153951) | ||
| 55907 | 55907 | 137045 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.792555023435796 | -122.41299717838899 | (37.7925550234358, -122.412997178389) | |||
| 172287 | 172287 | 56515 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 10 | Permit Number 17376 | 6008990.48315 | 2116704.87455 | 37.7925753427324 | -122.412818332001 | (37.7925753427324, -122.412818332001) | ||
| 174322 | 174322 | 137044 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1200 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008949.11114 | 2116700.62228 | 37.7925613447696 | -122.41296118031099 | (37.7925613447696, -122.412961180311) | |||
| 93435 | 93435 | 16411 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1200X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | |||
| 108708 | 108708 | 16415 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1200X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | |||
| 176511 | 176511 | 242400 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004412.57648 | 2096019.13863 | 37.7355192458083 | -122.427183945908 | (37.7355192458083, -122.427183945908) | ||||
| 182744 | 182744 | 242401 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 San Jose Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004422.12829 | 2096026.22682 | 37.7355392485419 | -122.427151426394 | (37.7355392485419, -122.427151426394) | ||||
| 82805 | 82805 | 44113 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 91822 | 91822 | 44116 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 102982 | 102982 | 44114 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 123175 | 123175 | 44112 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 172502 | 172502 | 242403 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008707.95248 | 2101269.88955 | 37.75017862504279 | -122.412704235035 | (37.7501786250428, -122.412704235035) | |||
| 36571 | 36571 | 83024 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1209 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52375 | 6013948.88284 | 2105690.7354200003 | 37.762610074220206 | -122.39489022832399 | (37.7626100742202, -122.394890228324) | |
| 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) | |
| 149313 | 149313 | 242611 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 121 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6006528.89277 | 2098549.54535 | 37.7425866319823 | -122.42004654122299 | (37.7425866319823, -122.420046541223) | |||
| 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) | ||
| 14251 | 14251 | 85786 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | ||
| 52590 | 52590 | 198500 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1215 Michigan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016504.90448 | 2102523.10402 | 37.754054221042 | -122.385828988529 | (37.754054221042, -122.385828988529) | |||
| 57062 | 57062 | 198499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1215 Michigan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016506.220509999 | 2102490.10595 | 37.753963688078706 | -122.38582213748 | (37.7539636880787, -122.38582213748) | |||
| 155342 | 155342 | 198498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1215 Michigan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016508.17513 | 2102448.92255 | 37.753850715249 | -122.38581250754801 | (37.753850715249, -122.385812507548) | |||
| 132769 | 132769 | 242379 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1217 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011152.0776 | 2102554.59258 | 37.7538430143636 | -122.40434267049 | (37.7538430143636, -122.40434267049) | |||
| 180271 | 180271 | 242380 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1217 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6011151.17373 | 2102568.66425 | 37.75388160155921 | -122.404346786677 | (37.7538816015592, -122.404346786677) | |||
| 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) | ||
| 27071 | 27071 | 137049 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008515.90058 | 2116780.9457099997 | 37.7927575660663 | -122.414465794683 | (37.7927575660663, -122.414465794683) | |||
| 49086 | 49086 | 137048 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008515.8047 | 2116792.05002 | 37.7927880503911 | -122.414466912531 | (37.7927880503911, -122.414466912531) | |||
| 60626 | 60626 | 137052 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008525.03986 | 2116714.30677 | 37.7925751052991 | -122.414429454859 | (37.7925751052991, -122.414429454859) | |||
| 76377 | 76377 | 137050 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008520.18365 | 2116745.46008 | 37.7926603718421 | -122.41444846295 | (37.7926603718421, -122.41444846295) | |||
| 159494 | 159494 | 53398 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1972 12:00:00 AM | 9 | Permit Number 9833 | 6008515.21769 | 2116802.84208 | 37.7928176497632 | -122.414469707612 | (37.7928176497632, -122.414469707612) |
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");