trees
29 rows where PlotSize = "Width 10ft" and qSpecies_id = 59 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21224 | 196043 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6017069.89025 | 2097009.95172 | 37.7389474821301 | -122.383491338448 | (37.7389474821301, -122.383491338448) | 10 | 3 | 8 | 58 | 1 | |||
35055 | 196038 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | 10 | 3 | 8 | 58 | 1 | |||
37731 | 196046 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017076.84536 | 2097020.98628 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | 10 | 3 | 8 | 58 | 1 | |||
38227 | 196030 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017023.70578 | 2097046.84349 | 37.739046226814 | -122.383653592346 | (37.739046226814, -122.383653592346) | 10 | 3 | 8 | 58 | 1 | |||
52670 | 196039 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017058.78761 | 2096996.23306 | 37.7389091998064 | -122.38352877184 | (37.7389091998064, -122.38352877184) | 10 | 3 | 8 | 58 | 1 | |||
66956 | 196045 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017076.58838 | 2097018.35028 | 37.7389709130863 | -122.383468763681 | (37.7389709130863, -122.383468763681) | 10 | 3 | 8 | 58 | 1 | |||
72063 | 196028 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6017030.63637 | 2097056.65947 | 37.7390735625998 | -122.383630312507 | (37.7390735625998, -122.383630312507) | 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 | |||
79693 | 196025 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017042.18161 | 2097072.11853 | 37.7391166482065 | -122.383591469892 | (37.7391166482065, -122.383591469892) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
98268 | 196037 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017049.14343 | 2096982.73756 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
104734 | 196035 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6017042.43736 | 2096973.93304 | 37.7388470647366 | -122.383583751905 | (37.7388470647366, -122.383583751905) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
112062 | 196048 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6017086.86394 | 2097032.16257 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | 10 | 3 | 8 | 58 | 1 | |||
124042 | 196027 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017034.20589 | 2097061.66689 | 37.7390875092666 | -122.383618319135 | (37.7390875092666, -122.383618319135) | 10 | 3 | 8 | 58 | 1 | |||
136935 | 196026 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017039.21913 | 2097067.45785 | 37.7391036871735 | -122.383601388517 | (37.7391036871735, -122.383601388517) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
148904 | 196044 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017074.4672 | 2097014.32935 | 37.7389597551859 | -122.383475817977 | (37.7389597551859, -122.383475817977) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
153530 | 196036 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017046.41048 | 2096978.72928 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | 10 | 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 | |||
159019 | 196047 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6017083.09876 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | 10 | 3 | 8 | 58 | 1 | |||
164057 | 196049 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 10ft | 6017090.91062 | 2097040.61449 | 37.7390328376916 | -122.383420792935 | (37.7390328376916, -122.383420792935) | 10 | 3 | 8 | 58 | 1 | |||
178720 | 196029 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017027.27121 | 2097051.6476 | 37.7390596150087 | -122.383641598974 | (37.7390596150087, -122.383641598974) | 10 | 3 | 8 | 58 | 1 | |||
99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
150253 | 234896 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 10ft | 6007240.7393 | 2101963.94083 | 37.7520018736867 | -122.417827151095 | (37.7520018736867, -122.417827151095) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 |
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) );