|
POST
|
No I have not read that. Thanks you for the input. I have already made up the python for this current project based on James and Blake's input. But next time....
... View more
04-15-2015
09:58 AM
|
0
|
2
|
1444
|
|
POST
|
James and Blake thanks for the help. I am able to get the data out of oracle with cx_Oracle without any problems. I did run into a little bit of a hard time getting the sql output to a numpy array. James I would be interested in seeing a code snippet of your work flow.
... View more
04-14-2015
05:12 PM
|
0
|
2
|
3713
|
|
POST
|
Thanks for the info James. Why would the date not make it? Is that because the numpy does not support that data type or something?
... View more
04-14-2015
12:16 PM
|
0
|
1
|
3713
|
|
POST
|
The situation: I have a table that is in a oracle database that I need to query and then spatialize. I need to select the most recant updated record for each group. I have a last update column to base the max date on. Then I have a name and a sand type columns that should make up the groups. So after some looking I think this is the sql that I need: SELECT NAME, SAND, MAX(LAST_UPDATE) AS "DATE" from MY_TABLE GROUP BY NAME, SAND I have run it in Toad and it produced the desired result. After the query I will need to do a join to a table that has the lat and long data and then make a xy events layer and then export the thing to a feature class in our SDE. The question: What it the best way to do this query in python in such a way that I can pass the output to arcpy for the join etc. Thanks for the help, Forest
... View more
04-14-2015
11:23 AM
|
0
|
16
|
9851
|
|
POST
|
I was unaware of the dissolve with unsplit lines option. That does look like the best option for this part.
... View more
03-22-2015
11:21 AM
|
0
|
0
|
2012
|
|
POST
|
John, I can think of two potential ways to solve your problem. 1. Use python to to get the end points of the lines. Use how they intersect to populate the Prob_Owner. I did not think it all the way to a solution but it is fully possible and could be fully automated. 2. Use Arc tools. I would suggest the following workflow: a. Set up topology to highlight all of the areas where the lines intersect. b. Select by attributes all of the segments that have names: Maybe Prob_Owner LIKE '__%' Export the section to a new FC. c. Select by hand all of the lines that intersect other lines. Export them to a new FC. Invert the selection and export again. The goal is to have only lines that do not intersect in each FC. (if this is not practical because there are too many of them this solution is problematic. I guess I would goto python at this point or maybe there is a way to efficiently do this selection that I did not think of.) d. Merge with the editor tool all of the features in one of the FCs from step c so that there is only one record in the FC. Then use explode off the advanced editing tool bar to turn them back in to distinct lines. e. Spatial Join the output of step d with the the output of step b. f. Use identify to break the output of step e with the ordinal pipeline data set. g. Repeat steps as need for the output of step c h. Merge everything together and clean up. OK hope that helps
... View more
03-21-2015
01:10 PM
|
0
|
0
|
2012
|
|
POST
|
I see so each line is contiguous and each has many sub segments. But there is no attribute to tie the line segments together - such as a line name? So one would have to use some sort of spatial operations to understand how the segments relate to a line. Just trying to understand the problem....
... View more
03-20-2015
12:48 PM
|
0
|
1
|
2012
|
|
POST
|
Does each shapefile or FC have only one line in it? Or are there hundreds of lines in each FC/shapefile? I am guessing that each segment has on row in the attribute table. Does each segment have a field with a line name? Maybe you could post a screenshot of the table if it is not sensitive information....
... View more
03-20-2015
10:48 AM
|
0
|
7
|
2012
|
|
POST
|
That sounds interesting. We do have ArcGIS Server available. Thanks Jason.
... View more
03-19-2015
11:33 AM
|
0
|
1
|
6684
|
|
POST
|
Right, I am using a mxd that has scale levels set for the layers so that everything does not try to draw at all scale levels. I also have a tiling custom scheme that I have made up for the area....
... View more
03-19-2015
11:26 AM
|
0
|
0
|
6684
|
|
POST
|
Well it looks like the tpk generation does not support the Parallel Processing Factor. It does not say that it is supported in the documentation. Also, I have run a small test and the generation time is the same with it set to 100%. But next time I do a big raster project I am going to start setting this. Thanks for the help Micah.
... View more
03-19-2015
11:22 AM
|
1
|
0
|
6684
|
|
POST
|
Micah, Thanks for the input - I was unaware of "Parallel Processing Factor" environment setting. I am going to take a look at this. Thanks, Forest
... View more
03-19-2015
10:12 AM
|
0
|
0
|
6684
|
|
POST
|
I have started a new tpk job on a new machine with 10.3. This one is going quite a bit faster. It has overtaken first one in outout size in four days. The first on has been building for about 12 days. As to why this it is going faster this time; I do not know for sure but I have done a few things differently: 1. I reprojected all of the source data to the SRS of the tpk. Before I was letting Arc reproject on the fly. 2. I changed layer transparency to colors. I am unclear how this would help with the generation.
... View more
03-19-2015
10:09 AM
|
1
|
0
|
6684
|
|
POST
|
We are using tpk files as basemaps for a Android application. Which works great. But they take a very long time to generate. The last one was around 8 or 10 days as I recall. I have one building now. It is on day 7 and at around 2.2GB. I would guess that in the end it is going to be over 5GB someplace. So, my question is how can we speed this up. Is it depended on cpu speed? Would getting a more powerful machine help? The source data is in a gdb on the machine's local drive and the output location is also on the local drive. Right now I have it running on a Lenovo ThinkPad with: Intel i7-4800MQ @ 2.70GHz 16GB RAM NVIDIA Quadro K2100M ArcGIS 10.2 Looking at task manager it does not look like I am using much of the machine's resources...
... View more
03-13-2015
11:15 AM
|
2
|
10
|
14278
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 10-04-2024 05:39 PM | |
| 1 | 07-30-2024 09:05 AM | |
| 1 | 07-08-2024 05:32 PM | |
| 1 | 03-20-2024 10:27 AM | |
| 6 | 03-13-2024 03:38 PM |
| Online Status |
Offline
|
| Date Last Visited |
11-12-2025
11:02 AM
|