Latest Contributions by DavidDenham

‎02-24-2020

I would also like to be able to download a previous version of Survey123 Connect. There is a bug in the most current version that changes the Survey123 basemap to the US Topographic base map. Previous versions of connect did not have this issue.

‎10-09-2019

Mark, Has the Full Motion Video add-in for Arc GIS Desktop been discontinued? When I go to my.esri.com I cannot find the FMV add-in under the download tab.

‎02-25-2019

I am having issues with two layers not being shown on the map in #Collector for Android, but they work fine in Collector for iOS. In both applications the services appear in the Layers list, but in the Android Collectore application the layers are turned off and I cannot make them display again.

‎02-05-2018

I want to automate the import of the XML file into a personal geodatabase so that I can generate a feature class from the XML file. So I would appreciate any advise, but the connection is where I am getting stuck now. I have not been able to find any on how to handle to connection when importing a XML file.

‎02-02-2018

Unfortunately we do not have a license for the Data Interoperability extension and I do not think that we can justify that for a single project. I am under the impression that the data belongs to Waze I do not believe that I can share it with the public. I will try to tell you what I can. This file is xml version 1.0 and it is from the Waze GeoRSS feed. When I import the data using the import xml file in Access it generates 2 table 1 called "channel" that contains information on the area covered by the data and another called "item" with contains the incident data with 15 text fields. Let me know if there is some other information that would help.

‎02-02-2018

I am working on a python application to download information from Waze that we receive in XML format. I have the part of the code written to download the file and name it based on the time and date. The problem that I have is automating the import of the XML file into a personal geodatabase. I am using pypyodbc to establish the connection to the database and the cursor for the SQL statement to import the xml data. The only example I have been able to find it for importing an Excel spreadsheet into Access. cnxn = pypyodbc . connect ( r 'Driver={Microsoft Access Driver (*.mdb, *.accdb)};' + r 'DBQ=C:\Users\Public\Database1.accdb' ) crsr = cnxn . cursor () crsr . execute ( r "SELECT * INTO fromExcel " + r "FROM [Excel 12.0 Xml;HDR=YES;IMEX=2;ACCDB=YES;DATABASE=C:\Users\Public\xlData.xlsx].[Sheet1$]" ) crsr . commit () crsr . close () cnxn . close () The part after "crsr.execute(" is where I am having problems with the syntax to set the name for the table. I cannot find much information on this part. Has anyone else dealt with this issue?

‎06-06-2017

There is a tool available here that will check for gaps, overlaps, and parity issues in the addresses in centerline data. I have used it in the past and it has been very useful.

‎01-27-2017

We use a similar strategy here. We have backup servers set up in case one or more gets damaged, but I still maintain local backups in various locations. It may not be as impressive as the applications that we can make now, but worst case scenario we can still perform analysis and print hard copies.

‎01-27-2017

I am not certain, but I believe that is the way that we have our Portal configured. We participate in the Community base map program and as a benefit they send us a copy of our data that ESRI uses to create the topographic base map. We use that to create a local cache for our server. That way we have a consistent look for our applications no matter which source Portal or AGO.

‎01-27-2017

Have you looked at using Portal for ArcGIS? It has a lot of the features that ArcGIS Online offers, but it is locally hosted. We have been using it for applications that we do not want to put on Arc GIS Online.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by DavidDenham

Re: Download earlier versions of Survey123 Connect

Re: Use Drone videos for Full Motion Video extension

Re: Hosted feature layer not showing in collector

Re: Importing an XML file into Access using Python

Re: Importing an XML file into Access using Python

Importing an XML file into Access using Python

Re: Any ideas for a check to find gaps in address ranges for connected road segments?

Re: Acces to ArcGIS Online Resources in Emergency Situations

Re: Acces to ArcGIS Online Resources in Emergency Situations

Re: Acces to ArcGIS Online Resources in Emergency Situations

911 GIS