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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
384 | 415 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 2X6 | 5990878.96388 | 2090116.60552 | 37.7185377326944 | -122.473543893183 | (37.7185377326944, -122.473543893183) | 9 | 8 | 4 | 64 | 40 | |||
825 | 175382 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 2 | Width 3ft | 5991305.51807 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | 9 | 8 | 6 | 64 | 24 | |||
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 | |||
2820 | 899 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418 | (37.7307693064514, -122.43007470418) | 9 | 7 | 6 | 28861 | 25 | |||
3714 | 19086 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994700.7848896 | 2087405.1340273 | 37.7113132610353 | -122.460137187577 | (37.7113132610353, -122.460137187577) | 9 | 8 | 6 | 28861 | 24 | |||
3741 | 228 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2974 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/1992 12:00:00 AM | 70 | 3X4 | 5990613.87863 | 2095369.93557 | 37.7329467072262 | -122.474843412516 | (37.7329467072262, -122.474843412516) | 1 | 8 | 4 | 64 | 40 | ||
3881 | 11625 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 300X Junipero Serra Blvd | 2 | 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 | |||
4126 | 115471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | ||||||||||||||
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 | |||
5204 | 7475 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 3 | 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 | |||
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 | |||
6012 | 16704 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1677X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | 5x6 | 6001608.07304 | 2092347.28192 | 37.7252781710498 | -122.43661741688 | (37.7252781710498, -122.43661741688) | 9 | 7 | 6 | 28861 | 25 | |||
6804 | 1081 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | 9 | 7 | 6 | 28861 | 25 | |||
6823 | 11708 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | 9 | 8 | 4 | 64 | 40 | ||
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 | |||
9603 | 215597 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 44 | : | Tree | Private 2 | 15 | Width 0ft | 5991275.01695 | 2092498.39745 | 37.7251004730822 | -122.472348449425 | (37.7251004730822, -122.472348449425) | 9 | 8 | 4 | 64 | 40 | |||
9727 | 25337 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2000 12:00:00 AM | 15 | 3X3 | 5994336.66394 | 2087473.55865 | 37.7114801885417 | -122.461400629858 | (37.7114801885417, -122.461400629858) | 9 | 8 | 6 | 28861 | 24 | ||
9808 | 262587 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 5994963 | 2087365 | 37.7112181411096 | -122.459228007495 | (37.7112181411096, -122.459228007495) | 9 | 8 | 6 | 28861 | 24 | ||||
10113 | 11713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 3 | 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 | |||
10682 | 978 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001786.79947 | 2092741.59351 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | 9 | 7 | 6 | 28861 | 25 | |||
11055 | 212275 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5991369.83991 | 2092286.4262 | 37.7245239402122 | -122.47200521689 | (37.7245239402122, -122.47200521689) | 9 | 8 | 4 | 59 | 40 | |||
11607 | 11613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 6 | 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 | |||
12102 | 180591 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.7228723703333 | -122.438023911598 | (37.7228723703333, -122.438023911598) | 9 | 7 | 6 | 28861 | 25 | |||
12178 | 1048 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | 9 | 7 | 6 | 28861 | 25 | ||||
12392 | 97505 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672 | 2110712 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | 8 | 2 | 9 | 28853 | 34 | |
12848 | 11711 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 800X Junipero Serra Blvd | 1 | 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 | |||
14050 | 180592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1830 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 4ft | 6001143.73267 | 2091406.40414 | 37.72266833577 | -122.438155223402 | (37.72266833577, -122.438155223402) | 9 | 7 | 6 | 28861 | 25 | |||
14370 | 185713 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984850.6272 | 2100403.3767 | 37.7464315188861 | -122.495139211963 | (37.7464315188861, -122.495139211963) | 1 | 8 | 3 | 29491 | 35 | |||
15030 | 215614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 55 | : | Tree | Private 2 | 5 | Width 0ft | 5991140.92054 | 2090646.29638 | 37.7200073002795 | -122.472677024844 | (37.7200073002795, -122.472677024844) | 9 | 8 | 4 | 64 | 40 | |||
15479 | 896 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 4X4 | 6003365.90456 | 2094243.14139 | 37.7305835136383 | -122.43067599245 | (37.7305835136383, -122.43067599245) | 9 | 7 | 6 | 28861 | 25 | |||
15951 | 39175 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | 2 | 4 | 7 | 28859 | 19 | |
16067 | 19787 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 50ST | |||||||||||||
16487 | 19779 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 50ST | |||||||||||||
18105 | 99912 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | ||||
18185 | 11652 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 699X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 18 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
18478 | 215618 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 60 | : | Tree | Private 2 | 8 | Width 0ft | 5991156.49559 | 2090631.32735 | 37.7199671005808 | -122.472622096952 | (37.7199671005808, -122.472622096952) | 9 | 8 | 4 | 64 | 40 | |||
18681 | 215586 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991393.38259 | 2092629.96723 | 37.725468580903 | -122.471948860848 | (37.725468580903, -122.471948860848) | 9 | 8 | 4 | 59 | 40 | |||
19727 | 1431 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 75X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5 | 5995471.94905 | 2115498.24125 | 37.7884941933869 | -122.459505186902 | (37.7884941933869, -122.459505186902) | 11 | 6 | 1 | 54 | 11 | |||
20560 | 82168 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | 11 | 6 | 1 | 54 | 31 | |||||
21007 | 215640 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 83 | : | Tree | Private 2 | 5 | Width 0ft | 5991139.98278 | 2090571.01197 | 37.7198005335596 | -122.472674780143 | (37.7198005335596, -122.472674780143) | 9 | 8 | 4 | 64 | 40 | |||
21352 | 106884 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 6 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
21545 | 392 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 2 | 5990516.36157 | 2090620.36486 | 37.7198999256056 | -122.474833997279 | (37.7198999256056, -122.474833997279) | 9 | 8 | 4 | 64 | 40 | |||
21569 | 215609 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 49 | : | Tree | Private 2 | 6 | Width 0ft | 5991151.21969 | 2090669.88886 | 37.7200726755881 | -122.472643143781 | (37.7200726755881, -122.472643143781) | 9 | 8 | 4 | 64 | 40 | |||
21872 | 7486 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 2679X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6008312.8272 | 2102836.8814 | 37.754459046451 | -122.414181457232 | (37.754459046451, -122.414181457232) | 2 | 4 | 7 | 28859 | 19 | |||
22161 | 7482 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2650X Folsom St | 10 | 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 | |||
22196 | 185716 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984901.6243 | 2100400.4346 | 37.7464264261744 | -122.494962655496 | (37.7464264261744, -122.494962655496) | 1 | 8 | 3 | 29491 | 35 | |||
22805 | 914 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1233 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X5 | 6003058.45033 | 2094142.01954 | 37.7302884326438 | -122.431731689776 | (37.7302884326438, -122.431731689776) | 9 | 7 | 6 | 28861 | 25 | |||
22831 | 11871 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3 | 5991566.5284818 | 2087248.8358641 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | 9 | 8 | 4 | 64 | 24 | |||
23482 | 19082 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994691.47902 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | 9 | 8 | 6 | 28861 | 24 | |||
23519 | 180581 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6002394.23037 | 2093854.80651 | 37.7294621373592 | -122.434007462878 | (37.7294621373592, -122.434007462878) | 9 | 7 | 5 | 28861 | 25 | |||
25798 | 215644 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 87 | : | Tree | Private 2 | 4 | Width 0ft | 5991153.98366 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | 9 | 8 | 4 | 64 | 40 | |||
26096 | 123479 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5995657.67406 | 2112077.16899 | 37.7791115222078 | -122.458614856747 | (37.7791115222078, -122.458614856747) | 11 | 6 | 2 | 54 | 16 | ||||
26371 | 215624 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 66 | : | Tree | Private 2 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.472680940482 | (37.7199191010706, -122.472680940482) | 9 | 8 | 4 | 64 | 40 | |||
26511 | 11792 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2 | 5991118.2706518 | 2089586.5464947 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | 1 | 8 | 4 | 64 | 14 | |||
26642 | 1061 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6000441.22371 | 2090128.46046 | 37.7191194136535 | -122.440492025318 | (37.7191194136535, -122.440492025318) | 9 | 7 | 6 | 28861 | 25 | |||
27130 | 137079 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008755.55812 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | 5 | 1 | 10 | 308 | 21 | |||
27401 | 912 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1229 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003089.95028 | 2094152.43682 | 37.7303188216593 | -122.431623533692 | (37.7303188216593, -122.431623533692) | 9 | 7 | 6 | 28861 | 25 | |||
27899 | 1421 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x12 | 5995527.21204 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | 11 | 6 | 1 | 54 | 31 | |||
28708 | 1010 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1840X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6001180.26428 | 2091487.57144 | 37.7228932804007 | -122.438034753125 | (37.7228932804007, -122.438034753125) | 9 | 7 | 6 | 28861 | 25 | |||
29564 | 215637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 80 | : | Tree | Private 2 | 4 | Width 0ft | 5991151.99496 | 2090577.2658 | 37.7198184003677 | -122.472633714397 | (37.7198184003677, -122.472633714397) | 9 | 8 | 4 | 64 | 40 | |||
30014 | 199844 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1601 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.393307337928 | (37.7267462633936, -122.393307337928) | 10 | 3 | 8 | 58 | 1 | |||
30210 | 29915 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 810 Junipero Serra Blvd | 4 | 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 | ||||
30217 | 1529 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 451 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X4 | 5995566.01052 | 2113204.19125 | 37.7822007565611 | -122.45901358165 | (37.7822007565611, -122.45901358165) | 11 | 6 | 2 | 54 | 11 | |||
30682 | 970 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1599 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 38 | 4X4 | 6001869.51123 | 2092911.87236 | 37.7268432620915 | -122.435754028151 | (37.7268432620915, -122.435754028151) | 9 | 7 | 6 | 28861 | 25 | |||
31061 | 215630 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 73 | : | Tree | Private 2 | 9 | Width 0ft | 5991138.04395 | 2090591.75646 | 37.7198573805858 | -122.47268299364 | (37.7198573805858, -122.47268299364) | 9 | 8 | 4 | 64 | 40 | |||
31067 | 123486 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | 5995665.69022 | 2111872.76649 | 37.7785507478592 | -122.458572325088 | (37.7785507478592, -122.458572325088) | 11 | 6 | 2 | 54 | 16 | ||||
31355 | 99913 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 3751X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768933 | 6005509.05056 | 2101091.11643 | 37.7495076933522 | -122.42375353502 | (37.7495076933522, -122.42375353502) | 2 | 4 | 5 | 28859 | 19 | |||
32172 | 215592 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 177 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995226.8577 | 2087383.90223 | 37.7112852083174 | -122.458317422904 | (37.7112852083174, -122.458317422904) | 9 | 8 | 6 | 28861 | 24 | |||
32835 | 1054 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | 9 | 7 | 6 | 28861 | 25 | |||
32871 | 26823 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5994408.88806 | 2087459.5005113 | 37.7114457448338 | -122.461149987895 | (37.7114457448338, -122.461149987895) | 9 | 8 | 6 | 28861 | 24 | |||
32925 | 10723 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.7831447510095 | -122.430058726681 | (37.7831447510095, -122.430058726681) | 7 | 9 | 11 | 29490 | 41 | |||
33148 | 106883 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 180X SAN MARCOS AVE | 4 | Median : Cutout | Tree | Private 2 | DPW | 4 | 5993452.8 | 2100406.9 | 37.7469410536635 | -122.465394372338 | (37.7469410536635, -122.465394372338) | 1 | 8 | 4 | 29491 | 40 | |||
33545 | 215612 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 53 | : | Tree | Private 2 | 1 | Width 0ft | 5991154.50456 | 2090649.59615 | 37.720017146953 | -122.472630310457 | (37.720017146953, -122.472630310457) | 9 | 8 | 4 | 64 | 40 | |||
33957 | 185719 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984913.7198 | 2100361.206 | 37.7463194231796 | -122.494917939299 | (37.7463194231796, -122.494917939299) | 1 | 8 | 3 | 29491 | 35 | |||
34810 | 137072 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3598 Clay St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 5997679.8137 | 2115460.24424 | 37.7885165665196 | -122.451863614513 | (37.7885165665196, -122.451863614513) | 11 | 6 | 1 | 54 | 31 | |||
35213 | 1085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999963.70084 | 2089791.48987 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | 9 | 7 | 6 | 28861 | 25 | |||
35862 | 1540 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 470X Arguello Blvd | 9 | 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 | |||
35965 | 19053 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.7112861454175 | -122.457367103015 | (37.7112861454175, -122.457367103015) | 9 | 8 | 6 | 28861 | 24 | |||
36233 | 398 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 3790X 19th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 2 | 5990471.16794 | 2090846.61881 | 37.7205185437854 | -122.475006721555 | (37.7205185437854, -122.475006721555) | 9 | 8 | 4 | 64 | 40 | |||
36993 | 11614 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 8 | 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 | |||
37019 | 215613 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 54 | : | Tree | Private 2 | 6 | Width 0ft | 5991146.23554 | 2090648.32868 | 37.7200131881383 | -122.472658800987 | (37.7200131881383, -122.472658800987) | 9 | 8 | 4 | 64 | 40 | |||
37400 | 10722 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 9 | 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 | |||
38604 | 215638 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 81 | : | Tree | Private 2 | 17 | Width 0ft | 5991161.28352 | 2090567.01377 | 37.7197907884826 | -122.472600860358 | (37.7197907884826, -122.472600860358) | 9 | 8 | 4 | 64 | 40 | |||
38637 | 215605 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 39 | : | Tree | Private 2 | 6 | Width 0ft | 5991158.3667 | 2090738.6198 | 37.7202618075092 | -122.472623447724 | (37.7202618075092, -122.472623447724) | 9 | 8 | 4 | 64 | 40 | |||
38772 | 58907 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.399409385456 | (37.7108941228427, -122.399409385456) | 10 | 3 | 8 | 309 | 1 | ||
41289 | 124637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.7879838891542 | -122.459265995172 | (37.7879838891542, -122.459265995172) | 11 | 6 | 1 | 54 | 31 | ||||
41457 | 10719 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50X Hollis St | 6 | 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 | |||
42318 | 215622 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 64 | : | Tree | Private 2 | 3 | Width 0ft | 5991146.64961 | 2090624.80021 | 37.7199486087273 | -122.472655655135 | (37.7199486087273, -122.472655655135) | 9 | 8 | 4 | 64 | 40 | |||
42710 | 175378 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5991360.88178 | 2088922.01369 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) | 9 | 8 | 6 | 64 | 24 | |||
43102 | 137067 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997931.48984 | 2116393.73013 | 37.791094081978 | -122.45106020067 | (37.791094081978, -122.45106020067) | 11 | 6 | 1 | 54 | 31 | |||
43276 | 215577 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | Width 3ft | 5994760.78175 | 2105295.21675 | 37.7604384740771 | -122.461225807922 | (37.7604384740771, -122.461225807922) | 15 | 5 | 4 | 56 | 12 | |||
44462 | 215584 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 751 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5991387.10122 | 2092540.18841 | 37.7252217070935 | -122.471964034223 | (37.7252217070935, -122.471964034223) | 9 | 8 | 4 | 59 | 40 | |||
44810 | 123491 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5995674.45752 | 2111730.9534 | 37.7781618705542 | -122.458531727532 | (37.7781618705542, -122.458531727532) | 11 | 6 | 2 | 54 | 16 | ||||
45200 | 215576 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 95 Kirkham St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | Width 3ft | 5994736.06961 | 2105294.2713 | 37.7604344559039 | -122.461311206651 | (37.7604344559039, -122.461311206651) | 15 | 5 | 4 | 56 | 12 | |||
45289 | 19085 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5994662.28634 | 2087388.84238 | 37.7112663135508 | -122.460269067765 | (37.7112663135508, -122.460269067765) | 9 | 8 | 6 | 28861 | 24 |
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) );