1,107 reputation
318
bio website
location Flin Flon
age
visits member for 2 years, 8 months
seen 9 mins ago

A bushpilot turned GIS Tech. Learning on the job in Mining related GIS.


1d
answered Meter Coordinates to decimal Coordinates
1d
comment Meter Coordinates to decimal Coordinates
To convert them you will also need to know the coordinate system that they are from. Do you know this? If you don't, where are these coordinates for? Someone might know common coordinate systems for your area. Does ArcGIS already have the coordinate system for the Feature Class?
Mar
13
awarded  Critic
Mar
13
comment What is the most annoying fact about the GIS market/industry?
The three programs you listed have been around for a long time now, and they each started from different roots and different niches. They've been building on their own platforms which don't change easily. I would be surprised it the differences are just for the sake of being different. I think the differences aren't bad, they are a testament to the number of ways you can do the same thing. Although simpler, something is lost when everyone conforms. Besides, if it was simple, who would need professionals?
Mar
6
revised How to Transform Many Projections Into One With SQL Server
More clarification of the situation
Mar
6
comment How to Transform Many Projections Into One With SQL Server
I'll update the answer with the code I'm using right now.
Mar
6
comment How to Transform Many Projections Into One With SQL Server
You are right. There are about 40,000 points for now, but I expect it to get up to a few hundred thousand. I'm using arcpy.PointGeometry.projectAs for each point as I'm going through the table. It was a simple implementation until we figured out a better way to structure the database in the backend. I am assuming that having a database table ready to go in the right projection will still be faster than finding another way to implement the transformation on the user's side. Is this true?
Mar
6
asked How to Transform Many Projections Into One With SQL Server
Feb
2
comment How to use SQL Server Spatial without ArcSDE
Maybe a column that has the username of who has brought it down for editing, and then when that user uploads it, the username is taken out and remains empty when it's available to be edited.
Feb
2
comment How to use SQL Server Spatial without ArcSDE
@Conor that would be pretty smooth, but you're right, it's probably out of the realm of what I can do in a reasonable time and budget. However, I think I'll look into what a simplified version would entail where the data that I want to edit is brought down into a File Geodatabase and then updated in SQL Server from that when the editing is done. I'm already getting my hands dirty with plugins to interface with the other databases we use, so this might not be much of a stretch. It's always the validation that can prove difficult though...
Feb
2
comment How to use SQL Server Spatial without ArcSDE
I'm going to need to look into the Interoperability extension further. I've definitely heard of FME a lot, but I've never thought it was necessary since there are so many other tools that can convert data to what is needed. But it sounds like it's the seemless integration with the various parties that makes it stand out. Thanks for the tips!
Feb
2
comment How to use SQL Server Spatial without ArcSDE
The data consists of maybe a few million line segments. Sometimes we have a major update where we add many thousands of lines at time, but usually it's 100 here, or a hundred there that need a rotation, or replacement.
Feb
2
comment How to use SQL Server Spatial without ArcSDE
Editing is done by the 3 of us in the GIS group. We have about 25 co-workers who would only be viewing the data. As long as the 3 of us are able to edit/use/view the data comfortably, that is all we need.
Feb
2
comment How to use SQL Server Spatial without ArcSDE
Do you recall what the server solution limitations were that stopped you from pursuing it?
Feb
2
comment How to use SQL Server Spatial without ArcSDE
The only suggestion there is GIS Squirrel, or an Arc License. I would have thought there were other ways...
Feb
2
asked How to use SQL Server Spatial without ArcSDE
Dec
8
comment Tutorial on creating python toolboxes?
I suppose. My company has not, but I should pitch it to them that way...
Dec
8
comment Tutorial on creating python toolboxes?
I have used the ArcGIS .NET C# Add-in package with Visual Studio 2010 Express, which means Visual Studio would not need to be bought. I would think the Express version would be sufficient for the OP's needs as well.
Dec
4
comment spatial relation between springs (points) and geological faults (polylines)
I work for a mine, but am not a geologist. So I have some understanding of faults, but not how they are represented. I'm guessing that your faults are depicted on the surface. Do you have data pertaining to there vertical orientaion or dip? If so, once you know the distance and direction of each point (spring) from the closest line (fault) you could also project the fault lines downward and see the relationship at depth. Or if you have a geological trend direction at each spring, than you could see where the springs and faults intersect at depth. But these both start with a Near table.
Dec
3
answered spatial relation between springs (points) and geological faults (polylines)