trees
334 rows where qSpecies_id = 59 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88473 | 85294 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2255 Mariposa St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752 | 2105977 | 37.7632178155038 | -122.405967315915 | (37.7632178155038, -122.405967315915) | 8 | 4 | 8 | 28859 | 19 | |||
| 248 | 119766 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 3136 | 234897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6009692.09622 | 2096449.43711 | 37.7369979030329 | -122.408960917621 | (37.7369979030329, -122.408960917621) | 10 | 7 | 7 | 28859 | 2 | ||||
| 11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
| 13002 | 260949 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
| 16015 | 220524 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.7702967937804 | -122.431683217203 | (37.7702967937804, -122.431683217203) | 15 | 9 | 11 | 29492 | 10 | |
| 17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
| 18074 | 19903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY34 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | |||||||||||||
| 35297 | 248111 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 1 | Side Yard : Yard | Tree | Private 2 | 24 | 6010383.71107 | 2099443.85944 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | 2 | 7 | 7 | 28859 | 2 | ||||
| 42959 | 117474 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
| 47415 | 125722 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 43 | Width 4ft | 6003540.89789 | 2117978.17849 | 37.7957641201722 | -122.431765029446 | (37.7957641201722, -122.431765029446) | 13 | 9 | 1 | 57 | 17 | |||
| 55125 | 98312 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | 9 | 7 | 4 | 59 | 40 | |||||
| 58975 | 119683 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 61218 | 201995 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013319.20907 | 2092521.70031 | 37.7264156560521 | -122.396145090149 | (37.7264156560521, -122.396145090149) | 10 | 3 | 8 | 58 | 1 | ||||
| 62379 | 195992 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018320.61791 | 2099573.80473 | 37.7460563567193 | -122.379344895446 | (37.7460563567193, -122.379344895446) | 10 | 3 | 8 | 58 | 1 | ||||
| 63685 | 135663 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996346.46825 | 2114626.15487 | 37.7861499232377 | -122.456416418905 | (37.7861499232377, -122.456416418905) | 11 | 6 | 1 | 54 | 31 | |||
| 77949 | 248121 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6010387.39582 | 2099398.52057 | 37.7451343735684 | -122.406764720109 | (37.7451343735684, -122.406764720109) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80814 | 248172 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 218 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6007302.01446 | 2098729.32454 | 37.7431237943252 | -122.417386043537 | (37.7431237943252, -122.417386043537) | 2 | 7 | 7 | 28859 | 2 | ||||
| 91426 | 196034 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 6017038.23562 | 2096967.92235 | 37.7388303283508 | -122.38359786136 | (37.7388303283508, -122.38359786136) | 10 | 3 | 8 | 58 | 1 | |||
| 95955 | 117473 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
| 96656 | 248613 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | 15 | 5 | 11 | 29492 | 9 | |||
| 110194 | 234887 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010600.22161 | 2100713.10517 | 37.7487558418292 | -122.406121399085 | (37.7487558418292, -122.406121399085) | 2 | 7 | 7 | 28859 | 2 | ||||
| 111973 | 247225 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002109.57301 | 2108309.81574 | 37.7691360073432 | -122.4360254903 | (37.7691360073432, -122.4360254903) | 15 | 5 | 5 | 29492 | 9 | ||||
| 118842 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | |||
| 129436 | 6094 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
| 142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
| 148446 | 53540 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.44022 | 2113376.70713 | 37.7826221103339 | -122.462172779062 | (37.7826221103339, -122.462172779062) | 11 | 6 | 2 | 54 | 11 | ||
| 148940 | 244260 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.2528 | 2110021.9252 | 37.7740355269714 | -122.424024758994 | (37.7740355269714, -122.424024758994) | 7 | 9 | 11 | 28852 | 10 | |||
| 151245 | 255455 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 31x Garlington Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6016454 | 2094669 | 37.7324856396877 | -122.385457730704 | (37.7324856396877, -122.385457730704) | 10 | 3 | 8 | 58 | 1 | ||||
| 152832 | 140079 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000729.2298 | 2112451.4153 | 37.7804292797496 | -122.441097181955 | (37.7804292797496, -122.441097181955) | 15 | 5 | 1 | 29490 | 41 | |||
| 155569 | 109374 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 1 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
| 160546 | 119721 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 161562 | 195955 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.388457404684 | (37.7480218628289, -122.388457404684) | 10 | 3 | 8 | 58 | 1 | ||||
| 165442 | 234871 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010740.98958 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | 10 | 4 | 7 | 28859 | 19 | ||||
| 169477 | 255308 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Mendell St | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | 6017061 | 2098665 | 37.7434914187463 | -122.383637271506 | (37.7434914187463, -122.383637271506) | 10 | 3 | 8 | 58 | 1 | ||
| 175828 | 195997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | 14 | 3 | 9 | 310 | 20 | ||||
| 178785 | 246557 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 1 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005728.07536 | 2109359.17359 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | 7 | 9 | 11 | 28852 | 10 | |||
| 183244 | 195979 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 1 | Side Yard : Yard | Tree | Private 2 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.7395264548697 | -122.39168875964 | (37.7395264548697, -122.39168875964) | 10 | 3 | 8 | 58 | 1 | |||
| 184663 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 1 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
| 184838 | 244427 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005661.3527 | 2109672.0384 | 37.7730774813758 | -122.423836948028 | (37.7730774813758, -122.423836948028) | 7 | 9 | 11 | 28852 | 10 | |||
| 187717 | 96978 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
| 215 | 119692 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 21014 | 119730 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 47866 | 195983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | 10 | 3 | 8 | 58 | 1 | ||||
| 80958 | 196006 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6015895.59891 | 2110702.13918 | 37.7764783468376 | -122.388506996001 | (37.7764783468376, -122.388506996001) | 14 | 3 | 9 | 310 | 20 | ||||
| 98854 | 244404 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005594.3943 | 2110164.7531 | 37.7744265766299 | -122.424103612435 | (37.7744265766299, -122.424103612435) | 7 | 9 | 11 | 28852 | 10 | |||
| 110153 | 196040 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017061.14337 | 2096999.06361 | 37.7389171021312 | -122.383520823632 | (37.7389171021312, -122.383520823632) | 10 | 3 | 8 | 58 | 1 | |||
| 121304 | 234879 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6010587.10266 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | 10 | 4 | 7 | 28859 | 19 | ||||
| 125376 | 234906 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6009686.02423 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | 10 | 7 | 7 | 28859 | 2 | |||
| 142683 | 246566 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 10 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005705.41603 | 2109475.54193 | 37.772540436826 | -122.423670553651 | (37.772540436826, -122.423670553651) | 7 | 9 | 11 | 28852 | 10 | |||
| 146085 | 248120 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.406813543437 | (37.745124840742, -122.406813543437) | 2 | 7 | 7 | 28859 | 2 | ||||
| 152914 | 196031 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017021.60504 | 2097043.83814 | 37.7390378586108 | -122.383660646635 | (37.7390378586108, -122.383660646635) | 10 | 3 | 8 | 58 | 1 | |||
| 155557 | 195964 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 10 | Back Yard : Yard | Tree | Private 2 | 8 | 6015516.57214 | 2100331.82177 | 37.7479826784534 | -122.38909391965 | (37.7479826784534, -122.38909391965) | 10 | 3 | 8 | 58 | 1 | ||||
| 158897 | 119775 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 178442 | 244333 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005640.1134 | 2109813.177 | 37.773463814863 | -122.423920455707 | (37.773463814863, -122.423920455707) | 7 | 9 | 11 | 28852 | 10 | |||
| 16362 | 119731 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 32481 | 246567 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | 7 | 9 | 11 | 28852 | 10 | |||
| 52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 56401 | 234907 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.408989332604 | (37.7367941301369, -122.408989332604) | 10 | 7 | 7 | 28859 | 2 | |||
| 63271 | 195965 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 11 | Back Yard : Yard | Tree | Private 2 | 8 | 6015497.16873 | 2100330.63483 | 37.7479783437428 | -122.389160933554 | (37.7479783437428, -122.389160933554) | 10 | 3 | 8 | 58 | 1 | ||||
| 64096 | 195982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6018502.10258 | 2099556.87815 | 37.7460198865213 | -122.378716163238 | (37.7460198865213, -122.378716163238) | 10 | 3 | 8 | 58 | 1 | ||||
| 72670 | 196032 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6017018.89253 | 2097040.84511 | 37.7390294904202 | -122.383669817022 | (37.7390294904202, -122.383669817022) | 10 | 3 | 8 | 58 | 1 | |||
| 81978 | 196007 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015874.48096 | 2110701.94702 | 37.7764766489106 | -122.388580036236 | (37.7764766489106, -122.388580036236) | 14 | 3 | 9 | 310 | 20 | ||||
| 106915 | 119693 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 114900 | 234880 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.406208290698 | (37.7490776534227, -122.406208290698) | 10 | 4 | 7 | 28859 | 19 | ||||
| 122485 | 244334 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005631.2066 | 2109866.6178 | 37.7736100475528 | -122.423955066597 | (37.7736100475528, -122.423955066597) | 7 | 9 | 11 | 28852 | 10 | |||
| 136053 | 244405 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005589.0478 | 2110200.651 | 37.7745248417047 | -122.424124660487 | (37.7745248417047, -122.424124660487) | 7 | 9 | 11 | 28852 | 10 | |||
| 187388 | 119776 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 127 | 119777 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 35418 | 119732 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 59524 | 244335 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005630.5215 | 2109874.8395 | 37.7736325836766 | -122.42395802123 | (37.7736325836766, -122.42395802123) | 7 | 9 | 11 | 28852 | 10 | |||
| 101044 | 244406 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005586.7565 | 2110217.4543 | 37.7745708501281 | -122.424133781799 | (37.7745708501281, -122.424133781799) | 7 | 9 | 11 | 28852 | 10 | |||
| 103959 | 195966 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 12 | Back Yard : Yard | Tree | Private 2 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | 3 | 8 | 58 | 1 | |||||
| 107339 | 119694 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 115793 | 234881 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.406244130469 | (37.749070568567, -122.406244130469) | 10 | 4 | 7 | 28859 | 19 | ||||
| 115890 | 246568 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005695.27816 | 2109533.51475 | 37.7726990439551 | -122.423709744321 | (37.7726990439551, -122.423709744321) | 7 | 9 | 11 | 28852 | 10 | |||
| 125984 | 234908 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6009679.55053 | 2096368.23252 | 37.7367742299367 | -122.408998565949 | (37.7367742299367, -122.408998565949) | 10 | 7 | 7 | 28859 | 2 | |||
| 145197 | 196008 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015854.16157 | 2110700.296 | 37.7764709894889 | -122.388650212137 | (37.7764709894889, -122.388650212137) | 14 | 3 | 9 | 310 | 20 | ||||
| 185083 | 195981 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6018524.13374 | 2099557.33259 | 37.7460223488573 | -122.378640013128 | (37.7460223488573, -122.378640013128) | 10 | 3 | 8 | 58 | 1 | ||||
| 187174 | 234894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 12 | Front Yard : Yard | Tree | Private 2 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | 2 | 7 | 7 | 28859 | 2 | ||||
| 431 | 119778 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 46467 | 244336 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6005628.4661 | 2109884.4314 | 37.7736588046762 | -122.423965813403 | (37.7736588046762, -122.423965813403) | 7 | 9 | 11 | 28852 | 10 | |||
| 49707 | 234909 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6009677.77783 | 2096362.72232 | 37.7367590008107 | -122.409004306302 | (37.7367590008107, -122.409004306302) | 10 | 7 | 7 | 28859 | 2 | |||
| 61977 | 244407 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005584.4651 | 2110232.73 | 37.774612664125 | -122.424142794808 | (37.774612664125, -122.424142794808) | 7 | 9 | 11 | 28852 | 10 | |||
| 78172 | 234882 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6010551.46993 | 2100825.34606 | 37.7490613037485 | -122.406297890147 | (37.7490613037485, -122.406297890147) | 10 | 4 | 7 | 28859 | 19 | ||||
| 90812 | 119733 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 100151 | 246569 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 13 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005694.60842 | 2109539.50826 | 37.772715462883 | -122.423712487254 | (37.772715462883, -122.423712487254) | 7 | 9 | 11 | 28852 | 10 | |||
| 102343 | 196033 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6017016.3348 | 2097035.41086 | 37.7390144276853 | -122.383678282325 | (37.7390144276853, -122.383678282325) | 10 | 3 | 8 | 58 | 1 | |||
| 126204 | 196009 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | 14 | 3 | 9 | 310 | 20 | ||||
| 138530 | 195967 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 13 | Back Yard : Yard | Tree | Private 2 | 5 | 6015456.78398 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | 3 | 8 | 58 | 1 | |||||
| 158208 | 196041 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017065.52556 | 2097005.97628 | 37.7389363251367 | -122.383506153 | (37.7389363251367, -122.383506153) | 10 | 3 | 8 | 58 | 1 | |||
| 173837 | 119695 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 12376 | 119696 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 37957 | 196010 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015807.5178 | 2110696.90854 | 37.7764591031505 | -122.38881133109 | (37.7764591031505, -122.38881133109) | 14 | 3 | 9 | 310 | 20 | ||||
| 64910 | 119734 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
| 79032 | 195968 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 14 | Back Yard : Yard | Tree | Private 2 | 7 | 6015437.03514 | 2100327.81381 | 37.7479672640843 | -122.389368677829 | (37.7479672640843, -122.389368677829) | 3 | 8 | 58 | 1 | |||||
| 116865 | 244408 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005581.41 | 2110245.7143 | 37.7746481433715 | -122.424154286626 | (37.7746481433715, -122.424154286626) | 7 | 9 | 11 | 28852 | 10 | |||
| 121894 | 244337 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6005627.7809 | 2109896.0788 | 37.7736907469384 | -122.423969012041 | (37.7736907469384, -122.423969012041) | 7 | 9 | 11 | 28852 | 10 | |||
| 131745 | 234883 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6010542.26084 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | 10 | 4 | 7 | 28859 | 19 | ||||
| 144912 | 196042 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017068.02223 | 2097008.36414 | 37.7389430197102 | -122.383497686772 | (37.7389430197102, -122.383497686772) | 10 | 3 | 8 | 58 | 1 |
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) );