Latest Contributions by MarcoBoeringa

‎02-19-2015

I am actually running in an interesting minor issue. I have rare case where I have a long string object, in which both a Definition Query is stored using a SQL predicate with a LIKE using the "%" character, and a variable that I would like to go through inline variable substitution. Now I noticed this inline variable substitution fails, if the string also contains the "%" character. This is probably no surprise, as the LIKE statements' "%" character, can not be replaced, and apparently causes the entire inline variable substitution to fail. Is there any way "inline variable substitution" can be escaped, so a to prevent an attempt to replace the % character? E.g., to get an idea, I have something like this: name LIKE ('%road');%Layer Folder%\LayerName.lyr

‎02-19-2015

Nothing to be embarrased about or to apologize for. We have all been there trying to make sense of the Geodatabase concept and all the documentation. Glad to have been of help, and certainly check out that Help page I linked as well!

‎02-19-2015

Marco Alejandro Bonilla schreef: Joshua, Inside SQL there are not such thing as versioned views. I can see a&d tables, also some "i" tables and the tables corresponding to the feature classes but nothing as "evw" tables. Is there another way to reach them? Tks They aren't listed under tables, they are database views! You should look under Views in SQL Server Management Studio to find them... Instead of fruitlessly trying to compress to state 0, you may also consider connecting to a specific version using versioned views. This may give a more "recent" picture, although it won't resolve all your issues, as it will not show edits going on in any other specific versions. You can find more information in this particular Help topic, especially see the remark about the set_current_version ability of versioned views: What is a versioned view?

‎02-15-2015

Dan Patterson schreef: The jumble reflects the way things were done within the model or sub model. The only way to fix that, is to examine the sequence that each part of a model was defined, then reorder it within the model...there are limited tools for doing that in modelbuilder. Admittedly, the way to force process flow effectively within the graphical ModelBuilder environment takes a bit of time to understand fully, it is not the most clear part of ModelBuilder for someone learning ArcGIS. But once you really understand how to use preconditions, and how to take advantage of Calculate Value and Merge Branch in this context, you can in fact control the exact flow and order of processes in ModelBuilder quite effectively in my experience. The models of my Renderer are actually a nice example of small branched sections using preconditions, including boolean ones calculated by Calculate Value, to fully control the desired process flow. I have made extensive usage of these options. Once it is out, it may give some nice examples for you to use in your teaching practice.

‎02-13-2015

I understand, but ModelBuilder's visual approach can have it's advantages as well. Actually, my model is a nice mixture of small Python scripts to do stuff that can't be easily done with ModelBuilder, and other processes setup within models that show the overall layout and process flow. Since this is ultimately intended for a non-programmer's audience as well (I am working on an advanced ArcGIS Renderer for OpenStreetMap: see here for early results, I have since made significant changes: OSM Renderer for ArcGIS (Page 1) / Development / OpenStreetMap Forum ), this will need to be a bit more accessible than just "code"... Thanks for the response anyway Dan.

‎02-13-2015

Dan Patterson schreef: Just a quick question...have you exported the model that works out to a python script to see the order in which things are done? And if so, does the resultant script work if you run it? No, I hadn't tried. But now looking at the exported data, it can't be run, as I see a number of vital huge "list-of-value" type string variables, not properly incorporated. It seems a bit of a jumble. Anyway, I do see the five different subflows reflected, in the order I restricted them by setting pre-conditions (not that the order actually matters in this case...). By the way, this is ArcGIS 10.2.0

‎02-13-2015

Hi, I have a problem that I can't figure out yet, and maybe someone else has dealt with a similar issue. The issue I encounter is that I have one big main model build in ModelBuilder that contains a number of disjunct / unconnected process streams of submodels and tools. This is intentional, as the output of one process flow is not the input for another one. In total, there are five of such "unconnected" process streams in this main model. The order in which they are run, is actually irrelevant, as long as everything is run. Now I can run this model fine directly, and it does exactly what it needs to do, and all process flows are run and output data properly created. So no problem here. However, since I wanted to implement some Python validation code for the model's inputs, I thought I could simply "wrap" the model in a Python script, duplicating all the input variables in the Python script settings, and add validation code there, as you can't define custom validation for a ModelBuilder model Fine, that seemed easy enough... not so! After implementing this, I discovered that after just one of the five process flows is finished, somehow ModelBuilder returns back to the script... This means that four of the five unconnected process flows aren't being executed! I have no idea why this is. I have made several attempts at fixing this, for example by using the ModelBuilder specific Collect Values tool to collect all outputs of the unconnected subprocesses, setting preconditions, and set the output of the Collect Values tool as the only output for the model, but all of these attempts, proved futile. In all cases, the model bails after the first process flow is executed, returning back to the script. The script then simply reports being "Completed" without any errors... Anyone know of how to solve this, or is it really impossible to call such a type of ModelBuilder model with multiple unconnected process flows from within a Python scripts, and do I really need to split it all up, and call five separate models from within my script?

