trees
430 rows where qSpecies_id = 99 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | |||
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 | |||||
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 | ||||
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 | |||
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 | |||
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 | |||||
91388 | 105784 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||
101438 | 108311 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 439x ARLINGTON ST | 1 | Back Yard : Yard | Tree | Private 2 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329169 | (37.7354814316621, -122.42878329169) | 2 | 7 | 5 | 63 | 7 | |||||
113992 | 51906 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 157 Day St | 1 | 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 | |||
123890 | 253385 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1100 Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004275 | 2112509 | 37.7807887188922 | -122.428834805692 | (37.7807887188922, -122.428834805692) | 7 | 9 | 11 | 29490 | 41 | |||||
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 | ||||
132451 | 99911 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005460.7 | 2101331.3 | 37.7501644526018 | -122.423937810125 | (37.7501644526018, -122.423937810125) | 2 | 4 | 5 | 28859 | 19 | ||||
134973 | 104704 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 3590X Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2014 12:00:00 AM | 3x3 | Permit Number 771748 | 5997841.875 | 2115466.23587 | 37.7885422986565 | -122.451303342479 | (37.7885422986565, -122.451303342479) | 11 | 6 | 1 | 54 | 31 | ||
156611 | 253429 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2198 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x7 | 5992046 | 2112030 | 37.7787737730441 | -122.471105555235 | (37.7787737730441, -122.471105555235) | 11 | 6 | 2 | 54 | 11 | ||||
160951 | 93024 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 3 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
190541 | 93023 | Permitted Site 7 | Ulmus pumila :: Siberian Elm 99 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 2 on 25th St | 6005476 | 2101410 | 37.7503814084322 | -122.423890497296 | (37.7503814084322, -122.423890497296) | 2 | 4 | 5 | 28859 | 19 | ||||
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 | |||
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 | |||
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 | |||
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 | |
123028 | 215619 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 61 | : | Tree | Private 2 | 10 | Width 0ft | 5991156.50194 | 2090623.66821 | 37.7199460708374 | -122.472621516875 | (37.7199460708374, -122.472621516875) | 9 | 8 | 4 | 64 | 40 | |||
159736 | 124642 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
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 | |||
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 | |||
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 | |||
94324 | 1471 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | 11 | 6 | 1 | 54 | 11 | |||
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 | |||
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 | |||
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 | |||
101449 | 185963 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2001 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984881.7314 | 2101336.1941 | 37.7489946017929 | -122.495100432866 | (37.7489946017929, -122.495100432866) | 1 | 8 | 3 | 29491 | 35 | |||
122634 | 215606 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 40 | : | Tree | Private 2 | 11 | Width 0ft | 5991163.46661 | 2090729.52448 | 37.7202371292081 | -122.472605156414 | (37.7202371292081, -122.472605156414) | 9 | 8 | 4 | 64 | 40 | |||
147602 | 939 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | 9 | 7 | 6 | 28861 | 25 | |||
152689 | 215628 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 71 | : | Tree | Private 2 | 11 | Width 0ft | 5991139.39343 | 2090599.41814 | 37.7198784957874 | -122.472678887333 | (37.7198784957874, -122.472678887333) | 9 | 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 | |||
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 | |||
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 | |
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
84065 | 19069 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.459133844577 | (37.711496124512, -122.459133844577) | 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 | |||
95397 | 123958 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.465590312648 | (37.7830615134244, -122.465590312648) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
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 | |||
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 | |||
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 | |||
121575 | 215579 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 851 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991331.01602 | 2091664.09591 | 37.7228129287478 | -122.472094084291 | (37.7228129287478, -122.472094084291) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
139373 | 215588 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 551 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991446.82162 | 2093469.8712 | 37.7277778402634 | -122.471825312909 | (37.7277778402634, -122.471825312909) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | ||
150849 | 215589 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 551 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5991458.35334 | 2093660.05844 | 37.7283007142025 | -122.47179930269 | (37.7283007142025, -122.47179930269) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
172121 | 97504 | Undocumented 4 | Ulmus pumila :: Siberian Elm 99 | 20X 10th St | 1 | 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 | |
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
89577 | 215596 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 500 Junipero Serra Blvd | 52 | : | Tree | Private 2 | 13 | Width 0ft | 5991321.6635 | 2093392.10663 | 37.7275570755768 | -122.472252316385 | (37.7275570755768, -122.472252316385) | 9 | 8 | 4 | 64 | 40 | |||
144774 | 215600 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 67 | : | Tree | Private 2 | 13 | Width 0ft | 5991265.70114 | 2092317.65324 | 37.7246036552159 | -122.472367482699 | (37.7246036552159, -122.472367482699) | 9 | 8 | 4 | 64 | 40 | |||
146390 | 215627 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 69 | : | Tree | Private 2 | 13 | Width 0ft | 5991161.91923 | 2090597.16869 | 37.7198736232612 | -122.472600860338 | (37.7198736232612, -122.472600860338) | 9 | 8 | 4 | 64 | 40 | |||
176937 | 137070 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 7 Laurel St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997942.37701 | 2116329.50618 | 37.7909183634316 | -122.451017898383 | (37.7909183634316, -122.451017898383) | 11 | 6 | 1 | 54 | 31 | |||
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 | |||
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 | |||
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 | |||
86503 | 215650 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 101 | : | Tree | Private 2 | 14 | Width 0ft | 5991145.97307 | 2090449.2056 | 37.7194664300225 | -122.472645197812 | (37.7194664300225, -122.472645197812) | 9 | 8 | 4 | 64 | 40 | |||
106085 | 185690 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 2101 Sunset Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984904.8934 | 2100540.6767 | 37.7468116841536 | -122.494961690438 | (37.7468116841536, -122.494961690438) | 1 | 8 | 3 | 29491 | 35 | |||
129053 | 215615 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 900 Junipero Serra Blvd | 57 | : | Tree | Private 2 | 14 | Width 0ft | 5991138.24471 | 2090632.0819 | 37.719968115927 | -122.472685238326 | (37.719968115927, -122.472685238326) | 9 | 8 | 4 | 64 | 40 | |||
136804 | 106867 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1974 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6003576.11959 | 2118663.726 | 37.7976484534674 | -122.431692125901 | (37.7976484534674, -122.431692125901) | 13 | 9 | 1 | 57 | 17 | |||
152584 | 215599 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 700 Junipero Serra Blvd | 52 | : | Tree | Private 2 | 14 | Width 0ft | 5991273.40065 | 2092440.71249 | 37.7249419909714 | -122.47234983349 | (37.7249419909714, -122.47234983349) | 9 | 8 | 4 | 64 | 40 | |||
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 | ||||
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 |
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) );