14 rows where Fire Prevention Districts = 8 and qSpecies_id = 95 sorted by qSpecies_id

View and edit SQL

Fire Prevention 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)
5674 69960 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1084 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6007591.27933 2109447.46349 37.7725696126174 -122.417145153823 (37.7725696126174, -122.417145153823) 8 2 9 28853 19
22936 42216 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 202X Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 3 3X3 Permit Number 42481 6009500.82528 2109156.27117 37.7718773055291 -122.410519244875 (37.7718773055291, -122.410519244875) 8 2 9 28853 34
32340 194551 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 364 09th St 1 : Tree Private 2     8 Width 3ft   6009495.1726 2109485.56506 37.7727811529595 -122.410562055301 (37.7727811529595, -122.410562055301) 8 2 9 28853 34
52206 233518 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 100 Hwy 101 Southbound 10 Back Yard : Yard Tree Private 2     7     6005873.99672 2108944.2877 37.7710912548825 -122.423049648243 (37.7710912548825, -122.423049648243) 8 2 5 28853 19
67193 61924 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 456 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1985 12:00:00 AM     Permit Number 21978 6005733.06565102 2107870.63152991 37.768135298323 -122.423460793102 (37.768135298323, -122.423460793102) 8 4 5 28853 19
68096 68705 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3725 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32713 6004069.33935091 2105955.57435513 37.7627829682463 -122.429078889929 (37.7627829682463, -122.429078889929) 8 4 5 28862 3
79049 194552 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1084 Natoma St 1 : Tree Private 2     12 Width 3ft   6007595.2752 2109454.36065 37.772588775377 -122.417131820472 (37.772588775377, -122.417131820472) 8 2 9 28853 19
119750 55850 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3452 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1984 12:00:00 AM     Permit Number 21322 6003863.92608723 2106588.23979029 37.7645084855972 -122.429834470805 (37.7645084855972, -122.429834470805) 8 4 5 28862 3
124906 62567 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 566 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/01/1986 12:00:00 AM     Permit Number 22768 6011492.88408448 2105735.21386833 37.7625953337074 -122.403387819029 (37.7625953337074, -122.403387819029) 8 3 8 28856 29
129295 194553 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 400 Vermont St 3 Sidewalk: Curb side : Cutout Tree Private 2     19     6011164.90304 2106222.99069 37.7639163349965 -122.404556531081 (37.7639163349965, -122.404556531081) 8 3 8 28856 29
132937 61400 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 3446 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1984 12:00:00 AM     Permit Number 21323 6003891.19192032 2106589.75258632 37.7645141833652 -122.429740273636 (37.7645141833652, -122.429740273636) 8 4 5 28862 3
150260 233517 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 100 Hwy 101 Southbound 12 Back Yard : Yard Tree Private 2     7     6005882.82166 2108930.28485 37.7710533043986 -122.423018127005 (37.7710533043986, -122.423018127005) 8 2 5 28853 19
178700 61907 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 410 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1985 12:00:00 AM     Permit Number 21954 6006015.61965589 2107886.23746349 37.7681940923018 -122.422484575665 (37.7681940923018, -122.422484575665) 8 4 5 28853 19
189412 194573 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 614 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009542.67378 2111646.52636 37.7787173088821 -122.410550367712 (37.7787173088821, -122.410550367712) 8 2 9 28853 34

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