Latest Contributions by ScottDeNeice

‎01-14-2020

When using the Create Enterprise GeoDatabase tool, the default is a 500 MB mdf and 125 MB ldf. Is there a way to change this? I have inventoried all of our sde databases, and only 1 is larger than 500 MB and that is due to a larger number of attached images. All the rest are less than 100 MB. The problem is, once you set the mdf/ldf file size, you cannot make them smaller. You can only ever shrink them to 500/124 MB. I am trying to create a tool that will create a geodatabase, and import a template schema, but do not want that size. I know you can create the db is SQL, then use the Enable SDE tool, but I was trying to find a way to create a tool that would leverage several other tools without having to create the db in SQL first

‎12-03-2019

Here is the form. The feature service is referenced in the form, but I will probably need to share the service for you to see it, as it is still in testing, and, therefore, in my content.

‎12-02-2019

I have 2 forms set up. 1 for a Polygon feature layer with a related Point feature layer. That survey123 form publishes with no issues. The other form is Polyline feature layer with a related Point feature layer. This service gives the error. Both forms point to separate feature services which have the Polygon/Point and PolylinePoint respectively. I can see no difference as to how the services or forms are set up, but cannot get the Polyline service to publish. The workflow is for field person to walk or draw a perimeter (polygon) or line(like a creek or fence) for the line feature, but to have photos that are related to the feature be at the spot of the photo, vs, click anywhere on a line or polygon. As I said, the Polygon/Point publishes, but the Polyline/Point fails on the error above. Any help or ideas would be greatly appreciated.

‎06-07-2018

Unfortunately, this is a third party service that I am working with on behalf of branch office of my company. I do not even know the contact for the third party to ask. FYI the feature class this comes from has over 600 columns (wayyyyy to big). There are, however only around 1600 features so, the process takes only a minute or two. My work around is to download the full feature, then do a make table view where I add the where clause as a parameter. Cludgy, but it works. I am using this tool as part of a model (in ArcPro 2.1) to download an AGOL feature to then output to a formatted (there are several different reports from this one feature) Excel spreadsheet, and the client wants to have the ability to produce annual, bi-annual or quarterly reports (possibly even monthly reports). Thanks anyway.

‎06-06-2018

Service works, as I can download the data without the where clause. Also, tested against the rest service, I can query in the rest service as well. I have figured a work around but it is not as clean as this would be. (What I really want is a between, VISIT_DATE >= date '1/1/2018' AND VISIT_DATE <= date '3/31/2018', for example). I have also tried VISIT_DATE > timestamp '2018-01-01 00:00:00' to no avail. Thanks for your help

‎06-05-2018

Has anyone tried to use the where clause in this tool to query for a date range? I can query via the rest api, and I can query the downloaded file geodatabase. However, no matter what syntax I use in the Where clause dialog box, I get URL erro (URL is incorrect. Or, Service is secure, please enter username and password) Thanks

‎05-22-2018

Thanks. I figured that was the case but was hoping someone knew a way around it.

‎05-22-2018

Hello, I am trying to create a model that will extract data from a feature data service hosted in AGOL into a fgdb, (using the Download Service tool) and then create a query layer (to insert columns into a new table where there are many case statements like if column a is null use column b (CASE WHEN column a IS NOT NULL THEN column a ELSEcolumn b END AS newcolumn). The last step is to export that data into a formated xlsx file, where the xlsx file has the column names and several other columns have built in expressions to calculate data from columns in the spread sheet. Is it possible to do the last step in model builder. I know I can create a new xlsx file using the Table to Excel tool, but do not see any way to export to an existing xlsx. I am using ArcGIS Pro 2.1.2. My python is limited to exporting a model to a script and make some slight modifications, so not an expert in actually programming with python. Thanks

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

My Ideas

Latest Contributions by ScottDeNeice

is there a way to limit the default mdf and ldf values when creating an enterprise geodatabase in sql

Re: Incompatible geometry types: esriGeometryPolyline! = esriGeometryPoint

Incompatible geometry types: esriGeometryPolyline! = esriGeometryPoint

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Download ArcGIS Online Feature Service or ArcGIS Server Feature/Map Service

Re: Append an existing Excel file using model builder

Append an existing Excel file using model builder