search

agrc / deq-enviro

DEQ Environmental Data Viewer
MIT License
6 stars 1 forks source link

Search returning duplicate results #210

Closed stdavis closed 10 years ago

stdavis commented 10 years ago

Example-Facility IDs with only one result: 0100524, 0100180, 0100186.

Example-Facility IDs with two results when they should be one: 1200445, 4000903, 3000251, 800047.

image

steveoh commented 10 years ago

@stdavis is the api returned json reflecting this or ...

stdavis commented 10 years ago

API is returning two results but I think that it's a data problem since they have different object id's: image

Haven't checked the data yet...

steveoh commented 10 years ago

yeah that was where i was going with that. probably an update script issue or just bad data from the agency.

steveoh commented 10 years ago

maybe run the remove duplicate gp task in the update script or something

stdavis commented 10 years ago

Fixed by deleting this feature class (FACILITYUST) in the fgdb and recreating it. Not sure what was wrong. Something must have corrupted it.

stdavis commented 10 years ago

This is happening again. :( Duplicate records created when running append from sde to fgdb. Can reproduce from command line outside of script. When running at command line in Desktop I get the following errors: WARNING 000594: Input feature 4033: Unexpected operation. Only for features with OBJECTID 1000 or higher.

Can successfully append to a test feature class in a different fgdb with no problems. Not sure what's screwed up in QueryLayer.gdb.

stdavis commented 10 years ago

Removed all GlobalId fields and recreated the data yet again in the file geodatabase. It's updating correctly for now. If this happens again I will send this to ESRI tech support.