Tag Info

Hot answers tagged

17

Give a look at this post on my blog: http://www.paolocorti.net/2008/06/06/spatial-database-for-postgres-and-arcgis-users-how-to-choose/ Basically you have 2 options: use PostGis with ArcSde (so you need an ArcSde license, and ArcEditor if you need to edit data) use zigGIS: http://www.obtusesoft.com/ (note that is not tested on ArcGis 10.0). You will just ...


12

I am not aware of an ArcObjects way to get it, but you can enable the Size column in the Customize menu -> ArcCatalog Options -> Contents tab: This works on file geodatabases but not on SDE geodatabases (in that case you could use some DBMS-specific queries to determine it though). It does not work on personal geodatabases.


10

If you are convenient with Python then writing script for this task is preferred. Take a look at these key things: Get a list of featureclasses/shapefiles in gdb/folder - ListFeatureClasses. In the bottom of this help article there is also an example "Copy shapefiles to a geodatabase" which you can use to start writing script. Check for existence of ...


9

you can use arcpy: import arcpy myField = "test" env.workspace = "D:/test/data.gdb" fcs = arcpy.ListFeatureClasses() for f in fcs: fieldList = arcpy.ListFields(f) for field in fieldList: if field.name == myField: print f Beside this you can use os.walk for files in your drive as: path = r"C:" for root, dirs, files in ...


8

