Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184419 | 184419 | 142972 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2010 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6009915.1882 | 2121025.8734 | 37.804491604686206 | -122.409923973004 | (37.8044916046862, -122.409923973004) | |||
| 187353 | 187353 | 142975 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2000 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6009927.4614 | 2120951.259 | 37.804287419917294 | -122.40987623003299 | (37.8042874199173, -122.409876230033) | |||
| 24510 | 24510 | 142976 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 392 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6009963.6556 | 2120937.6931 | 37.80425219968421 | -122.409750018417 | (37.8042521996842, -122.409750018417) | |||
| 180677 | 180677 | 102615 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 392 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6009946.866 | 2120935.8276 | 37.804246136595296 | -122.409807988636 | (37.8042461365953, -122.409807988636) | |||
| 166993 | 166993 | 107483 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1306x Montgomery St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | ||||
| 7781 | 7781 | 16359 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1306x Montgomery St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | |||
| 45548 | 45548 | 45657 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1330 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006609.23369 | 2119082.98627 | 37.798971095388396 | -122.421226497612 | (37.7989710953884, -122.421226497612) | ||
| 147002 | 147002 | 83273 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 3 | 6008750.425980001 | 2118601.9970299997 | 37.797770897055294 | -122.413783193943 | (37.7977708970553, -122.413783193943) | ||
| 33957 | 33957 | 137078 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | |||
| 171388 | 171388 | 137079 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008755.558119999 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | |||
| 8324 | 8324 | 106867 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1974 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003576.11959 | 2118663.726 | 37.797648453467396 | -122.431692125901 | (37.7976484534674, -122.431692125901) | |||
| 179443 | 179443 | 137080 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.79763977591279 | -122.41375141818999 | (37.7976397759128, -122.41375141819) | |||
| 175491 | 175491 | 137081 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | |||
| 36173 | 36173 | 137082 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008777.375519999 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | |||
| 136034 | 136034 | 137077 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2955 Steiner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 6001974.0393199995 | 2118352.39854 | 37.796702688621004 | -122.437213445266 | (37.796702688621, -122.437213445266) | |||
| 50637 | 50637 | 117189 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.793960957890896 | -122.415375111785 | (37.7939609578909, -122.415375111785) | |||
| 54703 | 54703 | 39229 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1335 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 15 | 3x3 | Permit Number 40871 | 6008226.63206 | 2117220.6849599998 | 37.793948727108 | -122.41549782608699 | (37.793948727108, -122.415497826087) | |
| 149713 | 149713 | 137067 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997931.48984 | 2116393.73013 | 37.791094081978 | -122.45106020067 | (37.791094081978, -122.45106020067) | |||
| 104261 | 104261 | 137068 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997936.78651 | 2116362.08959 | 37.7910075087313 | -122.45103959183001 | (37.7910075087313, -122.45103959183) | |||
| 66690 | 66690 | 137069 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997939.35301 | 2116349.8609700003 | 37.7909740791344 | -122.45102982968099 | (37.7909740791344, -122.451029829681) | |||
| 175894 | 175894 | 137070 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5997942.37701 | 2116329.50618 | 37.7909183634316 | -122.451017898383 | (37.7909183634316, -122.451017898383) | |||
| 149316 | 149316 | 137071 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997945.511630001 | 2116314.45646 | 37.7908772203684 | -122.451005967078 | (37.7908772203684, -122.451005967078) | |||
| 144278 | 144278 | 2933 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1834 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | ||
| 93568 | 93568 | 1421 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x12 | 5995527.212040001 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | |||
| 128580 | 128580 | 82168 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | |||||
| 145404 | 145404 | 1420 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3x3 | 5995529.5957 | 2115606.06371 | 37.7887935591586 | -122.45931355109501 | (37.7887935591586, -122.459313551095) | |||
| 66816 | 66816 | 124642 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | |||
| 37126 | 37126 | 124641 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5995529.17868 | 2115583.09769 | 37.7887304767053 | -122.459313330112 | (37.7887304767053, -122.459313330112) | |||
| 104190 | 104190 | 1423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x5 | 5995562.14611 | 2115577.70158 | 37.7887175558035 | -122.459198877421 | (37.7887175558035, -122.459198877421) | |||
| 172911 | 172911 | 105883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | ||||
| 86737 | 86737 | 1428 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.63795 | 2115574.8643900002 | 37.78870421691 | -122.459532573841 | (37.78870421691, -122.459532573841) | |||
| 120429 | 120429 | 1430 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5 | 5995476.6114 | 2115563.93405 | 37.7886748361207 | -122.45949381562299 | (37.7886748361207, -122.459493815623) | |||
| 95505 | 95505 | 1429 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.54596 | 2115556.4736099998 | 37.788653715516205 | -122.45953155962 | (37.7886537155162, -122.45953155962) | |||
| 37233 | 37233 | 105882 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5997612.13513 | 2115509.12693 | 37.78864690886571 | -122.45210129905001 | (37.7886469088657, -122.45210129905) | ||||
| 189005 | 189005 | 105881 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5997617.52659 | 2115483.20836 | 37.788576052199396 | -122.452080774722 | (37.7885760521994, -122.452080774722) | ||||
| 111256 | 111256 | 104704 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3590X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2014 12:00:00 AM | 3x3 | Permit Number 771748 | 5997841.875 | 2115466.23587 | 37.7885422986565 | -122.451303342479 | (37.7885422986565, -122.451303342479) | ||
| 42957 | 42957 | 137072 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3598 Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5997679.8137 | 2115460.2442400004 | 37.788516566519604 | -122.451863614513 | (37.7885165665196, -122.451863614513) | |||
| 49070 | 49070 | 137073 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3598 Clay St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5997662.024569999 | 2115459.05462 | 37.7885122812527 | -122.45192507598699 | (37.7885122812527, -122.451925075987) | |||
| 181588 | 181588 | 137074 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3598 Clay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5997641.85824 | 2115456.61364 | 37.7885044238892 | -122.45199467183998 | (37.7885044238892, -122.45199467184) | |||
| 124439 | 124439 | 1431 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5 | 5995471.94905 | 2115498.24125 | 37.788494193386896 | -122.459505186902 | (37.7884941933869, -122.459505186902) | |||
| 145198 | 145198 | 1432 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 5 | 5995472.27833 | 2115471.9588 | 37.7884220478225 | -122.45950214341002 | (37.7884220478225, -122.45950214341) | |||
| 119155 | 119155 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 1636 Bush St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665.0 | 2115204.0 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | |||
| 117946 | 117946 | 1434 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | |||
| 83607 | 83607 | 1433 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5X5 | 5995535.85964 | 2115388.7214900004 | 37.7881971563264 | -122.459276133553 | (37.7881971563264, -122.459276133553) | |||
| 91570 | 91570 | 1435 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 5 | 5995475.980819999 | 2115376.20265 | 37.7881593402184 | -122.459482395726 | (37.7881593402184, -122.459482395726) | |||
| 129385 | 129385 | 1437 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.78800235781971 | -122.459478767425 | (37.7880023578197, -122.459478767425) | |||
| 40857 | 40857 | 124637 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.787983889154205 | -122.459265995172 | (37.7879838891542, -122.459265995172) | ||||
| 89919 | 89919 | 1440 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | |||
| 87059 | 87059 | 1438 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 5 | 5995477.38208 | 2115292.8933900003 | 37.787930676078794 | -122.45947151175501 | (37.7879306760788, -122.459471511755) | |||
| 87605 | 87605 | 1441 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 138 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 5X5 | 5995537.91826 | 2115271.42403 | 37.7878752075455 | -122.459260513654 | (37.7878752075455, -122.459260513654) | |||
| 94783 | 94783 | 39243 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | |||
| 98239 | 98239 | 1470 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5995496.39039 | 2114788.7917299997 | 37.786547641872296 | -122.45936922598 | (37.7865476418723, -122.45936922598) | |||
| 108172 | 108172 | 1468 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5995558.6934 | 2114767.33782 | 37.786492317136606 | -122.459152120252 | (37.7864923171366, -122.459152120252) | |||
| 114688 | 114688 | 1471 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | |||
| 140740 | 140740 | 1474 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 234 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x5 | 5995562.8915 | 2114652.7171099996 | 37.7861778408698 | -122.459129293157 | (37.7861778408698, -122.459129293157) | |||
| 79844 | 79844 | 1477 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 245 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995501.2635699995 | 2114653.66128 | 37.7861768902412 | -122.45934257653799 | (37.7861768902412, -122.459342576538) | |||
| 2137 | 2137 | 124672 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | Width 4ft | 5995591.07711 | 2113866.14003 | 37.784019731735604 | -122.458974806266 | (37.7840197317356, -122.458974806266) | |||
| 107025 | 107025 | 1514 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 4X6 | 5995592.131 | 2113860.45299 | 37.7840041772291 | -122.458970748307 | (37.7840041772291, -122.458970748307) | |||
| 139352 | 139352 | 1510 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 369 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 5995536.869969999 | 2113765.1567 | 37.7837393424086 | -122.45915502719102 | (37.7837393424086, -122.459155027191) | |||
| 113757 | 113757 | 6416 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 400X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 6x5 | 5995602.32868 | 2113744.52068 | 37.7836864443545 | -122.458927071616 | (37.7836864443545, -122.458927071616) | |||
| 79677 | 79677 | 10721 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 80768 | 80768 | 10719 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 92480 | 92480 | 10715 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 96651 | 96651 | 10718 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 100033 | 100033 | 10714 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 103593 | 103593 | 10720 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 115302 | 115302 | 10716 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 122430 | 122430 | 10717 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 124683 | 124683 | 10723 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 128283 | 128283 | 10722 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 66806 | 66806 | 123958 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.46559031264799 | (37.7830615134244, -122.465590312648) | |||
| 138620 | 138620 | 1526 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 440 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 5995608.48873 | 2113422.41383 | 37.782802379218296 | -122.458882431606 | (37.7828023792183, -122.458882431606) | |||
| 88173 | 88173 | 6271 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.782778273754104 | -122.429763959937 | (37.7827782737541, -122.429763959937) | |||
| 89521 | 89521 | 6272 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003992.005369999 | 2113234.0209999997 | 37.782763424573005 | -122.429865551596 | (37.782763424573, -122.429865551596) | |||
| 95703 | 95703 | 6273 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003962.5783400005 | 2113230.61655 | 37.78275241032 | -122.42996711374701 | (37.78275241032, -122.429967113747) | |||
| 52532 | 52532 | 124686 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5995607.11329 | 2113402.43136 | 37.7827474336358 | -122.458885742796 | (37.7827474336358, -122.458885742796) | |||
| 111027 | 111027 | 6274 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003886.01337 | 2113219.41254 | 37.782717310542395 | -122.430231196525 | (37.7827173105424, -122.430231196525) | |||
| 183011 | 183011 | 124687 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5995608.47806 | 2113376.19737 | 37.782675480559504 | -122.45887912132 | (37.7826754805595, -122.45887912132) | |||
| 106502 | 106502 | 6275 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1421X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003957.217759999 | 2113179.66455 | 37.782612205263796 | -122.429982023346 | (37.7826122052638, -122.429982023346) | |||
| 107061 | 107061 | 6276 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1421X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003957.217759999 | 2113179.66455 | 37.782612205263796 | -122.429982023346 | (37.7826122052638, -122.429982023346) | |||
| 37355 | 37355 | 124688 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5995612.537930001 | 2113341.5687 | 37.782580632849395 | -122.458862568059 | (37.7825806328494, -122.458862568059) | |||
| 81090 | 81090 | 6279 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003832.24761 | 2113162.85488 | 37.782558971887205 | -122.430413166544 | (37.7825589718872, -122.430413166544) | |||
| 114366 | 114366 | 1525 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 439 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5X7 | 5995548.96018 | 2113291.48375 | 37.7824394582911 | -122.459078890487 | (37.7824394582911, -122.459078890487) | |||
| 129442 | 129442 | 1529 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 451 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X4 | 5995566.01052 | 2113204.19125 | 37.7822007565611 | -122.45901358165001 | (37.7822007565611, -122.45901358165) | |||
| 89099 | 89099 | 6281 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 93750 | 93750 | 6280 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 99544 | 99544 | 6284 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 101312 | 101312 | 6282 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 115146 | 115146 | 26486 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 145390 | 145390 | 6278 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 31393 | 31393 | 123644 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 445 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995555.16132 | 2113176.03479 | 37.78212282277371 | -122.45904907539101 | (37.7821228227737, -122.459049075391) | |||
| 113834 | 113834 | 1543 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5995618.1476548 | 2113146.4510222 | 37.782045214262205 | -122.458829030078 | (37.7820452142622, -122.458829030078) | |||
| 121917 | 121917 | 1542 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5995618.1476548 | 2113146.4510222 | 37.782045214262205 | -122.458829030078 | (37.7820452142622, -122.458829030078) | |||
| 85463 | 85463 | 1534 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 91709 | 91709 | 1533 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 99894 | 99894 | 1541 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 128940 | 128940 | 1540 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 166173 | 166173 | 124694 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5995618.45318 | 2113098.44712 | 37.78191342592 | -122.45882449658501 | (37.78191342592, -122.458824496585) | |||
| 107731 | 107731 | 1531 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 445 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5995560.27463 | 2113085.81754 | 37.7818754042369 | -122.459024851411 | (37.7818754042369, -122.459024851411) | |||
| 113835 | 113835 | 5927 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) |
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");