Street_Tree_List

Data source: data.sfgov.org

20 rows where qSiteInfo = 4 and qSpecies = 62

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23828 23828 177148 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1100 Junipero Serra Blvd 11 : 4 Tree 1 Private 1     3 Width 0ft   5991345.1062 2088786.2704900003 37.7149119421181 -122.47183574413401 (37.7149119421181, -122.471835744134)
26172 26172 246467 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 244 Duncan St 1 : 4 Tree 1 Private 1     8 Width 4ft   6004891.34106 2099910.0636400003 37.7462299051934 -122.42580553881099 (37.7462299051934, -122.425805538811)
37080 37080 250025 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2 Peter Yorke Way 4 : 4 Tree 1 Private 1     10 Width 4ft   6005592.08729 2114239.19437 37.7856138643192 -122.424401456086 (37.7856138643192, -122.424401456086)
41550 41550 250024 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2 Peter Yorke Way 3 : 4 Tree 1 Private 1     8 Width 3ft   6005604.615069999 2114246.3062 37.785634099068496 -122.42435861956301 (37.7856340990685, -122.424358619563)
46247 46247 250029 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1398 Gough St 2 : 4 Tree 1 Private 1     7 Width 4ft   6005499.34318 2114400.53474 37.7860516273342 -122.424733805923 (37.7860516273342, -122.424733805923)
51658 51658 250023 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2 Peter Yorke Way 2 : 4 Tree 1 Private 1     7 Width 3ft   6005617.72798 2114253.53243 37.785654680956505 -122.424313766772 (37.7856546809565, -122.424313766772)
52418 52418 177149 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1100 Junipero Serra Blvd 12 : 4 Tree 1 Private 1     3 Width 0ft   5991352.53535 2088761.3617099999 37.714843978538205 -122.47180825186301 (37.7148439785382, -122.471808251863)
55138 55138 250022 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2 Peter Yorke Way 1 : 4 Tree 1 Private 1     7 Width 3ft   6005626.62253 2114259.1773 37.785670682612704 -122.424283395778 (37.7856706826127, -122.424283395778)
55261 55261 191511 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 392 04th St 2 : 4 Tree 1 Private 1     5 Width 3ft   6012652.226419999 2112454.21838 37.7811088850041 -122.399849876973 (37.7811088850041, -122.399849876973)
59345 59345 191512 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 392 04th St 3 : 4 Tree 1 Private 1     4 Width 3ft   6012624.81518 2112484.97223 37.7811917997912 -122.39994686706001 (37.7811917997912, -122.39994686706)
63797 63797 217744 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 641 Frederick St 1 : 4 Tree 1 Private 1     14 Width 4ft   5996399.257130001 2107269.94525 37.765954731152895 -122.455701855365 (37.7659547311529, -122.455701855365)
64337 64337 191513 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 392 04th St 4 : 4 Tree 1 Private 1     4 Width 3ft   6012406.963219999 2112689.0006 37.7817398664304 -122.400714869196 (37.7817398664304, -122.400714869196)
129549 129549 250027 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1388 Gough St 2 : 4 Tree 1 Private 1     6 Width 4ft   6005504.43903 2114371.51964 37.7859722468757 -122.424714110791 (37.7859722468757, -122.424714110791)
131133 131133 250130 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1377 Post St 2 : 4 Tree 1 Private 1     8 Width 4ft   6005624.52501 2114452.88232 37.786202430153395 -122.42430443452601 (37.7862024301534, -122.424304434526)
150255 150255 250129 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1377 Post St 1 : 4 Tree 1 Private 1     8 Width 4ft   6005609.22184 2114451.0225400003 37.786196459532704 -122.42435724721201 (37.7861964595327, -122.424357247212)
150577 150577 191133 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 827 Wisconsin St 2 : 4 Tree 1 Private 1     5 Width 3ft   6012775.54197 2103646.6748599997 37.7569322215662 -122.398804956499 (37.7569322215662, -122.398804956499)
157651 157651 217741 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 683 Frederick St 1 : 4 Tree 1 Private 1     10 Width 3ft   5996265.43539 2107251.80334 37.7658972375023 -122.45616340274599 (37.7658972375023, -122.456163402746)
162256 162256 177150 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1100 Junipero Serra Blvd 13 : 4 Tree 1 Private 1     3 Width 0ft   5991357.8727400005 2088731.5467 37.7147624226096 -122.471787632218 (37.7147624226096, -122.471787632218)
162304 162304 249548 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 1398 Gough St 3 : 4 Tree 1 Private 1     7 Width 4ft   6005498.68778 2114410.1852 37.78607808808621 -122.424736760212 (37.7860780880862, -122.424736760212)
188493 188493 191514 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 392 04th St 5 : 4 Tree 1 Private 1     7 Width 3ft   6012567.22578 2112551.0938 37.7813701434666 -122.40015074427099 (37.7813701434666, -122.400150744271)

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