24 rows where Police Districts = 5 and qSpecies_id = 35

View and edit SQL

Suggested facets: Longitude

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)
19548 234472 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 4810 17th St 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 2ft   5998175.60392 2105685.14055 37.7617050378737 -122.449443663887 (37.7617050378737, -122.449443663887) 15 5 11 29492 9
20185 8536 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100 Geary Blvd 7 Median : Cutout Tree DPW 1   06/10/1994 12:00:00 AM 6 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651 (37.7837972495813, -122.43786449651) 15 5 11 29490 13
23996 8576 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 3 Median : Cutout Tree DPW 1     48 6   6001010.5429 2113459.32 37.7832127479531 -122.440196288881 (37.7832127479531, -122.440196288881) 15 5 11 29490 41
26940 8472 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 9 Median : Cutout Tree DPW 1     6 8   6002074.2026 2113678.2789 37.7838744530021 -122.436532136471 (37.7838744530021, -122.436532136471) 13 5 11 29490 41
38568 8471 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 8 Median : Cutout Tree DPW 1   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.7838791576421 -122.43635890448 (37.7838791576421, -122.43635890448) 13 5 11 29490 41
43150 8574 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 1 Median : Cutout Tree DPW 1     6 6   6001134.4053 2113480.979 37.7832792690603 -122.439769329053 (37.7832792690603, -122.439769329053) 15 5 11 29490 41
65234 8577 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 4 Median : Cutout Tree DPW 1     36 6   6000958.4259 2113453.9053 37.7831949132778 -122.440376203878 (37.7831949132778, -122.440376203878) 15 5 11 29490 41
66433 8563 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     36 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
71757 8562 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     48 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
83309 247525 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1101 Waller St 6 Side Yard : Yard Tree Private 2     2     6000029.93527 2108491.27934 37.7695158962756 -122.443231851395 (37.7695158962756, -122.443231851395) 15 5 11 29492 9
101800 8581 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 8 Median : Cutout Tree DPW 1     24 6   6000715.1007 2113420.9091 37.7830904567466 -122.441215640748 (37.7830904567466, -122.441215640748) 15 5 1 29490 41
107231 8560 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
110569 8474 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 11 Median : Cutout Tree DPW 1     6 8   6001879.2717 2113651.882 37.7837908949329 -122.437204633286 (37.7837908949329, -122.437204633286) 13 5 11 29490 41
112575 8469 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 6 Median : Cutout Tree DPW 1     48 8   6002244.0904 2113695.2 37.7839305664786 -122.435945599699 (37.7839305664786, -122.435945599699) 13 5 11 29490 41
113256 8561 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/1994 12:00:00 AM 6 3X3   6001214.79121 2113518.75863 37.7833875775095 -122.439493935571 (37.7833875775095, -122.439493935571) 15 5 11 29490 13
116060 8575 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 2 Median : Cutout Tree DPW 1     48 6   6001093.7947 2113474.2106 37.7832583731226 -122.439909339764 (37.7832583731226, -122.439909339764) 15 5 11 29490 41
122803 8535 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100 Geary Blvd 6 Median : Cutout Tree DPW 1     18 6   6001300.5704 2113502.1304 37.7833468021346 -122.439195981768 (37.7833468021346, -122.439195981768) 15 5 11 29490 41
126371 8532 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100 Geary Blvd 3 Median : Cutout Tree DPW 1   06/10/1994 12:00:00 AM 6 6   6001535.4351 2113580.6442 37.7835757427727 -122.438389071264 (37.7835757427727, -122.438389071264) 15 5 11 29490 41
127126 8475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Geary Blvd 12 Median : Cutout Tree DPW 1   06/03/1994 12:00:00 AM 6 8   6001831.8926 2113645.1136 37.7837696172579 -122.437368062109 (37.7837696172579, -122.437368062109) 13 5 11 29490 41
141624 8586 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 13 Median : Cutout Tree DPW 1     24 6   6000400.7068 2113377.2527 37.7829526738098 -122.442300177437 (37.7829526738098, -122.442300177437) 15 5 1 29490 41
170733 8578 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 5 Median : Cutout Tree DPW 1     18 6   6000905.6321 2113444.4294 37.7831658887746 -122.440558168856 (37.7831658887746, -122.440558168856) 15 5 11 29490 41
183037 8530 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100X Geary Blvd 1 Median : Cutout Tree DPW 1   06/10/1994 12:00:00 AM 15     6001630.1932 2113615.3325 37.7836763773468 -122.438063730933 (37.7836763773468, -122.438063730933) 15 5 11 29490 41
186033 8582 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Geary Blvd 9 Median : Cutout Tree DPW 1     18 6   6000649.7853 2113412.1102 37.7830625764785 -122.441440973241 (37.7830625764785, -122.441440973241) 15 5 1 29490 41
187307 8537 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2100 Geary Blvd 8 Median : Cutout Tree DPW 1   06/10/1994 12:00:00 AM 3 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651 (37.7837972495813, -122.43786449651) 15 5 11 29490 13

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