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
);
When I open this feature class in ArcMap it opens up the "neq query layer" dialogue:
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?
Thanks