Java FilterFactory2.and方法代码示例

import org.opengis.filter.FilterFactory2; //导入方法依赖的package包/类
public void logical() {
    FilterFactory2 ff = CommonFactoryFinder.getFilterFactory2();
    Filter filter;
    // logical start

    // you can use *not* to invert the test; this is especially handy
    // with like filters (allowing you to select content that does not
    // match the provided pattern)
    filter = ff.not(ff.like(ff.property("code"), "230%"));

    // you can also combine filters to narrow the results returned
    filter = ff.and(ff.greater(ff.property("rainfall"), ff.literal(70)),
            ff.equal(ff.property("land_use"), ff.literal("urban"), false));

    filter = ff.or(ff.equal(ff.property("code"), ff.literal("approved")),
            ff.greater(ff.property("funding"), ff.literal(23000)));

    // logical end
}
 

import org.opengis.filter.FilterFactory2; //导入方法依赖的package包/类
/**
 * Creates a base filter that will return a small subset of our results. This can be tweaked to
 * return different results if desired. Currently it should return 16 results.
 *
 * @return
 *
 * @throws org.geotools.filter.text.cql2.CQLException
 * @throws java.io.IOException
 */
static Filter createBaseFilter()
        throws CQLException, IOException {

    // Get a FilterFactory2 to build up our query
    FilterFactory2 ff = CommonFactoryFinder.getFilterFactory2();

    // We are going to query for events in Ukraine during the
    // civil unrest.

    // We'll start by looking at a particular time frame
    Filter timeFilter =
            ff.between(ff.property(Attributes.SQLDATE.getName()),
                       ff.literal("2013-01-01T05:00:00.000Z"),
                       ff.literal("2014-04-30T23:00:00.000Z"));

    // We'll bound our query spatially to Ukraine
    Filter spatialFilter =
            ff.bbox(Attributes.geom.getName(),
                    31.6, 44, 37.4, 47.75,
                    "EPSG:4326");

    // we'll also restrict our query to only articles about the US, UK or UN
    Filter attributeFilter = ff.like(ff.property(Attributes.Actor1Name.getName()), "UNITED%");

    // Now we can combine our filters using a boolean AND operator
    Filter conjunction = ff.and(Arrays.asList(timeFilter, spatialFilter, attributeFilter));

    return conjunction;
}
 

import org.opengis.filter.FilterFactory2; //导入方法依赖的package包/类
public static void queryGdelt(String[] args) throws Exception {
    CommandLineParser parser = new BasicParser();
    Options options = GDELTIngest.getCommonRequiredOptions();

    CommandLine cmd = parser.parse( options, args);
    Map<String, String> dsConf = GDELTIngest.getAccumuloDataStoreConf(cmd);

    String featureName = cmd.getOptionValue(GDELTIngest.FEATURE_NAME);

    // First, we get a handle to the data store and feature source
    DataStore ds = DataStoreFinder.getDataStore(dsConf);
    SimpleFeatureSource fs = ds.getFeatureSource(featureName);

    // Next, we form a query.  We need a FilterFactory2 to build
    // up our query
    FilterFactory2 ff = CommonFactoryFinder.getFilterFactory2();

    // We want to query for events in Ukraine during the
    // civil unrest.  We'll start by looking at January and February
    // of 2014
    DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
    Date start = df.parse("2014-01-01");
    Date end = df.parse("2014-02-28");
    Filter timeFilter = ff.between(ff.property("SQLDATE"), ff.literal(start), ff.literal(end));

    // We need to bound our query spatially to Ukraine
    Filter spatialFilter = ff.bbox("geom", 22.1371589, 44.386463, 40.228581, 52.379581, "EPSG:4326");

    // Now we can combine our time filter and our spatial filter using a boolean and operator
    Filter conjunction = ff.and(timeFilter, spatialFilter);

    // Let's constrain the results to just the date/time, location, and Actor names
    Query query = new Query("gdelt", conjunction, new String[]{ "SQLDATE", "geom", "Actor1Name", "Actor2Name" });

    // Finally, we submit our query to GeoMesa
    SimpleFeatureCollection results = fs.getFeatures(query);

    System.out.println("Number of results = " + results.size());

    // We can add an attribute filter
    Filter actor1Protest = ff.like(ff.property("Actor1Name"), "PROTEST%");
    Filter spatialTemporalAttribute = ff.and(conjunction, actor1Protest);
    Query query2 = new Query("gdelt", spatialTemporalAttribute, new String[]{ "SQLDATE", "geom", "Actor1Name", "Actor2Name" });
    SimpleFeatureCollection results2 = fs.getFeatures(query2);

    System.out.println("Number of results = " + results2.size());

    Filter eventRootCodeThreaten =  ff.equal(ff.property("EventRootCode"), ff.literal(13), false);
    Filter spatialTemporalAttribute2 = ff.and(conjunction, eventRootCodeThreaten);
    Query query3 = new Query("gdelt", spatialTemporalAttribute2, new String[]{ "SQLDATE", "geom", "Actor1Name", "Actor2Name", "EventRootCode", "EventBaseCode" });
    SimpleFeatureCollection results3 = fs.getFeatures(query3);

    System.out.println("Number of results = " + results3.size());
}
 

