Name: Trees
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Trees

Feature layer containing authoritative tree points for Sioux Falls, South Dakota.
Organization: City of Sioux Falls
Last updated: 2024-04-01T20:51:36.549126
Tags: lincoln, minnehaha, parks, sd, sioux-falls, south-dakota, trees

Tables

Table 1

@usgov.city_of_sioux_falls_trees_bde97.table_1

12.21 MB
81,826 rows
67 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "sitetype" VARCHAR,
  "location" VARCHAR,
  "locationname" VARCHAR,
  "fullname" VARCHAR,
  "commonname" VARCHAR,
  "genus" VARCHAR,
  "species" VARCHAR,
  "family" VARCHAR,
  "treetype" VARCHAR,
  "spread" DOUBLE,
  "height" DOUBLE,
  "diameter" DOUBLE,
  "trunks" DOUBLE,
  "condition" DOUBLE,
  "locationrating" DOUBLE,
  "landuse" VARCHAR,
  "growspace" VARCHAR,
  "utility" VARCHAR,
  "risk" VARCHAR,
  "special" VARCHAR,
  "specialcomments" VARCHAR,
  "source" VARCHAR,
  "appraise" DOUBLE,
  "conditionassesment" VARCHAR,
  "zoneid" VARCHAR,
  "installyear" DOUBLE,
  "inspector" VARCHAR,
  "lastinspecteddate" TIMESTAMP,
  "comments" VARCHAR,
  "photourl" VARCHAR,
  "address" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "datecreated" TIMESTAMP,
  "creator" VARCHAR,
  "refcode" VARCHAR,
  "managedby" VARCHAR,
  "parkdistrict" DOUBLE,
  "treatmentyear" DOUBLE,
  "treatmentapplied" VARCHAR,
  "removalyear" DOUBLE,
  "plannedplantingyear" DOUBLE,
  "project" VARCHAR,
  "painteddate" TIMESTAMP,
  "removallot" VARCHAR,
  "contractor" VARCHAR,
  "contractorcutdate" TIMESTAMP,
  "invoicenumber" VARCHAR,
  "invoicedate" TIMESTAMP,
  "ownercontactdate" TIMESTAMP,
  "ownerplan" VARCHAR,
  "blackoutdate" TIMESTAMP,
  "contractorcutnotes" VARCHAR,
  "treeid" VARCHAR,
  "siteid" DOUBLE,
  "assetid" VARCHAR,
  "globalid" VARCHAR,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "tagnumber" VARCHAR,
  "lastpruningdate" TIMESTAMP,
  "water" VARCHAR
);