|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | Re: [gislist] Sequential Numbering System |
| Date: |
10/31/2006 10:40:01 PM |
| From: |
Quantitative Decisions |
|
|
At 04:03 PM 10/30/2006 -0800, Lance Hutchinson wrote:
>I have a set of 366 parcels and need to incorporate a sequential numbering
>system into a database, which should be 1000565-1000930. I've created a line
>file (Feature Class) that intersects each of the parcels. Any idea how to
>dynamically create these numbers in an east to west direction? The
>query/solution must be geographical as the numbering sequence must follow
>the Feature Class line file.
Of the many ways to do this, the solutions that use high-level GIS
operations recommend themselves as requiring the least programming and
computational effort.
(1) If what you want is an east-to-west numbering, then compute the x
coordinate of a point associated with each parcel (such as its centroid or
one side of its bounding box). Sort the parcel table by descending value
and assign the numbers sequentially to the sorted records.
(2) A raster version of this begins with a grid whose values are the
x-coordinates (or the column indexes). Perform a zonal summary of this
grid by parcel. Retain the maximum x-value for each parcel. Sort the
parcel records in descending order of those maxima and assign the numbers
sequentially to the sorted records.
(3) To follow a given line, intersect the line with the parcel
layer. Convert the line into a measured line using distance from its start
as the measure. Convert the intersections into line events. Retain the
start measure of each line event. Sort these in descending order and
assign the numbers sequentially to the sorted records.
(4) Here is a raster solution. It assumes the line feature does not
intersect itself. Limit the raster calculation mask to the line. Compute
a costdistance solution beginning with the origin of the line. Perform a
zonal summary of this distance by parcel. Retain the minimum distance for
each parcel. As before, sort these in descending order and assign the
numbers sequentially to the sorted records.
--Bill Huber
Quantitative Decisions
_______________________________________________
gislist mailing list
gislist@lists.geocomm.com
http://lists.geocomm.com/mailman/listinfo/gislist
_________________________________
This list is brought to you by
The GeoCommunity
http://www.geocomm.com/
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
