Latest Contributions by MarcoBoeringa

Richard, Please note I am not a GPS expert, but from what I read about it all, I doubt if you will be getting 1 ft accuracy without correcting against a fixed reference GPS station like in RTK/DGPS. Stating the projection in which your "monument data" is stored (State Plane... etc.) doesn't tell anything about the accuracy of the monument data itself you compare the GPS readings too, it could be off by dozens to hundreds of feet for all we know... Projections are not a measure of accuracy. You may find this thread of some use: "Nightmare on GIS Street" by Eric Gakstatter ... View more

I remember that registration has two phases, register with SDE and register with Geodatabase, and I  never understand what the difference between them. So, my question, if I want to write a python script to register with the geodatabase, which arcpy commands I can use? and do I have to register it with SDE first? No, you don't. ArcSDE registration is an integral part of registering with the Geodatabase. So once you register a layer with the Geodatabase, it is also registered in ArcSDE system tables (but not the other way around: registering your layer with the "sdelayer" command in ArcSDE won't register it automatically with the Geodatabase). ... View more

I don't know if it is really relevant and does what you want, but ESRI has a File Geodatabase API that may be of use: http://www.esri.com/software/arcgis/geodatabase/interoperability ... View more

PS: 1. Database on Database Server is : Microsoft SQL Server 2012 (SP1) - 11.0.3393.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) The thing that interests me is the Hypervisor, are you running the database on a Virtual Machine? Although you should probably be able to run this, I think ESRI recommends against this configuration for true production environments. I also don't know (I don't have experience with it), if there are special configuration issues when running the database on a virtual machine, but I wouldn't be surprised there are... Maybe someone else with experience with this configuration will be able to help you out. ... View more

Marco I meant records. Sorry. Digitizing every job a surveying company has done for the last two decades. You have no idea how much data goes into that. Tracy, 10.000 (10k) records is nothing, this should be blazing fast in ArcGIS, and certainly not take minutes to open. There are spatial databases far larger than that around. I do see a potential issue with the way the data is digitized. Are you using some sort of "stream-digitizing" mode, automatically generating points along lines on scanned maps? This can lead to vast amounts of vertices, which could explain bad performance. You may need to weed out excess vertices using generalization, for example using the Simplify Line tool. For more options, see the An overview of the Generalization toolset Help page. I do appreciate the amount of work you are facing. I was involved in a major project here in the Netherlands regarding large scale (1:1000) photogrammetrically and survey derived datasets of the entire highway system of the Netherlands, with over 300+ object types recognized. The amount of data at these detailed large scales can be staggering... ... View more

Hi, ( I have a huge and growing geodatabase 10,000 fields now) and it's connected to a basic entry and search form for my coworkers to enter data with. Both have gotten extremely slow lately and I'm not sure what to do. I've compacted the database and deleted excess data. Right now it takes a good three or four minutes to simply OPEN. Submitting information also takes a very long time. Any ideas as to how to make it faster?? Thanks! -two point feature classes and five tables (one point class is the extremely large one) 10,000 fields? Have you considered separating out these fields into different tables and relating them to each other? this will be easier to manage. From this you can generate Views (as long as you are using the Enterprise Geodatabase in SQL). I have thought about separating them into different tables...just not sure how to go about that yet. Tracy, I can not even begin to fathom what enterprise data-model would require 10.000 fields to track attributes in just a handful of tables... Are you sure "fields" shouldn't be "records"?... How would you even handle and make sense of 10.000 attributes if you had to base some sort of decision or calculation on it? Can you please give some hints as to the kind of data these "tables" and "fields" contain? Shouldn't you possibly be pivoting the table to make records out of fields to make a sensible data-model of this? Marco ... View more

3. More than 1000 records (features) deleted from the source. -You should still be able to perform a synchronization if 1000 features or more are deleted.  If you are receiving an error, you should contact Tech Support. Jake, Jamal hit a 10.2 known and ESRI registered bug, that Asrujit pointed out in this other thread Jamal started: Bug NIM-094669 So I think it is time for ESRI to start doing some work instead... Ah, well, now see it is registered as fixed for the 10.3 release~! 😉 ... View more

I can't seem to access anything map related! The same scripts work perfectly in the Python window in ArcMap (an example below), but run as a py script = nothing. Code: import arcpy import ctypes mxd = arcpy.mapping.MapDocument("CURRENT") nam = mxd.activeDataFrame.name ctypes.windll.user32.MessageBoxA(0, nam, "Dialog Title", 1) Are there any limitations or approaches I should be aware of? Gary, have you tried to replace "CURRENT" with the full folder path to your *.mxd Map document? Current refers to the "current" document opened in ArcMap. Since you are running the Python script outside ArcMap, it probably has no knowledge what "current" is. ... View more

