POST
|
Thanks for your answer. I adopted your solution of setting the data frame projections and it worked. When I just ignore the warning, I would see a red exclamation mark against the basemap in TOC and won't see any basemap being displayed. After setting the data frame projections to match with the shapefiles, I am able to see the basemap displayed correctly. Presently, I am not that much worried about the accuracy.
... View more
12-18-2014
12:53 PM
|
0
|
0
|
2712
|
POST
|
I am trying to add shapefiles (lines) to the mxd file with the ESRI World Street Map as basemap. I get an error "Geographic Coordinate Systems Warning" The following data sources use a geographic coordinate system that is different from the one used by the data frame you are adding the data into" I noticed that I get this error only when I add a line shape file and not when I add point shape file. Besides, both the line and point shape file have the same projections and coordinate systems when I checked it through the ESRI catalog. Would appreciate any thoughts as to why I keep getting this error message.
... View more
12-18-2014
08:43 AM
|
0
|
2
|
12851
|
POST
|
Xander Bakker. Thank you so very much. That was a good primer on data access, lists, set and string functions. Yes, I was able to work around the limitations of SQL prefix like DISTINCT not working on multiple fields through arcpy.da.SearchCursor. Wish ESRI would further improve "DA".
... View more
09-11-2014
03:19 PM
|
0
|
1
|
382
|
POST
|
@Xander Bakker What does this do: set("{0}_{1}".format(r[0], r[1]) . Specifically, the curly brackets {} and the need for format(). Is format() mandatory? Is it possible to breakdown the following into more "bite sized", multi-line code: unique_list = list(set("{0}_{1}".format(r[0], r[1]) for r in arcpy.da.SearchCursor(FC_or_TBL, (fld_name1, fld_name2, fld_search), where))) Also, what is the difference between set() and list() do. Can't you do an app
... View more
09-09-2014
12:45 PM
|
0
|
3
|
382
|
POST
|
Wowww. Does "DISTINCT" work for you? If so what version of ArcMap are you using? The whole problem started since use sqlprefix didn't work with arcpy.da.SearchCursor. It won't throw an error but wouldn't give the correct distinct recrods. So what do you mean by "Speed field is a test type and not numeric". Does python have a data type "test". Just to rant, python could use better terminology for naming their data types - arrays(can they hold strings?), list, set, dictionary, tuples...... Ofcourse, I'm not an expert but its totally confusing.
... View more
09-09-2014
10:44 AM
|
0
|
14
|
653
|
POST
|
I get error for these, because I dont have those modules: import cx_Oracle - Is there an equivalent for SQL Server, our SDE runs of it. import pandas - Is it an open source freeware? Just to be sure.
... View more
09-09-2014
09:16 AM
|
0
|
1
|
1818
|
POST
|
Does the sql prefix - DISTINCT work well on SDE tables. http://resources.arcgis.com/en/help/main/10.1/index.html#//018w00000011000000 Syntax SearchCursor (in_table, field_names, {where_clause}, {spatial_reference}, {explode_to_points}, {sql_clause}) An SQL prefix clause is positioned in the first position and will be inserted between the SELECT keyword and the SELECT COLUMN LIST. The SQL prefix clause is most commonly used for clauses such as DISTINCT or ALL. My following example is resulting in all rows, not distinct rows. rs = arcpy.da.SearchCursor(sTableName, (sSelectField1, sSelectField2), sSqlExp, None, None, ("DISTINCT", sSqlPostfix)) What elese could I do to get truely distinct records only. I store the values in a list and are they any function to get unique values in a list. Example [1,2,2,3,3,3,5,6,7] to [1,2,3,5,6,7]. Also set(xyz) won't work because I'm using a list, whereas set(xyz) works on tuples.
... View more
09-08-2014
02:20 PM
|
0
|
24
|
9903
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|