Error Reading Uid From Table. Arcgis
Contents |
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Error Reading Oid From Table Arcgis 10
or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic arcgis oid field Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Why does reading shapefile from PostgreSQL database give Error reading OID from table …? up vote 1 down vote favorite I'm using arcgis 10.1 and i have a connection to a PostgreSQL 9.3 database. When i try to load a shapefile using the add query layer I get an error when opening the attribute table. The error says "Error reading OID from table. Reading rows has been stopped. Check that the datasource is valid. OID mapped column has null values. the operation is not supported by this implementation". I know there is a field that is causing this issue yet i don't know which one is or how to go solve it. Has anyone come across to the same issue? arcgis-desktop postgis arcgis-10.1 postgresql query-layer share|improve this question edited Jan 23 '14 at 23:10 PolyGeo♦ 39.2k1357144 asked Jan 23 '14 at 22:47 Daniel Jimenez 180211 1 Please detail the process you are using to add the query layer. There are a couple of spots where the process of adding the layer sometimes selects more than one column as a unique identifier. This may be what you are running up against. –Get Spatial Jan 24 '14 at 0:30 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote accepted There is advice in the Online Help that may help: Since the value in the unique identifier field uniquely identifies a row or feature object within ArcGIS, values in that field must always be unique and not null. It is your responsibility to guarantee that values in this field meet this requirement. The same error has been discussed on the Esri Forums. share|improve this answer edited Mar 8 '15 at 23:51 answered Jan 23 '14 at 22:58 PolyGeo♦ 39.2k1357144 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the an
message: [postgis-users] Null results from geocode_intersection, postgis 2.0.1, postgreSQL 9.1.6 Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] By the way, as the error occured when reading the table, did you check your table have a primary key ? (mine had integer one) Nicolas On 31 October 2012 17:17, Nicolas Ribot
messages) 1. 2012-10-31 Re: [postgis-users] Error reading OID error reading uid from Table. OID postgis-u Nicolas Ribot 2. 2012-10-31 Re: [postgis-users] Error reading OID from Table. OID postgis-u Nicolas Ribot 3. 2012-10-30 [postgis-users] Error reading OID from Table. OID Col postgis-u Mark Volz Configure | About | News | Addalist | SponsoredbyKoreLogic
used open source sqlite database as a data container since fall 2013. Furthermore, with the latest releases of the Runtime SDKs (iOS, Android, .Net), the sqlite database is supported now as geodatabase in the synchronization framerwork. The question is now, why those two approaches? What are the differences? Why can you use one with ArcMap, but not the other? This and the (shortly following) next blog post, will take a close look at the two "formats" and what they can be used for. Sqlite as spatial data container Since 10.2 ArcGIS support sqlite as a data container for simple features (Use of Sqlite in ArcGIS). The support allows the analysis and display of spatial data in a sqlite database in ArcMap. The spatial data can be stored in the Esri ST_Geometry or SpatiaLite format (the later was not tested for this post). The sqlite database can be created through ArcCatalog through some simple ArcPy commands. Once the DB is created data can be imported as well. Once the database added to ArcMap, it display and renderes reasonable fast, yet it was not possible to edit the data. A set of quick tests showed the following: supported are only simple features, therefore: true curves are converted to segmented polylines complex features (i.e. geom network, datasets, etc.) could not be imported annotations are not supported dimensions are not supported as mentioned before: no editing capabilities in ArcMap taking a look at the internals thest_geometry_columnsandst_spatial_reference_systemstables exist, which are required for a OGC compliant RDBMS system. If the schema is fully OGC compliant was not further investigated, but a first looked showed that the schema contains all the necessary tables and fields In contrast, does the schema not any Esri geodatabase specific tables ==> this indicates that the support is only designed for display and analysis purposes the analysis capabilities where tested with the following tools: buffer: worked fine simplify lines: worked fine and