Street_Tree_List

Data source: data.sfgov.org

18 rows where SiteOrder = 14 and qSpecies = 32

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3628 3628 127357 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2100 Webster St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2017 12:00:00 AM 3 Width 4ft   6003276.2668 2116362.2656799997 37.791312234126295 -122.432565221033 (37.7913122341263, -122.432565221033)
33228 33228 224420 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Treat Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008554.675480001 2106165.5358700003 37.7636123533609 -122.41358049213999 (37.7636123533609, -122.41358049214)
54843 54843 128426 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011789.8061 2116700.43731 37.7927198853778 -122.40313220998199 (37.7927198853778, -122.403132209982)
55750 55750 126634 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2800 Divisadero St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 6ft   6000614.8529199995 2118015.66138 37.7957007404413 -122.44189234447501 (37.7957007404413, -122.441892344475)
56918 56918 190166 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 70 Steuart St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6014549.85525 2116906.5438099997 37.7934395543337 -122.393596683051 (37.7934395543337, -122.393596683051)
76452 76452 192132 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 807 Mission St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 4ft   6011323.05989 2113588.9922599997 37.7841505189681 -122.40452805764299 (37.7841505189681, -122.404528057643)
116178 116178 453 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 740X 23rd Ave 14 Median : Cutout 11 Tree 1 DPW 2     12     5988823.177519999 2110218.88788 37.773614029759706 -122.482121711467 (37.7736140297597, -122.482121711467)
132581 132581 128702 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 300 Washington St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6012674.0223199995 2117875.6899200003 37.7959961893179 -122.400155342505 (37.7959961893179, -122.400155342505)
137284 137284 189677 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 14 : Yard 23 Tree 1 Private 1     9     6017255.58244 2102660.6719 37.754473466102795 -122.38324251223801 (37.7544734661028, -122.383242512238)
155526 155526 190186 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6014146.05348 2116808.04145 37.7931466442461 -122.394986975567 (37.7931466442461, -122.394986975567)
162286 162286 128180 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 211 Beach St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009206.52491 2122174.9503099998 37.80760693967 -122.41245764811801 (37.80760693967, -122.412457648118)
166212 166212 189710 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6012645.571 2105014.07683 37.7606795643282 -122.39935043848999 (37.7606795643282, -122.39935043849)
166467 166467 127210 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2332 Baker St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5999778.1743 2116971.1510799997 37.7927850799155 -122.44471227935699 (37.7927850799155, -122.444712279357)
167139 167139 128583 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6013161.5163900005 2117889.9024400003 37.7960623830203 -122.39846950485901 (37.7960623830203, -122.398469504859)
174941 174941 112710 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 100 North Point St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6009944.989709999 2121981.1208599997 37.8071161463469 -122.40988831469 (37.8071161463469, -122.40988831469)
175943 175943 190110 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 201 Utah St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6010609.78055 2107275.1616 37.7667743175026 -122.40655069138799 (37.7667743175026, -122.406550691388)
182898 182898 190217 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6013852.83638 2116693.6107400004 37.7928161353103 -122.395993509389 (37.7928161353103, -122.395993509389)
186430 186430 128282 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Francisco St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011187.65635 2121403.39656 37.805599422647205 -122.40554706506201 (37.8055994226472, -122.405547065062)

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