15 rows where qLegalStatus_id = 6 and qSiteInfo = "Front Yard :" sorted by qCareAssistant

View and edit SQL

qSiteInfo

  • Front Yard : · 15
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)
25036 95137 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 127 Front Yard : Tree Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590 2110608 37.7751884337973 -122.451824172116 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
33415 95138 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 128 Front Yard : Tree Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590 2110608 37.7751884337973 -122.451824172116 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
37022 95985 Significant Tree 6 Juniperus chinensis :: Juniper 113 577 Sanchez St 1 Front Yard : Tree Private 2           6003673 2104901 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168) 2 4 5 28862 3
37942 98308 Significant Tree 6 Tree(s) :: 17 1490 Fairfax Ave 1 Front Yard : Tree Private 2   01/25/2012 12:00:00 AM   3x3 Permit Number 768575 6016246.6 2097899.9 37.7413455620636 -122.386399955147 (37.7413455620636, -122.386399955147) 10 3 8 58 1
61598 99299 Significant Tree 6 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 1457 Willard St 1 Front Yard : Tree Private 2   05/02/2012 12:00:00 AM     Permit Number 768720 5996809.7 2106270.3 37.763233506694 -122.454210015753 (37.763233506694, -122.454210015753) 15 5 11 29492 12
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
89508 98309 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 401X Newhall St 1 Front Yard : Tree Private 2     6 3x3   6016081.14502 2097910.94016 37.7413667159929 -122.386972815546 (37.7413667159929, -122.386972815546) 10 3 8 58 1
119552 101202 Significant Tree 6 Tree(s) :: 17 7070 California St 1 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
126350 101810 Significant Tree 6 Tree(s) :: 17 38 Nebraska St 1 Front Yard : Tree Private 2   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261909 (37.740765720819, -122.41052261909) 10 7 7 28859 2
129276 93903 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 546 Page St   Front Yard : Tree Private 2           6003947 2109752 37.7732001072566 -122.429772814549 (37.7732001072566, -122.429772814549) 7 9 11 29492 10
135121 98310 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 1499@Newhall Evans Ave 2 Front Yard : Tree Private 2   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.27381 37.7417009175609 -122.386401389915 (37.7417009175609, -122.386401389915) 10 3 8 58 1
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
146707 103477 Significant Tree 6 Tree(s) :: 17 875 El Camino Del Mar 1 Front Yard : Tree Private 2   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739) 11 6 1 55 15
158642 94066 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 548 Page St   Front Yard : Tree Private 2   06/02/2010 12:00:00 AM     Permit Number 53460 6003937 2109751 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526) 7 9 11 29492 10
162612 101203 Significant Tree 6 Tree(s) :: 17 7070 California St 2 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33

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