topic Re: Combine line and point feature classes attributes in Data Management Questions

Combine line and point feature classes attributes

MathewSuran — Mon, 17 Aug 2015 15:15:09 GMT

I have a line feature class and point feature class in a gdb that is hosted on our server.

I want to utilize these in a webapp using the REST url.

I want to ultimately be able to only display a line feature and be able to select it to display both line and point attributes.

After doing some searching, I think I need to create a relationship class in the gdb.

Can anyone lend some expertise on best way to accomplish this?

Re: Combine line and point feature classes attributes

WesMiller — Tue, 18 Aug 2015 12:50:15 GMT

See this article and see if this points you in the right direction Creating relationship class in ArcMap 10.2 | mapsnigeriainitiative

Re: Combine line and point feature classes attributes

MathewSuran — Tue, 18 Aug 2015 19:44:18 GMT

Thanks for that info, that is on the same line as what I read before. When the relationship class is created and the geodata service is shared on our server along with the Map service, do I only have to load the REST url of the feature class that I want to be able to access both attribute data from?

For example:

The gdb has a line feature class, point feature class and relationship class for the line feature class to reference the point feature class attributes. When loading the REST url, I would normally load both line and point which would be www.somegisserver.com/mapservice/0 and www.somegisserver.com/mapservice/1 respectively (0 being line, and 1 being point). If I understand this correctly, I should only have to bring in the line feature (www.somegisserver.com/mapservice/0) and the relationship class will reference the point features attributes in the gdb when a line is selected in the webapp? Or does it not work like that for webapplications?

Re: Combine line and point feature classes attributes

sapnas — Wed, 19 Aug 2015 20:09:45 GMT

Is the data stored in Arcsde or File GDB? If its in Arcsde you can create view and use it instead

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 19 Aug 2015 20:11:18 GMT

Testing both ways, file and sde.

Re: Combine line and point feature classes attributes

sapnas — Wed, 19 Aug 2015 20:15:11 GMT

you may have to create a join in your mxd and publish it.

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 19 Aug 2015 20:18:08 GMT

What kind of join would you suggest since I have two different data types, Line and Point?

I don't really want to join since joining would give me all of the features. All I want are the Line features to be able to be displayed but when selected, reference the point features attribute data to use in a query (for a later discussion).

Re: Combine line and point feature classes attributes

sapnas — Wed, 19 Aug 2015 20:23:28 GMT

I normally prefer sde as File based data systems (FGDB) are not well managed compared to an enterprise
database such as Arcsde and moreover would not be handling data concurrency very efficiently
when multiple users use the system simultaneously. In SDE you can create views on the backend to join tables based on spatial data and/or attributes which is absent in FGDB.

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 19 Aug 2015 20:27:47 GMT

I completely agree, thanks for the advise. Can you elaborate on how to create views on the backend? Im using MSSQL.

Re: Combine line and point feature classes attributes

sapnas — Wed, 19 Aug 2015 20:30:02 GMT

Is there a common attribute between two feature class?

Re: Combine line and point feature classes attributes

sapnas — Wed, 19 Aug 2015 20:34:07 GMT

this link might get you started

resources.arcgis.com/en/help/main/10.1/index.html#//006z00000039000000

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 19 Aug 2015 20:36:03 GMT

Yes, there is a common field name that Identifies the location of both features named "Line". There is 1 line per location while there are many points around the line, not directly on it.

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 19 Aug 2015 20:45:32 GMT

Thanks for that. How would I reference this view to plug-in to my webapp?

Re: Combine line and point feature classes attributes

sapnas — Wed, 19 Aug 2015 20:55:17 GMT

Add view to your mxd and publish it as rest map service

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 19 Aug 2015 21:01:12 GMT

Ok, will try first thing tomorrow.

Re: Combine line and point feature classes attributes

williamcarr — Wed, 26 Aug 2015 14:54:27 GMT

Could you clarify on how the line and point are related?

From my understanding, you have a line and a point with a common field, then select a line and display the point attribute with the line attribute based on a similar field?

I have a few apps where I pull a single attribute from a feature I just selected. I use it to get water hydrant ID's when our service guys click on a hydrant.

hydrantRecord = evt.graphic.attributes.HydrantID;

This is how I pull the hydrant ID from a relationship query. Then I take this universal variable and plug it into my forms. It seems this would make your attribute data available for query later on.

Are you planning on using the attribute inspector, infowindow....?

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 26 Aug 2015 15:20:11 GMT

I have a similar field for both line and point features that specifies the location. The similar field will only be used for location purposes. When the line is selected, I want to display (in the form of a graph) the points elevation (Field name=Z) that relate to the same location of the line. The line is basically the template for where the points should be taken. Since displaying the location of the points is not important here, this is why I want to just display the line and have all of the points elevation data be referenced when it is selected.

