PostgreSql

PENÚLTIMA SEMANA DE SUFOCO!! TÁ ACABANDO =)

CREATE TABLE quadras (nome TEXT, id SERIAL PRIMARY KEY );
SELECT AddGeometryColumn('public','quadras','geometria',4674,'POLYGON',2 );
INSERT INTO quadras (nome,geometria) VALUES ('Quadra A', ST_GeometryFromText ( 'POLYGON((1 14 , 5 14, 5 9, 1 9, 1 14))', 4674));
INSERT INTO quadras (nome,geometria) VALUES ('Quadra B', ST_GeometryFromText ( 'POLYGON((7 14,11 14,11 9,7 9, 7 14))', 4674));
INSERT INTO quadras (nome,geometria) VALUES ('Quadra C', ST_GeometryFromText ( 'POLYGON((1 8,5 8,5 3,1 3, 1 8))', 4674));
INSERT INTO quadras (nome,geometria) VALUES ('Quadra D', ST_GeometryFromText ( 'POLYGON((7 8,11 8,11 3,7 3,7 8))', 4674));