Creating points from .csv

[Josh Swanson]

I have a CSV file with tax information for a small city that I wanted to make into a point file. I was hoping there is a way to create points using a relation to the parcel (polygon) file I have for this city. Both the csv file and parcel shape file have the same attribute field for parcel numbers that are unique that match up. Any suggestions?

[MattC]

If there are coordinates included in the .csv file for each record,
you can go to File > Open, filter by "Comma Delimited CSV(*.csv), and
create a tab file. Then go to Table > Create points, set the
projection/coord sys as needed, and specify the columns that contain
the coordinate values.

[Josh Swanson]

Unfortunately it doesn't have lat/long on the csv file, right now I am trying this option:

creating point file from the parcels and exporting that to a csv, then in excel messing around with vlookup to combine both tables and then reimport using the lat/long I created for the parcel/point file.

I was mainly wondering if there were a cool way to do this using SQL but figure this plan should work too.

[MattC]

In that case I assume you already have an existing table that contains
a point at the centroid of the parcel and is mappable. Again, go to

File > Open, filter by "Comma Delimited CSV(*.csv), and

create a tab file for your csv. And assuming there is a common field
between the two, do a SQL select like this, where "ID" is the name of
the column containing the unique identifier.:

Select * From csv_table, parcel_table Where csv_table.ID =
parcel_table.ID

Avoid going back and forth between Excel and MapInfo as much as
possible. Doing so increases the chance that data will be lost in the
process; metadata (if you have any) will not be retained if you export
a MapInfo table to Excel, and then bring it back into MapInfo.

[Joshua Swanson]

Sweet, thanks Matt!

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

--
-Joshua

[MattC]

Also, see this video from PBBI about table joins in MapInfo:

http://www.pbinsight.com/support/education/video-tutorials/detail/joining-tables/

[biggr...@gmail.com]

join the tables (tax table and polygon table) on the tax id and return the centroid of the polygon using the CentroidX(polygon.obj) and CentroidY(polygon.obj). save the results of that query as a permanent table and you can create points from the x,y values returned from the query.