trees

117 rows where Police Districts = 6 and qLegalStatus_id = 6 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

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)
163821 87242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 4131 Geary Blvd 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 50271 5994116.9 2112250.5 37.7794987690846 -122.46395756624 (37.7794987690846, -122.46395756624) 11 6 2 54 11
153312 91106 Significant Tree 6 Tree(s) :: 17 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
78031 91107 Significant Tree 6 Tree(s) :: 17 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
138623 91110 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
191593 91111 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
182598 92909 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 1 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
81784 93874 Significant Tree 6 Pistacia chinensis :: Chinese Pistache 32 2614 Sacramento St   Front Yard : Tree Private 2   04/14/2010 12:00:00 AM     Permit Number 53370 6002291 2115777 37.7896493226209 -122.435932319436 (37.7896493226209, -122.435932319436) 13 6 1 29490 27
6097 95161 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2721 Pacific Ave   Front Yard : Yard Tree Private 2         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252) 13 6 1 29490 27
147409 95215 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2203 Divisadero St   Front Yard : Yard Tree Private 2           6000868 2115894 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631) 13 6 1 29490 27
95953 95234 Significant Tree 6 Tree(s) :: 17 7 Almaden Ct   Front Yard : Yard Tree Private 2   01/25/2011 12:00:00 AM     Permit Number 767129 5995849 2112535 37.7803795989447 -122.457986127959 (37.7803795989447, -122.457986127959) 11 6 2 54 16
90328 96835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 6001 Geary Blvd 1 Front Yard : Cutout Tree Private 2           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894) 11 6 2 55 26
94461 98038 Significant Tree 6 Tree(s) :: 17 147 Lake St 1 Front Yard : Yard Tree Private 2   12/09/2011 12:00:00 AM     Permit Number 768423 5994977.2 2114852.5 37.7866927029397 -122.461170103848 (37.7866927029397, -122.461170103848) 11 6 1 54 11
127638 98241 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 3760 Washington St 1 Front Yard : Yard Tree Private 2   01/10/2012 12:00:00 AM 9   Permit Number 768462 5996814.46778 2115674.04938 37.7890540175629 -122.45487301497 (37.7890540175629, -122.45487301497) 11 6 1 54 31
174679 98491 Significant Tree 6 Robinia pseudoacacia :: Black Locust 286 55X Perine Pl 1 Back Yard : Cutout Tree Private 2         Permit Number 768655 6002130.5 2115544.8 37.7890026421633 -122.436471006098 (37.7890026421633, -122.436471006098) 13 6 1 29490 27
145768 98703 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070@ 32nd Ave California St 4 Front Yard : Tree Private 2   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
8456 99698 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1750 Divisadero St 1 Front Yard : Cutout Tree Private 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
188669 99699 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1750 Divisadero St 2 Front Yard : Cutout Tree Private 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27

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