202 reputation
210
bio website
location
age
visits member for 2 years, 1 month
seen 2 days ago

I'm a blockhead.

"Don't get tricked into believing that what's complicated is clever. In fact, endeavor to keep things simple, which, as we all know, is the principle of good design." -gar1t


Aug
18
awarded  Caucus
Aug
18
awarded  Constituent
Aug
18
comment Importing .shp to postgreSQL
@user30184 Absolutely correct, but do note that this assumes PostgreSQL 9.1 or higher. (There is very little reason to use anything older, in my opinion.)
Aug
18
comment Importing .shp to postgreSQL
-p for psql tells it the server's port, not the projection. The projection becomes embedded in the SQL script. See the fine manual for psql's behavior. In this case, the port the OP specifies is not the default port, so it is required. I would also generally advise against storing a shape without a projection. This limits your ability to change projections, which can be helpful for getting more accurate calculations.
Jul
16
awarded  Yearling
Jun
18
awarded  Citizen Patrol
Jun
18
comment Specify geoprocessing service connection at publish
I'm unclear on what exactly has to match. When I specify a connection file locally, it's essential a path, e.g. Database Connections\local.sde. What will ArcGIS look for to replace? The file path in my code? A parameter value (perhaps a workspace parameter)? What will it match on the server side? Additionally, are you saying that I need the data store to have different Publisher and Server database connections? My understanding is that this will trigger a data upload, which is not what I need. Sorry. I'm very lost on how to accomplish this, to the point that it's difficult to ask questions.
Jun
18
revised Specify geoprocessing service connection at publish
deleted 4 characters in body
Jun
18
comment What purpose do service definition packages serve?
I think I should clarify. When I said, "Could you elaborate?" I meant could you elaborate on your answer, not the specific text I quoted.
Jun
18
comment Specify geoprocessing service connection at publish
By the way, you can recompress an sd file. You have to use the right compression options. Options that work for me are Format: 7z, Word Size: 16, Solid Block size: Non-solid. I also set Dictionary Size to 64KB, but I don't think that matters. All other options were left to their defaults. (I made some educated guesses based on the fact 7-zip reports the compression method as "LZMA:16" for an sd file.)
Jun
18
comment What purpose do service definition packages serve?
I already have a separate question asking about configuring the connection. I asked this one because clearly there's some disconnect between what I thought SD files are for and what ESRI intends them to be used for; I was hoping to bridge that gap. Having a proper understand of what problem a tool is supposed to solve would help me better understand how to leverage it or whether I should be pursuing an entirely different option.
Jun
18
revised Specify geoprocessing service connection at publish
added 38 characters in body
Jun
18
comment What purpose do service definition packages serve?
That resource has left me with more questions than answers. In particular, I'm thrown off by this line: "Selecting this option creates a service definition file that will have to be configured to work with a server connection at the time of publishing." That seems to suggest there is some configuration option, but I sure can't figure out how to enable or use it. Could you elaborate? I'm a beginner in terms of ArcGIS, and what I have done, I've been consistently frustrated and confused by ESRI's designs.
Jun
18
revised Specify geoprocessing service connection at publish
added 579 characters in body
Jun
18
revised What purpose do service definition packages serve?
added 113 characters in body
Jun
18
asked What purpose do service definition packages serve?
Jun
18
comment Specify geoprocessing service connection at publish
So you're saying that packages are useless for redistribution when there are any differences between enviornments?
Jun
17
comment How do I use a server data store with a Python toolbox?
I opted to post a new question: gis.stackexchange.com/questions/102358/…. I may delete this one at some point.
Jun
17
asked Specify geoprocessing service connection at publish
Jun
17
comment How do I use a server data store with a Python toolbox?
"I can use one connection on my local machine and another on my server. (Right? Please tell me I'm right.)" Actually, I need to use different connections in different environments, and I don't want the people deploying to prod to have to recreate the service definition. The whole point is I need a variable connection. I guess I should revamp the question.