trees
430 rows where qSpecies_id = 99 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86222 | 7473 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 1 | 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 | |||
| 89777 | 1533 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 2 | 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 | |||
| 90221 | 1429 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 5 | 5995465.54596 | 2115556.47361 | 37.7886537155162 | -122.45953155962 | (37.7886537155162, -122.45953155962) | 11 | 6 | 1 | 54 | 11 | |||
| 91731 | 940 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1331 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6002472.82123 | 2093812.78737 | 37.7293512221746 | -122.433732764948 | (37.7293512221746, -122.433732764948) | 9 | 7 | 6 | 28861 | 25 | |||
| 92916 | 1258 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3815 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5992861.70969 | 2087523.33873 | 37.7115318707666 | -122.466502029665 | (37.7115318707666, -122.466502029665) | 9 | 8 | 4 | 64 | 24 | |||
| 93403 | 1620 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.7760378719372 | -122.458604095826 | (37.7760378719372, -122.458604095826) | 11 | 6 | 2 | 54 | 11 | |||
| 93616 | 19090 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X4 | 5994507.8215972 | 2087458.0224559 | 37.7114473793836 | -122.460807943318 | (37.7114473793836, -122.460807943318) | 9 | 8 | 6 | 28861 | 24 | |||
| 94192 | 10715 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 2 | 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 | |||
| 96176 | 10720 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 7 | 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 | |||
| 96850 | 87591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3840 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 5990782.62319 | 2090250.31161 | 37.7188992769151 | -122.473886649335 | (37.7188992769151, -122.473886649335) | 9 | 8 | 4 | 64 | 40 | ||||
| 98027 | 19106 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
| 98146 | 915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003037.51053 | 2094134.66319 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | 9 | 7 | 6 | 28861 | 25 | |||
| 98627 | 6282 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 5 | 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 | |||
| 98869 | 1470 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5995496.39039 | 2114788.79173 | 37.7865476418723 | -122.45936922598 | (37.7865476418723, -122.45936922598) | 11 | 6 | 1 | 54 | 11 | |||
| 100808 | 1541 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | 11 | 6 | 1 | 54 | 31 | |||
| 104079 | 10714 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 1 | 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 | |||
| 107344 | 6284 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 7 | 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 | |||
| 107664 | 1035 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | 9 | 7 | 6 | 28861 | 25 | |||
| 114049 | 1642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.458277318373 | (37.7744643941763, -122.458277318373) | 11 | 6 | 2 | 54 | 16 | |||
| 118533 | 6276 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
| 120650 | 11619 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 121303 | 4850 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x6 | 6002180 | 2093376 | 37.7281352832027 | -122.43471385212 | (37.7281352832027, -122.43471385212) | 9 | 7 | 6 | 28861 | 25 | |||
| 127111 | 256855 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1777 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6001446 | 2091921 | 37.7240984859228 | -122.437147179411 | (37.7240984859228, -122.437147179411) | 9 | 7 | 6 | 28861 | 25 | ||||
| 129130 | 7479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 7 | 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 | |||
| 129740 | 1468 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995558.6934 | 2114767.33782 | 37.7864923171366 | -122.459152120252 | (37.7864923171366, -122.459152120252) | 11 | 6 | 1 | 54 | 31 | |||
| 131369 | 6275 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1421X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003957.21776 | 2113179.66455 | 37.7826122052638 | -122.429982023346 | (37.7826122052638, -122.429982023346) | 7 | 9 | 11 | 29490 | 41 | |||
| 131642 | 1257 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 1X3 | 5992919.7951 | 2087516.70947 | 37.7115170200575 | -122.466300791391 | (37.7115170200575, -122.466300791391) | 9 | 8 | 4 | 64 | 24 | |||
| 132043 | 1514 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 55 | 4X6 | 5995592.131 | 2113860.45299 | 37.7840041772291 | -122.458970748307 | (37.7840041772291, -122.458970748307) | 11 | 6 | 1 | 54 | 31 | |||
| 132177 | 1423 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x5 | 5995562.14611 | 2115577.70158 | 37.7887175558035 | -122.459198877421 | (37.7887175558035, -122.459198877421) | 11 | 6 | 1 | 54 | 31 | |||
| 134673 | 7481 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 9 | 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 | |||
| 135020 | 979 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6001800.3284 | 2092768.49495 | 37.7264456502383 | -122.435982936161 | (37.7264456502383, -122.435982936161) | 9 | 7 | 6 | 28861 | 25 | |||
| 135722 | 10716 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 3 | 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 | |||
| 135925 | 1181 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | 9 | 7 | 6 | 28861 | 25 | |||
| 136153 | 400 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2 | 5990476.72602 | 2090904.23897 | 37.7206770765591 | -122.474991713144 | (37.7206770765591, -122.474991713144) | 9 | 8 | 4 | 64 | 40 | |||
| 136998 | 6416 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 400X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 6x5 | 5995602.32868 | 2113744.52068 | 37.7836864443545 | -122.458927071616 | (37.7836864443545, -122.458927071616) | 11 | 6 | 1 | 54 | 31 | |||
| 137453 | 6274 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1420X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003886.01337 | 2113219.41254 | 37.7827173105424 | -122.430231196525 | (37.7827173105424, -122.430231196525) | 7 | 9 | 11 | 29490 | 41 | |||
| 138539 | 7474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 2 | 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 | |||
| 138849 | 1058 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2055X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000480.4143 | 2090166.82631 | 37.719226989106 | -122.440359308841 | (37.719226989106, -122.440359308841) | 9 | 7 | 6 | 28861 | 25 | |||
| 139750 | 394 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990492.73788 | 2090676.25296 | 37.7200520114659 | -122.474919732673 | (37.7200520114659, -122.474919732673) | 9 | 8 | 4 | 64 | 40 | |||
| 140418 | 393 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 23 | 2 | 5990507.18031 | 2090652.75966 | 37.7199883416446 | -122.474868096697 | (37.7199883416446, -122.474868096697) | 9 | 8 | 4 | 64 | 40 | |||
| 140491 | 1027 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1965X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 31 | 3X3 | 6000825.64245 | 2090608.45865 | 37.7204592623287 | -122.439197625247 | (37.7204592623287, -122.439197625247) | 9 | 7 | 6 | 28861 | 25 | ||
| 140798 | 19100 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 281 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5994272.63935 | 2087395.39368 | 37.7112618807995 | -122.46161625041 | (37.7112618807995, -122.46161625041) | 9 | 8 | 6 | 28861 | 24 | |||
| 141137 | 11752 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 35 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991283.50431 | 2092598.49549 | 37.7253758086322 | -122.472326403438 | (37.7253758086322, -122.472326403438) | 9 | 8 | 4 | 64 | 40 | ||
| 142118 | 124672 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | Width 4ft | 5995591.07711 | 2113866.14003 | 37.7840197317356 | -122.458974806266 | (37.7840197317356, -122.458974806266) | 11 | 6 | 1 | 54 | 31 | |||
| 142481 | 26486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 8 | 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 | |||
| 143170 | 1543 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995618.1476548 | 2113146.4510222 | 37.7820452142622 | -122.458829030078 | (37.7820452142622, -122.458829030078) | 11 | 6 | 1 | 54 | 31 | |||
| 144590 | 1250 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3743 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X6 | 5993011.32335 | 2087550.57925 | 37.7116152990749 | -122.465986907877 | (37.7116152990749, -122.465986907877) | 9 | 8 | 4 | 64 | 24 | |||
| 146234 | 1525 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 439 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5X7 | 5995548.96018 | 2113291.48375 | 37.7824394582911 | -122.459078890487 | (37.7824394582911, -122.459078890487) | 11 | 6 | 2 | 54 | 11 | |||
| 146878 | 16359 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | 3 | 1 | 10 | 308 | 23 | |||
| 147868 | 1060 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2059X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000457.16463 | 2090146.24433 | 37.7191691518296 | -122.440438198589 | (37.7191691518296, -122.440438198589) | 9 | 7 | 6 | 28861 | 25 | |||
| 148629 | 11741 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
| 149879 | 5927 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | ||
| 149997 | 1001 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | 9 | 7 | 6 | 28861 | 25 | |||
| 151976 | 11615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | 1 | 8 | 4 | 64 | 40 | |||
| 152021 | 1029 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1989X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X6 | 6000859.82003 | 2090688.3349 | 37.7206805292285 | -122.439085206354 | (37.7206805292285, -122.439085206354) | 9 | 7 | 6 | 28861 | 25 | |||
| 152604 | 19063 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 175 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995252.88797 | 2087382.67456 | 37.7112833332178 | -122.458227367525 | (37.7112833332178, -122.458227367525) | 9 | 8 | 6 | 28861 | 24 | |||
| 152803 | 1531 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 499 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 5995560.27463 | 2113085.81754 | 37.7818754042369 | -122.459024851411 | (37.7818754042369, -122.459024851411) | 11 | 6 | 2 | 54 | 11 | |||
| 155276 | 1551 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 530 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995634.85993 | 2112642.48366 | 37.7806624148094 | -122.458734717129 | (37.7806624148094, -122.458734717129) | 11 | 6 | 2 | 54 | 16 | |||
| 155781 | 1014 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1852X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6001135.54804 | 2091400.82126 | 37.7226525409555 | -122.438183116075 | (37.7226525409555, -122.438183116075) | 9 | 7 | 6 | 28861 | 25 | |||
| 157104 | 1434 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | 11 | 6 | 1 | 54 | 31 | |||
| 158218 | 227 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 2X3 | 5990630.67566 | 2095430.16477 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | 1 | 8 | 4 | 64 | 40 | |||
| 159593 | 107483 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1306x Montgomery St | 6 | Median : Cutout | Tree | DPW 1 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | 3 | 1 | 10 | 308 | 23 | ||||
| 159991 | 11737 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x2 | 5991216.9689233 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | 9 | 8 | 4 | 64 | 40 | |||
| 161940 | 1052 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2039X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000548.43841 | 2090229.36669 | 37.719402583767 | -122.44012865812 | (37.719402583767, -122.44012865812) | 9 | 7 | 6 | 28861 | 25 | |||
| 164973 | 1430 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 5 | 5995476.6114 | 2115563.93405 | 37.7886748361207 | -122.459493815623 | (37.7886748361207, -122.459493815623) | 11 | 6 | 1 | 54 | 11 | |||
| 164981 | 11712 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 165263 | 19071 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994967.06362 | 2087386.65714 | 37.7112778401642 | -122.459215529972 | (37.7112778401642, -122.459215529972) | 9 | 8 | 6 | 28861 | 24 | |||
| 165369 | 19093 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 257 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994426.29409 | 2087392.81881 | 37.7112636542582 | -122.461084998394 | (37.7112636542582, -122.461084998394) | 9 | 8 | 6 | 28861 | 24 | |||
| 165558 | 1066 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2075X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000333.40297 | 2090026.65578 | 37.7188337409507 | -122.440857420165 | (37.7188337409507, -122.440857420165) | 9 | 7 | 6 | 28861 | 25 | |||
| 166456 | 175374 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5991412.70367 | 2088734.17301 | 37.7147728061926 | -122.471598306927 | (37.7147728061926, -122.471598306927) | 9 | 8 | 6 | 64 | 24 | |||
| 167729 | 1056 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2049X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6000499.53685 | 2090188.32691 | 37.7192871136702 | -122.440294750677 | (37.7192871136702, -122.440294750677) | 9 | 7 | 6 | 28861 | 25 | |||
| 168411 | 1542 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995618.1476548 | 2113146.4510222 | 37.7820452142622 | -122.458829030078 | (37.7820452142622, -122.458829030078) | 11 | 6 | 1 | 54 | 31 | |||
| 168595 | 10717 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 4 | 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 | |||
| 169822 | 1581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 629 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5995601.12395 | 2111917.66113 | 37.7786703056802 | -122.458798934123 | (37.7786703056802, -122.458798934123) | 11 | 6 | 2 | 54 | 11 | |||
| 170220 | 1597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 714 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995688.036 | 2111228.67679 | 37.7767835321697 | -122.458448388127 | (37.7767835321697, -122.458448388127) | 11 | 6 | 2 | 54 | 16 | |||
| 170778 | 1526 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 440 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 5995608.48873 | 2113422.41383 | 37.7828023792183 | -122.458882431606 | (37.7828023792183, -122.458882431606) | 11 | 6 | 1 | 54 | 31 | |||
| 173034 | 1248 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5993002.94201 | 2087547.889 | 37.7116074287673 | -122.466015680425 | (37.7116074287673, -122.466015680425) | 9 | 8 | 4 | 64 | 24 | |||
| 178234 | 1510 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 369 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3x3 | 5995536.86997 | 2113765.1567 | 37.7837393424086 | -122.459155027191 | (37.7837393424086, -122.459155027191) | 11 | 6 | 2 | 54 | 11 | |||
| 178273 | 175047 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5991389.20246 | 2088805.53688 | 37.7149673943122 | -122.47168473357 | (37.7149673943122, -122.47168473357) | 9 | 8 | 6 | 64 | 24 | |||
| 182532 | 26779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | 9 | 8 | 4 | 64 | 40 | |||
| 182658 | 19065 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 179 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5995218.7218404 | 2087397.9242615 | 37.7113232420063 | -122.458346556584 | (37.7113232420063, -122.458346556584) | 9 | 8 | 6 | 28861 | 24 | |||
| 183223 | 19107 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5995592.56281 | 2086919.93217 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | 9 | 8 | 6 | 28861 | 25 | |||
| 183540 | 29914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 3 | 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 | ||||
| 183694 | 2933 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1834 California St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | 13 | 9 | 1 | 28858 | 27 | ||
| 184825 | 22541 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1396X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3X3 | 6002380.38751 | 2093819.80205 | 37.7293652374447 | -122.434052817677 | (37.7293652374447, -122.434052817677) | 9 | 7 | 6 | 28861 | 25 | |||
| 185164 | 1474 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 234 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x5 | 5995562.8915 | 2114652.71711 | 37.7861778408698 | -122.459129293157 | (37.7861778408698, -122.459129293157) | 11 | 6 | 1 | 54 | 31 | |||
| 186626 | 917 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1245 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003003.64796 | 2094102.53816 | 37.7301769190865 | -122.431918330789 | (37.7301769190865, -122.431918330789) | 9 | 7 | 6 | 28861 | 25 | |||
| 188047 | 1025 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1948 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6000854.43502 | 2090852.74185 | 37.7211316470959 | -122.439115597724 | (37.7211316470959, -122.439115597724) | 9 | 7 | 6 | 28861 | 25 | |||
| 190088 | 1432 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 5 | 5995472.27833 | 2115471.9588 | 37.7884220478225 | -122.45950214341 | (37.7884220478225, -122.45950214341) | 11 | 6 | 1 | 54 | 11 | |||
| 191151 | 900 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1167 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003509.89866 | 2094295.64409 | 37.7307358309933 | -122.43018192766 | (37.7307358309933, -122.43018192766) | 9 | 7 | 6 | 28861 | 25 | |||
| 192958 | 6278 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1475 Ellis St | 1 | 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 | |||
| 1332 | 215594 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5994385 | 2087488 | 37.7115226229707 | -122.461234615187 | (37.7115226229707, -122.461234615187) | 9 | 8 | 6 | 28861 | 24 | |||
| 1712 | 105883 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | 11 | 6 | 1 | 54 | 31 | ||||
| 1798 | 242795 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1671 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009731.24755 | 2099988.43526 | 37.7467174150944 | -122.409075193563 | (37.7467174150944, -122.409075193563) | 2 | 7 | 7 | 28859 | 2 | |||
| 4371 | 45657 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006599 | 2119096 | 37.7990062508654 | -122.421262834262 | (37.7990062508654, -122.421262834262) | 13 | 9 | 1 | 28858 | 32 | ||
| 5037 | 215607 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 47 | : | Tree | Private 2 | 2 | Width 0ft | 5991157.54734 | 2090681.21679 | 37.7201041455671 | -122.472622096933 | (37.7201041455671, -122.472622096933) | 9 | 8 | 4 | 64 | 40 | |||
| 5701 | 215593 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5995757.42889 | 2087376.90008 | 37.7112964570463 | -122.456483140498 | (37.7112964570463, -122.456483140498) | 9 | 8 | 6 | 28861 | 24 | |||
| 5897 | 199851 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | 10 | 3 | 8 | 58 | 1 | |||
| 5950 | 185691 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984865.9917 | 2100533.4848 | 37.746789659782 | -122.49509567655 | (37.746789659782, -122.49509567655) | 1 | 8 | 3 | 29491 | 35 | |||
| 8385 | 83273 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6008750.42598 | 2118601.99703 | 37.7977708970553 | -122.413783193943 | (37.7977708970553, -122.413783193943) | 5 | 1 | 10 | 308 | 21 |
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) );