Examples of org.geotools.data.Query

org.geotools.data.Query
Encapsulates a request for data, typically as:
```
 Query query = ... myFeatureSource.getFeatures(query); 
```
The query class is based on the Web Feature Server specification and offers a few interesting capabilities such as the ability to sort results and use a filter (similar to the WHERE clause in SQL).
Additional capabilities:
- {@linkplain #setMaxFeatures(int)} and {@linkplain #setStartIndex(Integer)} can be usedimplement 'paging' through the data source's content. This is useful if, for example, the FeatureSource has an upper limit on the number of features it can return in a single request or you are working with limited memory.
- {@linkplain #setHandle(String)} can be used to give the query a mnemonic namewhich will appear in error reporing and logs.
- {@linkplain #setCoordinateSystem(CoordinateReferenceSystem)} is used to to specify thecoordinate system that retrieved features will be "forced" into. This is often used to correct a feature source when the application and the data format have different ideas about the coordinate system (for example, the "axis order" issue).
- {@linkplain #setCoordinateSystemReproject(CoordinateReferenceSystem)} is used to ask forthe retrieved features to be reproejcted.
Vendor specific:
- {@linkplain setHints(Hints)} is used to specify venfor specific capabilitiesprovided by a feature source implementation.
Joins:
The Query class supports the concepts of joins in that a query can result in a join of the feature type to other feature types in the same datastore. For example, the following would be a spatial join that selected the country that contain a particular city.
```
 Query query = new Query("countries"); Join join = new Join("cities", CQL.toFilter("CONTAINS(geometry, b.geometry)")); join.setAlias("b"); join.setFilter(CQL.toFilter("CITY_NAME = 'Canmore'")) query.getJoins().add(join); 
```
Example:
```
 Filter filter = CQL.toFilter("NAME like '%land'"); Query query = new Query( "countries", filter ); FeatureCollection features = featureSource.getFeatures( query ); 
```
@author Chris Holmes @source $URL$ @version $Id$

                        
              store = FileDataStoreFinder.getDataStore(file);
              if (store==null) throw new ActionException(this, "the layer "+file.getCanonicalPath()+" cannot be found. Skip execution.");
                        FeatureSource featureSource = store.getFeatureSource();
                        SimpleFeatureType schema = (SimpleFeatureType) featureSource.getSchema();
                        Query query = new Query( schema.getTypeName(), Filter.INCLUDE );
                        query.setCoordinateSystem(CRS.decode("EPSG:4326", true));
                        features = (SimpleFeatureCollection) featureSource.getFeatures( query );
                        
          //    features = (SimpleFeatureCollection) featureSource.getFeatures();
                    }

View Full Code Here


    private void insert(final WorkingTree workTree, final String path,
            @SuppressWarnings("rawtypes") final FeatureSource featureSource,
            final ProgressListener taskProgress) {


        final Query query = new Query();
        CoordinateSequenceFactory coordSeq = new PackedCoordinateSequenceFactory();
        query.getHints().add(new Hints(Hints.JTS_COORDINATE_SEQUENCE_FACTORY, coordSeq));
        workTree.insert(path, featureSource, query, taskProgress);


    }

View Full Code Here


        @SuppressWarnings({ "rawtypes", "unchecked" })
        @Override
        public Integer call() throws Exception {


            final Query query = new Query();
            CoordinateSequenceFactory coordSeq = new PackedCoordinateSequenceFactory();
            query.getHints().add(new Hints(Hints.JTS_COORDINATE_SEQUENCE_FACTORY, coordSeq));
            query.setStartIndex(offset);
            if (limit != null && limit.intValue() > 0) {
                query.setMaxFeatures(limit);
            }
            FeatureCollection collection = source.getFeatures(query);
            FeatureIterator features = collection.features();
            Iterator<Feature> fiterator = new FeatureIteratorIterator<Feature>(features);

View Full Code Here


        FeatureSource<SimpleFeatureType, SimpleFeature> source = dataStore
                .getFeatureSource(linesTypeName);
        assertEquals(1, source.getCount(null));


        FeatureReader<SimpleFeatureType, SimpleFeature> r = dataStore.getFeatureReader(new Query(
                linesTypeName.getLocalPart()), Transaction.AUTO_COMMIT);
        assertTrue(r.hasNext());


        f = r.next();
        assertEquals("foo", f.getAttribute("sp"));

View Full Code Here


        ReferencedEnvelope bounds;
        Filter filter;


        filter = ff.id(Collections.singleton(ff.featureId(RepositoryTestCase.idP2)));
        bounds = pointsSource.getBounds(new Query(pointsName, filter));
        assertEquals(boundsOf(points2), bounds);


        ReferencedEnvelope queryBounds = boundsOf(points1, points2);


        Polygon geometry = JTS.toGeometry(queryBounds);
        filter = ff.intersects(ff.property(pointsType.getGeometryDescriptor().getLocalName()),
                ff.literal(geometry));


        bounds = pointsSource.getBounds(new Query(pointsName, filter));
        assertEquals(boundsOf(points1, points2), bounds);


        ReferencedEnvelope transformedQueryBounds;
        CoordinateReferenceSystem queryCrs = CRS.decode("EPSG:3857");
        transformedQueryBounds = queryBounds.transform(queryCrs, true);


        geometry = JTS.toGeometry(transformedQueryBounds);
        geometry.setUserData(queryCrs);


        filter = ff.intersects(ff.property(pointsType.getGeometryDescriptor().getLocalName()),
                ff.literal(geometry));


        bounds = pointsSource.getBounds(new Query(pointsName, filter));
        assertEquals(boundsOf(points1, points2), bounds);


        filter = ECQL.toFilter("sp = 'StringProp2_3' OR ip = 2000");
        bounds = linesSource.getBounds(new Query(linesName, filter));
        assertEquals(boundsOf(lines3, lines2), bounds);
    }

View Full Code Here

        assertEquals(3, linesSource.getCount(Query.ALL));


        Filter filter;


        filter = ff.id(Collections.singleton(ff.featureId(RepositoryTestCase.idP2)));
        assertEquals(1, pointsSource.getCount(new Query(pointsName, filter)));


        ReferencedEnvelope queryBounds = boundsOf(points1, points2);


        Polygon geometry = JTS.toGeometry(queryBounds);
        filter = ff.intersects(ff.property(pointsType.getGeometryDescriptor().getLocalName()),
                ff.literal(geometry));


        assertEquals(2, pointsSource.getCount(new Query(pointsName, filter)));


        ReferencedEnvelope transformedQueryBounds;
        CoordinateReferenceSystem queryCrs = CRS.decode("EPSG:3857");
        transformedQueryBounds = queryBounds.transform(queryCrs, true);


        geometry = JTS.toGeometry(transformedQueryBounds);
        geometry.setUserData(queryCrs);


        filter = ff.intersects(ff.property(pointsType.getGeometryDescriptor().getLocalName()),
                ff.literal(geometry));


        assertEquals(2, pointsSource.getCount(new Query(pointsName, filter)));


        filter = ECQL.toFilter("sp = 'StringProp2_3' OR ip = 2000");
        assertEquals(2, linesSource.getCount(new Query(linesName, filter)));
    }

View Full Code Here

        Set<List<Object>> expected;


        Filter filter;


        filter = ff.id(Collections.singleton(ff.featureId(RepositoryTestCase.idP2)));
        collection = pointsSource.getFeatures(new Query(pointsName, filter));
        actual = Sets.newHashSet();
        for (SimpleFeature f : toList(collection)) {
            actual.add(f.getAttributes());
        }
        expected = Collections.singleton(((SimpleFeature) points2).getAttributes());


        assertEquals(expected, actual);


        ReferencedEnvelope queryBounds = boundsOf(points1, points2);


        Polygon geometry = JTS.toGeometry(queryBounds);
        filter = ff.intersects(ff.property(pointsType.getGeometryDescriptor().getLocalName()),
                ff.literal(geometry));


        collection = pointsSource.getFeatures(new Query(pointsName, filter));
        actual = Sets.newHashSet();
        for (SimpleFeature f : toList(collection)) {
            actual.add(f.getAttributes());
        }
        expected = ImmutableSet.of(((SimpleFeature) points1).getAttributes(),
                ((SimpleFeature) points2).getAttributes());


        assertEquals(expected, actual);


        ReferencedEnvelope transformedQueryBounds;
        CoordinateReferenceSystem queryCrs = CRS.decode("EPSG:3857");
        transformedQueryBounds = queryBounds.transform(queryCrs, true);


        geometry = JTS.toGeometry(transformedQueryBounds);
        geometry.setUserData(queryCrs);


        filter = ff.intersects(ff.property(pointsType.getGeometryDescriptor().getLocalName()),
                ff.literal(geometry));


        collection = pointsSource.getFeatures(new Query(pointsName, filter));
        actual = Sets.newHashSet();
        for (SimpleFeature f : toList(collection)) {
            actual.add(f.getAttributes());
        }
        expected = ImmutableSet.of(((SimpleFeature) points1).getAttributes(),
                ((SimpleFeature) points2).getAttributes());


        assertEquals(expected.size(), actual.size());
        assertEquals(expected, actual);


        filter = ECQL.toFilter("sp = 'StringProp2_3' OR ip = 2000");
        collection = linesSource.getFeatures(new Query(linesName, filter));
        actual = Sets.newHashSet();
        for (SimpleFeature f : toList(collection)) {
            actual.add(f.getAttributes());
        }
        expected = ImmutableSet.of(((SimpleFeature) lines2).getAttributes(),

View Full Code Here

                        
              store = FileDataStoreFinder.getDataStore(file);
              if (store==null) throw new ActionException(this, "the layer "+file.getCanonicalPath()+" cannot be found. Skip execution.");
                        FeatureSource featureSource = store.getFeatureSource();
                        SimpleFeatureType schema = (SimpleFeatureType) featureSource.getSchema();
                        Query query = new Query( schema.getTypeName(), Filter.INCLUDE );
                        query.setCoordinateSystem(CRS.decode("EPSG:4326", true));
                        features = (SimpleFeatureCollection) featureSource.getFeatures( query );
                        
          //    features = (SimpleFeatureCollection) featureSource.getFeatures();
                    }

View Full Code Here

        SimpleFeatureSource featureSource = store.getFeatureSource();


        CoordinateReferenceSystem sourceCRS = featureSource.getInfo().getCRS();
        CoordinateReferenceSystem WGS84 = CRS.decode("EPSG:4326", true);
        
        Query query = new Query();
        query.setCoordinateSystem(sourceCRS);
        query.setCoordinateSystemReproject(WGS84);
        SimpleFeatureCollection featureCollection = featureSource.getFeatures(query);
        
        SimpleFeatureIterator it = featureCollection.features();
        
        PointSet ret = new PointSet(featureCollection.size());

View Full Code Here

            CRSAuthorityFactory factory = ReferencingFactoryFinder.getCRSAuthorityFactory("EPSG",
                    hints);
            CoordinateReferenceSystem worldCRS = factory
                    .createCoordinateReferenceSystem("EPSG:4326");


            Query query = new Query();
            query.setCoordinateSystem(sourceCRS);
            query.setCoordinateSystemReproject(worldCRS);


            FeatureCollection<SimpleFeatureType, SimpleFeature> features = featureSource
                    .getFeatures(query);


            features = featureSource.getFeatures(query);

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.geotools.data.Query

mil.nga.giat.geowave.vector.plugin.ExtractTimeFilterVisitorTest

mil.nga.giat.geowave.vector.plugin.GeoWaveFeatureSourceTest

org.geoserver.feature.retype.FullyRetypingDataStoreTest

org.geoserver.feature.retype.RetypingDataStore

org.geoserver.feature.retype.RetypingDataStoreTest

org.geoserver.feature.retype.RetypingFeatureSource

org.geoserver.python.datastore.PythonDataStoreTest

org.geoserver.security.decorators.SecuredFeatureLocking

org.geoserver.security.decorators.SecuredFeatureSource

org.geoserver.security.decorators.SecuredFeatureStore

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.