Latest Contributions by Zeke

‎08-16-2013

I don't know about the Excel addin, but Calc, the spreadsheet in Open Office (free) will save as .dbf.

‎07-19-2013

There's also a tool to convert between tables, excel and csv. You can add it to a model, or adapt the code in your own scripts, or just use it on it's own. Very handy.

‎06-21-2013

I'm probably misunderstanding what you want, but is it to make the rectangular poly be coincident with the curveed poly between the two curved poly vertices? If that's the case, you can select the rectangle poly, click the Reshape Feature tool, then the Trace tool, then trace the curved polygon from vertex to vertex. See Help here. (Note that the image on that page refers to the additional instructions, not steps 1 - 7). If you get a Failed to Reshape message, it's almost always because your polys don't actually touch at the vertex. They may be a very small distance away, or overlap and not meet at the vertex.

‎06-10-2013

Thanks, but unless I'm misunderstsnding (always a possibility), what I was looking for was a count of the points in each classification, not the number of cells. Similar to a Select by Location if the raster classifications were polygons. That's essentially what I ended up doing once the Spatial Analyst license was released. Converted the floating point raster to integer using the Raster Calculator, converted that to polygons, merged all polygons for each classification, did a Select by Location on each class to get the count. There's probably an easier way, because that seems kind of Rube Goldbergish, but it worked.

‎06-06-2013

Is there a way to select points in a raster dataset by raster classification? I have a floating point raster created from the points, classified into 4 ranges by standard deviation. I want to find out how many points are in each range. I thought of converting the raster to polygons, but that requires an integer raster. Then I thought ok, convert the floating point raster to integer, but that requires Spatial Analyst, which someone else has checked out. Maybe there's something in Spatial Statistics, but not familiar with those tools. Thanks.

‎05-28-2013

Thanks both. Guess I never saw the relative path checkbox. We're still on 10.0, so I don't think python toolboxes are available at this point. The users do copy the whole folder, with their map templates, scripts, fgdb, etc. This isn't the most space eficient method, but they step all over each other's projects when they work out of a common shared folder and I get called down to fix it for them.

‎05-24-2013

Is it possible to make the path to the script for a tool relative rather than absolute? I have users who copy folders with the maps and scripts they need from one network location to another. Thanks.

‎05-18-2013

Distance is your only constraint, however, you could add penalties for slowing down at intersections. This is readily done as a service area analysis within the Network Analyst Extension. Thanks Dan, but wouldn't I at least need speed limits? Like I said, I could default those, but don't have them currently. This would be great if I could do it. Love expanding my skills.

‎05-17-2013

The fire department wants a map showing 5 and 7 minute response zones around each fire station. The only time data available is response time to past incidents, and our street layer doesn't (reliably, anyway) have speed limit data. It does have road class, such as freeway, major arterial, minor arterial, collector, etc., so I could put a default value for each of those if it would help.But since the speed limit doesn't apply when responding, don't know if it would help. I don't know how to determine the response time from this data, though. Rarely use Network Analyst, although I have done a little with it in the past. One of the tutorials has an example showing closest stations to an incident with travel time and directions, but this isn't exactly what I want. Is there a reasonable way to do this with the data we have? Thanks.

‎04-23-2013

Thanks Tiffany. Creating the poly layer from the lines was a method shown in an ESRI Meetup seesion; I'd link to it, but it's a login site. The reason for doing it this way, if I understand correctly, is so that after running the C&L tool on the lines, generating the poly layer from them means they will automatically match up correctly. This is different than the method in the data migration white paper. I'm not sure I understand what you mean by running the topology on both subs & parcels at the same time. Do you mean the 6 rule topology? My understanding is that it's run on the parcel line and poly layer, then on the sub line & poly layer. Also, if I run the rule (sub) 'boundary must be covered by...parcel line', I'm going to get a lot of exceptions to mark where parcel lines don't cover the sub boundary (streets, alleys, etc.), although maybe there's no way around that. Guess I'm confused.

‎04-19-2013

Well, like I said, I was kind of nitpicking. A true recursive function is one that calls itself, not one that is called multiple times in a loop. A classic example is finding factorials: def factorial( number ): if number <= 1: return 1 else: return number * factorial( number - 1 ) You could do the same thing in a loop, which is usually easier to understand, but a recursive call is much more efficient - runs faster, less overhead, etc. - in many cases.

‎04-19-2013

Note sure about your specific case or the exact logic you are employing in your workflow, but the general method of recursion relies on using a while loop. I apologize if this seems pedantic, but a recursive function is one that calls itself, not one that loops per se. You can often (always?) accomplish the same thing either way, but one or the other may be more efficient depending on what you're doing. Loops are definitely easier to understand though.

‎03-26-2013

I've been running some practice cases migrating our data to the parcel fabric, and ran into a question about topology. Our data is in two separate polygon layers - parcels and subdivisions. Parcels in subdivisions should be within the subdivision, and share a border when appropriate. I can run and validate a topology on the existing data to make sure this is correct. So far, so good. My question is how to maintain this after creating lines from the polygons and then running the Curves and Lines Tool. I've been using a suggested practice of recreating the polygon layer from the lines after the Curves and Line tool, which ensures that the polygons and lines match topologically. This works fine on individual feature types, but wouldn't that workflow result in errors for parcels correctly fitting into subdivisions when the Curves and Lines tool makes different adjustments for parcels than subdivisions? Then I'd have to fix errors for the polygon and line parcel class. Am I thinking about this incorrectly, or is there a way to deal with this issue that I'm not seeing? Thanks.

‎03-20-2013

Found an option under Hide Details in the dialog box that appears after clicking the .lpk. Don't know how or if importing the xml has some option to set the cs, at least in 10.0.

‎03-20-2013

I'm importing some test data (parcels and subdivisions) into the parcel fabric in the LGM. I imported the LGM schema from the xml document. But, how do I set the coordinate system for the LGM so it matches the one we use? I can manually change the projection for the Parcel Editing dataset, but would I have to do that for every dataset as we move other data into the other datasets? Or is there a setting that controls this? It looks like there's a way to do this when setting up the LGM in 10.1, which we'll be using when we go live, but I'd like to get some practice in the meantime. Thanks.

Online Status	Offline
Date Last Visited	‎12-12-2021 01:00 PM

My Ideas

Latest Contributions by Zeke

Re: Saving Excel 2007 or 2010 as a DBF using the SaveDBF add-in

Re: How to convert excel to csv?

Re: Joining straight lines to curves

Re: Selecting points in raster dataset

Selecting points in raster dataset

Re: Possible to make tool script path relative?

Possible to make tool script path relative?

Re: Determine fire response time zones

Determine fire response time zones

Re: Curves and Lines tool creates topology erros?

Re: Recursive Python Function

Re: Recursive Python Function

Curves and Lines tool creates topology erros?

Re: How to set coordinate system for LGM (ArcGIS 10.0 sp5)

How to set coordinate system for LGM (ArcGIS 10.0 sp5)

Conditional formatting for cells in a layout table...

Re: Change Legend Item names

Re: Keep labels in layout frame in map series

Keep labels in layout frame in map series

Re: Append not working