import org.opengis.filter.FilterFactory2; //导入方法依赖的package包/类
/**
     * Creates a base filter that will return a small subset of our results. This can be tweaked to
     * return different results if desired. Currently it should return 16 results.
     *
     * @return
     *
     * @throws CQLException
     * @throws IOException
     */
    static Filter createBaseFilter()
            throws CQLException, IOException {

        // Get a FilterFactory2 to build up our query
        FilterFactory2 ff = CommonFactoryFinder.getFilterFactory2();

        // We are going to query for events in Ukraine during the
        // civil unrest.

        // We'll start by looking at a particular day in February of 2014
        Calendar calendar = Calendar.getInstance();
        calendar.clear();
        calendar.set(Calendar.YEAR, 2013);
        calendar.set(Calendar.MONTH, Calendar.JANUARY);
        calendar.set(Calendar.DAY_OF_MONTH, 1);
        calendar.set(Calendar.HOUR_OF_DAY, 0);
        Date start = calendar.getTime();

        calendar.set(Calendar.YEAR, 2014);
        calendar.set(Calendar.MONTH, Calendar.APRIL);
        calendar.set(Calendar.DAY_OF_MONTH, 30);
        calendar.set(Calendar.HOUR_OF_DAY, 23);
        Date end = calendar.getTime();
//        2013-01-01T00:00:00.000Z/2014-04-30T23:00:00.000Z
        Filter timeFilter =
                ff.between(ff.property(GdeltFeature.Attributes.SQLDATE.getName()),
                           ff.literal(start),
                           ff.literal(end));

        // We'll bound our query spatially to Ukraine
        Filter spatialFilter =
                ff.bbox(GdeltFeature.Attributes.geom.getName(),
                        31.6, 44, 37.4, 47.75,
                        "EPSG:4326");

        // we'll also restrict our query to only articles about the US, UK or UN
        Filter attributeFilter = ff.like(ff.property(GdeltFeature.Attributes.Actor1Name.getName()),
                                         "UNITED%");

        // Now we can combine our filters using a boolean AND operator
        Filter conjunction = ff.and(Arrays.asList(timeFilter, spatialFilter, attributeFilter));

        return conjunction;
    }
 

import org.opengis.filter.FilterFactory2; //导入方法依赖的package包/类
/**
 * Creates a base filter that will return a small subset of our results. This can be tweaked to
 * return different results if desired. Currently it should return 16 results.
 *
 * @return
 *
 * @throws CQLException
 * @throws IOException
 */
static Filter createBaseFilter()
        throws CQLException, IOException {

    // Get a FilterFactory2 to build up our query
    FilterFactory2 ff = CommonFactoryFinder.getFilterFactory2();

    // We are going to query for events in Ukraine during the
    // civil unrest.

    // We'll start by looking at a particular day in February of 2014
    Calendar calendar = Calendar.getInstance();
    calendar.clear();
    calendar.set(Calendar.YEAR, 2014);
    calendar.set(Calendar.MONTH, Calendar.FEBRUARY);
    calendar.set(Calendar.DAY_OF_MONTH, 2);
    calendar.set(Calendar.HOUR_OF_DAY, 0);
    Date start = calendar.getTime();

    calendar.set(Calendar.HOUR_OF_DAY, 23);
    Date end = calendar.getTime();

    Filter timeFilter =
            ff.between(ff.property(GdeltFeature.Attributes.SQLDATE.getName()),
                       ff.literal(start),
                       ff.literal(end));

    // We'll bound our query spatially to Ukraine
    Filter spatialFilter =
            ff.bbox(GdeltFeature.Attributes.geom.getName(),
                    22.1371589,
                    44.386463,
                    40.228581,
                    52.379581,
                    "EPSG:4326");

    // we'll also restrict our query to only articles about the US, UK or UN
    Filter attributeFilter = ff.like(ff.property(GdeltFeature.Attributes.Actor1Name.getName()),
                                     "UNITED%");

    // Now we can combine our filters using a boolean AND operator
    Filter conjunction = ff.and(Arrays.asList(timeFilter, spatialFilter, attributeFilter));

    return conjunction;
}