I would like to know if there are any resources to learn more about how to create a system architecture for an enterprise GIS system like ArcGIS 10.2. This will be very helpful as I am very interested in this and that I will be involved in the coming year with planning for a Enterprise GIS System. Besides the huge and comprehensive ArcGIS Help system, I think these ESRI managed pages should be your first stop: System Design Strategies Preface ... View more

And while you're on it, you may as well consider reading some of the links regarding versioning and data management in a ESRI Geodatabase that I pointed out in this post in another thread, so as to really start understanding it. Especially the 2004 ESRI Versioning Whitepaper linked there is highly recommended reading, despite it's age. ... View more

No tutorial, but I think these resources should help you out: Data maintenance strategies A quick tour of versioning And although older and some of it getting outdated (e.g. ArcSDE Application Server is going on the next major release), these articles may still be of use, especially the 2004 Versioning whitepaper is still highly recommended reading to better understand versioning, even despite 10 years old... Please note that the actual mechanism of versioning basically hasn't changed a lot since then, ESRI mainly added new options relaxing constraints that were issues ten years ago: ESRI Versioning Whitepaper, 2004 Enterprise Geodatabase 101 - A review of design and key features for GIS managers and database administrators Derek Law, ESRI Versioning 101 Essential information about ArcSDE geodatabases By Derek Law, Esri Product Management ... View more

Oracle 11g ArcMap 10.2 Polygon features (NOT SDE feature class as its not registered with SDE) No of features (100k) My issue is when I add this spatial table or as a matter of fact any spatial table from Oracle into ArcMap it calculates the spatial extent on the fly (image attached). Also I have noticed larger the size of the added layer longer it takes ArcMap to calculate the spatial extent. I don't understand why ArcMap does not get this extent from USER_SDO_GEOM_METADATA which is already populated. Moreover the data loads quicker in QGIS. Any suggestions? While it may seem logical to you as an exclusive Oracle user, for ArcGIS to get this information from the USER_SDO_GEOM_METADATA table, it is not entirely so. The functionality you are using to access a database table that is not registered with a geodatabase, is generic and targeted at all databases ArcGIS supports (SQL Server, PostGreSQL, DB2 etc.), some of which may not have a similar USER_SDO_GEOM_METADATA table storing a geometry table's extent as Oracle has. While I can see ESRI adding functionality for this in a future release, it would require checking for database type, and than going after the proper "Metadata" type table storing the extent information. It would significantly complicate the code, and possibly make it more vulnerable to RDMBS changes and bugs, as changes to the underlying database between releases regarding the stored metadata, would start affecting the process of loading the datasets. With the current implementation, all ArcGIS needs to do is to extract the required data from the table containing geometries. That said, I don't know what ESRI's plans are in this respect. It seems likely more "intelligent" functionality might be added in future releases. And of course, you can already base the extent on the Spatial Reference Extent as a rough quick shortcut, although this may not be a satisfactory "workaround" for some datasets. ... View more

I'm struggling to understand at this point the correct method for creating spatial views at 10.1.  I have tried using the new view option when you right click a database connection and specify a query; When I do this, it creates a query table instead of a spatial view despite specifying the ObjectID and shape field in the view query.  ArcMap can't seem to determine the ObjectID field when I try to add it to the map either, so I get a dialog box asking to select a unique identifier field every time I add it to the map. What is the correct way to create a spatial view at 10.1? Should I just continue to use the sde command on my database server to do this? I really recommend you to read the entire thread I link below and try to digest what I have been writing there, as, although it has a different titel related to metadata too, it actually deals with the same issues and the misunderstandings about ordinary RDBMS database views (as the spatial view you created through the Create Database View tool or the New / View menu option), and ArcSDE  registered views created by the ArcSDE Command Line tools. These are not the same! Read this: Database Views and Metadata Marco ... View more

Map scale, contrary to a scale bar, has one difficult aspect to it regarding web application or screen display in general: it becomes screen ppi (pixels per inch) depended. E.g. the same 1000x1000 pixel image depicting the same 1x1 km area on the earth's surface can have vastly different sizes on different screens with different ppi resolution, and since there is a plethora out there, this is a major issue. This is especially apparent with all the new modern "retina" type resolution screens. Map scale only really has usage for printed output in this respect... and if you haven't told ArcGIS for Desktop what your screens' size is through the Advanced ArcMap Settings utility, the settings for "scale" can be way off in ArcGIS for Desktop. ... View more