Advertisement
hackerboxes

postgis 创建图形表格

Jul 25th, 2012
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. SET CLIENT_ENCODING TO UTF8;
  2. SET STANDARD_CONFORMING_STRINGS TO ON;
  3. BEGIN;
  4. CREATE TABLE "public"."shijiazhuang_grid_900913" (gid serial PRIMARY KEY,
  5. "id" int4);
  6. SELECT AddGeometryColumn('public','shijiazhuang_grid_900913','the_geom','-1','MU
  7. LTIPOLYGON',2);
  8. INSERT INTO "public"."shijiazhuang_grid_900913" ("id",the_geom) VALUES (NULL,'01
  9. 060000000100000001030000000100000005000000BB29804F6336684125247DFF272A5141D02F46
  10. 19C635684111CD1A59262A514117358144C535684172906E20622B5141C4469F7F62366841F713EB
  11. C6632B5141BB29804F6336684125247DFF272A5141');
  12. CREATE INDEX "shijiazhuang_grid_900913_the_geom_gist" ON "public"."shijiazhuang_grid_900913" using gist ("the_geom" gist_geometry_ops);
  13. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement