Street_Tree_List

Data source: data.sfgov.org

22 rows where qSiteInfo = 3 and qSpecies = 46

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Median : Yard · 22 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
22840 22840 251107 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1700X Quesada Ave 1 Median : Yard 3 Tree 1 DPW 2                    
26492 26492 242374 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006546.0037 2109148.1970900004 37.771689039651896 -122.42073962714899 (37.7716890396519, -122.420739627149)
30111 30111 198501 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 900x Carolina St 13 Median : Yard 3 Tree 1 DPW 2     15     6012463.03254 2103576.30053 37.7567215715659 -122.399880796574 (37.7567215715659, -122.399880796574)
40192 40192 246545 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 12 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6005664.26886 2109539.08097 37.7727125769595 -122.423817404855 (37.7727125769595, -122.423817404855)
43669 43669 246542 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 8 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   6005675.49099 2109463.50167 37.772505687922 -122.42377321126001 (37.772505687922, -122.42377321126)
50390 50390 246538 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 4 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005690.17012 2109380.36656 37.7722782475712 -122.423716522495 (37.7722782475712, -122.423716522495)
57780 57780 246553 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 7 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6005726.464930001 2109532.06592 37.7726968262309 -122.42360176272699 (37.7726968262309, -122.423601762727)
75717 75717 246541 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 7 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005680.0153 2109440.15852 37.772441848655795 -122.423755901126 (37.7724418486558, -122.423755901126)
131030 131030 246540 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 6 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6005683.44933 2109420.77798 37.7723888282128 -122.423742644211 (37.7723888282128, -122.423742644211)
135988 135988 242371 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 90x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     6 Width 10ft   6006102.65154 2109126.4322 37.771604280331005 -122.42227166541001 (37.771604280331, -122.42227166541)
136228 136228 246554 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 8 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6005723.73891 2109547.7321 37.772739687913706 -122.423612306376 (37.7727396879137, -122.423612306376)
138030 138030 242370 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 90x McCoppin St 1 Median : Yard 3 Tree 1 DPW 2     5 Width 10ft   6006121.14049 2109126.61017 37.7716058118802 -122.422207723609 (37.7716058118802, -122.422207723609)
151969 151969 246544 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 11 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6005666.89387 2109521.5509099998 37.7726645918273 -122.42380707793998 (37.7726645918273, -122.42380707794)
155019 155019 246537 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 3 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005694.1719 2109365.05441 37.7722364299905 -122.423701591057 (37.7722364299905, -122.423701591057)
160927 160927 242373 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 1 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006573.34583 2109150.3275 37.771696430266 -122.420645200112 (37.771696430266, -122.420645200112)
166774 166774 242781 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 95x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006152.38517 2109124.27435 37.771601160584 -122.42209948031099 (37.771601160584, -122.422099480311)
175443 175443 246555 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 9 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005721.04041 2109575.32182 37.772815290316295 -122.423623602744 (37.7728152903163, -122.423623602744)
178300 178300 246552 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 6 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6005729.77249 2109512.91923 37.77264444073 -122.423588959979 (37.77264444073, -122.423588959979)
181312 181312 246539 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 5 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6005686.56992 2109401.16217 37.7723351440794 -122.423730454802 (37.7723351440794, -122.423730454802)
183718 183718 246549 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 20x Octavia St 3 Median : Yard 3 Tree 1 DPW 2     3 Width 8ft   6005737.248 2109452.9268900002 37.77248013816789 -122.423558835368 (37.7724801381679, -122.423558835368)
183804 183804 198502 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 900x Carolina St 14 Median : Yard 3 Tree 1 DPW 2     9     6012462.6007 2103568.62023 37.75670045906929 -122.399881750743 (37.7567004590693, -122.399881750743)
185473 185473 242779 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006556.42632 2109149.52189 37.77169326466979 -122.420703668659 (37.7716932646698, -122.420703668659)

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