34 rows where Police Districts = 9 and qSpecies_id = 35 sorted by YCoord

View and edit SQL

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)
127704 4530 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485) 7 9 11 28858 41
137065 4531 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629) 7 9 11 28858 41
63272 4532 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6005027.0371 2113673.2533 37.784028006638 -122.42631605912 (37.784028006638, -122.42631605912) 7 9 11 28858 41
436 120628 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 5 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
1049 120626 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 3 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
40576 120625 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 2 Median : Cutout Tree DPW 1           6004349 2113949 37.7847467885767 -122.428681484586 (37.7847467885767, -122.428681484586) 13 9 11 29490 41
150152 120624 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 1 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
156411 120627 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 4 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
73905 8395 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 6 Median : Cutout Tree DPW 1   06/09/1994 12:00:00 AM 6 8   6004192.8617 2113973.9777 37.7848065332396 -122.429223453232 (37.7848065332396, -122.429223453232) 13 9 11 29490 41
97674 8394 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 5 Median : Cutout Tree DPW 1     36 8   6004234.0356 2113977.7901 37.784819331933 -122.429081276927 (37.784819331933, -122.429081276927) 13 9 11 29490 41
54682 8393 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 4 Median : Cutout Tree DPW 1     36 8   6004320.9581 2113985.4149 37.7848451877241 -122.428781097193 (37.7848451877241, -122.428781097193) 13 9 11 29490 41
74880 8392 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 3 Median : Cutout Tree DPW 1     36 8   6004378.144 2113996.8521 37.7848798278423 -122.428584068109 (37.7848798278423, -122.428584068109) 13 9 11 29490 41
65698 8391 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 2 Median : Cutout Tree DPW 1     36 8   6004438.3798 2114005.2394 37.784906265949 -122.428376269712 (37.784906265949, -122.428376269712) 13 9 11 29490 41
45559 8390 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 1 Median : Cutout Tree DPW 1     36 8   6004488.7034 2114010.5767 37.7849237683164 -122.428202546761 (37.7849237683164, -122.428202546761) 13 9 11 29490 41
94670 139359 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 9 Median : Cutout Tree DPW 1     28 Width 0ft   6004685.2851 2114039.9918 37.7850156556233 -122.427524533418 (37.7850156556233, -122.427524533418) 13 9 11 28858 41
74434 120629 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 6 Median : Cutout Tree DPW 1           6004538 2114050 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681) 13 9 11 29490 13
63063 139214 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 8 Median : Cutout Tree DPW 1     29 Width 0ft   6004809.3749 2114055.503 37.7850652633568 -122.427096327106 (37.7850652633568, -122.427096327106) 13 9 11 28858 41
187582 139358 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 7 Median : Cutout Tree DPW 1     19 Width 0ft   6004934.0187 2114075.446 37.7851270694756 -122.426666519258 (37.7851270694756, -122.426666519258) 13 9 11 28858 41
110654 139356 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 5 Median : Cutout Tree DPW 1     24 Width 0ft   6005063.0942 2114090.4032 37.7851754347521 -122.426221023287 (37.7851754347521, -122.426221023287) 13 9 11 28858 41
65641 139330 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 4 Median : Cutout Tree DPW 1     31 Width 0ft   6005126.2471 2114101.4827 37.7852094256692 -122.426003322666 (37.7852094256692, -122.426003322666) 13 9 11 28858 41
177341 139329 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 3 Median : Cutout Tree DPW 1     13 Width 0ft   6005196.3246 2114113.3931 37.7852460889347 -122.425761723999 (37.7852460889347, -122.425761723999) 13 9 11 28858 41
21559 8344 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 10 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 12 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
39949 8349 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 15 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
43907 8339 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 5 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 18 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
60514 8341 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 7 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
79654 8340 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 6 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
125264 8348 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 14 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
150834 8342 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 8 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
161286 8351 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 17 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
141285 120542 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3 DPW for City Agency         6002644.10897 2115479.97736 37.7888538273233 -122.434689351726 (37.7888538273233, -122.434689351726) 13 9 1 29490 27
65 264979 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
4438 254757 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 13 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
194127 122584 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2500X Lyon St 4 Median : Cutout Tree Private 2     11 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
94007 132160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1141 Chestnut St 5 Front Yard : Yard Tree Private 2     20     6006382.37262 2120397.93248 37.8025688116636 -122.422104980572 (37.8025688116636, -122.422104980572) 5 9 1 28858 32

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