Latest Contributions by LorneDmitruk

I'm reading a view from a non geodatabase Oracle table containing a number of date fields. In addition the view field names also contain spaces and parentheses. So I read the table into a pandas data frame using an sql query to get the field names GDB friendly, convert to a numpy record array and from there into a scratch table in a file GDB. I have played around using table to table but if I use field maps it takes a really long time to process, the table has over 100 fields as that's what the users want. Also the view has a couple of fields that are not required and I strip them out in the sql query. Unfortunately I don't have control over how the view was created and can't get it changed. ... View more

Apart from waiting for 10.4 does anyone have suggestions for dealing with dates not coming across from a numpy array to a table? ... View more

Setting Allowed methods to "None" results in the oldest imagery displaying over top the newest imagery. ... View more

Turns out the coordinate system in schema was way out to lunch in it's extents etc. etc. I ended up getting the right projection parameters into the schema and now things are displaying in the right spot. ... View more

Hi Vince, Here's the info you wanted: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production Long description of the source layer: ArcSDE 10.2 Layer    Administration Utility ----------------------------------------------------- Layer Description ....: <None> Table Owner ..........: PODS Table Name ...........: STATIONSERIES Spatial Column .......: SHAPE Layer Id .............: 385 SRID .................: 7 Auth SRID.............: 300004 Minimum Shape Id .....: 1 Offset ...............:   falsex:       -140.000000   falsey:          0.000000 System Units .........: 100079991719344.000000 Z Offset..............:     -30000.000000 Z Units ..............: 257348550135.457000 Measure Offset .......: -100000000.000000 Measure Units ........:      10000.000000 XY Cluster Tolerance .:          0.0 Z  Cluster Tolerance .:          0.000000000008 M  Cluster Tolerance .:          0.0002 Spatial Index ........:   parameter:    SPIDX_GRID,GRID0=2.8,FULL   exist:        Yes   array form:   2.8,0,0 Layer Envelope .......:   minx:      -113.34570,        miny:         2.30607   maxx:       -57.95347,        maxy:        57.39768 Entities .............: nslc3+M Layer Type ...........: Extended SQL Type/ST_GEOMETRY Creation Date ........: 10/30/13 11:39:02 I/O Mode .............: NORMAL Autolocking ..........: Enabled Precision.............: High User Privileges ......: SELECT, UPDATE, INSERT, DELETE Coordinate System ....: GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,98.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],VERTCS["CGVD_1928",VDATUM["Canadian_Geodetic_Vertical_Datum_of_1928"],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0]] Layer Configuration ..: DEFAULTS View SQL: create view podsstationseries as select * from PODS.StationSeries Register command: sdelayer -o register -l podsstationseries,shape -e nslc3+M -C objectid,USER -G 4269 -t ST_GEOMETRY -i sde:oracle11g:gs_dev:sheetcutter -u xxxx -p xxxx ArcSDE 10.2 Layer    Administration Utility ----------------------------------------------------- Successfully Created Layer. Spatial view long description: ArcSDE 10.2 Layer    Administration Utility ----------------------------------------------------- Layer Description ....: <None> Table Owner ..........: SHEETCUTTER Table Name ...........: PODSSTATIONSERIES Spatial Column .......: SHAPE Layer Id .............: 596 SRID .................: 6 Auth SRID.............: 300010 Minimum Shape Id .....: 1 Offset ...............:   falsex:       -400.000000   falsey:       -400.000000 System Units .........: 1000000000.000000 Z Offset..............:    -100000.000000 Z Units ..............:       1000.000000 Measure Offset .......:    -100000.000000 Measure Units ........:       1000.000000 XY Cluster Tolerance .:          0.000000008983 Z  Cluster Tolerance .:          0.002 M  Cluster Tolerance .:          0.002 Spatial Index ........:   parameter:    SPIDX_AUTOMATIC   exist:        No   array form:   0,0,0 Layer Envelope .......: <EMPTY> Entities .............: nslc3+M Layer Type ...........: Extended SQL Type/ST_GEOMETRY Creation Date ........: 02/12/15 07:52:52 I/O Mode .............: NORMAL Autolocking ..........: Enabled Precision.............: High User Privileges ......: SELECT Coordinate System ....: GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] Layer Configuration ..: DEFAULTS Screen shot of coordinates from display of feature class from view. This is not the full extent of the features. Here's a comparison of the coordinates between the spatial view and the source feature class: >>> with arcpy.da.SearchCursor("SHEETCUTTER.PODSSTATIONSERIES", 'SHAPE@XY') as rows: ...     for row in rows: ...         print(row) ...        ((2919522.7653198587, 5551640.811721431),) ((2919522.7653198587, 5551640.811721431),) >>> with arcpy.da.SearchCursor("StationSeries", 'SHAPE@XY') as rows: ...     for row in rows: ...         print(row) ...        ((-110.82411064233189, 55.476031885485135),) ((-110.82411064233189, 55.476031885485135),) Looks like there is major difference in the system units between the two in the long descriptions Cheers! ... View more

You need to keep in mind SQL Express is limited to 10 GB of storage, will only utilize a couple of CPU core and a couple GB of ram. Therefore as you add users and more data you hit the ceiling of what the database is capable of very quickly. Cheers! ... View more

Hi Cody, The geodatabase already exists when I run the tool. In this case my geodatabase is in Oracle. Cheers! ... View more

I found this bug, NIM084428  listed on the support site. The current work around is to use a file GDB. ... View more

What is the reasons of having mosaic inside mosaic? In my case organization. I have imagery for a number of projects, however there are situations where I want to have all the imagery from all projects available in a single place for convenience of the users. ... View more

You mean operation to workflow mapping ... Please send the steps with screenshots if possible .... Here's what I'm trying to do, I have a couple of existing applications as shown below: [ATTACH=CONFIG]22404[/ATTACH] And the existing operations workflow and operation [ATTACH=CONFIG]22405[/ATTACH] Here's the current workflow operation to software service association [ATTACH=CONFIG]22406[/ATTACH] So the View imagery operation is mapped to the google earth application. What I would like to be able to do is map the view imagery operation to the pipe access web application in addition to the google earth application. However when I access the pipe access web software service with the view pipeline imagery operation the operation to software service map shows the google earth mapping. [ATTACH=CONFIG]22407[/ATTACH] So I'm not sure how to proceed at this point. Can I just add the pipe access web to the operation as below and would it be a valid configuration? [ATTACH=CONFIG]22409[/ATTACH] Or do I have create a new workflow with the appropriate operations for pipe access web? ... View more