Street_Tree_List

Data source: data.sfgov.org

17 rows where DBH = 30, qSiteInfo = 3 and qSpecies = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24494 24494 233935 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 150x Dolores St 9 Median : Yard 3 Tree 1 DPW 2     30     6004826.52958 2107279.95522 37.766462234780604 -122.426554344032 (37.7664622347806, -122.426554344032)
27329 27329 194334 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 10 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993)
29064 29064 194335 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 11 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015932.5598 2112347.87113 37.7809992081901 -122.38849403588999 (37.7809992081901, -122.38849403589)
29492 29492 194379 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015888.45756 2115624.95631 37.7899948982019 -122.388875463533 (37.7899948982019, -122.388875463533)
35368 35368 194364 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016200.86003 2114659.13107 37.78736027221179 -122.387727152497 (37.7873602722118, -122.387727152497)
42530 42530 194380 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015792.97899 2115653.31942 37.79006748427221 -122.38920779542102 (37.7900674842722, -122.389207795421)
55101 55101 194331 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 7 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015869.7392 2112229.4323400003 37.7806705203569 -122.388703094985 (37.7806705203569, -122.388703094985)
61273 61273 194336 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 12 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015966.10007 2112335.54697 37.7809672274079 -122.38837714201799 (37.7809672274079, -122.388377142018)
69876 69876 194371 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016101.395269999 2115134.80634 37.7886608582508 -122.388104490939 (37.7886608582508, -122.388104490939)
70483 70483 194365 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016199.77941 2114766.14566 37.7876540501504 -122.38773836074199 (37.7876540501504, -122.387738360742)
119303 119303 194372 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016142.80175 2115153.3259099997 37.788714002784296 -122.387962522166 (37.7887140027843, -122.387962522166)
130735 130735 194346 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016057.40985 2113028.64004 37.782875364847705 -122.388109635977 (37.7828753648477, -122.388109635977)
155383 155383 194338 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 14 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015989.55415 2112403.0150099997 37.781153779156206 -122.388300712233 (37.7811537791562, -122.388300712233)
162596 162596 194326 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015764.48229 2112042.08861 37.7801502823482 -122.38905414805599 (37.7801502823482, -122.389054148056)
166815 166815 194285 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 28 Median : Yard 3 Tree 1 DPW 2     30     6014471.94536 2095201.4069599998 37.7338376601657 -122.39234744377701 (37.7338376601657, -122.392347443777)
177827 177827 234351 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 600x Dolores St 3 Median : Yard 3 Tree 1 DPW 2     30     6004966.99113 2104720.1905900002 37.759441669116796 -122.425886285347 (37.7594416691168, -122.425886285347)
183458 183458 194358 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016102.75205 2114084.3299 37.7857765633769 -122.388026462162 (37.7857765633769, -122.388026462162)

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