Tag Info

New answers tagged

1

I guess you added in your classpath gt-epsg-postgres instead of gt-epsg-hsql? Delete gt-epsg-postgresql-11.0.jar from your classpath and add gt-epsg-hsql-11.0.jar into it. EDIT(Inspired by comments): For making the answer more understandable for others: GeoTools was set to store the EPSG projection database into PostgreSQL database. The default is to use a ...


0

In the query you used to define the Query Layer, you could cast this bigint column to another type that is supported by ArcGIS. SELECT CAST(yourbigintcolumn as float)


3

There is an easier and more efficient way of doing this. Works for both PostGIS 2.1 and 2.0. Just use the ST_ValueCount function. http://postgis.net/docs/manual-2.1/RT_ST_ValueCount.html that will give you both the pixel value and number of pixels that have that value. So would be for your case SELECT DISTINCT (pvc).value FROM (SELECT ...


3

There are various forms of ST_Value and the one that will probably help you is the ST_Value(rast, band, x, y) one. Modifying one of the examples from the docs, you can dump all the values for each pixel using generate_series in the x and y direction, and then use group by (or distinct) on those to get the list of unique pixel values. SELECT count(b1val), ...


0

This was the best result on Google I could find, but the screenshot tutorial by G M is out of date and it took me a while to work out how to use the plugin. Once installed, Load the Group Stats control panel from the "Vector" menu. Select the layer of interest. From the fields list, drag the field of interest into the "rows" box. Now drag the same field ...


0

You can use the Spatial Join method for this. Spatial Join You should look at Merge Rules and the Field Mapping Control using these links. I recommend doing this through ArcMap without your script first to see how the field mapping control works. This provides a powerful way of renaming fields so they do not collide or merging them (as a Sum or Average ...


0

If I have understood then it sounds like you want to run the summary statistics tool setting the case fields to be your ID field AND your GRIDCODE field whilst counting on GRIDCODE. This then feeds into the pivot table tool. The Pivot tool requires an ArcInfo(Advanced) license.



Top 50 recent answers are included