Tag Info

Hot answers tagged

4

Not stupid at all buddy! Everyone has to learn sometime :) You may have already tried the way I am going to describe as I use QGIS 2.2 instead of 2.4. Open the attribute table, select New column and add the name and change the type: The format I normally use is YYYY-MM-DD when typing in the Date column: Hope this helps.


4

You cannot directly delete a row in a raster attribute table. This is because deleting a row would essentially be reclassifying the cells in that grid to NoData within the attribute table, which is not supported in ArcGIS. ArcGIS has a variety of tools to effectively "delete rows" including (to name a few) Reclassify and Con. These tools actually ...


3

If you are only interested in the attribute table, you can use the Summary Statistics tool, where 'Statistics Fields' = fields to sum, 'Statistics Type' = SUM, and 'Case Field' = ID.


3

In 2.4 there is even calendar widget ("date picker"). In the layers "Fields" tabs, select "Date/Time" widget for a date field and check "calendar popup" option in widget detail settings.


2

Assuming that the numbering of your rows always starts at 1 and proceeds with increments of 1 to a different number each time I think your model/code needs to do this: Use GetCount to count the number of rows (numRows) Use Calculate Field to do (numRows - ID) + 1


2

If I understand your question correctly, it sounds like want to have three points created for each row in your table (one for each of the three fields). When ArcMap imports a table like this, it will only create one point feature for each row in your table. So if you want it to create three points per row (one for each of your fields given for each ...


2

Try editing your table so the field names don't contain spaces, special characters etc. That's what causes the error on export to shape, and may be the root of some of the other issues you have as well...


2

You can use the Dissolve tool. You choose the dissolve field (ID) and then SUM for the statistics.


1

I do not believe there is a tool or function that allows you to export a table with reordered fields. If anyone knows better please enlighten me! I've always felt it has been a bit of a limitation that the geo-processing tools do not honour the reordered fields. Especially the conversion tools . In the past I had attempted to create a tool that did it. The ...


1

Right click the field and choose "Summarize" then choose your field and the method by which to summarize that field. Sum is what you are looking for.


1

You need a codeblock in your field calculator. The example below is with a Python parser total = 0 def cumsum(inc): global total total+=inc return total The first line initialize a variable to 0, then you define a function called cumsum with one argument. for the incrementation, you want your variable to be "global" that will keep incrementing the ...


1

The 'best' way depends on your intended use and the data itself. PolyGeo's comment and my answer at your follow-up question both suggest reviewing Join vs Relate. Your data can make use of a Relate, but doesn't have to. Some data sets don't have that choice. It's all about columns and rows. You have a set number of points. As long as each point has one and ...


1

Where is your image ? There was lots of Python modules to parse KML files (Pypi: KML) and you can also use all the Python modules to parse XML files (Pypi: XML), lxml is one of them, but not the easiest to use. For example bikepathparse.py is a script that parse a KML file (with lxml), and return path list of dictionaries with lists of coordinate points ...


1

I finally managed to do this. I created a new field (called it joinfield) with the $rownum expression I created a set of consecutive numbers (1,2,3...). I duplicated the attribute table, created another joinfield, amd this time I used $rownum - x (the time lag you want to apply, in my case, 8 minutes). If the delay is the other way around you can use ...


1

Instead of loading the .csv using Add vector layer, use the Delimited Text layer tool. It will try to detect the most fitting data type for each column. For more details see the QGIS user guide.


1

The GRASS v.distance function can be used for this. In QGIS you can access the function through the GRASS plugin (the Processing version is currently not working). A light-weight alternative (for small datasets) is the NNJoin plugin.



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