Build measure of state change The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)PostGIS union multiple tables, big dataset, faster approach?Spatial join based on fieldUsing Zonal Statistics As Table for overlapping polygons in ArcPy?Tabulate intersection of ArcGIS for Desktop returns empty output?Count overlapping polygons, including duplicatesGetting mean values of reclassified raster classes inside a fishnet gridHow to retrieve Intersected geometry of the polygons geometry POINT (lat,lng) input?QGIS Union Error: multiple overlapping polygons created where only one should exist?How to extract pixel value counts from a raster in QGIS, in different polygons?Counting occurrences across many rasters using ArcGIS Desktop?

60's-70's movie: home appliances revolting against the owners

The following signatures were invalid: EXPKEYSIG 1397BC53640DB551

How did the crowd guess the pentatonic scale in Bobby McFerrin's presentation?

Circular reasoning in L'Hopital's rule

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?

One-dimensional Japanese puzzle

Working through the single responsibility principle (SRP) in Python when calls are expensive

Can the DM override racial traits?

Button changing its text & action. Good or terrible?

Why doesn't a hydraulic lever violate conservation of energy?

Huge performance difference of the command find with and without using %M option to show permissions

What information about me do stores get via my credit card?

Can the Right Ascension and Argument of Perigee of a spacecraft's orbit keep varying by themselves with time?

Is it ok to offer lower paid work as a trial period before negotiating for a full-time job?

Student Loan from years ago pops up and is taking my salary

For what reasons would an animal species NOT cross a *horizontal* land bridge?

Mortgage adviser recommends a longer term than necessary combined with overpayments

Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?

Example of compact Riemannian manifold with only one geodesic.

Is 'stolen' appropriate word?

Did the new image of black hole confirm the general theory of relativity?

Can we generate random numbers using irrational numbers like π and e?

What happens to a Warlock's expended Spell Slots when they gain a Level?

Didn't get enough time to take a Coding Test - what to do now?



Build measure of state change



The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)PostGIS union multiple tables, big dataset, faster approach?Spatial join based on fieldUsing Zonal Statistics As Table for overlapping polygons in ArcPy?Tabulate intersection of ArcGIS for Desktop returns empty output?Count overlapping polygons, including duplicatesGetting mean values of reclassified raster classes inside a fishnet gridHow to retrieve Intersected geometry of the polygons geometry POINT (lat,lng) input?QGIS Union Error: multiple overlapping polygons created where only one should exist?How to extract pixel value counts from a raster in QGIS, in different polygons?Counting occurrences across many rasters using ArcGIS Desktop?



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I want to be able to build a measure in ArcGIS (ArcMap).



(1) I have some shapefiles of sovereign states by centuries. These are polygons with the name of the state as ID. (2) Moreover, I have a shapefile of current European regions at NUTS 2 level.



I would like to get a measure of the average number of States that existed in a given NUTS 2 region, over centuries. I have tried to build such a measure for days now.



My bet was to build this measure by using the tool Union. Take two maps of sovereign states for 1000 and 1100, for example, unionize them.
Union will give me a new attribute table with the polygons non-intersecting at t=1000, t=1100 and those intersecting in between.



What I want is a measure that will tell me how many States did rule in a given polygon.
Project the two sovereign states shapefiles for 1000 and 1100. Some polygons will likely maintain their borders, hence the measure should give 1 for the latter.
In other cases, the polygon in the first period will be crossed by another polygon. This will give three polygons: two that belong to the same states as before and another one (the intersection) which was belonging to state A in period t= 1000 and now to B in period t=1100. The measure should give 2 for this polygon.
Then I was thinking about using something like Spatial Join to be able to get the average count of polygons in a NUTS 2 region.



However the very first problem is that the attribute table that I get with GIS after using the Union tool as polygons with the State related at t=1000 and t= 11000 but I don't ever know how I can convert these different names to count (and a number).



enter image description here










