[Qgis-user] GDBTable Files

[Mike Flannigan]

I am looking for all the nodes of the boundary of
the polygons.

I followed your instructions and it worked perfectly.
Thanks so much.  Very helpful.

I obtained the XY figures:

X,Y,SMA_ID,HOLD_ID,DE_UNIT_CO,ADMIN_DEPT,ADMIN_AGEN,ADMIN_UNIT,ADMIN_UN_1,HOLD_DEPT_,HOLD_AGENC,created_us,created_da,last_edite,last_edi_1,GlobalID,Shape_Leng,Shape_Area
-19275637.433,6800032.5736000016,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000
-19275582.8992,6799982.8491000012,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000
-19275532.365499999,6799986.957699999,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000
-19275528.620700002,6799883.7621000037,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000


and then started to follow this:
https://gis.stackexchange.com/questions/64535/how-to-convert-x-y-coordinates-to-longitude-latitude-using-quantumgis
to obtain the lat/longs.  I selected 4326 as the CRS and
exported to a CSV.  I did not do the calculator $x and
$y part, but it still produced the lat/longs.  2.37 million
features and it worked good.  Very impressive.

X,Y,SMA_ID,HOLD_ID,DE_UNIT_CO,ADMIN_DEPT,ADMIN_AGEN,ADMIN_UNIT,ADMIN_UN_1,HOLD_DEPT_,HOLD_AGENC,created_us,created_da,last_edite,last_edi_1,GlobalID,Shape_Leng,Shape_Area
-173.15599717210276,51.999486312267607,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000
-173.15550728664238,51.999211302885627,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000
-173.15505333469162,51.999234026225835,2,,,DOI,BLM,,,,,ILMOCDBO,2017/05/19 
09:24:58.000,ILMOCDBO,2017/05/19 
09:24:58.000,{14C60FFA-9728-4EAA-A22D-25FAC0BA2A0B},122570475.346412150000000,1815402226406.394300000000000


So I am in a good place now.  I plan to change the CRS to NAD27,
but I think I am good to go.  I have a lot of work ahead of me.

I really appreciate your help.
Thank you Nyall.


Mike


On 6/17/2018 6:49 PM, Nyall Dawson wrote:
> On Mon, 18 Jun 2018 at 07:50, Mike Flannigan <mikeflan at att.net> wrote:
>
> Hi Mike!
>
> First off, I'd strongly suggest upgrading to 2.18 (or 3.0, if you like
> bleeding edge!). You'll get lots of bug fixes and improvement
> behaviour over the older, unsupported 2.14 release. If you're stuck on
> 2.14 for some reason, you definitely should be running the final patch
> release for that version, which is 2.14.22.
>
> Do you mean for each node in the polygons, or just for the centroid?
>
> The easiest way is to use the built-in Processing toolbox.
>
> If you're after a lat/long for the centroid:
> 1. Run the "Polygon centroids" algorithm to obtain a point for each centroid
> 2. Run the "Export/Add geometry columns" algorithm to add a field for
> centroid x/y values
> 3. Export to XLS/CSV/etc
>
> If you're after a lat/long for each node:
> 1. Run the "Extract Nodes" algorithm to obtain a point for each node
> 2. Run the "Export/Add geometry columns" algorithm to add a field for
> centroid x/y values
> 3. Export to XLS/CSV/etc
>
> Nyall
>