Tag Info

New answers tagged

0

This question is fairly broad, and so I am going to give a largely theoretical answer. In short, there is not a MS SQL Server tool that would do this. However, it's still possible, if not easy. You can run a visibility analysis (viewshed) on any array of elevation values (aka raster) using an external script/algorithm. Python libraries (e.g. NumPy) are ...


1

Simply add the alias in quotes after the column name.


1

Take a look at ArchaeoFusion from the Center for Advanced Spatial Technologies. It appears to handle magnetic survey data. Free as of now, and has been for quite some time.


0

There is a very nice discussion which helped me on this issue.(WFS and BOunding Box) QuantumGIS 1.8: how to define bounding box within Add WFS Layer dialog I quote from the other thread" " Thank you very much for this hint, here is how I´ve done it: I started downloading the WFS content via add WFS layer dialog and canceld the action. QGIS will add the ...


0

You can use Ctrl + Enter to insert new lines in the fields to make it easier to read the query in the dialog


0

Not an expert, but try one of these: http://stackoverflow.com/questions/1085662/new-line-in-sql-query Explanation: http://blog.sqlauthority.com/2009/07/01/sql-server-difference-between-line-feed-n-and-carriage-return-r-t-sql-new-line-char/


1

towgs parameter is actually a 7 parameter datum shift from the CRS in question to WGS84 (EPSG:4326), because WGS84 is commonly used as a kind of a "base datum", to which all other CRSs have known 7 parameters transformations. Why the definition in QGIS is different is hard to say, but in QGIS you could easily create a custom CRS which would be defined ...


2

A For Loop automatically adds to or subtracts from the counter variable. You are subtracting one from it and then the loop itself subtracts one from the counter. That's why it skips every second records in your table. If you are sure all your records are polylines and that noe of them have more than one segment, you can do this in a single update ...


2

Alan I would recommend that you insert the start and end coordinates as separate rows in your table. In that way you can create points for these individually like explanined below. I'm assuming that you have already: - created your new table - made this new table mappable - read the coordinates from the polyline into varialbes called fX1, fY1, fX2, fY2 ...


1

Software that does not rely on GDAL/PROJ (like QGIS does) handles datum shifts separately from the projection. This is useful when several datum shifts exist for a specific projection. If you can not define a custom datum with the mapinfo software, reproject your data to a CRS based on the WGS84 ellipsoid inside QGIS. Or create a second custom CRS with ...


0

I use a GPX2Tab utility that you can download here -: http://www.wap3.com/download/gpx2tab.zip


2

Sum and Count are aggregate functions meaning that you need to Group the data by a column for them to be meaningful. In MapInfo, area(obj,"sq km"), will simply return the area for the first object that it finds whereas Sum(Area(obj, "sq km")) will sum the areas for all objects that have the same attribute value in the "Grouped By" column.


1

Try Mid$(Map-Lot, 5, 3) if all of the Map-Lot are the same number of digits.


6

If I understand your question correctly, you might have values in the Map-Lot field that look like the following: 017-001 017-002 018-121 And you only want to show the portion after the "-". So, the above would be displayed like this: 001 002 121 If your Lot number is always going to be three characters long, then you can use the following label ...


3

When doing a group-by you need to do it this way: select field1, field2, aggregate(field3), aggregate(field4), count(*) from .. group by field1, field2 This means fields NOT listed in the group by, needs to be aggregated in some way such as sum, avg etc. Alternatively they should not be in the select at all. In your case you have both area(obj,"sq km"), ...



Top 50 recent answers are included