Street_Tree_List

Data source: data.sfgov.org

18 rows where qSiteInfo = 22

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, PlantDate, DBH, 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
21240 95973 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6100 Geary Blvd 2 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5988036.984 2112655.97284 37.780259822750295 -122.48502007741101 (37.7802598227503, -122.485020077411)
22824 251112 Landmark tree 9 Phoenix canariensis :: Canary Island Date Palm 100 1700X Quesada Ave 14 Median : 22 Tree 1 DPW 2                    
74201 103698 DPW Maintained 3 Palm (unknown Genus) :: Palm Spp 161 1306 Montgomery St 1 Median : 22 Tree 1 DPW 2     24     6011461.604719999 2119835.9957 37.8013110378213 -122.404488622371 (37.8013110378213, -122.404488622371)
78258 95981 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6800 Geary Blvd 2 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5985845.243869999 2112512.8777799997 37.7797390169842 -122.492591667736 (37.7797390169842, -122.492591667736)
79525 95976 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6300 Geary Blvd 8 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5987433.277530001 2112645.56538 37.7801960637602 -122.487107784765 (37.7801960637602, -122.487107784765)
80640 95966 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 5500 Geary Blvd 1 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2     5989915.47138 2112737.13311 37.780591904899104 -122.478527531838 (37.7805919048991, -122.478527531838)
85995 95969 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5600 Geary Blvd 4 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2     5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591)
87711 91236 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 804 Guerrero St 1 Median : 22 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3 3x100   6005614.0 2104300.0 37.758324467407704 -122.423618732861 (37.7583244674077, -122.423618732861)
90310 95970 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 5700 Geary Blvd 2 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5989285.66195 2112703.31658 37.780462469008896 -122.480703841334 (37.7804624690089, -122.480703841334)
92602 95971 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5900 Geary Blvd 5 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2     5988665.62185 2112680.2165599996 37.7803629858967 -122.482847132605 (37.7803629858967, -122.482847132605)
98676 95965 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5400 Geary Blvd 1 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2     5990210.87302 2112736.64328 37.7806077057511 -122.47750557201701 (37.7806077057511, -122.477505572017)
99563 95974 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6100 Geary Blvd 13 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5988036.984 2112655.97284 37.780259822750295 -122.48502007741101 (37.7802598227503, -122.485020077411)
100250 95977 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6400 Geary Blvd 2 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5987191.92688 2112582.17224 37.780007928322 -122.487938057094 (37.780007928322, -122.487938057094)
104582 95964 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5200 Geary Blvd 6 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM       5990756.89162 2112756.21837 37.780693122390204 -122.47561808245399 (37.7806931223902, -122.475618082454)
111342 95979 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6500 Geary Blvd 6 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5986883.76294 2112568.0929 37.779951289394205 -122.489003085019 (37.7799512893942, -122.489003085019)
114989 95975 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6300 Geary Blvd 1 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 1     5987433.277530001 2112645.56538 37.7801960637602 -122.487107784765 (37.7801960637602, -122.487107784765)
119612 96804 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1200X Revere Ave 1 Median : 22 Tree 1 DPW 2           6017205.4 2092876.1 37.7276042330013 -122.38273521775801 (37.7276042330013, -122.382735217758)
122416 95968 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5600 Geary Blvd 2 Median : 22 Tree 1 DPW 2   03/12/2011 12:00:00 AM 2     5989606.68558 2112715.06065 37.7805133679778 -122.479594141591 (37.7805133679778, -122.479594141591)

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 42.444ms · Data source: data.sfgov.org