337
edits
Changes
Jump to navigation
Jump to search
→Uploading TIF Data onto database (tigertest)
=Uploading TIF Data onto database (tigertest)=
== Uploading KML file ==
researcher@McNairDBServ:/bulk/tigertest$ ogr2ogr -f PostgreSQL PG:"dbname=tigertest" chicagotif.kml -nln chicagotif
(chicagotif.kml is the name of the KML file and chicagotif is the name I wish to name the table)
== Cities & Tables ==
=== Chicago ===
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
--------------+--------------------------+-----------+----------+---------------------------------------------+----------+--------------+-------------
ogc_fid | integer | | not null | nextval('chicagotif_ogc_fid_seq'::regclass) | plain | |
wkb_geometry | geometry(Geometry,4326) | | | | main | |
name | character varying | | | | extended | |
description | character varying | | | | extended | |
timestamp | timestamp with time zone | | | | plain | |
begin | timestamp with time zone | | | | plain | |
end | timestamp with time zone | | | | plain | |
altitudemode | character varying | | | | extended | |
tessellate | integer | | | | plain | |
extrude | integer | | | | plain | |
visibility | integer | | | | plain | |
draworder | integer | | | | plain | |
icon | character varying | | | | extended | |
name_trim | character varying | | | | extended | |
show | character varying | | | | extended | |
approval_d | character varying | | | | extended | |
ref | character varying | | | | extended | |
objectid | character varying | | | | extended | |
ind | character varying | | | | extended | |
repealed_d | character varying | | | | extended | |
comm_area | character varying | | | | extended | |
wards | character varying | | | | extended | |
shape_area | character varying | | | | extended | |
sbif | character varying | | | | extended | |
shape_len | character varying | | | | extended | |
type | character varying | | | | extended | |
expiration | character varying | | | | extended | |
use | character varying | | | | extended | |
