topic Re: How get the data matrix in the order of "FID" from the fields of shpfile in Python Questions

How get the data matrix in the order of "FID" from the fields of shpfile

BinbinLu — Thu, 27 Dec 2012 14:11:57 GMT

I am scripting with python and ArcGIS 10.1. I want to get fied data from the shpfile, what I did are as follows:

ssdo = SSDO.SSDataObject(inputFC, templateFC=OutputFC)
masterField = UTILS.setUniqueIDField(ssdo, weightsFile=DistM)
self.allVars = [self.DeVar] + self.IndeVars
ssdo.obtainDataGA(masterField, self.allVars, minNumObs=5, warnNumObs=20)
self.y = ssdo.fields[self.DeVar].returnDouble()
self.x = NUM.ones((self.dp_n, self.var_n), dtype=float)
for i in range(1, self.var_n):
      self.x[:, i] = ssdo.fields[self.IndeVars[i - 1]].returnDouble()
....................

BUT I found the populated "y" and "x" data is not in the order of "FID", for example:

In the original shpfile,
    (Intercept) FLOORSZ
0             1      54
1             1      82
2             1      65
3             1      90
4             1     132
5             1      76
6             1      56
7             1      76
8             1      48
9             1      45
10            1      87

BUT in the populated "x" data:
[   1.   80.]
[   1.   94.]
[   1. 150.]
[   1.   97.]
[   1.   83.]
[   1.   98.]
[   1. 254.]
[   1. 108.]
[   1.   80.]
[   1. 194.]

Anyone can tell me what happened here? And how can I make the populated data are in the order of FID?

Many many thanks!

Re: How get the data matrix in the order of "FID" from the fields of shpfile

markdenil — Thu, 27 Dec 2012 14:50:17 GMT

try inserting the x and y values as a list into a dictionary keyed to the FID.
Then you can access them by key, and you can order the keys any way you want.

One can never tell what order the records in a database actually have;
any tool to look the contents of a database table actually shows you a view,
which is usually ordered on the index field.
The records themselves can be in any order, and they may not be in the same order at some other point in time.

Re: How get the data matrix in the order of "FID" from the fields of shpfile

BinbinLu — Thu, 27 Dec 2012 23:02:44 GMT

Hi Mark, Many thanks for your reply.

I am begainer to use python, and Can you please give an example for this? Thanks again.

try inserting the x and y values as a list into a dictionary keyed to the FID.
Then you can access them by key, and you can order the keys any way you want.

One can never tell what order the records in a database actually have;
any tool to look the contents of a database table actually shows you a view,
which is usually ordered on the index field.
The records themselves can be in any order, and they may not be in the same order at some other point in time.

Re: How get the data matrix in the order of "FID" from the fields of shpfile

markdenil — Fri, 28 Dec 2012 11:40:12 GMT

a dictionary is intialized like this
adict = {}

then, once you extract the x, y, and fid from the record
you can add an entry keyed to the fid like this

adict[fid] = [x, y]

now your dictionary looks like this

{fid: [x, y]} or, from your example, {0: [1, 54]}

continue adding records, keyed to the respective fids
and you get a dictionary like this

{0: [1, 54], 1: [1, 82], 2: [1, 65], 3: [1, 90], 4: [1, 132], 5: [1, 76]}

reference the entries by the key
adict[0] returns the list [1, 54], so the x value for fid 0 is adict[0][0]

get a list of keys with adict.keys()

be aware that, just like the table, the dictionary keys can be in any order
so to order your output, you have to order your reference calls
(call the keys in the order you want: 0,1,2,3...)

hope that helps...

Re: How get the data matrix in the order of "FID" from the fields of shpfile

Anonymous User — Sat, 11 Dec 2021 16:32:03 GMT

Here is another way:

    srows = arcpy.SearchCursor(add)
    dictionary =dict([(r.OID,[r.POINT_X,r.POINT_Y]) for r in srows])
    for key,value in dictionary.iteritems():
        display = str(key) + " : " + str(value)
        print display

This returns:

0 : [2350777.4728, 594558.280203]
1 : [2253187.54954, 703592.805572]
2 : [2285922.63663, 652108.74942]
3 : [2287756.13231, 652063.65535]
4 : [2342506.34991, 687427.921891]
5 : [2253516.13747, 703548.009402]
6 : [2251173.05423, 702889.142281]
7 : [2252173.37801, 702899.971656]
8 : [2251146.67009, 702937.871514]
9 : [2251076.57509, 702964.549939]
10 : [2252051.53935, 702924.865307]
11 : [2280423.63778, 698390.86158]
12 : [2280502.55429, 698357.735005]
13 : [2228616.92381, 617827.380318]

Re: How get the data matrix in the order of "FID" from the fields of shpfile

peterAnderson2 — Mon, 20 May 2013 01:03:25 GMT

Can anyone tell me how to get Data Matrix in VB.NET? I want to create some Data Matrix barcodes in VB.NET. I googled and found tools like this. Must I use such a tool? And how can I choose a good one in the Internet? By this way, I read this guide of creating barcode in VB.NET and copied the sample code in my program. But it can not work. Why is this? Here is the sample code:
Imports OnBarcode.Barcode

Dim barcode As DataMatrix = New DataMatrix

' Data Matrix Barcode Basic Settings

barcode.Data = "112233445566"

barcode.DataMode = DataMatrixDataMode.ASCII

