Tag Info

New answers tagged

0

I assume that your railway lines are not already divided up into the 5m segments. If they were, you could just create centroids (Feature to Point with Advanced or adding two fields and using Calculate Geometry to get the coordinates, then converting that xy to a point) from your lines and that would give you the points you seek. You could theoretically find ...


3

drag-drop an Excel XLSX file onto the layer widget double click tool QGIS geoalgorithms\Vector creation tools\Point layer from Table, choose the new layer as Input layer and specify the columns representing X- and Y-field, run the process Two steps using current QGIS versions.


0

The formula for calculating grid convergence (sometimes called meridian convergence) for spherical UTM projections was given (very incorrectly until just now) at How to Calculate North? In case that is not clear γ = arctan [tan (λ - λ0) × sin φ] where γ is grid convergence, λ0 is longitude of UTM zone's central ...


1

The problem you have apparently run into here is character encoding. Particularly when moving between programs and fonts as your Excel > Word > Arc pasting does, and single quotes are one of the worst characters for this issue. ` (upper left standard keyboard) and ' (next to Enter standard keyboard) are two different characters. Likely your 'shorter' quotes ...


0

The work should be based on a good data model. You should make sure your objects adhere to national standards - if any. In Norway a lot of work has gone into standardizing graveyards. A PDF document is available describing this standard. It is unfortunately only available in Nrwegian, but Google translate should be able to help you out. From the foreword: ...


2

I think it might be because you do not add a layer to Mxd in code, because if it is in accordance with your code, the final layer will only exist in memory, and will not be automatically added to your Mxd, so when you keep Mxd when the layer will not be saved. Therefore, you need to add this section of code. # AddJoin ...


3

I like to use the openpyxl module to write excel files. It's super easy once you get the hang of it. Your code would look something like this - #import system modules import arcpy, os from openpyxl import Workbook #Set environment options arcpy.env.workspace = r'Z:\project\....gdb' #Create Workbook & worksheet wb = ...


1

Another option, not sure if it's practical for your application, but if you want to create formatted and fancy excel sheets you could invest a little time in learning the xlrd and xlwt python modules. You can pip install or easy_install them. There is a bit of a learning curve, but they have worked well for me to create nice-looking report/summary ...


0

One option would be to: Create a list and append exception record ID's to list (unique ID column/value) After the update cursor runs, make a feature layer of the fc Use a search cursor and iterate through each feature while looping over the list from step one and perform a select layer by attribute (add to selection method) all the exception features Once ...


2

My favorite way to get data into excel while running an arcpy script is to simply print out that which I wish to have in excel, with tabs separating my values. Then I can copy/paste what is created from the shell into excel. First I print a header, with mycolumn names separated by tabs, and then as I iterate through my for loops I print the lines of ...


1

No solution, but a workaround: in SQLExecutor transformer select Microsoft Access (MDB_ADO) as the format, edit the SQL string, press ok, save, execute notepad++, open fmw-file, search&replace MDB_ADO with XLS_ADO, add some additional lines (XLS_ADO_SHOW_NAMED_RANGES, XLS_ADO_FIRST_ROW_IS_HEADING), save. Start working. Obviously FME2014+ recognizes the ...



Top 50 recent answers are included