pastebin - collaborative debugging

pastebin is a collaborative debugging tool allowing you to share and modify code snippets while chatting on IRC, IM or a message board.

This site is developed to XHTML and CSS2 W3C standards. If you see this paragraph, your browser does not support those standards and you need to upgrade. Visit WaSP for a variety of options.

yancho private pastebin - collaborative debugging tool What's a private pastebin?


Posted by Yancho on Tue 29 Jan 10:39
report abuse | download | new post

  1. -- Table: streets
  2.  
  3. -- DROP TABLE streets;
  4.  
  5. CREATE TABLE streets
  6. (
  7.   gid serial NOT NULL,
  8.   cat bigint,
  9.   stseg bigint,
  10.   stid bigint,
  11.   stname character varying(80),
  12.   dir_pre character varying(80),
  13.   dir_suf character varying(80),
  14.   stype character varying(80),
  15.   "class" bigint,
  16.   f_elev bigint,
  17.   t_elev bigint,
  18.   map character varying(80),
  19.   priv character varying(80),
  20.   frleft bigint,
  21.   toleft bigint,
  22.   frright bigint,
  23.   toright bigint,
  24.   frleft_a bigint,
  25.   toleft_a bigint,
  26.   frright_a bigint,
  27.   toright_a bigint,
  28.   stateroad bigint,
  29.   cartoname character varying(80),
  30.   corp character varying(80),
  31.   speed bigint,
  32.   one_way character varying(80),
  33.   classname character varying(80),
  34.   l_zipname character varying(80),
  35.   r_zipname character varying(80),
  36.   ft_cost numeric,
  37.   tf_cost numeric,
  38.   labelname character varying(80),
  39.   f_node bigint,
  40.   t_node bigint,
  41.   cartolevel character varying(80),
  42.   shape_len numeric,
  43.   the_geom geometry,
  44.   source integer,
  45.   target integer,
  46.   length double precision,
  47.   x1 double precision,
  48.   y1 double precision,
  49.   x2 double precision,
  50.   y2 double precision,
  51.   reverse_cost double precision,
  52.   to_cost double precision,
  53.   "rule" text,
  54.   rcost double precision,
  55.   CONSTRAINT streets_pkey PRIMARY KEY (gid),
  56.   CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
  57.   CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTILINESTRING'::text OR the_geom IS NULL),
  58.   CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1)
  59. )
  60. WITHOUT OIDS;
  61. ALTER TABLE streets OWNER TO yancho;

Submit a correction or amendment below (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.

Syntax highlighting:

To highlight particular lines, prefix each line with @@


Remember me so that I can delete my post