Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If at all possible, migrate to using 10.1 where you get <code>arcpy.da</code>, a significantly more performant API for cursors. <a href="http://arcpy.wordpress.com/2012/07/12/getting-arcpy-da-rows-back-as-dictionaries/" rel="noreferrer">I've written a log post on this very topic of getting dictionaries back</a>. Geometries will all be the same because it uses a recycling cursor internally, so in 10.0 you'll want to grab <code>shape.__geo_interface__</code> instead and use <code>AsShape</code> to get it back to a geometry object.</p> <p>The order you get rows back is fairly arbitrary: you can expect it to be the same every time in a shapefile <em>without</em> a where clause and that's pretty much it, so your two-pass approach won't really be reliable.</p> <p>All this considered, you can do something like this:</p> <pre><code>def cursor_to_dicts(cursor, field_names): for row in cursor: row_dict = {} for field in field_names: val = row.getValue(field) row_dict[field] = getattr(val, '__geo_interface__', val) yield row_dict fc = '/path/to/fc' fields = [f.name for f in arcpy.ListFields(fc)] # get field list features = list(cursor_to_dicts(arcpy.SearchCursor(fc), fields)) </code></pre> <p>The magic is the <code>getattr()</code> call -- try to grab <code>value.__geo_interface__</code> if it exists, otherwise just default to <code>value</code>.</p> <p>As this question isn't really about the Python language in general but an API (<code>arcpy</code>) specific to GIS, you might be better off asking things like this on gis.stackexchange in the future.</p>
    singulars
    1. This table or related slice is empty.
    1. POLoading a feature class in a list using arcpy : strange behaviour of SearchCursor
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJason Scheirer
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POLoading a feature class in a list using arcpy : strange behaviour of SearchCursor
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI wasn't aware of arcpy.da which seems to be a great improvement for data access : http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000011000000. Having upgraded to 10.3 i'm going to give it a try. Thank you for this great tip @JasonShierer
      singulars
      1. PO
      1. USoutforawhile
    2. CO...and another option would be to use arcpy.da.FeatureClassToNumPyArray : http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000015000000
      singulars
      1. PO
      1. USoutforawhile
    3. CO...last edit : i have sp3 installed but being in France 10.1 is not available yet for me. I'll have to go for `__geo_interface__`.
      singulars
      1. PO
      1. USoutforawhile
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload