[OpenLayers-Users] Getting specific data from a single vector feature with a large attribute table

[Gery .]

Hello Julius,

I work with PostGis, Mapserver and Openlayers to plot my data. My tables are quite similar to what you have, but my code is different. If I understand well, you're trying to get the info stored in your tables after clicking each feature, is it that? if so, you have to play with the GetFeatureInfo code, here is the code: http://openlayers.org/dev/examples/getfeatureinfo-popup.html

I understand also that you want to display all the rows in your table based on survey_no column, but just clicking one feature (this is one row), is it that? as far as I know you can assign info to one feature, this is one row, and then press each feature to get its corresponding info, I know that in that way works, probably you may make a query and select only the features that match certain pattern in your survey_no column, ie. all of them that are multiple of 10.

Hope this helps,

Gery

Date: Mon, 28 May 2012 17:30:05 +0800
From: julius.sempio at gmail.com
To: openlayers-users at lists.osgeo.org
Subject: [OpenLayers-Users] Getting specific data from a single vector feature with a large attribute table

Good day, sires.

I am currently working on a web-based GIS project that mainly concerns with the extraction of data for viewing purposes, and we're using PostGIS, Geoserver and OpenLayers for the said project.


Right now we're trying to display data from several rows in the attribute table in a single vector, but right now we're pretty much stuck at displaying only the first line of the table (see example below):


fid        survey_no      wqms_id            do          surveydate
135      1                   WQS-10-1         8.45       1/27/2010       ==> only this line gets displayed right now
136      2                   WQS-10-2         1.27       1/28/2010

137      3                   WQS-10-3         1.08       2/24/2010        ==> we would like to display this (and others) using survey_no as the parameter to do so
138      4                   WQS-10-4         6.07       3/24/2010

...        ...                  ...                     ...           ...

We're currently using the following codes to get information on the feature:

function linkToWQMS(wqms){
    //clear focus layers from previous selection

    if (wqmsHoverFocus.features != null) {
        wqmsHoverFocus.removeAllFeatures();
    }
    if (popup != null){
        map.removePopup(popup);
    }
    
    //process wqmsid
    var wqmsSelected = wqms.name;

    getWQMS(wqmsSelected);
}

function getWQMS(wqms){
    var paramsWQMS = {
        REQUEST: "GetFeature",
        SERVICE: "WFS",
        VERSION: "1.1.0",
        TYPENAME: ["prism:WQMS"],

        OUTPUTFORMAT: "GML2",
        SRSNAME: "EPSG:4326",
        CQL_FILTER: "wqms_id = \'" + wqms + "\'"};
    
    OpenLayers.Request.GET({
        url: "http://202.92.159.15:8080/geoserver/prism/wfs",

        params: paramsWQMS,
        callback: handlerWQMS});
}

function handlerWQMS(response){
    //Create gml format object
    var gml = new OpenLayers.Format.GML();
    gml.extractAttributes = true;

        
    //Get array of OpenLayers.Feature.Vector
    var features = gml.read(response.responseText);
    
    //reproject geometry before buffering
    var wqmsid = features[0].attributes["wqms_id"];

    //alert(wqmsid);
    var geom = features[0].geometry.clone();
    geom.transform(geographic, mercator);
    
    //center tributary to center of bounds
    var parcelCenter = geom.getBounds().getCenterLonLat();

    map.panTo(parcelCenter);
    
    //pass the control to prismParcelInformationUI.js
    wqmsInformationController(features[0]);
    drawFeatures ("wqms", features, 0);
}

function wqmsInformationController(feature){

    //pass to create status info entry
    setTributaryInformationStatus(feature);
}

function setTributaryInformationStatus(feature){
    //code to prepare data for viewing
    var id, survno, dopercent;

    id = feature.attributes["wqms_id"];
    survno = feature.attributes["survey_no"];
    dopercent = Math.round(feature.attributes["do"]*100)/100;
        
    var tributaryInformationStatusTablePage = "<table style=\"width:100%\">"

        + "<tr><td style=\"font-family:verdana;color:navy;font-size:11px;text-align:right;width:25%\"><strong>Station ID:</strong></td>"
        + "<td style=\"font-family:verdana;color:navy;font-size:11px;text-align:left\">" + id + "</td></tr>"

        + "<tr><td style=\"font-family:verdana;color:navy;font-size:11px;text-align:right;width:25%\"><strong>Survey No:</strong></td>"
        + "<td style=\"font-family:verdana;color:navy;font-size:11px;text-align:left\">" + survno + "</td></tr>"

        + "<tr><td style=\"font-family:verdana;color:navy;font-size:11px;text-align:right;width:25%\"><strong>Dissolved Oxygen %:</strong></td>"
        + "<td style=\"font-family:verdana;color:navy;font-size:11px;text-align:left\">" + checkIfEmpty(dopercent) + "</td></tr>"

        + "</table>";
    
    //get html elements and attach tributaryInformationBasicPage
    
    var statustableDIV = document.getElementById('tributaryinformationstatustable');

    statustableDIV.innerHTML = tributaryInformationStatusTablePage;
    statusinitDIV.appendChild(statustableDIV);
    toolsStatusBar.setText("~(^.^)~ Viewing Tributary Status Information");
}

 We've been surfing a lot of Internet sources the past weeks in trying 
to find the answer, but as of the moment we have found no success. So any enlightening insights would be most welcome.

Yours truly:

Julius Sempio
Department of Geodetic Engineering
University of the Philippines


_______________________________________________
Users mailing list
Users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/openlayers-users 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/openlayers-users/attachments/20120528/c31c0496/attachment-0001.html>