Street_Tree_List

Data source: data.sfgov.org

17 rows where DBH = 6 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

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

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
15209 15209 19838 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60X            
17045 17045 19792 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY19 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 20ST            
32095 32095 224121 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452)
36817 36817 176286 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 901 Delano Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   5998666.60141 2089601.1299700001 37.7175702751322 -122.446588269645 (37.7175702751322, -122.446588269645)
37182 37182 143060 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 444 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6010718.0238 2120346.7181 37.80267177317779 -122.407097773383 (37.8026717731778, -122.407097773383)
37671 37671 176274 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 775 London St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6000713.865119999 2089358.3764799999 37.7170204575094 -122.439494437135 (37.7170204575094, -122.439494437135)
39445 39445 224131 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1340 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009255.1331 2101276.97976 37.7502287892492 -122.41081254437799 (37.7502287892492, -122.410812544378)
47316 47316 126572 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1001 Vallejo St 5 Front Yard : Yard 7 Tree 1 Private 1     6     6008680.36365 2118649.32289 37.7978969073709 -122.414028979559 (37.7978969073709, -122.414028979559)
50631 50631 191693 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2212 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6012143.16846 2101895.7398 37.752089281506706 -122.400868941954 (37.7520892815067, -122.400868941954)
55102 55102 191686 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1301 Minnesota St 14 Front Yard : Yard 7 Tree 1 Private 1     6     6015385.377169999 2102357.3727700002 37.7535371423304 -122.38968904242701 (37.7535371423304, -122.389689042427)
67005 67005 191705 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1700 Armstrong Ave 3 Side Yard : Yard 17 Tree 1 Private 1     6     6013900.77828 2092879.68746 37.727430958252604 -122.394159667654 (37.7274309582526, -122.394159667654)
72590 72590 249863 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 233 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     6 Width 0ft   6011630.0308300005 2120434.01589 37.8029624665125 -122.40394789778799 (37.8029624665125, -122.403947897788)
133017 133017 224114 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 70 Front Yard : Yard 7 Tree 1 Private 1     6     6004687.50549 2096549.1812200001 37.736990167061 -122.42627113673001 (37.736990167061, -122.42627113673)
154979 154979 224128 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 18 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5999679.40978 2101490.53022 37.750273576386704 -122.443941232111 (37.7502735763867, -122.443941232111)
170332 170332 191688 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 800 19th St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6014977.94549 2105331.22601 37.761680105066105 -122.39130591015 (37.7616801050661, -122.39130591015)
186390 186390 62603 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 792 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 6   Permit Number 22911 5984491.42084 2110500.08946 37.7741332293959 -122.497126446837 (37.7741332293959, -122.497126446837)
187509 187509 191704 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 3 Front Yard : Yard 7 Tree 1 Private 1     6 Width 4ft   6013263.69136 2096352.02038 37.736929838751294 -122.396605400918 (37.7369298387513, -122.396605400918)

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