'if your selected format mode doesnot have enough space to encode your data,
'the library will choose the right format mode for you automatically.
barcode.FormatMode = DataMatrixFormatMode.Format_48X48

'Set the ProcessTilde property to true, if you want use the tilde character "~"
'to specify special characters in the input data. Default is false.

'1) 1-byte character: ~0dd/~1dd/~2dd (character value from 000 ~ 255);
'   ASCII character '~' is presented by ~126;
'   Strings from "~256" to "~299" are unused
'   modified to FS, GS, RS and US respectively.
'2) 2-byte character (Unicode): ~6ddddd (character value from 00000 ~ 65535)
'   Strings from "~665536" to "~699999" are unused
'3) for GS1 AI Code:
'   ~ai2: AI with 2 digits
'   ~ai3: AI with 3 digits
'   ~ai4: AI with 4 digits
'   ~ai5: AI with 5 digits
'   ~ai6: AI with 6 digits
'   ~ai7: AI with 7 digits
'4) ECI: ~7dddddd (valid value of dddddd from 000000 to 999999)
'5) ~rp: Reader Programming (for ASCII mode and Auto mode only)
'6) ~m5: 05 Macro (for ASCII mode and Auto mode only)
'7) ~m6: 06 Macro (for ASCII mode and Auto mode only)
barcode.ProcessTilde = True

' Barcode Size Related Settings
barcode.UOM = UnitOfMeasure.PIXEL
   barcode.X = 3
barcode.LeftMargin = 0
   barcode.RightMargin = 0
barcode.TopMargin = 0
   barcode.BottomMargin = 0
barcode.Resolution = 96
   barcode.Rotate = Rotate.Rotate0

' Image format setting
barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Gif()

barcode.drawBarcode("c://data-matrix.gif")

Re: How get the data matrix in the order of "FID" from the fields of shpfile

dannyrough — Mon, 08 Jul 2013 01:36:01 GMT

Can anyone tell me how to get Data Matrix in VB.NET? I want to create some Data Matrix barcodes in VB.NET. I googled and found tools like this. Must I use such a tool? And how can I choose a good one in the Internet? By this way, I read this guide of creating barcode in VB.NET and copied the sample code in my program. But it can not work. Why is this? Here is the sample code:
Imports OnBarcode.Barcode

Dim barcode As DataMatrix = New DataMatrix

' Data Matrix Barcode Basic Settings

barcode.Data = "112233445566"

barcode.DataMode = DataMatrixDataMode.ASCII

'if your selected format mode doesnot have enough space to encode your data,
'the library will choose the right format mode for you automatically.
barcode.FormatMode = DataMatrixFormatMode.Format_48X48

'Set the ProcessTilde property to true, if you want use the tilde character "~"
'to specify special characters in the input data. Default is false.

'1) 1-byte character: ~0dd/~1dd/~2dd (character value from 000 ~ 255);
'   ASCII character '~' is presented by ~126;
'   Strings from "~256" to "~299" are unused
'   modified to FS, GS, RS and US respectively.
'2) 2-byte character (Unicode): ~6ddddd (character value from 00000 ~ 65535)
'   Strings from "~665536" to "~699999" are unused
'3) for GS1 AI Code:
'   ~ai2: AI with 2 digits
'   ~ai3: AI with 3 digits
'   ~ai4: AI with 4 digits
'   ~ai5: AI with 5 digits
'   ~ai6: AI with 6 digits
'   ~ai7: AI with 7 digits
'4) ECI: ~7dddddd (valid value of dddddd from 000000 to 999999)
'5) ~rp: Reader Programming (for ASCII mode and Auto mode only)
'6) ~m5: 05 Macro (for ASCII mode and Auto mode only)
'7) ~m6: 06 Macro (for ASCII mode and Auto mode only)
barcode.ProcessTilde = True

' Barcode Size Related Settings
barcode.UOM = UnitOfMeasure.PIXEL
   barcode.X = 3
barcode.LeftMargin = 0
   barcode.RightMargin = 0
barcode.TopMargin = 0
   barcode.BottomMargin = 0
barcode.Resolution = 96
   barcode.Rotate = Rotate.Rotate0

' Image format setting
barcode.ImageFormat = System.Drawing.Imaging.ImageFormat.Gif()

barcode.drawBarcode("c://data-matrix.gif")

thanks for sharing! the toolkits you shared are really useful!

Re: How get the data matrix in the order of "FID" from the fields of shpfile

makaveiljojo — Mon, 30 Dec 2013 00:05:20 GMT

Hi petersea,
To get Data Matrix barcode images, a Data Matrix font is required. But there are also a couple of other ways of generating Data Matrix, like getting a Data Matrix ASP.NET control or a professional generator.
I'm not so sure I read and understand the code you posted well. But my suggestion is to get open sources and try. If you have to use a commercial product, at least try a few trial versions before you get licensed.

Re: How get the data matrix in the order of "FID" from the fields of shpfile

mariahlewis — Mon, 17 Feb 2014 04:28:41 GMT

as for data matrix i just generated it using .net program ,not knowing whether helps?

Re: How get the data matrix in the order of "FID" from the fields of shpfile

fdsffdsf — Mon, 12 May 2014 03:22:48 GMT

as for data matrix i just generated it using .net program ,not knowing whether helps?

hello, cindy. how do you do it. i need more detailed information.