trees

43 rows where Police Districts = 7 and qSpecies_id = 59

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
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
19126 234903 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 7 Sidewalk: Property side : Yard Tree Private 2     18     6009692.65358 2096419.54828 37.7369158659624 -122.408956882348 (37.7369158659624, -122.408956882348) 10 7 7 28859 2
19786 248125 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 5 Front Yard : Yard Tree Private 2     7     6010397.04877 2099427.00914 37.7452131370768 -122.406733349058 (37.7452131370768, -122.406733349058) 2 7 7 28859 2
20810 248173 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 218 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     6     6007303.95131 2098726.55555 37.743116300271 -122.417379150221 (37.743116300271, -122.417379150221) 2 7 7 28859 2
23378 234893 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 7 Front Yard : Yard Tree Private 2     17     6010664.01336 2100659.8191 37.7486130978165 -122.405897053323 (37.7486130978165, -122.405897053323) 2 7 7 28859 2
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
37570 248117 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 7 Side Yard : Yard Tree Private 2     6     6010378.29952 2099414.5285 37.7451778188963 -122.406797301657 (37.7451778188963, -122.406797301657) 2 7 7 28859 2
40536 248113 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 3 Side Yard : Yard Tree Private 2     17     6010385.30327 2099441.28079 37.7452516667373 -122.406774968811 (37.7452516667373, -122.406774968811) 2 7 7 28859 2
40830 248124 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 4 Front Yard : Yard Tree Private 2     10     6010394.26479 2099420.04988 37.7451938726969 -122.406742485274 (37.7451938726969, -122.406742485274) 2 7 7 28859 2
47166 234889 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 3 Front Yard : Yard Tree Private 2     25     6010620.28496 2100677.87035 37.7486602169168 -122.406049537871 (37.7486602169168, -122.406049537871) 2 7 7 28859 2
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
52513 234888 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 2 Front Yard : Yard Tree Private 2     33     6010611.763 2100694.95228 37.7487066435094 -122.406080210127 (37.7487066435094, -122.406080210127) 2 7 7 28859 2
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
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
58340 234904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 8 Sidewalk: Property side : Yard Tree Private 2     15     6009689.76503 2096405.45865 37.7368770170648 -122.408965875569 (37.7368770170648, -122.408965875569) 10 7 7 28859 2
76548 234891 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 5 Front Yard : Yard Tree Private 2     12     6010619.31212 2100642.55964 37.7485632070257 -122.406050414705 (37.7485632070257, -122.406050414705) 2 7 7 28859 2
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
80514 248115 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 5 Side Yard : Yard Tree Private 2     7     6010382.66989 2099427.30215 37.7452131370921 -122.406783089664 (37.7452131370921, -122.406783089664) 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
83040 234899 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 3 Sidewalk: Property side : Yard Tree Private 2     24     6009698.94501 2096439.52165 37.7369710609585 -122.408936538802 (37.7369710609585, -122.408936538802) 10 7 7 28859 2
87689 248119 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 9 Side Yard : Yard Tree Private 2     18     6010375.35501 2099399.67941 37.7451368817742 -122.406806436993 (37.7451368817742, -122.406806436993) 2 7 7 28859 2
89186 248114 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 4 Side Yard : Yard Tree Private 2     15     6010381.0463 2099434.05906 37.7452315992509 -122.406789179902 (37.7452315992509, -122.406789179902) 2 7 7 28859 2
97525 234890 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 4 Front Yard : Yard Tree Private 2     14     6010623.85334 2100666.44158 37.7486290355994 -122.406036393361 (37.7486290355994, -122.406036393361) 2 7 7 28859 2
104444 248116 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 6 Side Yard : Yard Tree Private 2     9     6010379.57479 2099419.47211 37.745191464328 -122.406793240314 (37.745191464328, -122.406793240314) 2 7 7 28859 2
109416 212850 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 32 Malta Dr 32 Sidewalk: Curb side : Yard Tree Private 2     32 Width 3ft   5999489.82188 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429) 9 7 4 63 40
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
111007 234892 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 6 Front Yard : Yard Tree Private 2     18     6010653.55518 2100656.49907 37.7486033968442 -122.40593298392 (37.7486033968442, -122.40593298392) 2 7 7 28859 2
113044 248122 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 2 Front Yard : Yard Tree Private 2     14     6010390.78091 2099407.55033 37.7451593567256 -122.406753651253 (37.7451593567256, -122.406753651253) 2 7 7 28859 2
122830 234901 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 5 Sidewalk: Property side : Yard Tree Private 2     12     6009690.97834 2096436.62736 37.7369626675976 -122.408963879105 (37.7369626675976, -122.408963879105) 10 7 7 28859 2
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
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
126542 248127 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 7 Front Yard : Yard Tree Private 2     18     6010399.6226 2099438.06548 37.7452436393873 -122.406725228187 (37.7452436393873, -122.406725228187) 2 7 7 28859 2
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
145571 248126 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 6 Front Yard : Yard Tree Private 2     6     6010387.78953 2099433.6295 37.7452307970734 -122.406765832574 (37.7452307970734, -122.406765832574) 2 7 7 28859 2
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
147412 234898 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 2 Sidewalk: Property side : Yard Tree Private 2     24     6009700.61042 2096445.6891 37.7369880887377 -122.408931215729 (37.7369880887377, -122.408931215729) 10 7 7 28859 2
152488 234902 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 6 Sidewalk: Property side : Yard Tree Private 2     6     6009698.63441 2096418.94153 37.7369145349811 -122.408936161078 (37.7369145349811, -122.408936161078) 10 7 7 28859 2
153116 24282 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Winding Way 20 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
164603 234905 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 9 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6009688.58582 2096390.10165 37.736834783993 -122.40896886942 (37.736834783993, -122.40896886942) 10 7 7 28859 2
172175 248118 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 8 Side Yard : Yard Tree Private 2     6     6010376.97092 2099406.95495 37.7451569492381 -122.40680136209 (37.7451569492381, -122.40680136209) 2 7 7 28859 2
179780 234900 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6009696.65795 2096435.22954 37.7369591476365 -122.40894414348 (37.7369591476365, -122.40894414348) 10 7 7 28859 2
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
191905 248123 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 3 Front Yard : Yard Tree Private 2     13     6010392.06783 2099413.07866 37.7451746083214 -122.406749590819 (37.7451746083214, -122.406749590819) 2 7 7 28859 2

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);