Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 2 and qSpecies = 199

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
30147 30147 227061 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 800 Alvarado St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001153.3216699995 2102624.46205 37.75347104667021 -122.438925612327 (37.7534710466702, -122.438925612327)
30485 30485 227075 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 1720 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003949.62803 2098226.14791 37.741552998869295 -122.42894183272301 (37.7415529988693, -122.428941832723)
45749 45749 227069 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 880 Church St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004326.63425 2103721.26686 37.7566626515725 -122.42802976997 (37.7566626515725, -122.42802976997)
65370 65370 227064 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 4441 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6001211.68109 2104631.03803 37.7589839384659 -122.438867577298 (37.7589839384659, -122.438867577298)
66352 66352 176873 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 34 Kelloch Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008389.4363 2086207.95793 37.7088039104301 -122.412740993025 (37.7088039104301, -122.412740993025)
68137 68137 139627 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 1911 EDDY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6001197.3517 2112443.2085 37.7804333986461 -122.439477144015 (37.7804333986461, -122.439477144015)
70508 70508 191215 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 695 Wisconsin St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   6012749.19171 2104260.69013 37.758616704812496 -122.398939180317 (37.7586167048125, -122.398939180317)
134020 134020 176869 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 466 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 1ft   6001971.78547 2090916.90643 37.7213713443005 -122.435257834404 (37.7213713443005, -122.435257834404)
147129 147129 42951 Permitted Site 1 Lagerstroemia indica :: Crape Myrtle 199 454 Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 2   Permit Number 42844 6010612.89233 2106188.0109099997 37.7637894226584 -122.406463315032 (37.7637894226584, -122.406463315032)
148590 148590 227067 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 880 Church St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004324.426109999 2103760.8259900003 37.75677114668179 -122.428040225476 (37.7567711466818, -122.428040225476)
149825 149825 227070 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 3600 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004299.63219 2103676.28895 37.75653762513971 -122.428119947672 (37.7565376251397, -122.428119947672)
151843 151843 97782 Permitted Site 1 Lagerstroemia indica :: Crape Myrtle 199 1616 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/2010 12:00:00 AM 2 3x3 Permit Number 56445 6013154.51165 2104761.54844 37.760014529165296 -122.39757251837099 (37.7600145291653, -122.397572518371)
153420 153420 129363 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 2936 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001041.88573 2118458.1197099998 37.7969399387778 -122.44044648643299 (37.7969399387778, -122.440446486433)
156198 156198 186879 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 2700 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985177.7993 2096457.4623 37.7356162487584 -122.49371718453101 (37.7356162487584, -122.493717184531)
158758 158758 227066 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 880 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004322.18511 2103780.44049 37.7568248766824 -122.42804937340401 (37.7568248766824, -122.428049373404)
177767 177767 227068 Undocumented 2 Lagerstroemia indica :: Crape Myrtle 199 880 Church St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004327.06054 2103741.95573 37.7567194824462 -122.428029769971 (37.7567194824462, -122.428029769971)

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