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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 1048 | 1048 | 251423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5999946.0 | 2089791.0 | 37.718164612456604 | -122.44217960719999 | (37.7181646124566, -122.4421796072) | ||||
| 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) | |||
| 3284 | 3284 | 253385 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1100 Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004275.0 | 2112509.0 | 37.780788718892204 | -122.428834805692 | (37.7807887188922, -122.428834805692) | |||||
| 3375 | 3375 | 253429 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2198 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7 | 5992046.0 | 2112030.0 | 37.7787737730441 | -122.471105555235 | (37.7787737730441, -122.471105555235) | ||||
| 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) | |||
| 9045 | 9045 | 1066 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2075X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000333.402969999 | 2090026.65578 | 37.71883374095071 | -122.440857420165 | (37.7188337409507, -122.440857420165) | |||
| 10333 | 10333 | 899 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418002 | (37.7307693064514, -122.43007470418) | |||
| 10343 | 10343 | 978 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6001786.79947 | 2092741.5935099998 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | |||
| 10656 | 10656 | 970 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1599 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4X4 | 6001869.51123 | 2092911.87236 | 37.7268432620915 | -122.435754028151 | (37.7268432620915, -122.435754028151) | |||
| 10846 | 10846 | 997 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1693 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X6 | 6001548.3914 | 2092219.7643099998 | 37.724924644828704 | -122.43681460581301 | (37.7249246448287, -122.436814605813) | |||
| 10978 | 10978 | 1259 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3821 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992830.40302 | 2087513.47902 | 37.7115029917542 | -122.46660951663601 | (37.7115029917542, -122.466609516636) | |||
| 11041 | 11041 | 16703 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1677X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 43 | 5x6 | 6001597.82921 | 2092328.38749 | 37.7252257090852 | -122.436651476894 | (37.7252257090852, -122.436651476894) | |||
| 11189 | 11189 | 914 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1233 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X5 | 6003058.45033 | 2094142.0195400002 | 37.730288432643796 | -122.431731689776 | (37.7302884326438, -122.431731689776) | |||
| 11221 | 11221 | 938 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6002521.94299 | 2093864.9840400002 | 37.729497329615704 | -122.433566675476 | (37.7294973296157, -122.433566675476) | |||
| 11261 | 11261 | 936 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.0300900002 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | ||
| 11320 | 11320 | 1260 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3827 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992804.99866 | 2087505.2482200002 | 37.7114789258702 | -122.46669672210301 | (37.7114789258702, -122.466696722103) | |||
| 11385 | 11385 | 4849 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1469X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X6 | 6002249.52444 | 2093516.68285 | 37.7285255132222 | -122.43448355857402 | (37.7285255132222, -122.434483558574) | |||
| 11419 | 11419 | 940 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1331 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6002472.82123 | 2093812.78737 | 37.7293512221746 | -122.433732764948 | (37.7293512221746, -122.433732764948) | |||
| 11486 | 11486 | 1258 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3815 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992861.70969 | 2087523.33873 | 37.7115318707666 | -122.466502029665 | (37.7115318707666, -122.466502029665) | |||
| 11782 | 11782 | 915 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003037.510530001 | 2094134.6631900002 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | |||
| 11865 | 11865 | 939 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | |||
| 11932 | 11932 | 900 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1167 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003509.8986599995 | 2094295.64409 | 37.7307358309933 | -122.43018192766 | (37.7307358309933, -122.43018192766) | |||
| 11990 | 11990 | 1085 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999963.70084 | 2089791.4898700002 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | |||
| 12595 | 12595 | 1250 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3743 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X6 | 5993011.32335 | 2087550.57925 | 37.7116152990749 | -122.46598690787701 | (37.7116152990749, -122.465986907877) | |||
| 12842 | 12842 | 912 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1229 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003089.95028 | 2094152.4368200002 | 37.730318821659296 | -122.431623533692 | (37.7303188216593, -122.431623533692) | |||
| 12927 | 12927 | 1025 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1948 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6000854.43502 | 2090852.74185 | 37.7211316470959 | -122.439115597724 | (37.7211316470959, -122.439115597724) | |||
| 13931 | 13931 | 19779 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 16388 | 16388 | 115471 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | |||||||||
| 17204 | 17204 | 19082 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994691.4790199995 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | |||
| 17410 | 17410 | 19053 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.711286145417496 | -122.457367103015 | (37.7112861454175, -122.457367103015) | |||
| 17794 | 17794 | 19085 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994662.28634 | 2087388.8423799998 | 37.711266313550794 | -122.46026906776501 | (37.7112663135508, -122.460269067765) | |||
| 18392 | 18392 | 19097 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.46171582334298 | (37.711481126537, -122.461715823343) | |||
| 18427 | 18427 | 19072 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 204 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5994955.69063 | 2087466.73543 | 37.7114970625193 | -122.459260632792 | (37.7114970625193, -122.459260632792) | |||
| 18615 | 18615 | 19086 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994700.784889599 | 2087405.1340273 | 37.71131326103529 | -122.460137187577 | (37.7113132610353, -122.460137187577) | |||
| 19211 | 19211 | 19069 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.45913384457701 | (37.711496124512, -122.459133844577) | |||
| 19243 | 19243 | 39175 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | |
| 19652 | 19652 | 99912 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005509.050559999 | 2101091.11643 | 37.7495076933522 | -122.42375353501998 | (37.7495076933522, -122.42375353502) | ||||
| 19881 | 19881 | 19078 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 215 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5994825.043959999 | 2087387.37086 | 37.711271633946296 | -122.459706433929 | (37.7112716339463, -122.459706433929) | |||
| 20873 | 20873 | 19088 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 238 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5994602.312969999 | 2087471.0641 | 37.7114886250695 | -122.460482303322 | (37.7114886250695, -122.460482303322) | |||
| 20889 | 20889 | 19100 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 281 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 5994272.63935 | 2087395.39368 | 37.7112618807995 | -122.46161625041 | (37.7112618807995, -122.46161625041) | |||
| 21264 | 21264 | 19063 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 175 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995252.88797 | 2087382.67456 | 37.7112833332178 | -122.45822736752501 | (37.7112833332178, -122.458227367525) | |||
| 21339 | 21339 | 19071 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994967.06362 | 2087386.6571400003 | 37.7112778401642 | -122.459215529972 | (37.7112778401642, -122.459215529972) | |||
| 21385 | 21385 | 19093 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 257 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994426.29409 | 2087392.8188099999 | 37.711263654258204 | -122.461084998394 | (37.7112636542582, -122.461084998394) | |||
| 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) | |||
| 25535 | 25535 | 180581 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6002394.23037 | 2093854.8065099998 | 37.72946213735921 | -122.434007462878 | (37.7294621373592, -122.434007462878) | |||
| 26083 | 26083 | 123491 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5995674.45752 | 2111730.9534 | 37.77816187055421 | -122.458531727532 | (37.7781618705542, -122.458531727532) | ||||
| 26368 | 26368 | 137075 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 Hayes St | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 5ft | 6004617.552730001 | 2110839.21576 | 37.776223284701 | -122.42753075415001 | (37.776223284701, -122.42753075415) | |||
| 34555 | 34555 | 180593 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2136 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6000017.35738 | 2089840.46995 | 37.718304512220605 | -122.44193650477699 | (37.7183045122206, -122.441936504777) | |||
| 36799 | 36799 | 123470 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 778 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5995383.59468 | 2110411.0672400002 | 37.7745210919414 | -122.45944230753099 | (37.7745210919414, -122.459442307531) | |||
| 36822 | 36822 | 215590 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 501 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 3ft | 5991474.9385 | 2093941.2931 | 37.729073873942795 | -122.47176245478701 | (37.7290738739428, -122.471762454787) | |||
| 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) | |||
| 38340 | 38340 | 11711 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 44608 | 44608 | 215594 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 246 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994531.01193 | 2087471.53389 | 37.7114858129011 | -122.46072877062299 | (37.7114858129011, -122.460728770623) | |||
| 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) | ||
| 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) | |
| 56269 | 56269 | 1048 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | ||||
| 57260 | 57260 | 242793 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | |||
| 60841 | 60841 | 215593 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995757.42889 | 2087376.9000799998 | 37.7112964570463 | -122.45648314049801 | (37.7112964570463, -122.456483140498) | |||
| 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) | |||
| 69286 | 69286 | 58907 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.39940938545601 | (37.7108941228427, -122.399409385456) | ||
| 69626 | 69626 | 180591 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1804 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.72287237033329 | -122.438023911598 | (37.7228723703333, -122.438023911598) | |||
| 74903 | 74903 | 215591 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 233 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994635.3694400005 | 2087388.76073 | 37.711264541001206 | -122.460362092762 | (37.7112645410012, -122.460362092762) | |||
| 74958 | 74958 | 180583 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1114 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6003761.56491 | 2094470.84041 | 37.731231131690706 | -122.42932436652599 | (37.7312311316907, -122.429324366526) | |||
| 77050 | 77050 | 181893 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2370 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5987361.9916 | 2099162.5217 | 37.7431711693476 | -122.486364226347 | (37.7431711693476, -122.486364226347) | |||
| 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) | |||
| 79845 | 79845 | 933 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1294X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6002802.17626 | 2094143.63343 | 37.7302783338422 | -122.432617778446 | (37.7302783338422, -122.432617778446) | |||
| 82094 | 82094 | 1645 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 881 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 6X6 | 5995652.78213 | 2110475.54294 | 37.7747135991516 | -122.458515810277 | (37.7747135991516, -122.458515810277) | |||
| 82113 | 82113 | 929 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1286X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6002834.53778 | 2094157.0386599998 | 37.73031697676271 | -122.432506857514 | (37.7303169767627, -122.432506857514) | |||
| 83287 | 83287 | 1622 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 781 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X4 | 5995639.652530001 | 2110927.44628 | 37.7759536520848 | -122.45859394843201 | (37.7759536520848, -122.458593948432) | |||
| 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) | |||
| 86397 | 86397 | 239 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 86707 | 86707 | 7464 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2599 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008286.46562 | 2103308.5385 | 37.7557526290701 | -122.41430599230301 | (37.7557526290701, -122.414305992303) | |||
| 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) | |||
| 87541 | 87541 | 121665 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993653.0 | 2099666.0 | 37.7449182738718 | -122.46464831295299 | (37.7449182738718, -122.464648312953) | ||||
| 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) | |||
| 88057 | 88057 | 883 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1100X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X6 | 6003437.0 | 2094359.0 | 37.7309056628368 | -122.43043846836599 | (37.7309056628368, -122.430438468366) | |||
| 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) | |||
| 88504 | 88504 | 19105 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 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) | |||
| 89969 | 89969 | 1617 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.775876579407296 | -122.458377647589 | (37.7758765794073, -122.458377647589) | |||
| 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) | |||
| 94286 | 94286 | 19045 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995778.761022701 | 2087391.1107423 | 37.7113367008986 | -122.45641043862801 | (37.7113367008986, -122.456410438628) | |||
| 94466 | 94466 | 7473 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
| 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) | |||
| 94881 | 94881 | 19090 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 5994507.8215972 | 2087458.0224558997 | 37.7114473793836 | -122.460807943318 | (37.7114473793836, -122.460807943318) | |||
| 95650 | 95650 | 7425 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2501 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008288.6679 | 2103807.30911 | 37.7571222633799 | -122.414333665067 | (37.7571222633799, -122.414333665067) | |||
| 96797 | 96797 | 1620 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.776037871937206 | -122.45860409582599 | (37.7760378719372, -122.458604095826) | |||
| 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) | |||
| 98822 | 98822 | 51906 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 157 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.42559837996599 | (37.7428856098168, -122.425598379966) | |||
| 99073 | 99073 | 108311 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 439x ARLINGTON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329168998 | (37.7354814316621, -122.42878329169) | |||||
| 99379 | 99379 | 1642 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.45827731837299 | (37.7744643941763, -122.458277318373) | |||
| 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) | |||
| 100174 | 100174 | 1637 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 830 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5995713.25263 | 2110507.70954 | 37.7748053952412 | -122.45830896062701 | (37.7748053952412, -122.458308960627) | |||
| 103661 | 103661 | 1035 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | |||
| 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) | |||
| 104642 | 104642 | 1257 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X3 | 5992919.7951 | 2087516.7094700001 | 37.7115170200575 | -122.46630079139099 | (37.7115170200575, -122.466300791391) | |||
| 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) | |||
| 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) |
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");