trees
430 rows where qSpecies_id = 99
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46026 | 1477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 245 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995501.26357 | 2114653.66128 | 37.7861768902412 | -122.459342576538 | (37.7861768902412, -122.459342576538) | 11 | 6 | 1 | 54 | 11 | |||
| 46257 | 1259 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3821 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5992830.40302 | 2087513.47902 | 37.7115029917542 | -122.466609516636 | (37.7115029917542, -122.466609516636) | 9 | 8 | 4 | 64 | 24 | |||
| 46333 | 21830 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1419X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X6 | 6002361.46709 | 2093663.80125 | 37.7289358208429 | -122.434107079856 | (37.7289358208429, -122.434107079856) | 9 | 7 | 6 | 28861 | 25 | |||
| 46485 | 6279 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003832.24761 | 2113162.85488 | 37.7825589718872 | -122.430413166544 | (37.7825589718872, -122.430413166544) | 7 | 9 | 11 | 29490 | 41 | |||
| 47049 | 215580 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 3ft | 5991366.74972 | 2092229.04743 | 37.7243662135233 | -122.472011718965 | (37.7243662135233, -122.472011718965) | 9 | 8 | 4 | 59 | 40 | |||
| 47119 | 180584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1114 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6003732.95256 | 2094463.14814 | 37.7312083905422 | -122.429422736186 | (37.7312083905422, -122.429422736186) | 9 | 7 | 5 | 28861 | 25 | |||
| 47411 | 1433 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5X5 | 5995535.85964 | 2115388.72149 | 37.7881971563264 | -122.459276133553 | (37.7881971563264, -122.459276133553) | 11 | 6 | 1 | 54 | 31 | |||
| 48000 | 105881 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5997617.52659 | 2115483.20836 | 37.7885760521994 | -122.452080774722 | (37.7885760521994, -122.452080774722) | 11 | 6 | 1 | 54 | 31 | ||||
| 48438 | 26629 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | 10 | 3 | 8 | 58 | 1 | ||
| 48960 | 1645 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 881 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 6X6 | 5995652.78213 | 2110475.54294 | 37.7747135991516 | -122.458515810277 | (37.7747135991516, -122.458515810277) | 11 | 6 | 2 | 54 | 11 | |||
| 49035 | 1182 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
| 49417 | 997 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1693 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6001548.3914 | 2092219.76431 | 37.7249246448287 | -122.436814605813 | (37.7249246448287, -122.436814605813) | 9 | 7 | 6 | 28861 | 25 | |||
| 49919 | 11696 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 50531 | 242796 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 2ft | 5997883.86583 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | 15 | 5 | 11 | 29492 | 12 | |||
| 50866 | 1622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 781 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X4 | 5995639.65253 | 2110927.44628 | 37.7759536520848 | -122.458593948432 | (37.7759536520848, -122.458593948432) | 11 | 6 | 2 | 54 | 11 | |||
| 51308 | 242791 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1001 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 6005175.70924 | 2096892.88162 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | 2 | 7 | 5 | 28859 | 2 | ||||
| 52619 | 1032 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
| 53519 | 123480 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 34 | 5995658.30802 | 2112054.06112 | 37.7790481105637 | -122.458610990374 | (37.7790481105637, -122.458610990374) | 11 | 6 | 2 | 54 | 16 | ||||
| 53699 | 10721 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 54348 | 933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1294X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6002802.17626 | 2094143.63343 | 37.7302783338422 | -122.432617778446 | (37.7302783338422, -122.432617778446) | 9 | 7 | 5 | 28861 | 25 | |||
| 55585 | 11626 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 300X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | |||
| 55591 | 11677 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991320.9947906 | 2093088.5989831 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | 9 | 8 | 4 | 64 | 40 | |||
| 55643 | 123482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 35 | 5995660.39644 | 2111993.63742 | 37.7788823231397 | -122.458599390427 | (37.7788823231397, -122.458599390427) | 11 | 6 | 2 | 54 | 16 | ||||
| 55859 | 11620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 55899 | 180586 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001346.13618 | 2093162.98872 | 37.7275030272355 | -122.437581294937 | (37.7275030272355, -122.437581294937) | 9 | 7 | 6 | 28861 | 25 | |||
| 56066 | 137081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | 5 | 1 | 10 | 308 | 21 | |||
| 56237 | 1042 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1999X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6000738.08152 | 2090455.78835 | 37.7200350812737 | -122.439489356062 | (37.7200350812737, -122.439489356062) | 9 | 7 | 6 | 28861 | 25 | |||
| 56459 | 1867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2555 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | 10 | 3 | 8 | 309 | 1 | |||
| 56999 | 929 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1286X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002834.53778 | 2094157.03866 | 37.7303169767627 | -122.432506857514 | (37.7303169767627, -122.432506857514) | 9 | 7 | 5 | 28861 | 25 | |||
| 57509 | 1260 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3827 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5992804.99866 | 2087505.24822 | 37.7114789258702 | -122.466696722103 | (37.7114789258702, -122.466696722103) | 9 | 8 | 4 | 64 | 24 | |||
| 57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 57726 | 177713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.7156537101333 | -122.471934040933 | (37.7156537101333, -122.471934040933) | 9 | 8 | 6 | 64 | 24 | |||
| 58154 | 121665 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5993653 | 2099666 | 37.7449182738718 | -122.464648312953 | (37.7449182738718, -122.464648312953) | 1 | 8 | 4 | 29491 | 40 | ||||
| 58765 | 242794 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 4 | Median : Yard | Tree | DPW 1 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | 2 | 7 | 7 | 28859 | 2 | ||||
| 59579 | 123469 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 772 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 5995383.36925 | 2110442.32995 | 37.7746069181393 | -122.459445351917 | (37.7746069181393, -122.459445351917) | 11 | 6 | 2 | 54 | 11 | |||
| 60170 | 181893 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2370 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 5987361.9916 | 2099162.5217 | 37.7431711693476 | -122.486364226347 | (37.7431711693476, -122.486364226347) | 1 | 8 | 3 | 29491 | 35 | |||
| 60286 | 19057 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995437.65535 | 2087381.53973 | 37.7112908326789 | -122.457588686968 | (37.7112908326789, -122.457588686968) | 9 | 8 | 6 | 28861 | 24 | |||
| 60777 | 1617 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.7758765794073 | -122.458377647589 | (37.7758765794073, -122.458377647589) | 11 | 6 | 2 | 54 | 16 | |||
| 60921 | 239 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.7323143965058 | -122.474793962374 | (37.7323143965058, -122.474793962374) | 1 | 8 | 4 | 64 | 40 | |||
| 61047 | 1534 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
| 61390 | 26778 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 61561 | 1440 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | 11 | 6 | 1 | 54 | 31 | |||
| 61972 | 19303 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.441033210291 | (37.7186921269443, -122.441033210291) | 9 | 7 | 6 | 28861 | 25 | |||
| 61984 | 7476 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 62520 | 936 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.03009 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | 9 | 7 | 6 | 28861 | 25 | ||
| 63130 | 11668 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 5991320.9947906 | 2093088.5989831 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | 9 | 8 | 4 | 64 | 40 | |||
| 63749 | 938 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6002521.94299 | 2093864.98404 | 37.7294973296157 | -122.433566675476 | (37.7294973296157, -122.433566675476) | 9 | 7 | 6 | 28861 | 25 | |||
| 64618 | 1441 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 138 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 5X5 | 5995537.91826 | 2115271.42403 | 37.7878752075455 | -122.459260513654 | (37.7878752075455, -122.459260513654) | 11 | 6 | 1 | 54 | 31 | |||
| 64978 | 11676 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991320.9947906 | 2093088.5989831 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | 9 | 8 | 4 | 64 | 40 | |||
| 65090 | 11694 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 65775 | 180589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6003010.99045 | 2094126.19284 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | 9 | 7 | 6 | 28861 | 25 | |||
| 66200 | 395 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 2 | 5990486.24663 | 2090696.51982 | 37.7201072830556 | -122.474943649084 | (37.7201072830556, -122.474943649084) | 9 | 8 | 4 | 64 | 40 | |||
| 66372 | 883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X6 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | |||
| 66722 | 215590 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 501 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 3ft | 5991474.9385 | 2093941.2931 | 37.7290738739428 | -122.471762454787 | (37.7290738739428, -122.471762454787) | 9 | 8 | 4 | 59 | 40 | |||
| 66794 | 1428 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5 | 5995465.63795 | 2115574.86439 | 37.78870421691 | -122.459532573841 | (37.78870421691, -122.459532573841) | 11 | 6 | 1 | 54 | 11 | |||
| 67605 | 11627 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 300X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | 9 | 8 | 4 | 64 | 40 | |||
| 68192 | 19105 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
| 68257 | 215598 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 48 | : | Tree | Private 2 | 13 | Width 0ft | 5991274.41833 | 2092469.99796 | 37.7250224604947 | -122.472348449422 | (37.7250224604947, -122.472348449422) | 9 | 8 | 4 | 64 | 40 | |||
| 68289 | 11690 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 799X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 30 | 3x3 | 5991356.324435 | 2092039.0089713 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | 9 | 8 | 4 | 59 | 40 | |||
| 68307 | 6271 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.7827782737541 | -122.429763959937 | (37.7827782737541, -122.429763959937) | 7 | 9 | 11 | 29490 | 41 | |||
| 68463 | 11849 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
| 68509 | 6281 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 68561 | 215635 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 78 | : | Tree | Private 2 | 3 | Width 0ft | 5991140.25702 | 2090584.02001 | 37.7198362663069 | -122.47267478013 | (37.7198362663069, -122.47267478013) | 9 | 8 | 4 | 64 | 40 | |||
| 68771 | 6272 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6003992.00537 | 2113234.021 | 37.782763424573 | -122.429865551596 | (37.782763424573, -122.429865551596) | 7 | 9 | 11 | 29490 | 41 | |||
| 68937 | 19072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 204 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 5994955.69063 | 2087466.73543 | 37.7114970625193 | -122.459260632792 | (37.7114970625193, -122.459260632792) | 9 | 8 | 6 | 28861 | 24 | |||
| 69092 | 885 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1100X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003437 | 2094359 | 37.7309056628368 | -122.430438468366 | (37.7309056628368, -122.430438468366) | 9 | 7 | 5 | 28861 | 25 | ||||
| 69394 | 215626 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 68 | : | Tree | Private 2 | 3 | Width 0ft | 5991156.30566 | 2090612.66695 | 37.7199158527268 | -122.472621393671 | (37.7199158527268, -122.472621393671) | 9 | 8 | 4 | 64 | 40 | |||
| 69680 | 397 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990474.69146 | 2090771.67661 | 37.720312975301 | -122.474989074306 | (37.720312975301, -122.474989074306) | 9 | 8 | 4 | 64 | 40 | |||
| 69926 | 215610 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 50 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.77446 | 2090663.32778 | 37.7200544031655 | -122.472658031161 | (37.7200544031655, -122.472658031161) | 9 | 8 | 4 | 64 | 40 | |||
| 69972 | 180587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1473 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6002172.86661 | 2093413.14517 | 37.7282368704302 | -122.434741167586 | (37.7282368704302, -122.434741167586) | 9 | 7 | 6 | 28861 | 25 | |||
| 70264 | 7477 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | 2 | 4 | 7 | 28859 | 19 | |||
| 70794 | 242793 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2x Coso Ave | 1 | Median : Yard | Tree | DPW 1 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | 2 | 7 | 7 | 28859 | 2 | |||
| 71394 | 123487 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5995668.73883 | 2111844.87781 | 37.7784743481439 | -122.458559759476 | (37.7784743481439, -122.458559759476) | 11 | 6 | 2 | 54 | 16 | ||||
| 71766 | 391 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | 2 | 5990530.65648 | 2090591.3498 | 37.7198210858115 | -122.474782468587 | (37.7198210858115, -122.474782468587) | 9 | 8 | 4 | 64 | 40 | |||
| 71995 | 215621 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 63 | : | Tree | Private 2 | 3 | Width 0ft | 5991148.36748 | 2090618.2199 | 37.7199306402575 | -122.47264923759 | (37.7199306402575, -122.47264923759) | 9 | 8 | 4 | 64 | 40 | |||
| 73351 | 142972 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2010 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6009915.1882 | 2121025.8734 | 37.8044916046862 | -122.409923973004 | (37.8044916046862, -122.409923973004) | 3 | 1 | 10 | 308 | 23 | |||
| 73537 | 19097 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.461715823343 | (37.711481126537, -122.461715823343) | 9 | 8 | 6 | 28861 | 24 | |||
| 74287 | 137080 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.7976397759128 | -122.41375141819 | (37.7976397759128, -122.41375141819) | 5 | 1 | 10 | 308 | 21 | |||
| 74694 | 51907 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.425598379966 | (37.7428856098168, -122.425598379966) | 2 | 7 | 5 | 63 | 22 | |||
| 74728 | 215639 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 82 | : | Tree | Private 2 | 8 | Width 0ft | 5991150.62056 | 2090568.42161 | 37.7197940368438 | -122.472637820681 | (37.7197940368438, -122.472637820681) | 9 | 8 | 4 | 64 | 40 | |||
| 74945 | 16703 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 43 | 5x6 | 6001597.82921 | 2092328.38749 | 37.7252257090852 | -122.436651476894 | (37.7252257090852, -122.436651476894) | 9 | 7 | 6 | 28861 | 25 | |||
| 75188 | 1437 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.7880023578197 | -122.459478767425 | (37.7880023578197, -122.459478767425) | 11 | 6 | 1 | 54 | 11 | |||
| 75417 | 7464 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2599 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008286.46562 | 2103308.5385 | 37.7557526290701 | -122.414305992303 | (37.7557526290701, -122.414305992303) | 2 | 4 | 7 | 28859 | 19 | |||
| 75663 | 401 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2 | 5990481.9086 | 2090947.80374 | 37.7207969949539 | -122.474976977183 | (37.7207969949539, -122.474976977183) | 9 | 8 | 4 | 64 | 40 | |||
| 76484 | 7472 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2637 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 4X4 | 6008329.44308 | 2103061.47825 | 37.7550766717901 | -122.414139883786 | (37.7550766717901, -122.414139883786) | 2 | 4 | 7 | 28859 | 19 | |||
| 76530 | 10718 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
| 76840 | 117189 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.7939609578909 | -122.415375111785 | (37.7939609578909, -122.415375111785) | 5 | 1 | 10 | 28858 | 21 | |||
| 76992 | 6280 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.430193118546 | (37.7821822086902, -122.430193118546) | 7 | 9 | 11 | 29490 | 41 | |||
| 77624 | 29916 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 77661 | 7425 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008288.6679 | 2103807.30911 | 37.7571222633799 | -122.414333665067 | (37.7571222633799, -122.414333665067) | 2 | 4 | 7 | 28859 | 19 | |||
| 78845 | 215641 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 84 | : | Tree | Private 2 | 24 | Width 0ft | 5991139.80827 | 2090562.73433 | 37.719777795098 | -122.472674780143 | (37.719777795098, -122.472674780143) | 9 | 8 | 4 | 64 | 40 | |||
| 79311 | 215642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 85 | : | Tree | Private 2 | 3 | Width 0ft | 5991146.32719 | 2090562.00537 | 37.7197761709066 | -122.47265219364 | (37.7197761709066, -122.47265219364) | 9 | 8 | 4 | 64 | 40 | |||
| 80156 | 39243 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | 11 | 6 | 1 | 54 | 31 | |||
| 80212 | 26772 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 80496 | 215623 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 65 | : | Tree | Private 2 | 7 | Width 0ft | 5991145.2526 | 2090614.88415 | 37.7199213008035 | -122.472659761464 | (37.7199213008035, -122.472659761464) | 9 | 8 | 4 | 64 | 40 | |||
| 80969 | 11747 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 30 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.94649 | 2092660.64259 | 37.7255466483325 | -122.4723190326 | (37.7255466483325, -122.4723190326) | 9 | 8 | 4 | 64 | 40 | ||
| 81017 | 117256 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
| 82136 | 215651 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2105 09th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 3ft | 5993642.48221 | 2101265.67926 | 37.7493099806718 | -122.464800828005 | (37.7493099806718, -122.464800828005) | 1 | 8 | 4 | 29491 | 40 | |||
| 82986 | 215646 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 89 | : | Tree | Private 2 | 21 | Width 0ft | 5991144.95252 | 2090553.16119 | 37.7197518073936 | -122.47265630085 | (37.7197518073936, -122.47265630085) | 9 | 8 | 4 | 64 | 40 | |||
| 83226 | 182457 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1500 31st Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 0ft | 5986548.9803 | 2104732.6813 | 37.7584178970063 | -122.489584885211 | (37.7584178970063, -122.489584885211) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );