Latest Contributions by JayJohnson2

‎01-21-2022

You could use Add XY Coordinates in ArcMap to convert the table of coordinates to points, and then share the result as a map. Leaflet can be used to publish it, but isn't required.

‎02-14-2019

Awesome. I wonder if dissolve would have helped me in early Navigator problems at BNSF.

‎01-17-2019

ArcGIS Pro: Calculate Field Python examples—Data Management toolbox | ArcGIS Desktop

‎01-17-2019

ArcGIS Help 10.1

‎01-17-2019

Expression: ' '.join([i.capitalize() for i in !STATE_NAME!.split(' ')]) Expression Type: PYTHON_9.3 Expression: string.capwords(!STATE_NAME!, ' ') Expression Type: PYTHON_9.3 Code Block: import string Expression: MySub(!STATE_NAME!) Expression Type: PYTHON_9.3 Code Block: def MySub(myfieldname): import string return string.capwords(myfieldname, ' ')

‎01-17-2019

Here is the way to do this in Excel: https://www.groovypost.com/howto/convert-text-uppercase-lowercase-capitalize-excel-2016/

‎01-15-2019

Joshua, I will try that. My coworker Ryan did get it to work without between: Status = 'Completed' AND Delivery_Date <= CURRENT_DATE AND Delivery_Date >= CURRENT_DATE - 365 Status = 'Completed' AND Delivery_Date <= CURRENT_DATE -365 AND Delivery_Date >= CURRENT_DATE -730 Status = 'Completed' AND Delivery_Date <= CURRENT_DATE -730 AND Delivery_Date >= CURRENT_DATE -1095 Status = 'Completed' AND Delivery_Date <= CURRENT_DATE -1095 AND Delivery_Date >= CURRENT_DATE -1460 Status = 'Completed' AND Delivery_Date <= CURRENT_DATE -1460 AND Delivery_Date >= CURRENT_DATE -1825 Status = 'Completed' AND Delivery_Date < CURRENT_DATE -1825 Jay

‎01-15-2019

My source data is a set of annual tables that have been merged into one. If I use these definition queries, only the first one works. Is there an error in my SQL statement? Status = 'Completed' AND Delivery_Date > date '2018-01-15 00:00:00' Status = 'Completed' AND Delivery_Date < date '2018-01-15 00:00:00' AND Delivery_Date > date '2017-01-15 00:00:00' Status = 'Completed' AND Delivery_Date < date '2017-01-15 00:00:00' AND Delivery_Date > date '2016-01-15 00:00:00' Status = 'Completed' AND Delivery_Date < date '2016-01-15 00:00:00' AND Delivery_Date > date '2015-01-15 00:00:00' Status = 'Completed' AND Delivery_Date < date '2015-01-15 00:00:00' AND Delivery_Date > date '2014-01-15 00:00:00' Status = 'Completed' AND Delivery_Date > date '2014-01-15 00:00:00' The data works fine as separate feature classes. My client requested I do it this way.

‎01-14-2019

It does.

‎01-12-2019

Joshua, how can I designate this tool to output file geodatabases? Or is that not possible?

‎01-12-2019

I was using the feature class to geodatabase tool. I am instead using data, export data in Map since that defaults to file gdb without much user intervention. The folder structure is fairly deep and has unique file names for point and polygon parcels, so I think writing a script would take about as long as exporting 100 counties.

‎01-11-2019

What is a good way to convert shapefiles to geodatabases in Pro? Can it be done as a batch? I keep ending up with a shapefile copy in my destination folder since there is no option to designate this file type. I would prefer not to use Map, that's what I am doing for now. It seems there has to be a way to get this to work, the Pro documentation promises it.

‎10-22-2018

Yes, except for the data part. I never heard Navigator speak about attributes.

‎09-06-2018

To create the mobile map package and to share the mobile map requires ArcGIS Pro. Loading the map card is after the fact. The routes are being compressed and used offline. You can easily replace the map cards for yourself or your phone/tablet users, they just have to spend some time in the office or online to get the updates.

‎06-27-2018

What sort of computer are you running it on? To check a computer for ArcGIS Pro system requirements: Go to http://pro.arcgis.com Click the Get Started tab Click the link at “Review the system requirements” On the right side of the page, click Supported Operating Systems Click check your computer’s ability to run ArcGIS Pro 2.2 A new page opens at systemrequirementslab.com Click the blue “Can You Run it?” button Detection.exe downloads, click Run (yes, that works without administrative rights) The program runs and gives you a report.

Online Status	Offline
Date Last Visited	‎01-21-2022 01:07 PM

My Ideas

Latest Contributions by JayJohnson2

Re: Creating a featurelayer from an array of locations

Re: MMPK opens in navigator but app crashes when trying to route

Re: how to change a field to proper case

Re: how to change a field to proper case

Re: how to change a field to proper case

Re: how to change a field to proper case

Re: How can I write a definition query for feature classes to divide a larger table by year?

How can I write a definition query for feature classes to divide a larger table by year?

Re: Workflow for converting shapefiles to file geodatabases in Pro

Re: Workflow for converting shapefiles to file geodatabases in Pro

Re: Workflow for converting shapefiles to file geodatabases in Pro

Workflow for converting shapefiles to file geodatabases in Pro

Re: ArcGIS Navigator Capabilities

Re: Is navigator compatible with ArcMap 10.3

Re: Create Mobile Map Package failed at 72%

Re: Authoritative GIS Data for New Mexico

Re: Adding shapefiles in a different coordinate sy...

Re: Is navigator compatible with ArcMap 10.3

Re: ArcGIS Pro licensing limitation with hosted fe...

Re: how to draw links for georeferencing