Paste number 39917: shp2pgsql

Paste number 39917: shp2pgsql
Pasted by: stefan postgis
When:2 years, 2 months ago
Share:Tweet this! | http://paste.lisp.org/+UST
Channel:None
Paste contents:
Raw Source | XML | Display As
BEGIN;
CREATE TABLE "public"."_g24" (gid serial PRIMARY KEY,
"ID" int8,
"FEATTYP" int2,
"FT" int2,
"F_JNCTID" int8,
"F_JNCTTYP" int2,
"T_JNCTID" int8,
"T_JNCTTYP" int2,
"PJ" int2,
"METERS" float8,
"FRC" int2,
"NETCLASS" int2,
"NETBCLASS" int2,
"NET2CLASS" int2,
"NAME" varchar(70),
"NAMELC" varchar(3),
"SOL" int2,
"NAMETYP" varchar(2),
"CHARGE" varchar(2),
"ROUTENUM" varchar(10),
"RTETYP" int2,
"RTEDIR" varchar(2),
"RTEDIRVD" varchar(2),
"PROCSTAT" int2,
"FOW" int2,
"SLIPRD" int2,
"FREEWAY" int2,
"BACKRD" int2,
"TOLLRD" varchar(2),
"RDCOND" int2,
"STUBBLE" int2,
"PRIVATERD" int2,
"CONSTATUS" varchar(2),
"ONEWAY" varchar(2),
"F_BP" int2,
"T_BP" int2,
"F_ELEV" int2,
"T_ELEV" int2,
"KPH" int2,
"MINUTES" float8,
"POSACCUR" int2,
"CARRIAGE" varchar(1),
"LANES" int2);
SELECT AddGeometryColumn('public','_g24','the_geom','4326','MULTILINESTRING',2);
CREATE INDEX "_g24_the_geom_gist" ON "public"."_g24" using gist ("the_geom" gist_geometry_ops);
COPY "public"."_g24" ("ID","FEATTYP","FT","F_JNCTID","F_JNCTTYP","T_JNCTID","T_JNCTTYP","PJ","METERS","FRC","NETCLASS","NETBCLASS","NET2CLASS","NAME","NAMELC","SOL","NAMETYP","CHARGE","ROUTENUM","RTETYP","RTEDIR","RTEDIRVD","PROCSTAT","FOW","SLIPRD","FREEWAY","BACKRD","TOLLRD","RDCOND","STUBBLE","PRIVATERD","CONSTATUS","ONEWAY","F_BP","T_BP","F_ELEV","T_ELEV","KPH","MINUTES","POSACCUR","CARRIAGE","LANES",the_geom) FROM stdin;
512760001147050	4110	0	512760200017359	0	512760200947163	0	0	310	8	0	0	6	\N	\N	0	\N	\N	\N	0	\N	\N	1	15	0	0	0	\N	2	0	0	\N	N	0	0	0	0	15	1.067	0	\N	0	SRID=4326;010500000001000000010200000012000000CCD77624A85F2840DA37F7578F7F4840203B6F63B35F2840B61C9E149C7F4840203B6F63B35F2840B61C9E149C7F4840A403A3DCC75F2840FF42EAD1AF7F4840948C41CCCA5F28401BEEC8FDB37F48407453B93FCD5F2840E42ABB05B77F484054D27943D05F28401C7343F8BC7F484064111EC8D55F284001E54A98C47F484098D6F03ED85F28409A6F8E84C77F484060F93DFBDB5F28409807FA55CA7F48401CCAF55BE05F2840C7511443CD7F48405C59EC40E75F284066998FB5D07F4840BC56314BF15F284027B1B508D67F4840A4E7CC2CF85F2840255D8EB2D97F48400418E0CCF95F28409B6D1393DC7F4840982DA3A2FB5F2840F3226EA9DE7F4840FCF21318FC5F2840158B845BE37F4840DC291DACFF5F28401245926AE97F4840

and so on ...

BEGIN;
COPY "public"."_g24" ("ID","FEATTYP","FT","F_JNCTID","F_JNCTTYP","T_JNCTID","T_JNCTTYP","PJ","METERS","FRC","NETCLASS","NETBCLASS","NET2CLASS","NAME","NAMELC","SOL","NAMETYP","CHARGE","ROUTENUM","RTETYP","RTEDIR","RTEDIRVD","PROCSTAT","FOW","SLIPRD","FREEWAY","BACKRD","TOLLRD","RDCOND","STUBBLE","PRIVATERD","CONSTATUS","ONEWAY","F_BP","T_BP","F_ELEV","T_ELEV","KPH","MINUTES","POSACCUR","CARRIAGE","LANES",the_geom) FROM stdin;
522760003221743	4110	0	100000000005583	0	522760200562014	0	0	193	7	0	0	5	\N	\N	0	\N	\N	\N	0	\N	\N	1	3	0	0	3	\N	1	0	0	\N	\N	0	0	0	0	35	0.291	0	\N	0	SRID=4326;01050000000100000001020000000D000000D4D74EEF3DDB2540E8C715CDB9E24840A898DE5916DB25408871EDFABBE24840A898DE5916DB25408871EDFABBE24840FCC7F8E6EDDA254010F39B78BDE248400C5641B1BADA25404B051555BFE24840BC929A2CA4DA25408C362273C0E2484080069B3A8FDA25407997E6B1C1E2484054698B6B7CDA25408AA07B20C3E24840BCE93B646FDA2540C528BE90C4E248403471BC4C5EDA2540B2F913F0C6E24840A8D370804FDA2540109AB8B0C9E248402469DC4026DA2540A13B7771D1E24840D08D55EF15DA2540828C2551D4E24840

This paste has no annotations.

Colorize as:
Show Line Numbers

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.