Tag Info

Hot answers tagged

17

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.


16

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 ...


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 ...


9

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, ...


8

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 ...


8

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 ...


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.


6

You are using the wrong option, you need to use the 'Database Connections' versus 'Database Servers' option. You can setup 'A Spatial Database Connection' from here.


6

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. ...


6

I would use the ITable interface if it is a standalone table. List<int> OIDList = new List<int>(); ICursor pCursor = pTable.Search(null,False); while((pRow = pCursor.NextRow) != null)) { OIDList.Add(pRow.OID); }


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

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

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

You should try this, Add XY coordinates to your featureclass, then Dissolve on the X,Y fields. This should remove your stacked, duplicate features. You can then join the attributes from your source file. You may need to concatenate X,Y to form a single field for the join.


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 ...


4

Its under your user profile, AppData\Esri\ArcCatalog folder, it varies a little from 9.3.x and 10, but that should get you to the main location. Just look for the .sde files.


4

The free version of ET Geowizards will do this. Basic -> Sort shapes. I just tested it on a v10 File Geodatabase and it works. It has to create a new feature class though.


4

you need to use this code within ArcMap and the field calculator. Add your feature class in the table of content, right click on it to open the table, right click on the name of the field and launch the field calculator. Then you check for codeblock and copy the code you mentioned. now for your code snippets, here is what I would do rec=0 def ...


4

Unfortunately, I think pulling out a backup is your only hope but you can also vote for an ArcGIS Idea entitled ArcCatalog Recycle Bin.


4

I'm not sure why you got no warning message. My machine prompts me with the typical Windows message of "Are you sure you want to delete this? Yes/No" if I use the delete key on anything. In fact if I delete a folder (not a geodatabase or any kind of individual file, feature class, etc.) using the key, it does send it to the Recycle Bin. I'm on 10.2 on Win 7 ...


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

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 ...



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