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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6092 | 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 | |||||||||
| 170446 | 170446 | 141756 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 10 HOLLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003949.9068 | 2113305.5788 | 37.7829575203066 | -122.43001630101801 | (37.7829575203066, -122.430016301018) | |||
| 58597 | 58597 | 198595 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1000 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013296.53525 | 2107120.49149 | 37.7664995737224 | -122.397246743447 | (37.7664995737224, -122.397246743447) | |||
| 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) | |||
| 118411 | 118411 | 17613 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1001X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004077.225620099 | 2090145.4202003002 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | |||
| 120654 | 120654 | 102761 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.40821818771099 | (37.7785759102049, -122.408218187711) |
| 62865 | 62865 | 244423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | |||
| 10917 | 10917 | 17498 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.43487036238501 | (37.72266164479, -122.434870362385) | |||
| 1234 | 1234 | 119748 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 176821 | 176821 | 244373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | |||
| 30655 | 30655 | 180517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004131.62894 | 2090104.3716099998 | 37.719262719168896 | -122.42773399285299 | (37.7192627191689, -122.427733992853) | |||
| 168800 | 168800 | 180514 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1027 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 4ft | 6004210.581680001 | 2090053.8218900003 | 37.7191283865346 | -122.427457483699 | (37.7191283865346, -122.427457483699) | |||
| 128531 | 128531 | 119710 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 166414 | 166414 | 137039 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1034 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009772.70737 | 2116813.88249 | 37.7929185267084 | -122.410119497111 | (37.7929185267084, -122.410119497111) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 21400 | 21400 | 14591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/09/2011 12:00:00 AM | 3 | 3x3 | 5999412.7083 | 2108624.4902 | 37.7698464448905 | -122.445376387082 | (37.7698464448905, -122.445376387082) | ||
| 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) | ||
| 117448 | 117448 | 16434 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1299X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | |||
| 46120 | 46120 | 200598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.732956277793896 | -122.385302911931 | (37.7329562777939, -122.385302911931) | |||
| 13491 | 13491 | 85780 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.41169762032699 | (37.7735740897245, -122.411697620327) | ||
| 181077 | 181077 | 198691 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016677.93992 | 2094927.14945 | 37.7332068541071 | -122.384701486 | (37.7332068541071, -122.384701486) | |||
| 157714 | 157714 | 242603 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1311 Clayton St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5999039.00902 | 2105211.58372 | 37.7604541213822 | -122.44642343560699 | (37.7604541213822, -122.446423435607) | |||
| 156746 | 156746 | 137642 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1315 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002857.7118 | 2111638.0989 | 37.7783171230031 | -122.433675627626 | (37.7783171230031, -122.433675627626) | |||
| 86746 | 86746 | 14840 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1315X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.43366409969101 | (37.7783201948721, -122.433664099691) | ||
| 167299 | 167299 | 242443 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1331 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6003922.3896699995 | 2100509.1649599997 | 37.7478200945407 | -122.429198764536 | (37.7478200945407, -122.429198764536) | |||
| 76771 | 76771 | 141891 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1335 EDDY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004124.0082 | 2112861.9655 | 37.7817493272221 | -122.42938233738998 | (37.7817493272221, -122.42938233739) | |||
| 119450 | 119450 | 23808 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1375X Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6003890.67101 | 2112819.25759 | 37.7816188487105 | -122.43018652655701 | (37.7816188487105, -122.430186526557) | |||
| 89115 | 89115 | 16420 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016497.0965599995 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | |||
| 100525 | 100525 | 16440 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 16758 | 16758 | 85768 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008662.6876 | 2109384.932 | 37.772458131185104 | -122.41343460643999 | (37.7724581311851, -122.41343460644) | ||
| 163449 | 163449 | 198684 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009045.18869 | 2110977.41659 | 37.7768521887265 | -122.41222406538701 | (37.7768521887265, -122.412224065387) | |||
| 13792 | 13792 | 98860 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008529.07758 | 2110594.62185 | 37.7757721514991 | -122.41398236951099 | (37.7757721514991, -122.413982369511) | |||
| 30762 | 30762 | 242600 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002217.824030001 | 2096159.0098299999 | 37.735778939431896 | -122.434782025597 | (37.7357789394319, -122.434782025597) | |||
| 106773 | 106773 | 141786 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1471 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003844.5104 | 2113167.1525 | 37.7825714667037 | -122.430371049321 | (37.7825714667037, -122.430371049321) | |||
| 103920 | 103920 | 117152 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.72855094559029 | -122.389513905896 | (37.7285509455903, -122.389513905896) | |||
| 14994 | 14994 | 98857 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008572.87311 | 2110548.2851 | 37.775647381359995 | -122.41382759079501 | (37.77564738136, -122.413827590795) | |||
| 102013 | 102013 | 101949 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 48110 | 48110 | 198677 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010377.80869 | 2111537.89689 | 37.778465822479795 | -122.407653636128 | (37.7784658224798, -122.407653636128) | |||
| 107376 | 107376 | 11877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 155595 | 155595 | 136987 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1508 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005725.54512 | 2118613.25141 | 37.797631464383294 | -122.42425093115101 | (37.7976314643833, -122.424250931151) | |||
| 132989 | 132989 | 120388 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 151 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5988095.61955 | 2115306.5323400004 | 37.787540921662604 | -122.485011751628 | (37.7875409216626, -122.485011751628) | |||
| 15259 | 15259 | 85857 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008243.2994 | 2108951.1128 | 37.771243409160206 | -122.414854606958 | (37.7712434091602, -122.414854606958) | ||
| 74354 | 74354 | 200792 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.735849808179296 | -122.389034132513 | (37.7358498081793, -122.389034132513) | |||
| 173849 | 173849 | 200942 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1595 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008302.9396 | 2108913.0233 | 37.771142175293896 | -122.414645612489 | (37.7711421752939, -122.414645612489) | |||
| 62594 | 62594 | 30619 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.41516782897499 | (37.7703758225592, -122.415167828975) | |
| 86647 | 86647 | 46504 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 121798 | 121798 | 198688 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 165 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008649.71032 | 2110465.86433 | 37.775425388204496 | -122.413555960437 | (37.7754253882045, -122.413555960437) | |||
| 138078 | 138078 | 200948 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1665 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6008110.2367 | 2108543.9059 | 37.770117837090204 | -122.41528604670201 | (37.7701178370902, -122.415286046702) | |||
| 146604 | 146604 | 198554 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 6014551.87687 | 2096170.8022200002 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | |||
| 185967 | 185967 | 198527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6014634.66691 | 2096168.3212099997 | 37.736501643630795 | -122.39185244975599 | (37.7365016436308, -122.391852449756) | |||
| 66171 | 66171 | 31077 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.766563649504704 | -122.422496504935 | (37.7665636495047, -122.422496504935) | |
| 39339 | 39339 | 198561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6014636.301940001 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | |||
| 39939 | 39939 | 201908 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.39464378978901 | (37.7284270698286, -122.394643789789) | |||
| 68043 | 68043 | 137034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1756 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6005175.40466 | 2117844.84093 | 37.7954905257115 | -122.426099835651 | (37.7954905257115, -122.426099835651) | |||
| 110800 | 110800 | 38063 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1805X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40255 | 6000940.99475203 | 2111717.60117276 | 37.77842647246 | -122.440311948792 | (37.77842647246, -122.440311948792) | |
| 117414 | 117414 | 72754 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 181 RUSS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1998 12:00:00 AM | 3 | 5x5 | 6010587.0 | 2111361.1 | 37.777992087388604 | -122.40691749681999 | (37.7779920873886, -122.40691749682) | ||
| 134176 | 134176 | 138169 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1884 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004466.1638 | 2115036.3369 | 37.7877389735872 | -122.42835366119301 | (37.7877389735872, -122.428353661193) | |||
| 151867 | 151867 | 141076 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 189 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5996534.5761 | 2113062.8589 | 37.781868325512704 | -122.45565257993401 | (37.7818683255127, -122.455652579934) | |||
| 103257 | 103257 | 17810 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1900X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2012 12:00:00 AM | 4 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | ||
| 40331 | 40331 | 198670 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 194 Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6010573.77225 | 2111256.57135 | 37.77770433593079 | -122.40695588722099 | (37.7777043359308, -122.406955887221) | |||
| 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) | ||
| 94890 | 94890 | 108482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 40222 | 40222 | 121875 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 198 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5990257.12502 | 2114144.50591 | 37.784475988028 | -122.477448493001 | (37.784475988028, -122.477448493001) | |||
| 129205 | 129205 | 111106 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 199X Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002254.0 | 2096173.0 | 37.7358194070146 | -122.43465795136001 | (37.7358194070146, -122.43465795136) | |||
| 155019 | 155019 | 246537 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | |||
| 136237 | 136237 | 141750 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 HOLLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004009.3479 | 2113234.7782 | 37.7827664857396 | -122.429805607802 | (37.7827664857396, -122.429805607802) | |||
| 64148 | 64148 | 180549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002285.837859999 | 2091218.55546 | 37.722217434571796 | -122.43419379793 | (37.7222174345718, -122.43419379793) | |||
| 36619 | 36619 | 215549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994024.47246 | 2096717.6403700002 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | |||
| 173527 | 173527 | 244256 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | |||
| 178955 | 178955 | 180555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.72224222258421 | -122.43398729649799 | (37.7222422225842, -122.433987296498) | |||
| 1194 | 1194 | 119795 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 62806 | 62806 | 244235 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | |||
| 112254 | 112254 | 119783 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 127319 | 127319 | 97269 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2050X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769192 | 5999973.8 | 2116027.1 | 37.79020412496 | -122.443967546887 | (37.79020412496, -122.443967546887) | |||
| 102037 | 102037 | 108135 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2055 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | ||||
| 32732 | 32732 | 242571 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008126.47482 | 2106341.38137 | 37.7640711307933 | -122.415073955818 | (37.7640711307933, -122.415073955818) | |||
| 143592 | 143592 | 17509 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 209 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x3 | 6002301.24651 | 2091251.1556 | 37.7223078217962 | -122.434142863321 | (37.7223078217962, -122.434142863321) | |||
| 183718 | 183718 | 246549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6005737.248 | 2109452.9268900002 | 37.77248013816789 | -122.423558835368 | (37.7724801381679, -122.423558835368) | |||
| 172766 | 172766 | 137007 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2110 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6000409.7888400005 | 2115912.00692 | 37.78991296994779 | -122.442450796488 | (37.7899129699478, -122.442450796488) | |||
| 173324 | 173324 | 242568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2121 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008133.25009 | 2106138.4736900004 | 37.7635143740114 | -122.41503615908701 | (37.7635143740114, -122.415036159087) | |||
| 119017 | 119017 | 36147 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2201 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | ||
| 64644 | 64644 | 137021 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6003013.18529 | 2117480.30225 | 37.7943671528679 | -122.43355541147498 | (37.7943671528679, -122.433555411475) | |||
| 144902 | 144902 | 17485 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 220X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002262.892318901 | 2091226.5881509997 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | |||
| 143698 | 143698 | 215500 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618004 | -122.46301588057301 | (37.736806354618, -122.463015880573) | |||
| 70239 | 70239 | 74649 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010746.42629 | 2106444.22464 | 37.76450039699821 | -122.406019510419 | (37.7645003969982, -122.406019510419) | ||
| 137176 | 137176 | 215557 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994081.97838 | 2096463.44747 | 37.7361495860356 | -122.462932691498 | (37.7361495860356, -122.462932691498) | |||
| 189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
| 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) | |||
| 79662 | 79662 | 17920 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2397X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002488.019783099 | 2115056.9941341 | 37.787683560918495 | -122.435199131446 | (37.7876835609185, -122.435199131446) | |||
| 181242 | 181242 | 215560 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994063.02887 | 2096405.4928599999 | 37.7359893655189 | -122.462994003686 | (37.7359893655189, -122.462994003686) | |||
| 25498 | 25498 | 138314 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2400 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002354.5046 | 2115095.0933 | 37.7877805887944 | -122.435663794316 | (37.7877805887944, -122.435663794316) | |||
| 137681 | 137681 | 183427 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2419 22nd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5989498.022999999 | 2098855.9096 | 37.7424535651362 | -122.478956057135 | (37.7424535651362, -122.478956057135) |
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");