40 rows where Neighborhoods (old) = 24 and qSpecies_id = 35

View and edit SQL

Neighborhoods (old)

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)
450 178165 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 20 Median : Cutout Tree Private 2     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
9866 178155 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 10 : Tree Private 2     6 Width 0ft   5993366.44396 2087810.43567 37.7123492834548 -122.464778384525 (37.7123492834548, -122.464778384525) 9 8 4 64 24
25077 178166 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 21 : Tree Private 2     5 Width 0ft   5992891.51235 2087851.51661 37.7124346884767 -122.466422861421 (37.7124346884767, -122.466422861421) 9 8 4 64 24
27670 178138 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 9 : Tree Private 2     7 Width 0ft   5992224.93754 2087880.30275 37.7124752425212 -122.468728820297 (37.7124752425212, -122.468728820297) 9 8 4 64 24
30677 178169 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 24 : Tree Private 2     6 Width 0ft   5992786.91057 2087851.54482 37.7124287295635 -122.466784396099 (37.7124287295635, -122.466784396099) 9 8 4 64 24
37951 178151 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 4 : Tree Private 2     3 Width 0ft   5993597.52442 2087641.38278 37.7118984245322 -122.463967443352 (37.7118984245322, -122.463967443352) 9 8 4 64 24
43976 178156 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 11 : Tree Private 2     5 Width 0ft   5993327.47852 2087822.82752 37.712381061909 -122.464913959129 (37.712381061909, -122.464913959129) 9 8 4 64 24
49587 178167 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 22 : Tree Private 2     5 Width 0ft   5992858.09731 2087851.49534 37.7124327018762 -122.466538351485 (37.7124327018762, -122.466538351485) 9 8 4 64 24
51083 178139 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 10 : Tree Private 2     6 Width 0ft   5992188.74587 2087889.24466 37.7124977039766 -122.468854559004 (37.7124977039766, -122.468854559004) 9 8 4 64 24
52379 178161 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 16 : Tree Private 2     6 Width 0ft   5993106.56964 2087853.50799 37.7124525633948 -122.465679708459 (37.7124525633948, -122.465679708459) 9 8 4 64 24
66301 178130 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 1 : Tree Private 2     7 Width 0ft   5992655.54446 2087848.4586 37.7124126730818 -122.4672382093 (37.7124126730818, -122.4672382093) 9 8 4 64 24
68619 178132 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 3 : Tree Private 2     6 Width 0ft   5992585.12632 2087848.18621 37.7124078599039 -122.467481573927 (37.7124078599039, -122.467481573927) 9 8 4 64 24
71095 178152 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 7 : Tree Private 2     5 Width 0ft   5993523.09133 2087729.02455 37.7121347780763 -122.464231061624 (37.7121347780763, -122.464231061624) 9 8 4 64 24
75099 178157 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 12 : Tree Private 2     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.465034470985 (37.712406882332, -122.465034470985) 9 8 4 64 24
82846 178140 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 11 : Tree Private 2     6 Width 0ft   5992153.76433 2087899.91411 37.712524978625 -122.468976240883 (37.712524978625, -122.468976240883) 9 8 4 64 24
84561 178158 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 13 : Tree Private 2     5 Width 0ft   5993255.20411 2087840.25906 37.7124247572585 -122.465165024673 (37.7124247572585, -122.465165024673) 9 8 4 64 24
87580 178149 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 20 : Tree Private 2     4 Width 0ft   5991654.66793 2087995.14516 37.712757610756 -122.470708188538 (37.712757610756, -122.470708188538) 9 8 4 64 24
88271 178133 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 4 : Tree Private 2     6 Width 0ft   5992553.46677 2087849.43624 37.7124094643071 -122.467591088862 (37.7124094643071, -122.467591088862) 9 8 4 64 24
88362 178135 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 6 : Tree Private 2     5 Width 0ft   5992385.69997 2087851.79588 37.7124062555186 -122.468171108404 (37.7124062555186, -122.468171108404) 9 8 4 64 24
90257 178131 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 2 : Tree Private 2     5 Width 0ft   5992618.59421 2087849.23546 37.7124126730667 -122.467365975965 (37.7124126730667, -122.467365975965) 9 8 4 64 24
90962 178141 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 12 Median : Yard Tree Private 2 DPW   5 Width 0ft   5992021.87667 2087934.24208 37.7126116138994 -122.469434578544 (37.7126116138994, -122.469434578544) 9 8 4 64 24
111520 178143 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 14 : Tree Private 2     5 Width 0ft   5991964.10718 2087949.4813 37.7126501183836 -122.4696353549 (37.7126501183836, -122.4696353549) 9 8 4 64 24
117654 178148 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 19 : Tree Private 2     5 Width 0ft   5991783.61367 2087988.33952 37.7127463800143 -122.470262019583 (37.7127463800143, -122.470262019583) 9 8 4 64 24
121908 178144 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 15 : Tree Private 2     4 Width 0ft   5991934.88004 2087954.77106 37.7126629535013 -122.469736757058 (37.7126629535013, -122.469736757058) 9 8 4 64 24
122237 178153 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 8 : Tree Private 2     7 Width 0ft   5993495.89449 2087748.40295 37.7121864189299 -122.464326467118 (37.7121864189299, -122.464326467118) 9 8 4 64 24
133124 178162 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 17 : Tree Private 2     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.465797709423 (37.7124585223038, -122.465797709423) 9 8 4 64 24
134318 178164 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 19 : Tree Private 2     5 Width 0ft   5993000.50065 2087852.84302 37.71244461881 -122.46604626403 (37.71244461881, -122.46604626403) 9 8 4 64 24
142106 178147 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 18 : Tree Private 2     4 Width 0ft   5991814.6494 2087985.34878 37.712739962461 -122.47015453352 (37.712739962461, -122.47015453352) 9 8 4 64 24
145727 178137 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 8 : Tree Private 2     5 Width 0ft   5992316.61451 2087859.09194 37.7124222985339 -122.468410417129 (37.7124222985339, -122.468410417129) 9 8 4 64 24
157706 178159 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 14 : Tree Private 2     5 Width 0ft   5993218.97583 2087844.63687 37.7124346884772 -122.465290557432 (37.7124346884772, -122.465290557432) 9 8 4 64 24
159200 178136 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 7 : Tree Private 2     5 Width 0ft   5992351.13254 2087854.27594 37.7124110686957 -122.468290763208 (37.7124110686957, -122.468290763208) 9 8 4 64 24
160793 178142 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 13 : Tree Private 2     5 Width 0ft   5991993.89623 2087943.01111 37.7126340744777 -122.469531924782 (37.7126340744777, -122.469531924782) 9 8 4 64 24
167203 178168 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 23 : Tree Private 2     5 Width 0ft   5992821.74753 2087850.08942 37.712426743882 -122.466663884229 (37.712426743882, -122.466663884229) 9 8 4 64 24
170410 178146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 17 : Tree Private 2     4 Width 0ft   5991839.8077 2087981.8975 37.7127319405071 -122.47006732805 (37.7127319405071, -122.47006732805) 9 8 4 64 24
174956 178160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 15 : Tree Private 2     6 Width 0ft   5993144.35627 2087854.16093 37.7124565357104 -122.465549154771 (37.7124565357104, -122.465549154771) 9 8 4 64 24
178432 178154 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 9 : Tree Private 2     7 Width 0ft   5993415.34716 2087786.98511 37.7122877131728 -122.464607659932 (37.7122877131728, -122.464607659932) 9 8 4 64 24
182192 178134 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 5 Side Yard : Yard Tree DPW 1     5 Width 0ft   5992424.40969 2087850.98169 37.7124062555176 -122.468037257827 (37.7124062555176, -122.468037257827) 9 8 4 64 24
182755 178163 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 18 : Tree Private 2     5 Width 0ft   5993033.97644 2087855.75659 37.7124545499972 -122.465930773993 (37.7124545499972, -122.465930773993) 9 8 4 64 24
184676 178150 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 21 : Tree Private 2     4 Width 0ft   5991622.99627 2087995.81221 37.7127576107372 -122.470817703474 (37.7127576107372, -122.470817703474) 9 8 4 64 24
184903 178145 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 16 : Tree Private 2     4 Width 0ft   5991905.80045 2087967.06921 37.7126950404068 -122.469838159212 (37.7126950404068, -122.469838159212) 9 8 4 64 24

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