Creating Counties Table

[mkeller3]

Hello,

When creating the table for the California counties:

CREATE TABLE counties (Area string, Perimeter string, State string, County string, Name string, BoundaryShape binary)
ROW FORMAT SERDE 'com.esri.hadoop.hive.serde.JsonSerde'
STORED AS INPUTFORMAT 'com.esri.json.hadoop.EnclosedJsonInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat';

It notes that a column is called BoundaryShape, but when i convert the json file to a feature class it does not have the column so I am trying to figure out where it gets this information from to find the boundaries for each of the polygons.

I am trying to do a similar project with the US States and am trying to figure out what would be the equivalent to the BoundaryShape field.

[randallwhitman]

By "when i convert the json file to a feature class",

• do you mean import it to ArcGIS Desktop with the JSON To Features tool?
• do you mean custom Java code using com.esri.json.EsriFeatureClass#fromJson?
• do you mean something else?

[mkeller3]

Import it to ArcGIS Desktop with the JSON To Features tool

[randallwhitman]

ArcGIS Desktop likely calls it "SHAPE" rather than "BoundaryShape".

[mkeller3]

If ArcGIS Desktop likely calls it "SHAPE" rather than "BoundaryShape" then for my other file where "Area" is called "Shape_Area" in ArcGIS Desktop would I put "BoundaryShapeArea" inside the create table function for hadoop?

[randallwhitman]

ArcGIS desktop automatically generates "Shape_Area" for polygon feature classes.

[mkeller3]

So for any json file when creating the table it should be labeled BoundaryShape not Shape_Area?

[randallwhitman]

That should work OK.