Check out this function from by Bjorn Kuiper to test if a field exists : def FieldExist(featureclass, fieldname): fieldList = arcpy.ListFields(featureclass, fieldname) fieldCount = len(fieldList) if (fieldCount == 1): return True else: return False with the following example of use: if (not FieldExist(myFeatureClass, ...


7

It's been a while since this question was updated, so briefly ArcGIS 10.1 and ArcGIS 10.2 both natively support PostGreSQL and PostGIS data types. Included in the help for both versions is a walkthrough of gettting set up, and configuring tables to use the PostGIS geometry types.


7

I have a few posts on doing it with 9.3. The first is here and you can get to the rest of them from there: http://geobabble.wordpress.com/2008/05/28/using-arcsde-93-with-postgresql-part-1/ I've done it once with 10.0 and have had no issues. I will say that, when using PostgreSQL and PostGIS with ArcSDE, that I strongly recommend sticking to whatever ...


7

I may be too late, but in case someone else comes across this forum for the same problem (as I did ;)). This is because you have to install the correct files for your client: http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_PostgreSQL/002p0000003q000000/. It took me a while to figure this out as the ESRI online ...


5

No. The closest you're going to get is with personal or workgroup SDE. Those editions let you create databases from ArcCatalog but you still need to run the post-install initially to set up a SQL Server Express instance. If you're using enterprise, you're stuck with the post install (or the command line tools :)).


5

I think you'll have to configure some major database pooling, so that your two servers appear as one. Then, connecting clients won't (and shouldn't) know which server they are actually connecting to, and you can tinker with the back ends as much as you like. Now, this is only an ideal solution if your backup is for availability - or if you want to take the ...


5

As for me I would recommend choosing python scripting for this task (arcpy). Here are some ideas: Use ListDatasets for getting all datasets. Use ListFeatureClasses for getting all featureclasses. Use SearchCursor for querying data. Take a look at Describe function - it also can be very usefull for some tasks. UPDATE: Have found after posting: @Aragon ...


5

Here is a model that looks like it duplicates the process you have listed above. There are a couple of things different than the procedure you have outlined above. Instead of using a while loop to increment through the features, there is a Feature Selection Iterator that loops directly over the features in a featureclass. What is nice about this iterator ...


5

public void Irow(ITable table, string nameOfFrstField , string nameofSecField) { int fieldFrstIndex = table.FindField(nameOfFrstField); int fieldSecIndex = table.FindField(nameofSecField); //insert row IRow row = table.CreateRow(); //initalize all of the default field values for the new row. ...


5

For better performance, consider using IRowBuffer and an insert cursor with client-side buffering enabled (e.g. pass in true for the useBuffering parameter of the ITable.Insert method). See "Using insert cursors" in the Creating features help topic for more info.


5

In answer to another question I said that it is possible to use Summary Statistics to do the equivalent of PULLITEMS (old speak for reorder fields). That technique works well on Tables only but there is another script available now that says it works on both feature classes and table. UPDATE I would also recommend the Answer to another Question which was ...


3

Using Spatial Database Connection in ArcCatalog http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Making_an_ArcSDE_service_connection_from_ArcGIS_Desktop_to_a_geodatabase_in_Oracle/002n0000008n000000/


3

Go to the ESRI site and it will explain it to you in detail. http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?id=3026&pid=3025&topicname=An_overview_of_ArcCatalog


3

First of all: You will only be able to use ArcGIS with PostgreSQL using OLE DB connections, meaning, you will only be able to read common tables and collumns (you even will be able to read the spatial collumns, but ArcGIS cannot do anything to them, To use ArcGIS and PostgreSQL + PostGIS (meaning that you need to see spatial data), you will need ArcSDE or ...


3

New to the scene: ST-Links pgMap. The software is freeware, and works with ArcGIS 9.3 and up. The download has a nice PDF to document the capabilities, which include viewing, editing, etc. As I know, many people have been using this small useful tools since last year. The tool work with PostgreSQL 8.3/8.4. Not work for PostgreSQL 9.0 yet. A new release for ...


3

The ArcGIS Server logs contain detailed information about server usage. They're located in: C:\Program Files\ArcGIS\Server\user\log or C:\Program Files\ArcGIS\Server10.0\server\user\log They're XML files that you could load into a spreadsheet, but the data there might be a bit overwhelming, especially for a busy site. Also, there will be at least one ...


3

Try IGxAGSObject. if (pGxObj is IGxAGSObject) { var agsObj = pGxObj as IGxAGSObject; object names; object values; agsObj.AGSServerObjectName.AGSServerConnectionName.ConnectionProperties.GetAllProperties(out names, out values); var n = names as string[]; var o = values as object[]; System.Text.StringBuilder sb = new ...


3

Sorry to say your not going to find a quick way to do it as of SP2; primarily because Metadata is badly broken @ ArcGIS 10. I really would not expect that sample code you see to work cleanly, I suspect it might even damage the metadata. Your real only option is going to be to do it manually.We undertook a major metadata update project over the last 2 months ...


3

You need to obtain schema lock, i.e you must be the only one connected to the database. Then you change the values in the domain connected to your subtype field. At least before version 10 using SQL server you couldn't change a value within a domain, only add and delete at the end. To change a value you have to delete from the bottom up to the value you ...


3

You need to run MakeTableQuery from the Layers and Table Views toolset to reorder fields. From the documentation, The order of the fields in the field list indicates the order the fields will appear in the output layer or table view. Also, If a Shape column is added to the field list, the result is a layer; otherwise, it is a table view. This is available ...


3

As mentioned in the comments you can reorder fields with ArcGIS Diagrammer. I posted a more general step by step in this answer: How to update the length property of a feature class field?


3

Try to compress database : http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Compress%20File%20Geodatabase%20Data%20%28Data%20Management%29


3

If you have ArcEditor or ArcInfo desktop level, you have the ability to use SQL Server Express. Even though only one user can edit at a time, the locking and unlocking may be better -- you might try this out first. There lot's of documentation on how to do it, and you don't have to be a dba -- though I like postgres. No offense QGIS folks ;) Also, make sure ...


3

I wrote a plugin that gives ArcGIS access to 50+ vector formats (including PostGIS). It is still experimental, but you can try it out and tell me how it goes. There are advantages of using this approach over the built-in functionality in ArcGIS (look at the FAQ), but again, it is still experimental. Download and instructions here


3

The registration process has several small activities (storing column names and types) which are relatively fixed in duration (milliseconds) and table scan activities which test for uniqueness in the regsitered rowid column and topology class consistency (all point, or all line, or all polygon of the same dimensionality), which are dependent on the number of ...


3

Attachments can be enabled only on feature classes stored within a geodatabase (this can be any type of geodatabase - personal, file, or enterprise). You cannot attach your files to a shapefile because there is no container the data can be stored in. To convert your shapefile to a geodatabase, you can use a GP tool Feature Class To Feature Class ...



Only top voted, non community-wiki answers of a minimum length are eligible