Latest Contributions by JonathanBailey

Following is what my DBA has reported. Does this make any sense? select * from dba_tab_privs where grantee='PUBLIC' and owner='SDE' order by table_name; You’ll see the GDB_ITEMS there. This could suggest that synonyms are missing. The query doesn’t specifically refer to SDE.GDB_ITEMS. Is there a missing step to create those synonyms? There’s an easy way to do it: Thanks, Jon. ... View more

Hi Vince, I'll check with our DBA to see if anything like that has been done. I still don't understand, however, why the user seems to have access through ArcCatalog but not through other clients like SQL Developer. Thanks, Jon. ... View more

Hi Vince, Understood that I shouldn't be able to see the system tables in ArcCatalog -- but it seems that the GFPTest user can't access these tables at all. This issue arose because I was trying to connect to the geodatabase using a third-party tool, and received an error indicating that the GDB_ITEMS table couldn't be found -- which is what led me to connect with SQL Developer to see what could be accessed. Thanks, Jon. Edit: See reply at bottom for an explanation of why the third-party tool was generating an error. ... View more

Hi George, I'm trying to create a new geodatabase user -- so that user would need to be able to read the SDE and GDB system tables, wouldn't they? Thanks, Jon. ... View more

Hi Chris, I tried that, but it still doesn't seem to be producing the correct results. I changed the map projection to UTM, re-ran the tool, increased the tolerances to well larger than any differences that are present, still producing the same result. I also tried in ArcCatalog, with the same result. I also notice that if I check the Continue Comparison result, the tool generates more warnings -- for different features. I was under the impression that this option would create multiple warnings for the same feature, if warranted, but perhaps I misunderstand that. Thanks, Jon. ... View more

Hi George, Thanks for your response. Yes, if I create a new table in ArcCatalog using the GFPTest user, I can see it in SQL Developer. How can I configure the user so that I can see the rest of the contents in the database (especially the SDE and GDB schema tables)? Thanks, Jon. ... View more

Hi Chris, Yes, omitting the Shape field works. Why? However, I would like to compare the shapes -- but it seemed that the results that I was getting were wrong, based on the tolerances that were defined. Thanks, Jon. ... View more

Hi Brian, Thanks for your thoughtful response. It's the former case -- a version will represent an entire unit of work (for example, a new set of survey data). We wish to preserve that in its own version for record keeping; however, only some of the surveyed features represent changes to the features in the DEFAULT version, and only those should be posted. I suppose that your thought could work -- the entire survey could be loaded into its own version; we could perform an analysis to determine which features are "changed" and these could be copied into the appropriate feature classes in another version which is then posted in its entirety to the DEFAULT version. Thanks, Jon. ... View more

Hi Brian, What workarounds have you used in the past when you've needed to do this? Thanks, Jon. ... View more

OK. Thanks for your help and patience, Melita! Jon. ... View more

Hi Melita, After more discussions with the client, here's what we think is happening: Data are surveyed using GPS and coordinates are tied to WGS84. Surveyor publishes survey data in CAD and PDF format, tied to NAD83 (Original) UTM Zone <appropriate zone for the location; -- in the case of Ottawa, Zone 18N>; not sure what transformation is used to convert from WGS84 to NAD83, as there's no metadata carried through with the data. Coordinates are converted from UTM to geographic NAD83 and carried through the rest of the client's systems. I'm bringing this data into a dataset that's tied to WGS84; in the absence of any additional information, I'm using NAD_1983_To_WGS_1984_1 as the transformation, which is a zero-parameter transformation. Assuming that the surveyor used a zero-parameter transformation to go from WGS84 to UTM, the coordinates that I end up with in my WGS84 dataset should the same as those surveyed. Does that make sense at all? Thanks, Jon. ... View more

Hi Melita, Thanks for your response. Now I know why it recommended a different transformation depending on whether I had a basemap or not. The transformation that ArcMap is recommending is WGS_1984_(ITRF00)_To_NAD_1983. Currently, my feature class contains only survey-level data at the airport in Ottawa, but eventually it will contain survey level data at various airports across Canada. Would I be better off choosing one transformation to use everywhere across Canada (and would it be WGS_1984_(ITRF00)_To_NAD_1983?), or to choose a different one depending on the specific airport (i.e., maintain a different map document for editing for each airport)? Also, my understanding is that the client uses WGS84 and NAD83 interchangeably, so I suspect that what is being reported as NAD83 may in fact be NAD83 (CSRS) or NAD83 (2011). Short of having a definitive answer on what it actually is, is there an approach that we can take to minimize the risk of assuming one over the other? Another possibility is that, since these surveys are conducted by different surveyors (in different provinces, which regulate surveyors), is that different reference systems (NAD83, NAD83 (CSRS), NAD83 (2011)) have been used for the different surveys, but that they all ended up in the client's database as "NAD83". In the future, we can fix this (by ensuring that surveyors specify exactly which reference system is used), but are there any approaches that we could use to mitigate the fact that we don't know exactly what the reference system is for existing data? Thanks, Jon. ... View more