trees

13 rows where SiteOrder = 6 and qSpecies_id = 162

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
15895 140445 DPW Maintained 1 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1101 FILLMORE ST 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6003336.4315 2112141.3403 37.7797260501135 -122.432055505631 (37.7797260501135, -122.432055505631) 15 9 11 29490 41
22818 105631 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1401X Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009102.15962 2108882.87062 37.7711042533217 -122.411878939782 (37.7711042533217, -122.411878939782) 8 2 9 28853 34
24445 101578 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1200X Bryant St 6 Sidewalk: Property side : Cutout Tree Private 2     8 3x3   6009691.5 2108599.6 37.7703595033467 -122.409820383511 (37.7703595033467, -122.409820383511) 8 2 9 28853 34
54800 14509 DPW Maintained 1 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 500X Masonic Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2001 12:00:00 AM 20 6X6   5999167.52145 2111070.84281 37.7765495060171 -122.446400495731 (37.7765495060171, -122.446400495731) 15 5 11 29492 16
77136 101553 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 435X 11th St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009095.5 2108566.4 37.770234925082 -122.411879608901 (37.770234925082, -122.411879608901) 8 2 9 28853 34
93118 105560 Undocumented 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 450 10th St 6 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6009467.7 2108781.2 37.7708455901598 -122.410607336919 (37.7708455901598, -122.410607336919) 8 2 9 28853 34
130377 113654 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
132671 103165 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1201X Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003055.6 2112559.2 37.7808574628324 -122.43305688657 (37.7808574628324, -122.43305688657) 15 9 11 29490 41
139456 105608 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 401X 11th St 6 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6009144.21767 2108487.31593 37.7700205116512 -122.41170550536 (37.7700205116512, -122.41170550536) 8 2 9 28853 34
140986 105587 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1200X Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009691.5 2108599.6 37.7703595033467 -122.409820383511 (37.7703595033467, -122.409820383511) 8 2 9 28853 34
146434 48048 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 3251 18th St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   2x2 Permit Number 52041 6007813.0003926 2105579.22117963 37.7619607946272 -122.416104194982 (37.7619607946272, -122.416104194982) 2 4 7 28859 19
146493 103241 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1240 Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003317 2112564 37.7808854664086 -122.432152919664 (37.7808854664086, -122.432152919664) 15 9 11 29490 41
182557 86786 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1390 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2009 12:00:00 AM   3x3 Permit Number 52918. Tree 6 on 10th St 6007989 2110462 37.7753776559059 -122.415841246268 (37.7753776559059, -122.415841246268) 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)
);