Hi, I've set up postgre /postgis and enterprise SDE. An example of my sql for setting up a table follows:
CREATE TABLE bird_sighting ( bird_id integer PRIMARY KEY, field_id integer REFERENCES field(field_ID), birdev_id integer REFERENCES bird_event(birdev_id), sight_date date NOT NULL CHECK(sight_date > '2016-05-01'), activity character varying (30), rel_location character varying (20), species character varying (40), geom geometry(Point, 26917) NOT NULL );
Is this correct? I thought that if I already defined the SRID and geometry type that this should already be populated?
Can someone explain to me why arcmap does this, or perhaps what I am doing wrong?