Latest Contributions by MarkPaulson

The zoom level need to be changed where it does not limit the zoom in on a web app. We are getting detail from small UAVs that are very detailed when zoomed in at 1:120. The trick by Kirk works but limits the base map availability. Mark Paulson ... View more

Thanks, but I already know that. I don't want the aerial from the drone as the base map. I want to overlay the available base maps but overide the base map limit of 19. ... View more

Is the zoom level still limited to 19. I have been gathering aerial with a UAV and the zoom level is not granular enough. ... View more

I'm glad I read this thread. I didn't realize there were other samples not listed in the table of contents. I haven't used the JavaScript API in a long time, but now I'm looking at getting into it again. It would be nice to see a listing of all the samples on a single page. The search is ok, but seeing a complete listing would be very helpful. Why not a link to a page that list all the samples? ... View more

Yes, something is wrong.  File geodatabase should be a bit faster, but not by two orders of magnitude.  Full table queries should always be bound by I/O access to the table blocks. - V Just heard back from ESRI support and they are experiencing the same issue with the data I sent them. I will post findings. ... View more

It sounds like you need to export this event layer into a feature class. - V That is exactly what I am doing. I then process that feature class with the add XY tool. This part takes about 44 minutes. If I export it to a file geodatabase and process that feature class the same way, it only takes about 40 seconds. While I understand it shoul take a little longer, I think taking 60 plus times longer means something is wrong... Thanks for the responses. ... View more

It's hard to tell what the issue might be without further clarification -- What version of SQL-Server are you using?  Express, Standard, or Enterprise? What version of ArcGIS are you using? Did you load the point data into an ArcSDE layer?  What storage format Do you have a spatial index built? - V I'm Running Express 2008 R2 and Desktop Advanced 10.1 sp1. I don't know what you mean by and ArcSDE Layer. Like I said I'm a noob. I drug a table created by querying another SQL database  on another machine which created the local table on my Machine. --TRUNCATE TABLE Temp_Prod_Data; DROP TABLE Temp_Prod_Data; CREATE TABLE [dbo].[Temp_Prod_Data]( [client] [varchar](50) NULL, [ownerno] [varchar](25) NULL, [propertyno] [varchar](25) NULL, [lease] [varchar](50) NULL, [API] [varchar](25) NULL, [LPD_ID] [varchar](25) NULL, [well_name] [varchar](50) NULL, [WELL_NUM] [varchar](15) NULL, [COUNTY] [varchar](50) NULL, [STATE] [varchar](2) NULL, [OPERATOR] [varchar](50) NULL, [YYYYMM] [varchar](10) NULL, [ProdDateT] [datetime] NULL, [ProdDate] [varchar](25) NULL, [GAS] [float] NULL, [OIL] [float] NULL, [Latitude] [float] NULL, [Longitude] [float] NULL, [DEPTH] [int] NULL ) ON [PRIMARY] GO INSERT INTO Temp_Prod_Data (client, ownerno, propertyno, lease, API, LPD_ID, well_name, WELL_NUM, COUNTY, STATE, OPERATOR, YYYYMM, ProdDate, GAS, OIL, Latitude, Longitude, DEPTH) Exec [trinitylt\SQL2008].[LandTracker].dbo.sp_Prod_Data_5_year_Export; SELECT * FROM Temp_Prod_Data; The above creates the table that I use to create the XY event layer which is then exported back into my database as a feature class. Which is what I use to add the run the XY coordinate tool. Hope this makes sense. I have no idea about the Spatial index. Thanks ... View more

Take a look at this sample perfect. Thanks for the help. ... View more

Hello all, I'm an idiot, I spent hours trying to figure this out and the whole time I had my X & Y reversed. The MakeXYEventLayer_management works perfectly. I'm a dumb a__. Now all I have to do is figure out how to export to the database with the correct coordinate system. ... View more

Is there a reason you're using an event layer in desktop?  The below code could be modified to simply write the geometries into a new feature class rather than printing the values.  It's untested code, but should be pretty close.  It reprojects each row of your csv file into the new coordinate system with the transformation and prints it out. import arcpy infile = open("yourfilename.csv","r") for line in iter(infile): aRow = line.split(',') point = arcpy.Point() point.X = aRow[5] #array position of X value point.Y = aRow[6] #array position of Y value inputSR = arcpy.SpatialReference("c:/coordsystems/NAD 1983.prj") outputSR = arcpy.SpatialReference("c:/coordsystems/NAD 1927.prj") pointGeometry = arcpy.PointGeometry(point,inputSR) projectedPointGeometry = pointGeometry.projectAs(outputSR,"Name_Of_The_Transformation") outputPoint = projectedPointGeomtry.centroid print outputPoint.X,outputPoint.Y The reason I am using the XY event layer is that it the manual process that I use and I have a schema.ini file that I use for the field formatting from my CSV. The bigger reason is that I am a beginner at Python and I barely have an idea what you are doing with the above code. I did try to modify it, but that started sending me down some other rabbit holes. For some reason, one of the fields  causes the position of the X and Y to move on some lines. Trying to figure this out is not a task I'm ready to tackle. Thank you for your input though. On another note, the project tool will work with the an event layer created with the "Display XY Data" option in desktop, but it will not work with "MakeXYEventLayer_management" in arcpy. I can try and project the feature class in desktop and it always fails. ... View more

You might need to project your data 2 times. First project it from NAD27 (source) to NAD83(destination) using right transformation for your region (for US excluding Alaska and Hawaii I gues it should be "NAD_1927_To_NAD_1983_NADCON"). After that grab new projected dataset and project it again from NAD83 to WebMercator using transformation for your region (again for US states other then Alaska and Hawaii it should be WGS_1984_(ITRF00)_To_NAD_1983). It's all possible using ArcPy Project_Managment function. I am not sure though if event layer can be used with this logic... Hope this helps. Shouldn't have to as it transforms fine in desktop... ... View more

So wouldn't your workflow simply be: 1. Make your XY event layer specifying NAD 27 LL as the SR 2. Project the event layer to web mercator specifying the proper datum transformation - output would be an on-disk featureclass. ? Tried that, but with no luck. Ended up calling ESRI support and the tech I spoke with couldn't get the tool to work they are researching it now. ... View more

I could be wrong, but I'm 99% sure you need to use the Project tool (using the xy event layer as input) to properly apply datum transformations for xy event layers. Note that for whatever reason you cannot use the in_memory workspace as an output workspace for the Project tool, but you can use the scratch workspace (arcpy.env.scratchGDB). Another option would be to apply the coordinate/datum transformation directly to the coordinates in your .csv file wth the Convert Coordinate Notation tool. See: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0017000000tw000000 According to the help, this tool will pick the "correct" datum transformation for you.... Perhaps the Make XY Event Layer tool does this also, but I'm not sure... The convert tool does not support web mercator. I will check on the project tool. I think the MakeXYEventLayer_management spatial reference option will do what I want but I have not had time to check. ... View more