Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [geomesa-users] Empty feature count or incorrect on query
Hi Dave,

GeoMesa uses stored statistics to estimate counts by default. There are two things you can do to help:

1. Re-generate your stats, to ensure they are up-to-date:

http://www.geomesa.org/documentation/user/accumulo/commandline_tools.html#stats-analyze

2. Force an exact count, either for all queries through a system property or per-query:

http://www.geomesa.org/documentation/user/datastores/runtime_config.html#geomesa-force-count
http://www.geomesa.org/documentation/user/datastores/query_config.html#setting-query-hints

Note that exact counts will essentially require running the query twice, with the performance penalties that implies.

Thanks,

Emilio

On 04/03/2017 08:04 AM, David Boyd wrote:

Follow up.  The correct count should be 3177.   Ignore the part below about the other feature.

I did do a query call with getFeatures from code and get a correct count.



On 4/3/17 11:07 AM, David Boyd wrote:

All:

   This is a strange one.   I have some features and the counts returned by
geoserver are not correct or in one case 0. 

I am running geoserver 2.10.1
With the latest Geomesa 1.3.1

Here is the WFS request:

http://172.16.152.130:8181/geoserver/OE_Repository/ows?service=WFS&version=1.1&request=GetFeature&typeName=OE_Repository:GDELTArtifact_GDELT_0.1.GDELTArtifactSection.GDELTArtifactRecordset&outputFormat=application%2Fjson

Here is the first part of the result:

{"type":"FeatureCollection","totalFeatures":0,"features":[{"type":"Feature","id":"00fa1380-0000-4024-80a5-3a0c8941d859","geometry":{"type":"Polygon","coordinates":[[[-180,-90],[-180,90],[180,90],[180,-90],[-180,-90]]]},"geometry_name":"theWorld","properties":{"objectKey":"0d43af79-4f3c-4b23-94ad-2e50c8ef6a07","entityName":"GDELTArtifact","entitySource":"GDELT","entityTitle":"G2CoreEntity","recordKey":"3a9aaa67-3502-4601-8542-fd3024770bec","SourceFileName":"20170119161500.export.CSV","GlobalEventID":618742924,"RawText":"618742924\\t20170119\\t201701\\t2017\\t2017.0521\\tIRL\\tDUBLIN\\tIRL\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t\\t0\\t192\\t192\\t19\\t4\\t-9.5\\t2\\t1\\t2\\t-0.51679586563308\\t1\\tGibraltar\\tGI\\tGI\\t\\t36.1833\\t-5.3667\\tGI\\t0\\t\\t\\t\\t\\t\\t\\t\\t4\\tDublin, Dublin, Ireland\\tEI\\tEI07\\t18288\\t53.3331\\t-6.24889\\t-1502554\\t20170119161500\\thttp://www.chicagotribune.com/news/sns-wp-brexit-trump-b53d117a-de56-11e6-acdf-14da832ae861-20170119-story.html"}},
If I ask for just the hits via:
http://172.16.152.130:8181/geoserver/OE_Repository/ows?service=WFS&version=1.1&request=GetFeature&typeName=OE_Repository:GDELTArtifact_GDELT_0.1.GDELTArtifactSection.GDELTArtifactRecordset&resultType=hits

I get:
<wfs:FeatureCollection xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:OE_Repository="http://oerepo.tradoc.army.mil" xmlns:wfs="http://www.opengis.net/wfs"xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc" xmlns:ows="http://www.opengis.net/ows" xmlns:xlink="http://www.w3.org/1999/xlink"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" numberOfFeatures="0" timeStamp="2016-11-13T00:26:02.701Z" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd"/>

I have another layer which I know has 13K points and it's count returns just over 3K.

I am not seeing any relevant errors in my geoserver or catalina logs.


 
-- 
========= mailto:dboyd@xxxxxxxxxxxxxxxxx ============
David W. Boyd                     
VP,  Data Solutions       
10432 Balls Ford, Suite 240  
Manassas, VA 20109         
office:   +1-703-552-2862        
cell:     +1-703-402-7908
============== http://www.incadencecorp.com/ ============
ISO/IEC JTC1 WG9, editor ISO/IEC 20547 Big Data Reference Architecture
Chair ANSI/INCITS TC Big Data
Co-chair NIST Big Data Public Working Group Reference Architecture
First Robotic Mentor - FRC, FTC - www.iliterobotics.org
Board Member- USSTEM Foundation - www.usstem.org

The information contained in this message may be privileged 
and/or confidential and protected from disclosure.  
If the reader of this message is not the intended recipient 
or an employee or agent responsible for delivering this message 
to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication 
is strictly prohibited.  If you have received this communication 
in error, please notify the sender immediately by replying to 
this message and deleting the material from any computer.

 


_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geomesa-users

-- 
========= mailto:dboyd@xxxxxxxxxxxxxxxxx ============
David W. Boyd                     
VP,  Data Solutions       
10432 Balls Ford, Suite 240  
Manassas, VA 20109         
office:   +1-703-552-2862        
cell:     +1-703-402-7908
============== http://www.incadencecorp.com/ ============
ISO/IEC JTC1 WG9, editor ISO/IEC 20547 Big Data Reference Architecture
Chair ANSI/INCITS TC Big Data
Co-chair NIST Big Data Public Working Group Reference Architecture
First Robotic Mentor - FRC, FTC - www.iliterobotics.org
Board Member- USSTEM Foundation - www.usstem.org

The information contained in this message may be privileged 
and/or confidential and protected from disclosure.  
If the reader of this message is not the intended recipient 
or an employee or agent responsible for delivering this message 
to the intended recipient, you are hereby notified that any 
dissemination, distribution or copying of this communication 
is strictly prohibited.  If you have received this communication 
in error, please notify the sender immediately by replying to 
this message and deleting the material from any computer.

 


_______________________________________________
geomesa-users mailing list
geomesa-users@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geomesa-users

Back to the top