How to display and export the attribute table of a particular layer in the Geocortex?
How to display and export the attribute table of a particular layer in the Geocortex?
I’m wondering if there is a way to export the attribute table of a particular layer in the Geocortex.
Thank you
Best
Jamal
-
When you identify on the map, the features show up on the left. If you click "Table View" at the top of the list it shows all the visible attributes of each layer in a table. You can then click "Export to CSV" to export the tables.
0 -
Thanks Stephanie for the answer,
What I wanted here is to display\export the ENTIRE attribute table of a particular layer but not just few values.
An idea crossed my mind: I apply “simple query” that returns all the values of the attribute table and then I export them. Is this the best practice?
0 -
As far as I know you are limited to 1000 query results from any one layer, so you probably can't export the entire table from the map. There might be a way to increase the number of results, but then you might have performance issues.
If it is a specific layer that people will need, you could export the entire table from ArcMap (manually, or script it to update regularly), then copy the table to your server and create a workflow to display a hyperlink so they can download the table.
0 -
Thanks Stephanie,
The limitation of 1000 values is really an issue.
Then the other option is to develop workflow. It appears to be the solution
Best
Jamal
0 -
You can increase the number of records returned by modifying that particular property in the Parameters section of your map service (ArcGIS Server Manger)
0 -
Many thanks Jared for the help. This resolves my issue.
What consequences do we still have if we INCREASE the number of records returned by the server?
best
Jamal
/customer/servlet/servlet.FileDownload?file=00P6000000em18UEAQ
0 -
Hi Jamal,
Increasing the number of features returned by ArcGIS Server can cause performance issues, depending on the layer. A query returning 2000 point features with only a couple of attributes each will be a much lighter operation than a query returning 500 results from a polygon layer with complex geometries and many attributes.
If you want to return all of the features in a layer, you will definitely need to consider how many features exist in the layer, how complex their geometries are, how many attributes they have, etc. Also, increasing this setting in you map service properties will affect all of your layers, so while you may see acceptable performance when filtering a query to a particular layer, the global search (which could span many layers) could take much, much longer.
-Victoria
0 -
Many thanks Victoria for the useful input.
One should choose either performance or business requirements. Both of them appear not to be always possible.
Best
Jamal
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
8 Kommentare