Street_Tree_List

Data source: data.sfgov.org

11 rows where qSiteInfo = 2 and qSpecies = 94

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 11 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25337 25337 250803 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 283 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 4ft   5986183.75415 2114029.47113 37.7839229338472 -122.491532293599 (37.7839229338472, -122.491532293599)
31967 31967 224626 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 601 Buena Vista Ave West 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999843.00884 2107568.58853 37.7669717582745 -122.443812120926 (37.7669717582745, -122.443812120926)
67463 67463 176433 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 118 Chester Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5991720.02905 2088438.7014799998 37.7139792884876 -122.470514566313 (37.7139792884876, -122.470514566313)
72099 72099 250802 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 283 31st Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5986182.86321 2114039.35976 37.7839500331106 -122.491536104007 (37.7839500331106, -122.491536104007)
136604 136604 224627 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 601 Buena Vista Ave West 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5999834.58358 2107589.10397 37.767027607963904 -122.443842736578 (37.7670276079639, -122.443842736578)
148290 148290 176417 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 825 Lisbon St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6001125.807159999 2088973.54213 37.7159872246076 -122.438043004189 (37.7159872246076, -122.438043004189)
155045 155045 224625 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 50 Piedmont St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5999457.54578 2107020.99028 37.7654461969099 -122.44510599986602 (37.7654461969099, -122.445105999866)
173633 173633 224486 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 12 Lundys Ln 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 2ft   6007182.48369 2099609.18315 37.7455329629926 -122.417861705765 (37.7455329629926, -122.417861705765)
181204 181204 176413 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 816 Lisbon St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6001088.39895 2089005.3588599998 37.7160724587542 -122.43817458219999 (37.7160724587542, -122.4381745822)
184163 184163 176435 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 275 De Long St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 10ft   5993714.58235 2086792.86785 37.7095753489021 -122.46350132202299 (37.7095753489021, -122.463501322023)
187775 187775 250901 Undocumented 2 Ficus microcarpa :: Chinese Banyan 94 262 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5986843.4258 2114179.11857 37.784372351133 -122.489261109739 (37.784372351133, -122.489261109739)

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