Latest Contributions by mpboyle

‎09-26-2014

I am using the developer WebApp Builder beta 2.0 and have an app built that uses a web map that is part of a private group on our AGOL site. When I download the app and deploy it to our web server and try to load it, I am prompted to sign in to view the web map. When I click OK to do so, I'm getting an invalid redirect error, show below. Any ideas what is causing this or how to fix it would be appreciated. Thanks!

‎09-18-2014

I can't be the only person after an auto-incremented field within the database. Is there a way of doing this within SSMS with a trigger, stored procedure, etc...?

‎09-18-2014

Is there a certain criteria where it would work and where it wouldn't? For a typical feature class, registered with the geodatabase, versioned or non-versioned (if versioned, I'm assuming it'd need to be on the A table if it would work). I'm really just after a good way of assigning an auto-incremented field in the table that is NOT the OBJECTID.

‎09-18-2014

Is it possible to use the Identity property within SQL Server for a feature class?

‎09-18-2014

Coming back to this topic...has anyone tried implementing a sequence to auto-increment a field within SQL Server...? Are sequences only available at SQL Server 2012 and above?...are they available within 2008 R2?

‎09-16-2014

I have just started playing around with SQL Server Reporting Services (SSRS) and trying to insert a map into a report using our GIS features stored in SDE (SQL Server 2008 R2). It seems pretty straight forward, but I'm not getting the desired results. I'm trying to insert a map that centers and zooms to the parcel the report shows. I have a parameter set and my dataset is filtered by the input parameter. That all works fine as the information displayed is correct for the GPN (id) entered in the parameter. What isn't working though is the map. The map doesn't show anything. Our parcel layer is around 100,000 features. The feature class I'm pulling from is in Web Mercator projection. A couple questions / issues: 1) Does my feature class need to be in WGS84 in order to overlay a Bing basemap? --> The coordinate system is set to planar since this is a Projected coordinate system. Can you not switch the coordinate system to Geographic within SSRS and have the data re-projected? 2) Why is my spatial data not being filtered the same way as my field data? 3) Are there certain properties of the map that I'm overlooking? --> In the map layer properties, the 'Use spatial data from: ' property is set to 'Spatial field in an analytical data region' with the SHAPE field being used. The filter property is set to GPN = @prmGPN. I have also tried removing the polygon layer and adding just the Bing basemap to get the coordinate system into Geographic and then adding the polygon layer through the add layer wizard. When I do this, I get the error: 'Must declare the scalar variable "@prmGPN". What exactly does this mean? Any ideas / suggestions / thoughts would be appreciated. Thanks!

‎09-11-2014

Ashley Seim‌ - We haven't had any issues when it comes to having the ability to add attachments on a mobile device using Collector. For the most part, I believe most of our users are using an Android device. The issue we were having is we had users trying to add attachments from their laptops through ArcGIS Online and it just didn't seem to work. We could browse to the photo we wanted to attach, but the photo wouldn't attach for whatever reason. For your issue...first of all, do you see the option to add an attachment in Collector? If memory serves me correct, once you create a feature, the ability to add an attachment is symbolized by a paper clip icon while filling out the attributes. If you don't see the paper clip icon, I might try re-publishing your service with feature access capability enabled. If you do see the paper clip icon and are having issues getting the attachments to post, that could be a whole different issue...internet connectivity, cellular reception, etc...

‎09-08-2014

I went to open Operations Dashboard and it tries to update but fails. I've attached the log file produced when failing. Any ideas? I've tried using a username with Admin rights and it also fails there too.

‎08-29-2014

Jake Skinner‌ Perfect! Exactly what I was looking for. Thanks!

‎08-29-2014

I'm trying to export the contents of a map document to shapefiles and then zip the folder that contains the shapefiles. Below is the script I have written so far. It only exports 1 layer instead of the 3 layers that are in the map document. I'm wondering how to iterate through the data sources and export each one? import arcpy import os import glob import shutil import time MapDoc = r'\\...path to mapdoc.mxd' ShpDirectory = r'\\...path to ShapefileOut folder' ShpZip = r'\\...path to ShapefileZip folder' mxd = arcpy.mapping.MapDocument(MapDoc) lyrs = arcpy.mapping.ListLayers(mxd) for lyr in lyrs: try: print(lyr.name,lyr.dataSource) except: print('Unable to retrieve layer information') inFeatures = lyr.dataSource inFeatureName = lyr.name arcpy.FeatureClassToShapefile_conversion(inFeatures, ShpDirectory) shutil.make_archive(ShpZip, "zip", ShpDirectory) del mxd I'm wondering what needs to be done to export each individual layer's data source? Thanks in advance!

‎08-22-2014

I suppose this is more of a question for Esri staff... Is the ability to add records to a related table using Collector an anticipated enhancement anytime in the future? If so, is there any sort of time table for this implementation? We have field staff that do many different types of inspections and having the ability to select a feature and create a non-spatial related record would be an ideal workflow for something similar to inspections. I am just curious if this is anywhere close to a possibility...?

‎08-22-2014

Have you tried using the AttributeAssistant tools that Esri has? They can be found within the Water Utility Network Editing download found here. You will get a sample geodatabase and map document. We only use the Attribute Assistant add-in, which can be used to automate all kinds of editing tasks...not just utility data. You will need to install the AttributeAssistant add-in and copy in the DynamicValue and GenerateId tables found within the sample geodatabase. Rules are built within the DynamicValue and GenerateId tables and there are examples within the downloaded data which you can use for reference, as well as the links below. I think for what you're after, you'll want to read up on the GENERATE_ID method within the DynamicValue table. Attribute Assistant rules: http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#//028s000000n6000000 Dynamic Value table: http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#//028s0000008z000000

‎08-20-2014

I believe I found the answer I was after... select Shape.STArea() as 'Area' from 'Parcel' Just as it appears in ArcMap and ArcCatalog.

‎08-20-2014

Does anyone know if it's possible to extract the shape details of a polygon (area, length) within a SQL Server query/view using a feature class with SQL geometry as the shape storage type...? Ex: I have a parcel feature class and I want to create a SQL Server (2008 R2) query/view within SQL Server that displays all the areas of the polygons...similar to the Shape.STArea() field within ArcMap/ArcCatalog. Is this possible? Thanks in advance!

‎08-11-2014

We have field users who are trying to add picture attachments to already created points but their attachments don't seem to be getting pushed to the database. The file that's trying to be attached is roughly 1.5MB in size ... so it's not a large file that's trying to be uploaded. They are Internet Explorer as their web browser and a hot spot for their internet access. When I try adding a picture as an attachment from here in the office, I don't have a problem doing so. I'm wondering if anyone has ideas what could be causing the issue on their end?

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by mpboyle

WebApp Builder Sign In to AGOL Error

Re: Using Identity Property within SQL Server Feature Class

Re: Using Identity Property within SQL Server Feature Class

Using Identity Property within SQL Server Feature Class

Re: Auto-Increment Field within SDE

SQL Server Reporting Services and ArcGIS Data

Re: Adding Attachments to Editable Feature Service

Update Fails

Re: Export Layers from Map Document to Shapefiles

Export Layers from Map Document to Shapefiles

Ability to add records to related table through Collector

Re: Autopopulate a field in a feature class when created

Re: Get Shape Content in SQL Server Query

Get Shape Content in SQL Server Query

Adding Attachments to Editable Feature Service

Re: Use Button to filter list

Print Error After February 2026 Update

Overwrite Experiences to Maintain IDs

Provide Icons in Image Elements

Re: Ballooning Feature Layer Size