‎02-13-2015

Susan Zwillinger schreef: I'm assuming that the term "spatial view" is equivalent to an "indexed view" in SQL Server terms. No, a spatial view is a view containing a spatial column, containing actual geometries, and most likely a spatial index for these geometries to enhance display performance.This is not the same as an indexed view (indexes could just be attribute indexes, not refering to any geometry data). Simple columns with lat/long data are just attribute columns with numeric data from a GIS perspective, they are NOT equivalent to a geometry column. Susan Zwillinger schreef: Since the client wants to use Desktop Basic (and not Standard or Advanced), is there any problem with updating or adding new points in this scenario? This would either require custom development in ArcGIS, or your client could simply access the base table (not the spatial view) and edit the numerical lat/long data from within ArcGIS. If you have then setup triggers like Vince suggested, the spatial column should be updated as well, and the updated data visible in the spatial view.

‎06-29-2014

It sound to me like you are having projection issues. OSM data is in WGS 1984. Make sure you set ArcMap, or the environment export settings during conversion to CAD, to something your CAD system actually supports. If the exported CAD file is in a coordinate system your CAD system doesn't support, it may show up stretched or deformed compared to other data, as you experienced.

‎06-27-2014

Layerfiles (.lyr) can be imported into Pro. You cannot save a lyr file. Pro will save lyrx files which are not backwards compatible to 10.x Hi Kevin, is that option for importing layer files (*.lyr) 100% compatible, and especially will the display of all feature symbolization and feature labelling be 100% the same in both ArcGIS for Desktop and Pro? It is a real nightmare for cartographers to have to redesign loads of layer files, so it is vital to have truly good compatibility and transfer of properties to the maximum extent possible.

‎06-27-2014

I checked the data to see if the deviations might be caused by measurement errors but they are accurate and represent relatively large differences in groundwater level head over short distances. This is because one well is representing the shallower unconfined aquifer and the other wells an artesian aquifer with much higher head. Simon, why are you combining groundwater levels of wells in different aquifers stratified vertically in one interpolation? As you already stated yourself, this can, and most likely will, result in significant differences in head if there is either infiltration, or significant seepage. In one instance, as demonstrated by a forester, I have seen water levels in a transparent pipe rise to 3 meters above ground level in a spring / brook system for a pipe going 100 meters deep and with known significant seepage, compared to a head of just 5 cm below ground level for the surface level pipe going just 1 meter deep at exactly the same location... This is an image I will never forget, as it demonstrated the mechanism and phenomenon of seepage so well. Combining such measurements in one interpolation is bound to cause major issues. I think you will need to remove any head measurements not related to the same aquifer. If needed, you can interpolate the other heads of the deeper aquifer separately.

‎06-10-2014

Thanks for the link & the time you put into the step by step directions! Thanks, I'd be interested though to here some real confirmations that people actually managed to install their copy of an ArcSDE Personal Server using these instructions. Was it all clear enough? Any step or issue I forgot? Did you manage to get it up and running in one go?

‎06-05-2014

