25 rows where DBH = 3 and qLegalStatus_id = 8 sorted by DBH

View and edit SQL

These facets timed out: DBH

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)
2474 256556 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 5 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
5745 193934 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 Width 3ft   6016623.26344 2095403.70542 37.7345123576517 -122.384923708478 (37.7345123576517, -122.384923708478) 10 3 8 58 1
20664 121198 Property Tree 8 Cordyline australis :: Dracena Palm 64 2521 18th Ave 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5990743 2098231 37.740809941753 -122.47460574514 (37.740809941753, -122.47460574514) 1 8 4 29491 40
22174 33799 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 10 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
27877 33781 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x misson st 12 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6013804.30364325 2116217.11127164 37.7915050790356 -122.396128026757 (37.7915050790356, -122.396128026757) 12 2 9 28855 6
31871 33776 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
34431 256554 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 3 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
43580 33793 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
48396 109097 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
54368 33775 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
55834 121404 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1900 08th Ave 1 Back Yard : Yard Tree Private 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
62239 33794 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 13 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
71205 33789 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
90011 256555 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 4 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:48:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
90477 109091 Property Tree 8 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 4235 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
91079 33787 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
106561 97238 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
106981 109092 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
140802 33786 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
163103 33791 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
167692 33790 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
175776 256557 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 6 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:44:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
176971 256553 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 2 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
185435 33788 Property Tree 8 Magnolia grandiflora :: Southern Magnolia 19 200x Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
189291 256552 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 1 Side Yard : Yard Tree SFUSD 4   02/08/2019 08:54:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3

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