Street_Tree_List

Data source: data.sfgov.org

16 rows where qSiteInfo = 25

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantType, PlantDate, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
66105 98309 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 82 401X Newhall St 1 Front Yard : 25 Tree 1 Private 1     6 3x3   6016081.14502 2097910.9401599998 37.741366715992896 -122.386972815546 (37.7413667159929, -122.386972815546)
75158 95137 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 127 Front Yard : 25 Tree 1 Private 1   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590.0 2110608.0 37.7751884337973 -122.45182417211599 (37.7751884337973, -122.451824172116)
77945 95138 Significant Tree 6 Tree(s) :: 17 2130 Fulton St 128 Front Yard : 25 Tree 1 Private 1   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590.0 2110608.0 37.7751884337973 -122.45182417211599 (37.7751884337973, -122.451824172116)
89463 99299 Significant Tree 6 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 1457 Willard St 1 Front Yard : 25 Tree 1 Private 1   05/02/2012 12:00:00 AM     Permit Number 768720 5996809.7 2106270.3 37.763233506694 -122.454210015753 (37.763233506694, -122.454210015753)
95092 93874 Significant Tree 6 Pistacia chinensis :: Chinese Pistache 150 2614 Sacramento St   Front Yard : 25 Tree 1 Private 1   04/14/2010 12:00:00 AM     Permit Number 53370 6002291.0 2115777.0 37.789649322620896 -122.43593231943599 (37.7896493226209, -122.435932319436)
101905 97139 Undocumented 2 Juniperus chinensis :: Juniper 19 937 Goettingen St   Front Yard : 25 Landscaping 2 Private 1           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644)
104145 101810 Significant Tree 6 Tree(s) :: 17 38 Nebraska St 1 Front Yard : 25 Tree 1 Private 1   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261908999 (37.740765720819, -122.41052261909)
104638 101202 Significant Tree 6 Tree(s) :: 17 7070 California St 1 Front Yard : 25 Tree 1 Private 1   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
109889 93903 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 546 Page St   Front Yard : 25 Tree 1 Private 1           6003947.0 2109752.0 37.773200107256606 -122.42977281454901 (37.7732001072566, -122.429772814549)
110409 98703 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 7070@ 32nd Ave California St 4 Front Yard : 25 Tree 1 Private 1   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
116206 103477 Significant Tree 6 Tree(s) :: 17 875 El Camino Del Mar 1 Front Yard : 25 Tree 1 Private 1   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739)
117221 94066 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 161 548 Page St   Front Yard : 25 Tree 1 Private 1   06/02/2010 12:00:00 AM     Permit Number 53460 6003937.0 2109751.0 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526)
122098 101203 Significant Tree 6 Tree(s) :: 17 7070 California St 2 Front Yard : 25 Tree 1 Private 1   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427)
126156 98308 Significant Tree 6 Tree(s) :: 17 1490 Fairfax Ave 1 Front Yard : 25 Tree 1 Private 1   01/25/2012 12:00:00 AM   3x3 Permit Number 768575 6016246.6 2097899.9 37.7413455620636 -122.386399955147 (37.7413455620636, -122.386399955147)
129210 95985 Significant Tree 6 Juniperus chinensis :: Juniper 19 577 Sanchez St 1 Front Yard : 25 Tree 1 Private 1           6003673.0 2104901.0 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168)
159181 98310 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 1499@Newhall Evans Ave 2 Front Yard : 25 Tree 1 Private 1   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.2738099997 37.7417009175609 -122.38640138991501 (37.7417009175609, -122.386401389915)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 49.415ms · Data source: data.sfgov.org