select count(*) from obis.obis_resources; = 72 select count(*) from obis.operation_type; = 72 -- obis.resources_vw select r.*, o.* from obis.obis_resources r, obis.operation_type o where r.resource_id = o.resource_id; = 72 select resource_id, provider_id from obis.obis_resources; select count(*) from obis.resources_vw; = 72 select count(*) from obis.providers; = 72 -- geoserver.resources_points select a.*, b.* from obis.resources_vw a, obis.obis_resources b where a.ron_id = b.resource_id; = 70? select a.*, c.* from obis.resources_vw a, obis.providers c where a.provider_id=c.provider_id; = 70? select count(*) from geoserver.resources_points; = 70 select ron_id from obis.resources_vw; two are null? select resource_id from obis.obis_resources; select provider_id from obis.resources_vw; two are null? select provider_id from obis.providers; Upon visual inspection, two resources CCK and SPI are missing both ron_id and provider_id. Upon review with BB: obis.providers "who paid for it" and obis.rons "geographic location" Need to add new provider_id from CCK = Western Australia Fisheries = 1008 Then edit obis.obis_resources and set CCK ron_id=9992002 (though obis.rons=9002), provider_id=1008 and set SPI ron_id=9992007 (though obis.rons=9008) and provider_id=1001 (CFI Funds) insert into obis.providers (provider_id, provider_name) values (1008,'Western Australia Fisheries'); -- resource_acronym CCK update obis.obis_resources set ron_id = 9992002, provider_id = 1008 where resource_id=9990010; -- resource_acronym SPI update obis.obis_resources set ron_id = 9992007, provider_id = 1001 where resource_id=9990011; Also, to "fix" Geoserver, otn:resources_points layer need to remove any/all CR from table obis.obis_resources: select * from obis.obis_resources where (taxon_bound like '%'||chr(10)||'%'); -- two records resource_id=9990002, 9990004 update obis.obis_resources set taxon_bound = replace(taxon_bound,chr(10),';'); -- now returns no rows select * from obis.obis_resources where (taxon_bound like '%'||chr(10)||'%'); Test Fix, including removal of 50 record return limit: http://kil-otn-1.ucis.dal.ca/geoserver/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=otn:resources_points&outputFormat=csv Chart "example" as provided by geoserver.f_mooring_chart: http://chart.apis.google.com/chart?cht=bvg&chs=600x100&chtt=Instruments+by+Yr&chd=t1:30,31,58|44,51,1&chxt=x,y&chxl=0:|2008|2009|2010&chm=D,FF0000,1,0,5,1&chdl=Receivers|Transmitters&chco=00FF00,FF0000