home / trees

Street_Tree_List

Data source: data.sfgov.org

16 rows where qSiteInfo = 12

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantType, PlantDate, DBH, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
1055 101202 Significant Tree 4 Tree(s) :: 13 7070 California St 1 Front Yard : 12 Tree 1 Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427) 11 6 1 55 33
1056 101203 Significant Tree 4 Tree(s) :: 13 7070 California St 2 Front Yard : 12 Tree 1 Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427) 11 6 1 55 33
1596 101810 Significant Tree 4 Tree(s) :: 13 38 Nebraska St 1 Front Yard : 12 Tree 1 Private 2   11/22/2012 12:00:00 AM     Permit Number 769374 6009268.6 2097830.3 37.740765720819 -122.41052261908999 (37.740765720819, -122.41052261909) 10 7 7 28859 2
3113 103477 Significant Tree 4 Tree(s) :: 13 875 El Camino Del Mar 1 Front Yard : 12 Tree 1 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
185851 93874 Significant Tree 4 Pistacia chinensis :: Chinese Pistache 67 2614 Sacramento St   Front Yard : 12 Tree 1 Private 2   04/14/2010 12:00:00 AM     Permit Number 53370 6002291.0 2115777.0 37.789649322620896 -122.43593231943599 (37.7896493226209, -122.435932319436) 13 6 1 29490 27
185880 93903 Significant Tree 4 Washingtonia robusta :: Mexican Fan Palm 86 546 Page St   Front Yard : 12 Tree 1 Private 2           6003947.0 2109752.0 37.773200107256606 -122.42977281454901 (37.7732001072566, -122.429772814549) 7 9 11 29492 10
186004 94066 Significant Tree 4 Palm (unknown Genus) :: Palm Spp 2 548 Page St   Front Yard : 12 Tree 1 Private 2   06/02/2010 12:00:00 AM     Permit Number 53460 6003937.0 2109751.0 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526) 7 9 11 29492 10
186987 95137 Significant Tree 4 Tree(s) :: 13 2130 Fulton St 127 Front Yard : 12 Tree 1 Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590.0 2110608.0 37.7751884337973 -122.45182417211599 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
186988 95138 Significant Tree 4 Tree(s) :: 13 2130 Fulton St 128 Front Yard : 12 Tree 1 Private 2   01/07/2011 12:00:00 AM   3x3 Permit Number 54069 5997590.0 2110608.0 37.7751884337973 -122.45182417211599 (37.7751884337973, -122.451824172116) 15 5 2 29492 16
187844 95985 Significant Tree 4 Juniperus chinensis :: Juniper 94 577 Sanchez St 1 Front Yard : 12 Tree 1 Private 2           6003673.0 2104901.0 37.7598649162805 -122.430374442168 (37.7598649162805, -122.430374442168) 2 4 5 28862 3
188859 97139 DPW Maintained 1 Juniperus chinensis :: Juniper 94 937 Goettingen St   Front Yard : 12 Landscaping 2 Private 2           6011052.0 2090410.0 37.720490952554606 -122.40383424464399 (37.7204909525546, -122.403834244644) 10 7 8 309 28
189899 98308 Significant Tree 4 Tree(s) :: 13 1490 Fairfax Ave 1 Front Yard : 12 Tree 1 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
189900 98309 Significant Tree 4 Pyrus kawakamii :: Evergreen Pear 65 401X Newhall St 1 Front Yard : 12 Tree 1 Private 2     6 3x3   6016081.14502 2097910.9401599998 37.741366715992896 -122.386972815546 (37.7413667159929, -122.386972815546) 10 3 8 58 1
189902 98310 Significant Tree 4 Ginkgo biloba :: Maidenhair Tree 49 1499@Newhall Evans Ave 2 Front Yard : 12 Tree 1 Private 2   01/25/2012 12:00:00 AM 4   Permit Number 768575 6016248.7932 2098029.2738099997 37.7417009175609 -122.38640138991501 (37.7417009175609, -122.386401389915) 10 3 8 58 1
190281 98703 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 7070@ 32nd Ave California St 4 Front Yard : 12 Tree 1 Private 2   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.49337605842699 (37.7850123376907, -122.493376058427) 11 6 1 55 33
190860 99299 Significant Tree 4 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 162 1457 Willard St 1 Front Yard : 12 Tree 1 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

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 83.878ms · Data source: data.sfgov.org