share|improve this question
























  • Intersect with 1000, use summary statistics, where case field is NUTS' id. Use attribute join by that id to transfer frequency to nuts table, perhaps to a new field.

    – FelixIP
    Apr 7 at 3:38











  • Are you looking for a count such as Ghana: 13, Croatia: 1, Mumha: 54, etc...?

    – Aaron
    Apr 7 at 4:02











  • Hello, actually at the end of the day I am looking for a count, say 5 in Lombardia, 10 in Piemonte, etc.

    – Rororo
    Apr 7 at 5:12

















0















I want to be able to build a measure in ArcGIS (ArcMap).



(1) I have some shapefiles of sovereign states by centuries. These are polygons with the name of the state as ID. (2) Moreover, I have a shapefile of current European regions at NUTS 2 level.



I would like to get a measure of the average number of States that existed in a given NUTS 2 region, over centuries. I have tried to build such a measure for days now.



My bet was to build this measure by using the tool Union. Take two maps of sovereign states for 1000 and 1100, for example, unionize them.
Union will give me a new attribute table with the polygons non-intersecting at t=1000, t=1100 and those intersecting in between.



What I want is a measure that will tell me how many States did rule in a given polygon.
Project the two sovereign states shapefiles for 1000 and 1100. Some polygons will likely maintain their borders, hence the measure should give 1 for the latter.
In other cases, the polygon in the first period will be crossed by another polygon. This will give three polygons: two that belong to the same states as before and another one (the intersection) which was belonging to state A in period t= 1000 and now to B in period t=1100. The measure should give 2 for this polygon.
Then I was thinking about using something like Spatial Join to be able to get the average count of polygons in a NUTS 2 region.



However the very first problem is that the attribute table that I get with GIS after using the Union tool as polygons with the State related at t=1000 and t= 11000 but I don't ever know how I can convert these different names to count (and a number).



enter image description here










share|improve this question
























  • Intersect with 1000, use summary statistics, where case field is NUTS' id. Use attribute join by that id to transfer frequency to nuts table, perhaps to a new field.

    – FelixIP
    Apr 7 at 3:38











  • Are you looking for a count such as Ghana: 13, Croatia: 1, Mumha: 54, etc...?

    – Aaron
    Apr 7 at 4:02











  • Hello, actually at the end of the day I am looking for a count, say 5 in Lombardia, 10 in Piemonte, etc.

    – Rororo
    Apr 7 at 5:12













0












0








0








I want to be able to build a measure in ArcGIS (ArcMap).



(1) I have some shapefiles of sovereign states by centuries. These are polygons with the name of the state as ID. (2) Moreover, I have a shapefile of current European regions at NUTS 2 level.



I would like to get a measure of the average number of States that existed in a given NUTS 2 region, over centuries. I have tried to build such a measure for days now.



My bet was to build this measure by using the tool Union. Take two maps of sovereign states for 1000 and 1100, for example, unionize them.
Union will give me a new attribute table with the polygons non-intersecting at t=1000, t=1100 and those intersecting in between.



What I want is a measure that will tell me how many States did rule in a given polygon.
Project the two sovereign states shapefiles for 1000 and 1100. Some polygons will likely maintain their borders, hence the measure should give 1 for the latter.
In other cases, the polygon in the first period will be crossed by another polygon. This will give three polygons: two that belong to the same states as before and another one (the intersection) which was belonging to state A in period t= 1000 and now to B in period t=1100. The measure should give 2 for this polygon.
Then I was thinking about using something like Spatial Join to be able to get the average count of polygons in a NUTS 2 region.



However the very first problem is that the attribute table that I get with GIS after using the Union tool as polygons with the State related at t=1000 and t= 11000 but I don't ever know how I can convert these different names to count (and a number).



enter image description here










share|improve this question
















I want to be able to build a measure in ArcGIS (ArcMap).



(1) I have some shapefiles of sovereign states by centuries. These are polygons with the name of the state as ID. (2) Moreover, I have a shapefile of current European regions at NUTS 2 level.



I would like to get a measure of the average number of States that existed in a given NUTS 2 region, over centuries. I have tried to build such a measure for days now.



