Street_Tree_List

Data source: data.sfgov.org

21 rows where PlotSize = "Width 0ft" and qSpecies = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, qSiteInfo

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25420 25420 185893 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2000 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985001.2813 2101166.1106 37.748534597155704 -122.49467449717399 (37.7485345971557, -122.494674497174)
39126 39126 184014 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1600 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984965.7137 2103757.8086 37.755648605544295 -122.494988561115 (37.7556486055443, -122.494988561115)
47090 47090 181401 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1500 Sunset Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984931.8298 2104672.7619 37.758158829946 -122.495173208442 (37.758158829946, -122.495173208442)
52395 52395 186279 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984978.0469 2102499.6631 37.752194806922 -122.494853149984 (37.752194806922, -122.494853149984)
53924 53924 185395 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2300 Sunset Blvd 7 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985077.1425 2098975.4486 37.7425240740104 -122.494250726815 (37.7425240740104, -122.494250726815)
55315 55315 183955 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2100 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985033.6446 2100586.6805 37.746945534293 -122.494519878447 (37.746945534293, -122.494519878447)
60439 60439 185423 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2300 Sunset Blvd 39 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985071.643999999 2099284.3632 37.7433719482454 -122.494292503743 (37.7433719482454, -122.494292503743)
60595 60595 183954 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2100 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985054.4746 2100602.91 37.746991315173794 -122.494449047407 (37.7469913151738, -122.494449047407)
63529 63529 187142 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984897.1125 2099461.8744 37.7438491307401 -122.494909065698 (37.7438491307401, -122.494909065698)
64387 64387 187161 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984952.2414 2099389.4695 37.7436535534966 -122.494713108664 (37.7436535534966, -122.494713108664)
66439 66439 187150 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984947.2414 2099450.3955 37.74382054712321 -122.494734888113 (37.7438205471232, -122.494734888113)
67097 67097 187153 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2301 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984906.5006 2099427.4325 37.7437551121762 -122.494874065391 (37.7437551121762, -122.494874065391)
69553 69553 186176 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1700 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984967.0954 2103538.8321 37.755047437501 -122.49496763736 (37.755047437501, -122.49496763736)
73259 73259 185895 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2000 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985036.6346 2101201.464 37.748633737152296 -122.49455485368799 (37.7486337371523, -122.494554853688)
130897 130897 186280 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985011.8758 2102500.8713 37.7522001044765 -122.494736255211 (37.7522001044765, -122.494736255211)
132070 132070 181429 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1500 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984933.5007 2104844.5838 37.7586307029356 -122.495180100301 (37.7586307029356, -122.495180100301)
147449 147449 186314 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984957.5078 2102814.9976 37.7530594263796 -122.494947425095 (37.7530594263796, -122.494947425095)
148559 148559 184085 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1600 Sunset Blvd 86 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984928.3026 2104071.5069 37.756507744074604 -122.495141070042 (37.7565077440746, -122.495141070042)
167100 167100 186055 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1901 Sunset Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984800.4513 2102206.1385 37.751378471683005 -122.495445647673 (37.751378471683, -122.495445647673)
169988 169988 183953 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 2100 Sunset Blvd 41 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985069.1522 2100584.5154 37.74694166760111 -122.49439693858 (37.7469416676011, -122.49439693858)
185669 185669 186313 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1800 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984992.9477 2102798.4858 37.753016164086205 -122.494823651515 (37.7530161640862, -122.494823651515)

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