Latest Contributions by JohnReiser

‎06-23-2021

We have a PostgreSQL server that is shared between departments. As there are non-GIS related tables in other databases on the same server, we'd like to limit the team working with ArcSDE from accessing or potentially impacting other data in other databases. In order to do so and to adhere to the principle of least privilege, we'd like to maintain an "sde" account without superuser privileges. We can make the sde account owner off the associated GIS databases, but would want to restrict the account from seeing the non-GIS databases. Is this possible? It would be acceptable if the majority of GIS tasks could still be completed but the tasks like kicking users fails. Are there any issues with restricting the sde account by removing the superuser role?

DevSummit Past User Presentations · ‎01-12-2018

Leveraging the Power of Databases for Spatial Analysis and Processing Abstract Databases can often be overlooked as simply an option for storage. Triggers, functions, and other functionality present in modern databases can help you perform spatial analysis entirely within your database. The talk will discuss and give examples how database rules were used to help quality control crowdsourced spatial data, a project management system that could update ArcMap, and how PostgreSQL is being used to study habitat change for 60 endangered and threatened species in New Jersey. Author John Reiser Organization Rowan University Contact Information 201 Mullica Hill Road Glassboro, NJ 08028 (856) 256-5117 http://njgeo.org/ @johnjreiser (Twitter, GitHub) Biography John Reiser is the Director of Information Systems in Analytics, Systems, and Applications at Rowan University. He also runs websites that make real estate data easily accessible to the public.

‎07-15-2014

When you add a script, you'll need to define those parameters. It looks like that scripts accepts a MultiValue of files, some booleans for the desired actions (save as AI, printing, etc) and then an output folder and another boolean for merging the files into one PDF. You can configure that yourself from within the Script's properties within your Toolbox. If you're more comfortable with ModelBuilder, you could use what this person outlined here: arcgis 10.0 - How to export data frame as PNG in ModelBuilder? - Geographic Information Systems Stack Exchange If you need a place to start for learning or getting a refresher on both Python and ModelBuilder, I have some resources that I've put together that are free: Scripting ArcGIS with Python & ModelBuilder Python Programming and GIS Naturally, the ESRI courses for Python are a great resource, too: Esri Training | Python for Everyone (free) Esri Training | Basics of Python (for ArcGIS 10) Esri Training | Python Scripting for Map Automation in ArcGIS 10

‎07-15-2014

You should be able to do the following: Iterate over a directory of MXDs Using arcpy.mapping, open each Write out the document's properties for later review: http://resources.arcgis.com/en/help/main/10.2/index.html#/MapDocument/00s30000000n000000/ Export the map document as a JPG: http://resources.arcgis.com/en/help/main/10.2/index.html#/ExportToJPEG/00s300000038000000/ Writing something like this should not take long. This will not check to see if the data frames have unbroken links, but if you know all of your MXDs are good to go, that shouldn't be a problem.

‎12-04-2013

Take a look at the csv.DictWriter class: http://docs.python.org/2/library/csv.html You can then specify a dictionary to writerow, with the order specified as a list when the DictWriter was created. You should then also change your loop to be a list of dictionaries instead of a list of lists, aka a 2D array, as it is now. Not tested, but this should work: import arcpy, csv fc = "E:\HUC2_DATA\HUC02\NewShapes\Result.gdb\HUC02Transect200m15pt" #input feature class rows = arcpy.SearchCursor(fc) fieldnames = [f.name for f in arcpy.ListFields(fc)] csvFile = csv.DictWriter(open("E:\HUC2_DATA\HUC02\NewShapes\HUC02Test.csv", 'wb'), fieldnames) #output csv allRows = [] for row in rows: rowlist = {} for field in fieldnames: rowlist['field'] = row.getValue(field)) allRows.append(rowlist) csvFile.writeheader() for row in allRows: csvFile.writerow(row) Hope this helps.

‎12-04-2013

Your problem is likely due to a CGI script starting from scratch for each request & IIS is timing out because the script takes too long to start. You might want to look into a framework like FastCGI or Web.py. That way, your ArcGIS Engine (via arcpy) is fired up once and left running until the server shuts down. Each request of the FastCGI/Web.py script reuses the same objects from modules like arcpy, psycopg2, etc instead of recreating them each time. FastCGI on IIS: http://www.iis.net/downloads/microsoft/fastcgi-for-iis Web.py: http://webpy.org/ (on IIS: http://webpy.org/cookbook/iis7_iis6_windows_pyisapie )

Read-only SDE user · ‎02-14-2011

你好!我想实现truly read only SDE user. I am currently using PostgreSQL as the backend to a 9.3 SDE database. I have a "gisuser" role that has only been granted SELECT privileges on all the tables in the database. Also, the role was created with basic privileges: nocreatedb, noinherit, etc. I've found that selections fail unless the current user to has a schema in the DB. I'm assuming Select By Attributes requires the creation of temporary tables. I'm sure there are other functions out there that also require the current user to have some privileges for temporary data storage. However, giving the "gisuser" account a schema also allows the "gisuser" to create its own feature classes. I would like to be able to allow users (mostly GIS novices and students learning the software) access to data stored in SDE, but I want to prevent them from inadvertently creating feature classes in SDE. My concern is that most of geoprocessing tools (Clip, for instance) automatically specifies the output location to be the same workspace as the input features. I'm sure that someone will forget to specify a local GDB as the output and clutter up the SDE database with "orphaned" feature classes in the gisuser schema. Any ideas on how to provide access to SDE to several users through a "read only" account would be appreciated. Thanks! PS I'm not a DBA, so if I'm off on details I apologize and would appreciate getting set straight.

‎02-12-2011

It seems that if I specify the instance as "-i sde:postgresql:gis" everything is happy. I've looked around for documentation on how SDE handles connections and I didn't see specifying it as such from the command line. Is there recent documentation on how ArcSDE handles connections? Re-reading through the documentation hasn't made things clearer for me.

‎02-11-2011

I'm having an issue with sdetable on RHEL. I'd like to use sdetable to create some spatial views. I've used sdesetup to create and configure PostgreSQL GDBs on my Linux server, so I know I've installed SDE correctly and the .so libraries are in the correct locations. The error I receive is this: Error: Underlying DBMS error (-51). Error: Could not create a connection on server gis, for user gisadmin. Extended DBMS error code: -51 ERROR: cross-database references are not implemented: "sde.sde.sde_server_config" Do I have the permissions wrong in the DB? Is there something misconfigured? The error is the same for any operation; I also tried creating the join using sdetable and then tried making the view in psql, then registering it with sdetable. For testing this out, I just wanted to make a view that is a subset of a larger parcel feature class. Here's what I'm putting in at the command line: sdetable -o create_view -T just_glassboro -t parcels -c * -w "mun = '0806'" -s gis.rowan.edu -D newjersey -u gisadmin Of course, it fails with the error above. Any help would be greatly appreciated.

‎10-20-2010

This seems to work for me: And it works for me, too. Many thanks!

Online Status	Offline
Date Last Visited	Thursday

My Ideas

Latest Contributions by JohnReiser

sde superuser role on PostgreSQL

Leveraging the Power of Databases for Spatial Analysis and Processing

Re: exporting Jpegs with ptyhon

Re: exporting Jpegs with ptyhon

Re: Changing Column Order with Python Export CSV

Re: import arcpy fails with cgi script

Read-only SDE user

Re: Issue with sdetable on PostgreSQL

Issue with sdetable on PostgreSQL

Re: Removing one point from a multipoint feature class

Leveraging the Power of Databases for Spatial Anal...