My bet was to build this measure by using the tool Union. Take two maps of sovereign states for 1000 and 1100, for example, unionize them.
Union will give me a new attribute table with the polygons non-intersecting at t=1000, t=1100 and those intersecting in between.



What I want is a measure that will tell me how many States did rule in a given polygon.
Project the two sovereign states shapefiles for 1000 and 1100. Some polygons will likely maintain their borders, hence the measure should give 1 for the latter.
In other cases, the polygon in the first period will be crossed by another polygon. This will give three polygons: two that belong to the same states as before and another one (the intersection) which was belonging to state A in period t= 1000 and now to B in period t=1100. The measure should give 2 for this polygon.
Then I was thinking about using something like Spatial Join to be able to get the average count of polygons in a NUTS 2 region.



However the very first problem is that the attribute table that I get with GIS after using the Union tool as polygons with the State related at t=1000 and t= 11000 but I don't ever know how I can convert these different names to count (and a number).



enter image description here







arcgis-10.2 spatial-analyst spatial-join zonal-statistics union






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Apr 7 at 5:21







Rororo

















asked Apr 7 at 1:36









RororoRororo

112




112












  • Intersect with 1000, use summary statistics, where case field is NUTS' id. Use attribute join by that id to transfer frequency to nuts table, perhaps to a new field.

    – FelixIP
    Apr 7 at 3:38











  • Are you looking for a count such as Ghana: 13, Croatia: 1, Mumha: 54, etc...?

    – Aaron
    Apr 7 at 4:02











  • Hello, actually at the end of the day I am looking for a count, say 5 in Lombardia, 10 in Piemonte, etc.

    – Rororo
    Apr 7 at 5:12

















  • Intersect with 1000, use summary statistics, where case field is NUTS' id. Use attribute join by that id to transfer frequency to nuts table, perhaps to a new field.

    – FelixIP
    Apr 7 at 3:38











  • Are you looking for a count such as Ghana: 13, Croatia: 1, Mumha: 54, etc...?

    – Aaron
    Apr 7 at 4:02











  • Hello, actually at the end of the day I am looking for a count, say 5 in Lombardia, 10 in Piemonte, etc.

    – Rororo
    Apr 7 at 5:12
















Intersect with 1000, use summary statistics, where case field is NUTS' id. Use attribute join by that id to transfer frequency to nuts table, perhaps to a new field.

– FelixIP
Apr 7 at 3:38





Intersect with 1000, use summary statistics, where case field is NUTS' id. Use attribute join by that id to transfer frequency to nuts table, perhaps to a new field.

– FelixIP
Apr 7 at 3:38













Are you looking for a count such as Ghana: 13, Croatia: 1, Mumha: 54, etc...?

– Aaron
Apr 7 at 4:02





Are you looking for a count such as Ghana: 13, Croatia: 1, Mumha: 54, etc...?

– Aaron
Apr 7 at 4:02













Hello, actually at the end of the day I am looking for a count, say 5 in Lombardia, 10 in Piemonte, etc.

– Rororo
Apr 7 at 5:12





Hello, actually at the end of the day I am looking for a count, say 5 in Lombardia, 10 in Piemonte, etc.

– Rororo
Apr 7 at 5:12










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318005%2fbuild-measure-of-state-change%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318005%2fbuild-measure-of-state-change%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Export of reprojected layer from GEE fails Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Iterate over features and years to export images for each feature-yearEarth engine reproject: why does reprojecting a pixel at 30m scale gives me pixels with an area of ~550?Exporting slope raster for entire country in GEEGEE Landsat SR year composite // mask cloud / shadow out w/ other method than quality pixel"export region contains no valid (un-masked) pixels - Google Earth EgineGoogle Earth Engine, how to distinguish between rivers/streams and ponds/lakes in a water maskPython script tool fails when processing rainfall data from Google Earth EngineGoogle Earth Engine Error: Number of pixels requested from Image.load exceeds the maximum allowedCloudfree images in small area from Sentinel-2Using Image exportToDrive in Google Earth Engine?

Creating closest line along the point''s azimuth using PostgreSQL Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given