Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1183 | 1183 | 119797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1185 | 1185 | 119832 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 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) | |||||
| 1189 | 1189 | 119798 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1191 | 1191 | 119838 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 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) | |||||
| 1196 | 1196 | 119750 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1202 | 1202 | 119754 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1206 | 1206 | 119801 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1208 | 1208 | 119803 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1209 | 1209 | 119800 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1211 | 1211 | 119836 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 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) | |||||
| 1222 | 1222 | 119837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1226 | 1226 | 119830 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1228 | 1228 | 119831 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1230 | 1230 | 119834 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1231 | 1231 | 119833 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1233 | 1233 | 119757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 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) | |||||
| 1235 | 1235 | 119756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 2504 | 2504 | 55970 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.9939099997 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | ||
| 3831 | 3831 | 30286 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 10 | Permit Number 132 | 6008896.76565 | 2117570.49119 | 37.794946853168604 | -122.41320383718599 | (37.7949468531686, -122.413203837186) | ||
| 5267 | 5267 | 62038 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2015 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | Permit Number 773957 | 6000922.27992 | 2115385.7995599997 | 37.788497339028204 | -122.440639868553 | (37.7884973390282, -122.440639868553) | ||
| 6092 | 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 | |||||||||
| 7478 | 7478 | 46291 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10167 | 10167 | 110034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008245.7 | 2102789.4 | 37.754324902547204 | -122.414410241803 | (37.7543249025472, -122.414410241803) | |||||
| 10371 | 10371 | 46304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11759 | 11759 | 46302 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 14093 | 14093 | 97435 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.732951043415206 | -122.385341956131 | (37.7329510434152, -122.385341956131) | |||
| 17037 | 17037 | 54753 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4140-4142 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | Permit Number 10601 | 6002268.53854801 | 2101815.27696084 | 37.7513126050411 | -122.435011090977 | (37.7513126050411, -122.435011090977) | |||
| 17976 | 17976 | 46914 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 19273 | 19273 | 48943 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901001 | (37.7524811515419, -122.40536498901) | ||
| 19810 | 19810 | 47528 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.42641232227899 | (37.7468583456276, -122.426412322279) | ||
| 22840 | 22840 | 251107 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1700X Quesada Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 23152 | 23152 | 17929 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2396 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6002533.0362 | 2115117.8233 | 37.78785313848039 | -122.435047735755 | (37.7878531384804, -122.435047735755) | ||||
| 25485 | 25485 | 198641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | ||||
| 25771 | 25771 | 198601 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016359.83761 | 2108655.37305 | 37.770884091558706 | -122.386758280474 | (37.7708840915587, -122.386758280474) | ||||
| 28275 | 28275 | 198639 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015936.8101699995 | 2108752.54325 | 37.7711274696967 | -122.38822833839 | (37.7711274696967, -122.38822833839) | ||||
| 30111 | 30111 | 198501 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | ||||
| 30311 | 30311 | 56524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 623 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5994686.99201 | 2111263.70978 | 37.776822144368 | -122.461913814497 | (37.776822144368, -122.461913814497) | ||||
| 30589 | 30589 | 80188 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2002 12:00:00 AM | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.41326474488501 | (37.7723172927739, -122.413264744885) | ||
| 32519 | 32519 | 66997 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 816 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1992 12:00:00 AM | 5 | Permit Number 30351 | 6012151.3036 | 2112714.2862 | 37.7817950322681 | -122.40160111437099 | (37.7817950322681, -122.401601114371) | ||
| 33611 | 33611 | 72449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.45334848155899 | (37.7873175292136, -122.453348481559) | ||
| 34666 | 34666 | 57073 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 958 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 17 | Permit Number 14340 | 6015221.7654 | 2104138.81007 | 37.758419515877705 | -122.390379311651 | (37.7584195158777, -122.390379311651) | ||
| 34705 | 34705 | 30348 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 420 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1956 12:00:00 AM | 13 | Permit Number 31 | 6012919.88824 | 2105064.35635 | 37.760832905929604 | -122.39840522041901 | (37.7608329059296, -122.398405220419) | ||
| 35199 | 35199 | 32994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.849280001 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | |
| 36409 | 36409 | 198632 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015782.37645 | 2108741.7224 | 37.77108919993629 | -122.38876177932501 | (37.7710891999363, -122.388761779325) | ||||
| 36737 | 36737 | 53651 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 829 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/1969 12:00:00 AM | 1 | Permit Number 6587 | 6012068.4217 | 2112548.0645 | 37.7813340008977 | -122.401876160632 | (37.7813340008977, -122.401876160632) | ||
| 37105 | 37105 | 51255 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2485 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2006 12:00:00 AM | 8 | Permit Number 49056 | 6001759.16032 | 2117307.5117200003 | 37.7938214847188 | -122.437882095676 | (37.7938214847188, -122.437882095676) | ||
| 38337 | 38337 | 51849 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4000 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 48073 | 6003004.48334918 | 2104779.15411028 | 37.7594924661239 | -122.43267780892599 | (37.7594924661239, -122.432677808926) | |||
| 39087 | 39087 | 55752 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2224 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1973 12:00:00 AM | 19 | Permit Number 11785 | 6002371.1638 | 2118147.1071 | 37.7961615782478 | -122.435824610533 | (37.7961615782478, -122.435824610533) | ||
| 39204 | 39204 | 32023 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 18 | Permit Number 35413 | 6001158.18036 | 2116931.31755 | 37.792754360865295 | -122.43993455095699 | (37.7927543608653, -122.439934550957) | ||
| 39927 | 39927 | 32998 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.784654089848296 | -122.398013908317 | (37.7846540898483, -122.398013908317) | |
| 40339 | 40339 | 48429 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2460 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 10 | Permit Number 45807 | 6001230.18864 | 2118334.23878 | 37.7966105144187 | -122.439786028808 | (37.7966105144187, -122.439786028808) | |
| 40344 | 40344 | 31076 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.3894700003 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | |
| 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) | ||||
| 40762 | 40762 | 198606 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6016250.47578 | 2108648.85468 | 37.7708601381228 | -122.387136114449 | (37.7708601381228, -122.387136114449) | ||||
| 41607 | 41607 | 198633 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015806.0947900005 | 2108744.2847599997 | 37.771097550144404 | -122.388679914958 | (37.7710975501444, -122.388679914958) | ||||
| 41952 | 41952 | 51434 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 277 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.724636968819205 | -122.433701359735 | (37.7246369688192, -122.433701359735) | ||
| 43054 | 43054 | 198631 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015760.25573 | 2108742.67593 | 37.771090592083794 | -122.388838362899 | (37.7710905920838, -122.388838362899) | ||||
| 45247 | 45247 | 32993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | |
| 46651 | 46651 | 55949 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2814 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1989 12:00:00 AM | 3 | Permit Number 28156 | 5999490.08281 | 2118090.45953 | 37.7958419601055 | -122.44578961952101 | (37.7958419601055, -122.445789619521) | ||
| 46850 | 46850 | 123166 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 579 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992807.48236 | 2111535.8684400003 | 37.777461036027496 | -122.468435352622 | (37.7774610360275, -122.468435352622) | ||||
| 46975 | 46975 | 198638 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015910.558069999 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | ||||
| 47159 | 47159 | 74944 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 4 | 6010701.03805 | 2106443.01503 | 37.7644945370101 | -122.40617641152201 | (37.7644945370101, -122.406176411522) | ||
| 47292 | 47292 | 54971 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 558 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1974 12:00:00 AM | 14 | Permit Number 14440 | 5993167.14361 | 2111676.4715400003 | 37.7778678620954 | -122.467201401573 | (37.7778678620954, -122.467201401573) | ||
| 47772 | 47772 | 69334 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2059 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1994 12:00:00 AM | 12 | Permit Number 33419 | 6003702.41325 | 2117935.1422599996 | 37.795655107937705 | -122.43120308357 | (37.7956551079377, -122.43120308357) | ||
| 48967 | 48967 | 47103 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.777158358184295 | -122.45799622921801 | (37.7771583581843, -122.457996229218) | ||
| 50325 | 50325 | 32022 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1995 12:00:00 AM | 3 | Permit Number 35413 | 6001178.71293 | 2116932.64189 | 37.7927591659501 | -122.43986360254499 | (37.7927591659501, -122.439863602545) | ||
| 51305 | 51305 | 30285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/1956 12:00:00 AM | 8 | Permit Number 132 | 6008895.30173 | 2117592.00623 | 37.7950058459972 | -122.41321042471901 | (37.7950058459972, -122.413210424719) | ||
| 51546 | 51546 | 49734 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.75023581813571 | -122.413951255275 | (37.7502358181357, -122.413951255275) | ||
| 52546 | 52546 | 68218 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 233 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/2010 12:00:00 AM | 4 | Permit Number 53885 | 5990842.3093 | 2113821.7941400004 | 37.7836238495535 | -122.475400406913 | (37.7836238495535, -122.475400406913) | |
| 52918 | 52918 | 41547 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | |||
| 53033 | 53033 | 198629 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015714.39108 | 2108739.8004900003 | 37.7710801545587 | -122.38899681088101 | (37.7710801545587, -122.388996810881) | ||||
| 54610 | 54610 | 198620 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015807.975319999 | 2108623.11457 | 37.770764947581895 | -122.38866495024901 | (37.7707649475819, -122.388664950249) | ||||
| 55185 | 55185 | 198604 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6016296.79375 | 2108651.46445 | 37.7708698687766 | -122.386976080084 | (37.7708698687766, -122.386976080084) | ||||
| 55928 | 55928 | 198630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015737.06642 | 2108741.11663 | 37.7710850252717 | -122.38891846733401 | (37.7710850252717, -122.388918467334) | ||||
| 56574 | 56574 | 198635 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015851.9543 | 2108746.90695 | 37.7711072915897 | -122.38852146699399 | (37.7711072915897, -122.388521466994) | ||||
| 56778 | 56778 | 198623 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | ||||
| 57322 | 57322 | 198607 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6016227.74089 | 2108648.22285 | 37.7708571442621 | -122.387214711603 | (37.7708571442621, -122.387214711603) | ||||
| 58881 | 58881 | 198617 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015877.04462 | 2108628.30945 | 37.7707830392222 | -122.388426398764 | (37.7707830392222, -122.388426398764) | ||||
| 59240 | 59240 | 198605 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6016273.49532 | 2108650.02611 | 37.770864629317 | -122.38705657031099 | (37.770864629317, -122.387056570311) | ||||
| 59755 | 59755 | 198619 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015825.0595 | 2108624.79715 | 37.770770514383 | -122.388605972695 | (37.770770514383, -122.388605972695) | ||||
| 61149 | 61149 | 96876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
| 61499 | 61499 | 97836 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 61732 | 61732 | 55989 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 653 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1973 12:00:00 AM | 11 | Permit Number 12064 | 6013032.801630001 | 2104035.48043 | 37.7580141275685 | -122.397942523747 | (37.7580141275685, -122.397942523747) | ||
| 62540 | 62540 | 32997 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.39805475731501 | (37.784617751847, -122.398054757315) | |
| 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) |
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");