Guest User

Untitled

a guest
Nov 12th, 2018
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. UPDATE "public"."400_map_grid" SET geom = ST_SetSRID(geom, 4326);
  2. ALTER TABLE "public"."400_map_grid" ALTER COLUMN geom TYPE geometry(MultiPolygon, 4326);
  3.  
  4. 2977708.89153, 9976225.51161 - 3236908.88834, 10200225.50756
  5.  
  6. -97.97695, 29.92911 - -97.52100, 30.75366 (see attached image2).
  7.  
  8. -- Table: public."400_map_grid"
  9. -- DROP TABLE public."400_map_grid";
  10.  
  11. CREATE TABLE public."400_map_grid"
  12. (
  13. gid integer NOT NULL DEFAULT nextval('"400_map_grid_gid_seq"'::regclass),
  14. objectid bigint,
  15. perimeter numeric,
  16. grid_id character varying(20) COLLATE pg_catalog."default",
  17. geom geometry(MultiPolygon),
  18. CONSTRAINT "400_map_grid_pkey" PRIMARY KEY (gid)
  19. )
  20. WITH (
  21. OIDS = FALSE
  22. )
  23. TABLESPACE pg_default;
  24.  
  25. ALTER TABLE public."400_map_grid"
  26. OWNER to postgres;
  27.  
  28. -- Index: 400_map_grid_geom_idx
  29. -- DROP INDEX public."400_map_grid_geom_idx";
  30.  
  31. CREATE INDEX "400_map_grid_geom_idx"
  32. ON public."400_map_grid" USING gist
  33. (geom)
  34. TABLESPACE pg_default;
Add Comment
Please, Sign In to add comment