Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 0ft", qCaretaker = 1 and qSpecies = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
495 495 248613 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442)
3855 3855 248614 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5997650.5459 2107506.4452 37.7666758289672 -122.451390984496 (37.7666758289672, -122.451390984496)
26304 26304 140079 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 100 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6000729.2298 2112451.4153 37.780429279749605 -122.44109718195499 (37.7804292797496, -122.441097181955)
33120 33120 249800 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 8 Front Yard : Yard 7 Tree 1 Private 1     16 Width 0ft   6010811.58408 2121055.18857 37.8046222939481 -122.406823966551 (37.8046222939481, -122.406823966551)
33977 33977 249894 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 30 Back Yard : Yard 13 Tree 1 Private 1     24 Width 0ft   6011403.76038 2120447.63681 37.802987222140395 -122.40473187458599 (37.8029872221404, -122.404731874586)
46771 46771 140080 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 102 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6000726.8608 2112462.5832 37.7804598090154 -122.441106178881 (37.7804598090154, -122.441106178881)
61728 61728 249895 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 31 Back Yard : Yard 13 Tree 1 Private 1     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639)
65833 65833 249798 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 6 Front Yard : Yard 7 Tree 1 Private 1     14 Width 0ft   6010832.73906 2121063.1197 37.8046452545423 -122.406751316639 (37.8046452545423, -122.406751316639)
74522 74522 249896 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 32 Back Yard : Yard 13 Tree 1 Private 1     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676)
127197 127197 249899 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 3 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701)
154711 154711 249797 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 5 Front Yard : Yard 7 Tree 1 Private 1     13 Width 0ft   6010839.41961 2121064.72571 37.804650038031795 -122.40672831108499 (37.8046500380318, -122.406728311085)
164715 164715 139060 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1455 Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     39 Width 0ft   5999670.4186 2113895.7324 37.7843346353185 -122.444863945857 (37.7843346353185, -122.444863945857)
169265 169265 140081 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 104 Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6000726.183999999 2112472.3974 37.7804867177527 -122.441109224562 (37.7804867177527, -122.441109224562)
171284 171284 249897 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 5 Side Yard : Yard 17 Tree 1 Private 1     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.40479885070101 (37.8030148322229, -122.404798850701)
175227 175227 140083 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6000722.7998 2112497.1022 37.7805543580623 -122.441122705034 (37.7805543580623, -122.441122705034)
185525 185525 249893 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 29 Back Yard : Yard 13 Tree 1 Private 1     13 Width 0ft   6011394.800530001 2120441.53452 37.8029699659579 -122.404762450627 (37.8029699659579, -122.404762450627)

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