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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188978 | 188978 | 245223 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | |||
| 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) | |||
| 185874 | 185874 | 136985 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5998649.64618 | 2115048.5568 | 37.787441680630295 | -122.44847849798799 | (37.7874416806303, -122.448478497988) | |||
| 184479 | 184479 | 137013 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2920 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 5999627.956569999 | 2117064.96637 | 37.79303409860729 | -122.445238785654 | (37.7930340986073, -122.445238785654) | |||
| 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) | |||
| 182189 | 182189 | 244315 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.42442816055599 | (37.7754801903482, -122.424428160556) | |||
| 181726 | 181726 | 200749 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | |||
| 181379 | 181379 | 242616 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 301 Highland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006929.96078 | 2096538.12906 | 37.737086318962604 | -122.418517164938 | (37.7370863189626, -122.418517164938) | |||
| 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) | |||
| 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) | |||
| 180867 | 180867 | 180533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002751.65611 | 2090978.09371 | 37.7215836076762 | -122.43256640991699 | (37.7215836076762, -122.432566409917) | |||
| 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) | |||
| 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) | |||
| 176784 | 176784 | 198471 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 704 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6015348.95336 | 2105815.2595900004 | 37.7630297401524 | -122.390056547668 | (37.7630297401524, -122.390056547668) | |||
| 176765 | 176765 | 215495 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 69 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993977.518540001 | 2097401.11032 | 37.7387181577226 | -122.46336187135401 | (37.7387181577226, -122.463361871354) | |||
| 176025 | 176025 | 244355 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.42413022622601 | (37.7750804055544, -122.424130226226) | |||
| 175466 | 175466 | 110635 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 631 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013464.4845 | 2113882.0453 | 37.7850746181572 | -122.397139998491 | (37.7850746181572, -122.397139998491) | |||
| 175445 | 175445 | 242723 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 291 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004435.5728 | 2103937.2017599996 | 37.7572617205823 | -122.42766840527 | (37.7572617205823, -122.42766840527) | |||
| 175108 | 175108 | 215542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993945.302519999 | 2097292.64109 | 37.7384184721345 | -122.463465388735 | (37.7384184721345, -122.463465388735) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 171766 | 171766 | 136964 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2590 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000622.04414 | 2118252.24291 | 37.7963507407448 | -122.441884450223 | (37.7963507407448, -122.441884450223) | |||
| 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) | |||
| 169918 | 169918 | 198614 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015943.0209 | 2108631.5395299997 | 37.7707955640939 | -122.388198408934 | (37.7707955640939, -122.388198408934) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 165712 | 165712 | 242625 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 295 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008400.82271 | 2100348.1633599997 | 37.747630528223 | -122.413701124526 | (37.747630528223, -122.413701124526) | |||
| 164969 | 164969 | 136977 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 304 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5998585.82745 | 2115521.2848799997 | 37.788736018186604 | -122.448733358666 | (37.7887360181866, -122.448733358666) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 156653 | 156653 | 242429 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 300 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005025.3306599995 | 2109905.44475 | 37.773682432830206 | -122.426053649163 | (37.7736824328302, -122.426053649163) | |||
| 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) | |||
| 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) | |||
| 153686 | 153686 | 198484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6015200.57665 | 2104577.87924 | 37.7596239302292 | -122.390483271483 | (37.7596239302292, -122.390483271483) | |||
| 153260 | 153260 | 198603 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6016318.412280001 | 2108651.0285 | 37.7708698687754 | -122.386901269979 | (37.7708698687754, -122.386901269979) | ||||
| 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) | |||
| 151341 | 151341 | 200746 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | |||
| 150713 | 150713 | 32996 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.022469999 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | |
| 150080 | 150080 | 93910 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 16 | 3x3 | 6001101.2138 | 2114914.769 | 37.7872141986511 | -122.439986998855 | (37.7872141986511, -122.439986998855) | ||
| 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) | |||
| 147817 | 147817 | 198693 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6016661.34411 | 2095009.8516799998 | 37.733433020107 | -122.38476462199199 | (37.733433020107, -122.384764621992) | |||
| 147637 | 147637 | 242459 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 434 Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008569.03881 | 2096702.1560799999 | 37.7376288403924 | -122.412861705413 | (37.7376288403924, -122.412861705413) | |||
| 147593 | 147593 | 180523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 703 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003530.180369999 | 2090485.1231200001 | 37.720274138132 | -122.42984011692499 | (37.720274138132, -122.429840116925) | |||
| 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) | |||
| 144933 | 144933 | 119701 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
| 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) | |||
| 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) | |||
| 142684 | 142684 | 103276 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2800X Pine St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | ||||
| 141634 | 141634 | 112877 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 300x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x2 | 6010100.0 | 2099291.0 | 37.744823060949294 | -122.407750909418 | (37.7448230609493, -122.407750909418) | |||
| 140480 | 140480 | 87306 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 139652 | 139652 | 17941 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2445 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2016 12:00:00 AM | 18 | 3x3 | 6002249.5312774 | 2115023.8576257 | 37.7875790308508 | -122.43602188230601 | (37.7875790308508, -122.436021882306) | ||
| 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) | |||
| 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) | |||
| 137296 | 137296 | 137014 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2795 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000218.16422 | 2117453.42518 | 37.7941343759438 | -122.44322455337401 | (37.7941343759438, -122.443224553374) | |||
| 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) | |||
| 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) | |||
| 134924 | 134924 | 198565 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 01st St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6014744.18848 | 2114165.67532 | 37.7859245585079 | -122.39273243905599 | (37.7859245585079, -122.392732439056) | |||
| 134733 | 134733 | 136986 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 689 Hayes St | 3 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6004705.5479 | 2110850.60835 | 37.776259542675604 | -122.42722716640101 | (37.7762595426756, -122.427227166401) | |||
| 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) | |||
| 133104 | 133104 | 137058 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 440 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011933.40589 | 2118423.08303 | 37.797457876336296 | -122.40275654969801 | (37.7974578763363, -122.402756549698) | |||
| 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) | |||
| 131414 | 131414 | 198575 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6014794.5907 | 2114154.82505 | 37.78589756536171 | -122.392557300594 | (37.7858975653617, -122.392557300594) | |||
| 130420 | 130420 | 242655 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 502 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001805.86123 | 2102847.44693 | 37.7541204147416 | -122.436684955058 | (37.7541204147416, -122.436684955058) | |||
| 129975 | 129975 | 138586 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2702 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000914.7508 | 2114889.5525 | 37.78713434421321 | -122.440630309715 | (37.7871343442132, -122.440630309715) | |||
| 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) | |||
| 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) | |||||
| 128474 | 128474 | 119819 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 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) | |||
| 126904 | 126904 | 101710 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874.0 | 2103773.0 | 37.7572288087602 | -122.40193172517901 | (37.7572288087602, -122.401931725179) | ||
| 126009 | 126009 | 17576 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.72011720804429 | -122.429795147634 | (37.7201172080443, -122.429795147634) | |||
| 125021 | 125021 | 38383 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3815-3817 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769372 | 6003483.0 | 2105926.0 | 37.762668556023996 | -122.43110471906799 | (37.762668556024, -122.431104719068) | ||||
| 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) | |||
| 120892 | 120892 | 3749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 934 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012421.507139799 | 2103592.6632765 | 37.756764184951 | -122.40002555654199 | (37.756764184951, -122.400025556542) | |||
| 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) |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 113567 | 113567 | 7662 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3340 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4x4 | 6008466.34336 | 2099149.1524799997 | 37.744341989826104 | -122.413389775903 | (37.7443419898261, -122.413389775903) | |||
| 112673 | 112673 | 103419 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015432.6 | 2105817.0 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | ||||
| 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) | |||||
| 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) | |
| 108438 | 108438 | 35674 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 108126 | 108126 | 17534 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 445X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002799.2909021 | 2090948.5412154999 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | |||
| 107595 | 107595 | 98272 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | ||
| 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) | |||
| 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) | |||
| 105805 | 105805 | 119677 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) |
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");