Street_Tree_List

Data source: data.sfgov.org

22 rows where SiteOrder = 13 and qSpecies = 32

✎ View and edit SQL

This data as json, CSV (advanced)

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

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29482 29482 128425 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 555 California St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6011770.64614 2116698.01908 37.7927121754866 -122.403198334431 (37.7927121754866, -122.403198334431)
41170 41170 126717 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2350 Green St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6001632.11762 2118051.74254 37.7958577234076 -122.438375018588 (37.7958577234076, -122.438375018588)
54585 54585 192117 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 367 Tehama St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011557.32481 2112660.98946 37.781615529763705 -122.403652263664 (37.7816155297637, -122.403652263664)
56712 56712 190216 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 121 Main St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6013858.93345 2116683.31017 37.792788191571 -122.395971690938 (37.792788191571, -122.395971690938)
60628 60628 112709 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 100 North Point St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 3x3   6009982.61169 2121986.87678 37.8071340590486 -122.409758521838 (37.8071340590486, -122.409758521838)
62530 62530 189709 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 4ft   6012645.7874300005 2105024.7394 37.760708853455704 -122.399350438495 (37.7607088534557, -122.399350438495)
64432 64432 189622 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1022 Harrison St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 0ft   6010815.005059999 2110468.41734 37.7755537439388 -122.406065837194 (37.7755537439388, -122.406065837194)
64470 64470 128677 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 250 Washington St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6013274.45075 2117959.00066 37.7962584010691 -122.39808357702 (37.7962584010691, -122.39808357702)
71225 71225 192131 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 807 Mission St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6011287.52807 2113553.9917200003 37.784052429914496 -122.404648520918 (37.7840524299145, -122.404648520918)
73532 73532 224419 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Treat Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 4ft   6008550.92068 2106134.213 37.7635261371397 -122.41359126333 (37.7635261371397, -122.41359126333)
74429 74429 117416 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 Beach St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6010137.827269999 2122299.49705 37.8080011332052 -122.409243437841 (37.8080011332052, -122.409243437841)
86980 86980 454 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 740X 23rd Ave 13 Median : Cutout 11 Tree 1 DPW 2     12 8-HOA   5988822.540159999 2110230.27386 37.7736452554339 -122.482124750469 (37.7736452554339, -122.482124750469)
91225 91225 102347 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401X Shotwell St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6007842.0 2105589.3 37.7619900992271 -122.416004610168 (37.7619900992271, -122.416004610168)
135473 135473 128139 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2600 Jones St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007843.1671400005 2121954.12395 37.8069240026131 -122.417160222869 (37.8069240026131, -122.417160222869)
137461 137461 128179 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 211 Beach St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009178.9677099995 2122171.51863 37.8075959706319 -122.41255277389601 (37.8075959706319, -122.412552773896)
150764 150764 190185 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 91 Spear St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6014134.54859 2116822.4237599997 37.793185494956205 -122.395027791311 (37.7931854949562, -122.395027791311)
162083 162083 190252 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 60 New Montgomery St 13 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6012311.13686 2114949.13545 37.787940324123895 -122.40120525333201 (37.7879403241239, -122.401205253332)
164217 164217 128281 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 55 Francisco St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   6011166.44271 2121400.19755 37.8055894527535 -122.405620252789 (37.8055894527535, -122.405620252789)
174903 174903 247035 DPW Maintained 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 550x Valley St 13 Median : Yard 3 Tree 1 DPW 2     13     6002263.72164 2099154.77603 37.7440072235471 -122.434837508343 (37.7440072235471, -122.434837508343)
178329 178329 128582 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 401 Washington St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6013142.92236 2117888.29945 37.7960569457318 -122.39853373176001 (37.7960569457318, -122.39853373176)
178819 178819 128701 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 300 Washington St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6012701.41446 2117879.31888 37.796007680862495 -122.400060814761 (37.7960076808625, -122.400060814761)
179345 179345 190165 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 70 Steuart St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6014495.0412099995 2116963.1449599997 37.7935919219713 -122.393790308884 (37.7935919219713, -122.393790308884)

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