Have a look at the below link: http://www.esri.com/software/arcgis/geodatabase/multi-user-geodatabase Check the "Desktop" Multiuser geodatabase(also known as SDE Personal Geodatabase), which comes free along with ArcGIS Desktop. But, there are certain things that you need to consider for the above type: 1. You need SQL Server Express to use that 2. Even though almost all the functionalities of SDE(versioning, replication, etc) is available with it...it has a limitation on the Number of Concurrent Users (1 editor and 3 readers) To extent on this, I have written a detailed instruction of how to install a "Desktop Geodatabase" a.k.a. "Personal ArcSDE" a.k.a. "ArcSDE Personal Server". You can find it in this post in another thread. This is definitely the way to go for you, unless you need to store massive amounts of data (you are restricted by Microsoft to 10GB databases by SQL Server Express, but you can setup multiple databases), or need more than 1 editor and 3 concurrent readers directly on the SQL Server database (ESRI limits you to that). This whole setup of SQL Server Express and a Desktop Geodatabase, could be considered "a poor man's ArcSDE" 😉 since you pay 0 for a separate ArcSDE / ArcGIS for Server license, but than, you already paid a serious price for your ArcGIS for Desktop "Standard" license... (you can not create a Desktop Geodatabase based on just a "Basic" license). Note that you can also run this setup based on an ArcGIS for Home Use "Advanced" license, but only for non-commercial activities as restricted by the ArcGIS for Home Use program's license. There is definitely a learning curve for all of this when coming from an Access / *.mdb personal geodatabase environment, especially regarding getting to know SQL Server, but it is well worth the effort to learn to manage this!

‎06-04-2014

1- How can I tell if my data is spatially fragmented or not? The short answers are: 1) By observing the character of the returned rows 2) Reorganize the table with an ORDER BY query 3) No, the index isn't the problem. To supplement the bold comment: do the returned features while in the process of being displayed in ArcMap pop-up randomly all over the screen (sign of spatial fragmentation!), or do they draw from one side of the screen to the other (direction arbitrary) or, more logically, in blocks / groups of features in close proximity to each other (data spatially structured, less fragmentation), e.g. when the data has been added to the table on for example a neighbourhood-by-neighbourhood or county-by-county basis. 3- Doesn't spatial index help in this case? Not much, if the data is all over the place in terms of spatial location, to extract a single view in ArcMap, ArcGIS will need to do an almost full table scan (or at least pick specific record data from everywhere in the table) in the table to get your data, which is less efficient than reading large blocks of grouped data. You really need to restructure the data in this case, as Vince suggested, especially if the Feature Classes contain massive amounts of records.

‎06-03-2014

the smaller the cell size is, the closer the raster surface will be to the the mathmatical result, right? So in theory i can get a very detailed raster surface (forget about the interpolated errors) even with small amount of input point data right? Jason No, the raster cells will always conform to the mathematical result. *With this I mean the raster cell's centre!*, but since the raster cell's centre is the value assigned to the cell, you could say the entire cell conforms to the mathematical result. But of course, the smaller the cells, the more the resulting raster will "look" like the computed surface if you could view both in 3D, and this is what you probably meant to say. The raster is a kind of pixelated approximation of the true computed surface. So in theory i can get a very detailed raster surface (forget about the interpolated errors) even with small amount of input point data right? Jason Don't equate a "very detailed raster with small cell size" to being an accurate / reliable raster... Cell size is arbitrary in terms of accuracy, it is just a property of the output you set during the interpolation. The more sample points you have, the better your estimate will be, so to increase the accuracy / reliability of the raster, you need more sample points, not necessarily a finer raster with smaller cell size (although setting a big cell size also doesn't make sense) By the way, a nice introduction to interpolation methods is "Geostatistics Without Tears" by Gregg Babish. See this post: http://forums.arcgis.com/threads/95588-Simple-Kriging-question-please-help!!?p=339687&viewfull=1#post339687

Online Status	Online
Date Last Visited	yesterday

My Ideas

Latest Contributions by MarcoBoeringa

Escape "inline variable substitution"?

Re: Enable SQL Access - Versioned Views

Re: Enable SQL Access - Versioned Views

Re: ModelBuilder / scripting issue

Re: ModelBuilder / scripting issue

Re: ModelBuilder / scripting issue

ModelBuilder / scripting issue

Re: Best practices for using nonspatial tables (SQL Views) as event layers?

Re: ARCMAP - OSM convert to CAD. MAP is being stretched a bit, help please.

Re: Python in ArcGIS 10.3

Re: Emprical Bayesian Kriging

Re: "Poor Mans" create child geo dbase workflow

Re: "Poor Mans" create child geo dbase workflow

Re: Huge Feature Class load slowly in Arcmap & Server

Re: Spline interpolation

Re: Hinduja Swiss (Switzerland) IT-Professional-Ho...

Re: Issues with Editors using the new threading op...

Re: Issues with Editors using the new threading op...

Re: Issues with Editors using the new threading op...

Re: Issues with Editors using the new threading op...