Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 89632 | 89632 | 215576 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 95 Kirkham St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 3ft | 5994736.06961 | 2105294.2713 | 37.7604344559039 | -122.461311206651 | (37.7604344559039, -122.461311206651) | |||
| 89901 | 89901 | 11849 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 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) | |||
| 90284 | 90284 | 401 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5990481.9086 | 2090947.8037400001 | 37.7207969949539 | -122.474976977183 | (37.7207969949539, -122.474976977183) | |||
| 90643 | 90643 | 11668 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 5991320.9947906 | 2093088.5989831001 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | |||
| 90813 | 90813 | 26778 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 90931 | 90931 | 11627 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 300X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | |||
| 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) | |||
| 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) | |||
| 91904 | 91904 | 11692 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 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) | |||
| 92672 | 92672 | 85425 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | |||
| 92989 | 92989 | 26772 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 93005 | 93005 | 7472 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2637 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6008329.443080001 | 2103061.47825 | 37.75507667179011 | -122.41413988378599 | (37.7550766717901, -122.414139883786) | |||
| 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) | |||
| 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) | |||
| 94026 | 94026 | 29916 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 810 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | ||||
| 94173 | 94173 | 117256 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 94262 | 94262 | 106880 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 3 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 5 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 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) | |||
| 94750 | 94750 | 11616 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 95655 | 95655 | 29917 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 810 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 100073 | 100073 | 11656 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 699X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 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) | |||
| 101162 | 101162 | 87591 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3840 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5990782.62319 | 2090250.3116099997 | 37.7188992769151 | -122.473886649335 | (37.7188992769151, -122.473886649335) | ||||
| 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) | |||
| 102679 | 102679 | 19106 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 104287 | 104287 | 215601 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 155 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991211.33426 | 2091424.54649 | 37.7221482587196 | -122.472490339055 | (37.7221482587196, -122.472490339055) | |||
| 104574 | 104574 | 11619 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 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) | |||
| 106471 | 106471 | 7479 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 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) | |||
| 106977 | 106977 | 11873 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 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) | |||
| 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) | |||
| 107172 | 107172 | 4850 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6002180.0 | 2093376.0 | 37.728135283202704 | -122.43471385212 | (37.7281352832027, -122.43471385212) | |||
| 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) | |||
| 108076 | 108076 | 11722 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
| 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) | |||
| 109658 | 109658 | 11633 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 109973 | 109973 | 99911 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005460.7 | 2101331.3 | 37.750164452601794 | -122.42393781012501 | (37.7501644526018, -122.423937810125) | ||||
| 110227 | 110227 | 11741 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 900X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | |||
| 110485 | 110485 | 1001 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | |||
| 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) | |||
| 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) | ||
| 111277 | 111277 | 11695 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 112174 | 112174 | 400 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2 | 5990476.72602 | 2090904.23897 | 37.7206770765591 | -122.474991713144 | (37.7206770765591, -122.474991713144) | |||
| 112238 | 112238 | 7474 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 112240 | 112240 | 1060 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2059X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000457.1646300005 | 2090146.24433 | 37.7191691518296 | -122.440438198589 | (37.7191691518296, -122.440438198589) | |||
| 112345 | 112345 | 26171 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
| 113163 | 113163 | 11689 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 113267 | 113267 | 393 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 2 | 5990507.18031 | 2090652.7596599997 | 37.7199883416446 | -122.47486809669701 | (37.7199883416446, -122.474868096697) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 113884 | 113884 | 11686 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 114019 | 114019 | 1027 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1965X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 31 | 3X3 | 6000825.64245 | 2090608.45865 | 37.7204592623287 | -122.439197625247 | (37.7204592623287, -122.439197625247) | ||
| 114194 | 114194 | 1058 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2055X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6000480.4143 | 2090166.82631 | 37.719226989106005 | -122.440359308841 | (37.719226989106, -122.440359308841) | |||
| 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) | |||
| 114677 | 114677 | 7481 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 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) | |||
| 114875 | 114875 | 415 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X6 | 5990878.963880001 | 2090116.60552 | 37.718537732694394 | -122.473543893183 | (37.7185377326944, -122.473543893183) | |||
| 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) | |||
| 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) | |||
| 115742 | 115742 | 394 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990492.73788 | 2090676.25296 | 37.720052011465896 | -122.474919732673 | (37.7200520114659, -122.474919732673) | |||
| 116279 | 116279 | 1181 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | |||
| 117028 | 117028 | 137076 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 Hayes St | 4 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6004731.627309999 | 2110853.90859 | 37.776270079140396 | -122.427137185641 | (37.7762700791404, -122.427137185641) | |||
| 117409 | 117409 | 227 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2X3 | 5990630.67566 | 2095430.1647700001 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | |||
| 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) | |||
| 118300 | 118300 | 1581 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 629 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995601.12395 | 2111917.66113 | 37.7786703056802 | -122.458798934123 | (37.7786703056802, -122.458798934123) | |||
| 118796 | 118796 | 11718 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
| 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) | |||
| 119227 | 119227 | 1030 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | 3X6 | 6000847.46445 | 2090663.0926299999 | 37.7206105166164 | -122.43912610743799 | (37.7206105166164, -122.439126107438) | |||
| 119337 | 119337 | 1597 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 714 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995688.036 | 2111228.67679 | 37.7767835321697 | -122.458448388127 | (37.7767835321697, -122.458448388127) | |||
| 120071 | 120071 | 1029 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X6 | 6000859.82003 | 2090688.3349 | 37.7206805292285 | -122.43908520635401 | (37.7206805292285, -122.439085206354) | |||
| 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) | |||
| 120490 | 120490 | 11712 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 120708 | 120708 | 1551 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 530 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995634.85993 | 2112642.48366 | 37.7806624148094 | -122.458734717129 | (37.7806624148094, -122.458734717129) |
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");