Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About ChristianWells
ChristianWells
Esri Regular Contributor
since
07-04-2014
3 weeks ago
284
Posts created
70
Kudos given
44
Solutions
229
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by ChristianWells
|
POST
|
Hi Katherine, you can return these values as strings with numbers prefixed by zeros using the zfill method. Python String zfill() Method num = 1
str(num).zfill(4)
'0001'
... View more
06-01-2016
07:57 AM
|
1
|
3
|
2395
|
|
POST
|
Another consideration here is that in SMSS, all shapes are stored and queried without a resolution or tolerance. However, in ArcMap we employ the use of these, which can, in some cases, truncate the coordinates therefore rendering an incomplete shape. In this case the Union Aggregate could be creating coordinates that are too granular for ArcMap to pick up. At this point, I would recommend contacting Technical Support to review this issue.
... View more
05-25-2016
03:22 PM
|
1
|
1
|
3041
|
|
POST
|
Although the query is successful in SMSS it seems that ArcMap is getting caught on the render part of the query, not the query itself. You could consider running an STIsValid() function in SMSS to see if any shapes are invalid: CREATE VIEW dbo.intermediate
AS
SELECT MIN(pa.OBJECTID) OBJECTID, MIN(pa.INT_NAME) INT_NAME,
MIN(pa.INT_NAME) + ' INT' AS CAMPUS, MIN(pa.ISD) ISD,
geometry::UnionAggregate(pa.Shape) SHAPE,
geometry::UnionAggregate(pa.shape).STIsValid() as validate
FROM dbo.pa_evw as pa
GROUP BY pa.ISD, pa.INT_NAME STIsValid (geometry Data Type) Edit: The return is a boolean where 0 = False and 1 = True. Any records that are 0 would be considered invalid.
... View more
05-25-2016
01:51 PM
|
1
|
3
|
3041
|
|
POST
|
Table_name can be replaced with the actual name of the table on disk or DBMS. Are you using SDE or a FGDB here?
... View more
05-24-2016
04:39 PM
|
0
|
1
|
7226
|
|
POST
|
You should be able to do this via a subquery: id = (select max(id) from table_name) To do this, standardized queries must be set to true: About standardized queries—Documentation (10.3 and 10.3.1) | ArcGIS for Server
... View more
05-23-2016
03:48 PM
|
0
|
3
|
7226
|
|
POST
|
Sounds like Amy is not using Versioning here. One thing that could affect SQL Server on the size of the file is the recovery model being used and the indexes.
... View more
05-19-2016
10:51 AM
|
0
|
0
|
1580
|
|
POST
|
Hi Amy, What DBMS are you using? Based off of that, how are you querying the DBMS to find the size?
... View more
05-19-2016
10:32 AM
|
0
|
3
|
1580
|
|
POST
|
Joshua Bixby, I'll use this thread to advocate for it with our product team.
... View more
05-12-2016
01:35 PM
|
0
|
0
|
418
|
|
POST
|
Does a capital 'N' work? Other tools have had this problem too, such as the Create Database user tool, where DOMAIN\tim doesn't work properly. However, I found that switching the value to a capital letter, allowed me to move forward, as \n or \t is an escape but not \T or \N. In reviewing the current defects within Esri Technical Support, the following defect sounds like the issue: NIM082676 - Unexpected behavior occurs when using input parame.. But as Joshua Bixby said, please log an Esri Technical Support case so we can attach you to this defect.
... View more
05-12-2016
10:19 AM
|
4
|
3
|
3654
|
|
POST
|
This could be the result of the domain having two different "owners". If you compare the XML documentation column of the GDB_ITEMS table do you see the fully qualified name of the domain having a different owner?
... View more
03-14-2016
08:17 PM
|
0
|
1
|
683
|
|
POST
|
The access level of the version is stored in the table's status column. To work with this column you would need to know a version that is public, private, protected so you can identify the status number for each. System tables of a geodatabase in SQL Server—Help | ArcGIS for Desktop However, if you are planning on using CreateVersion_management, an easier approach would be to use the Data Access module to list the version objects. Then you can use the version access property. ListVersions—Data Access module | ArcGIS for Desktop Version—Data Access module | ArcGIS for Desktop Sample: import arcpy
oldgdb = 'Database Connections\old.sde'
newgdb = 'Database Connections\new.sde'
for ver in arcpy.da.ListVersions(oldgdb):
arcpy.CreateVersion_management(newgdb, ver.parentVersionName, ver.name, ver.access)
... View more
03-09-2016
08:04 AM
|
2
|
0
|
1278
|
|
POST
|
Hello all, Please refer to Esri KB 45811 regarding CVE-2015-8277 45811 - Warning of two security vulnerabilities in Flexera FlexNet Publisher
... View more
02-25-2016
07:32 PM
|
4
|
0
|
2619
|
|
POST
|
Which version of the SDE/st_shapelib are you using? If I use a WKT example like you mentioned, where there is an extra coordinate on the line between two original points, ST_Equals resolves to true. select SDE.ST_EQUALS(
sde.st_geometry('POLYGON ((0 0, 2 0, 2 1, 2 2, 0 2, 0 0))', 0),
sde.st_geometry('POLYGON ((0 0, 2 0, 2 2, 0 2, 0 0))', 0)) FROM DUAL; Could you provide the WKT of the example you have?
... View more
01-19-2016
07:47 AM
|
0
|
1
|
3794
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 3 | 10-09-2025 08:31 AM | |
| 13 | 09-27-2022 06:23 AM | |
| 3 | 03-28-2024 05:12 AM | |
| 3 | 12-20-2023 06:42 AM | |
| 6 | 08-31-2023 05:42 PM |
Activity Feed
- Got a Kudo for Receive ArcGIS patch notifications in the Esri Support App. 03-24-2026 08:04 AM
- Got a Kudo for Re: Is it better to use Pandas/SQLAlchemy or Arcpy/SDE to retrieve data from MSSQL Server?. 10-14-2025 08:14 AM
- Got a Kudo for Re: Is it better to use Pandas/SQLAlchemy or Arcpy/SDE to retrieve data from MSSQL Server?. 10-13-2025 09:38 AM
- Got a Kudo for Receive ArcGIS patch notifications in the Esri Support App. 10-09-2025 03:01 PM
- Got a Kudo for Re: Is it better to use Pandas/SQLAlchemy or Arcpy/SDE to retrieve data from MSSQL Server?. 10-09-2025 09:29 AM
- Posted Re: Is it better to use Pandas/SQLAlchemy or Arcpy/SDE to retrieve data from MSSQL Server? on Python Questions. 10-09-2025 08:31 AM
- Posted Re: Is it better to use Pandas/SQLAlchemy or Arcpy/SDE to retrieve data from MSSQL Server? on Python Questions. 10-09-2025 08:23 AM
- Kudoed Hello from Your New Community Manager for ArcGIS Ideas for NairiSevajian. 07-11-2025 01:34 PM
- Got a Kudo for The Art of Resumes: Apply These Best Practices. 07-03-2025 10:39 AM
- Kudoed GIS Career Pathways: Support Analyst for CallumD. 06-24-2025 08:29 AM
- Got a Kudo for Receive ArcGIS patch notifications in the Esri Support App. 04-10-2025 01:00 PM
- Got a Kudo for Receive ArcGIS patch notifications in the Esri Support App. 03-27-2025 10:28 PM
- Posted Re: How to report a bug in ArcGIS Pro on ArcGIS Pro Documents. 03-17-2025 05:20 AM
- Got a Kudo for Receive ArcGIS patch notifications in the Esri Support App. 02-20-2025 10:16 AM
- Posted Re: Support Dot Esri Dot Com on Esri Technical Support Blog. 02-20-2025 08:57 AM
- Got a Kudo for Re: Future Proofing Your GIS Career. 12-18-2024 10:48 AM
- Posted Re: Bug with arcpy.management.EnableEditorTracking on Enterprise 10.9.1 on ArcGIS Enterprise Questions. 11-25-2024 09:10 AM
- Got a Kudo for Receive ArcGIS patch notifications in the Esri Support App. 10-28-2024 07:33 AM
- Got a Kudo for Re: Looking for Guidance: Masters in GIS. 10-26-2024 08:03 PM
- Posted Re: Future Proofing Your GIS Career on Esri Young Professionals Network Networking. 10-16-2024 10:56 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
3 weeks ago
|