I am looking for the best way to set this up in the gdb I am pulling the features from. Whether it is creating a relationship class or what Sapna suggested above.

No need for the attribute inspector or infowindow, since the elevation data will be automatically populated in the line graph.

Re: Combine line and point feature classes attributes

williamcarr — Wed, 26 Aug 2015 16:07:56 GMT

Ahhh.

here is the whole function that I use to pull an attribute from a feature.(Sorry I don't have time to clean it up or test it or figure out the necessary portions. .)

You could be able to extract that attribute, in this example 'hydrantRecord', and use it in your query.

If i get some more time I'll try to come up with a better tested example if I get some time today.

map.on("click", function(evt) {

var selectionQuery = new esri.tasks.Query();

var tol = map.extent.getWidth()/map.width * 30;

var x = evt.mapPoint.x;

var y = evt.mapPoint.y;

var queryExtent = new esri.geometry.Extent(x-tol,y-tol,x+tol,y+tol,evt.mapPoint.spatialReference);

selectionQuery.geometry = queryExtent;

asdf.selectFeatures(selectionQuery, FeatureLayer.SELECTION_NEW, function(features) {

//store the current feature

updateFeature = features[0]; console.log("adf");

map.infoWindow.setTitle(features[0].getLayer().name); console.log("adf");

map.infoWindow.show(evt.screenPoint,map.getInfoWindowAnchor(evt.screenPoint)); console.log("adf");

});

var record = document.getElementById('record');

//add event listener

record.addEventListener('click', function(e3) {

m5.on("click", lang.hitch(this, onLayerClick2));

var relatedTable2 = new FeatureLayer("http:", {

mode: FeatureLayer.MODE_ONDEMAND,

outFields: ["*"],

id: "relatedTable2"

});

console.log("Ran over the related table");

relatedTable.on("load", lang.hitch(this, function () {

console.log("RelatedTable Load");

var layerInfos = [

{

'featureLayer': relatedTable2,

'showAttachments': false,

'isEditable': true,

'fieldInfos': arrayUtils.map(relatedTable2.fields, function (field) {

return {

'fieldName': field.name,

'isEditable': field.editable,

'tooltip': field.type,

'label': field.alias

};

})

}

];

var attInspector = new AttributeInspector({

layerInfos: layerInfos

}, domConstruct.create("div"));

attInspector.on("attribute-change", function (evt) {

evt.feature.attributes[evt.fieldName] = evt.fieldValue;

evt.feature.getLayer().applyEdits(null, [evt.feature], null);

});

attInspector.on("delete", function (evt) {

evt.feature.getLayer().applyEdits(null, null, [evt.feature]);

map.infoWindow.hide();

});

map.infoWindow.setContent(attInspector.domNode);

map.infoWindow.resize(350, 400);

}));

console.log("Record start")

function onLayerClick2(evt) {

map.infoWindow.setTitle("Searching for related items...");

map.infoWindow.show(evt.screenPoint, map.getInfoWindowAnchor(evt.screenPoint));

//-------------------this is what is pulling the attribute for querying

hydrantRecord = evt.graphic.attributes.HydrantID;

console.log(hydrantRecord);

//-------------------this is what is pulling the attribute for querying

//Done pulling the valve ID

var graphicAttributes = evt.graphic.attributes;

var title = graphicAttributes[m5.displayField];

var objectId = graphicAttributes[m5.objectIdField];

var relatedQuery = new RelationshipQuery();

relatedQuery.outFields = ["*"];

relatedQuery.relationshipId = 5;

relatedQuery.objectIds = [objectId];

console.log("relate found?");

console.log(relatedQuery.objectIds)

m5.queryRelatedFeatures(relatedQuery, lang.hitch(this, function (relatedRecords) {

var fset = relatedRecords[objectId];

if (fset) {

map.infoWindow.setTitle(title || "No Title");

var relatedObjectIds = arrayUtils.map(fset.features, function (feature) {

return feature.attributes[relatedTable2.objectIdField];

});

var selectQuery = new Query();

selectQuery.objectIds = relatedObjectIds;

relatedTable2.selectFeatures(selectQuery, FeatureLayer.SELECTION_NEW);

console.log(feature.attributes)

} else {

map.infoWindow.setTitle("No Related Items");

}

}));

}

});

Re: Combine line and point feature classes attributes

MathewSuran — Wed, 26 Aug 2015 17:36:41 GMT

Thanks. Just to clarify, did you create a relationship class in your gdb? How do you have your data set up?

Re: Combine line and point feature classes attributes

williamcarr — Wed, 26 Aug 2015 18:23:24 GMT

Yes, I created a relationship in my MapService, but I don't think you will need one.

How did you initially planned to select the feature?