[GIS] ERROR 000212: Cannot create XY event source Failed to execute (MakeXYEventLayer)

arcgis-10.0arcgis-desktopcsverror-000212point

I have a csv file that is 133mb in size and has over 1.3 million lines of data. Each line of data has its own lat/long and I was wondering what would be the best way to display those points based off the lat/longs in ArcGIS Desktop 10 and ultimately turn it into a point shapefile?

So far I have tried the "Make XY Event Layer" tool but that keeps failing…

ERROR 000212: Cannot create XY event source
Failed to execute (MakeXYEventLayer).

The csv file is properly formatted and the lat/long fields are numeric so I have no idea why it keeps crashing.

Here is what the first 2 lines of my CSV look like, the first line is what should be the header:

"LAT","LONG","CUSTOMER_MASTER_ID","STORE_NBR","TRANSACTION_DT","SKU_DIVISION_ID","SKU_DEPARTMENT_ID","SKU_CLASS_ID","SKU_CATEGORY_ID","SKU_NBR","SALES_AMT"
"32.363544","-110.969778","2000000792627","2940","8/11/2010","2060","3920","5120","84021","5127866","13.99"

Any ideas?

Best Answer

Since the Lat and Long field values "32.363544","-110.969778" have quotes around them, they aren't really treated as numeric.

The display x-y data needs the x and y fields to be numeric.

Remove the surrounding quotes and it should work. If you have access to a unix machine grep/sed sure would make this job easier. There are also windows ports of these tools.

Also, I'd avoid using "Long" as a field name - there might be cases where it is treated as a reserved word.

Related Solutions

[GIS] Loading CSV File with Data Labels

I have a .csv file (Comma-separated values), i.e. a raw ascii text file like this:

"House_number","count"
"1",103991
"10",81932
"100",4997
"100A",358
"100B",350
"100C",184

I load it in QGIS, using 'Add Delimited text layer', like this:

And it shows up perfect in the table afterwards. Note that text fields left-justify, while number fields right-justify.

QGIS – Linking Points with Lines for Display in QGIS for Better Visualization

You can connect the points using geometry generator. Let's say you have two points layers, where the fid is matching the potints in each layer you want to connect with a line. For demonstration, I just created two layers with 10 random points on each.

In one of the layers, add a symbol layer and use geometry generator for symbol layer type - see screenshot below. As geometry type, set LineString. Now you have to define the expression that generates your line (see below for how the expression should look).

The advantage is that the line adapts automatically to every change (adding or removing points, moving points to another place etc.) in realtime. And you don't need a separate layer. However, if you would like to make the lines permanent and store them in a separate file and show them in an own layer, you can paste the same expression to the geometry by expression algorithm (from processing toolbox).

The expression could look like this, just adapt to include the layer-name you use (instead of 'your_layer2' - layer names shold look someting like 'layer_2_d5d61a64_fe2d_44bf_a62e_1168bd89d4ea' - best select the layer from the expression editor):

make_line(
   $geometry,  
   geometry(
       get_feature_by_id( 
       'your_layer2',  "fid" )
    )
)

Explanation: Selecting layer 1, use make_line (point1, point2) to create the line. Point1 can be set to $geometry, thus for each feature on your layer1, you want to have a line starting from there. The line should go to the corresponding point on the other layer: to the feature on layer2 with the same fid. Thus use get_feature_by_id(layer,feature_id) and add the layer and the fid-field (if you just paste the field-name, it will take the field from layer1 - that is what you want, because the fid for layer2 should be the same as for layer1). Best use the column in the middle of the expression editor and select the entries from there (expand the headlines for map layers and fields and values). This returns you a feature. You have to use geometry(feature) to convert the feature to a geometry (a point, in this case). The parameter (feature) is the expression we just discussed before.

You see the two points layers, each in a different color. I added a label with the fid to show how the lines are drawn.

Best Answer

Related Solutions

[GIS] Loading CSV File with Data Labels

QGIS – Linking Points with Lines for Display in QGIS for Better Visualization

Related Question