Esempio n. 1
0
    def testLayerDataAttribsFilter(self):
        """ functions layerdata.layerDataFilterBy* with 'where' clause
        returns filtered layer data as dictionary according to
        http://resources.arcgis.com/en/help/rest/apiref/fslayer.html
        http://resources.arcgis.com/en/help/rest/apiref/fsquery.html
        """
        import layerdata, esri, mapfs_controller, postgis, mfslib

        ds = postgis.DataSource(self.conn)
        lyrinf = mapfs_controller.getLayerConfig('0')
        spfilter = esri.SpatialFilterParams(102100,
                                            '{"xmin":57850.1,"ymin":4009328.1,"xmax":11328948.1,"ymax":9410063.1,"spatialReference":{"wkid":102100}}',
                                             'esriGeometryEnvelope',
                                             'esriSpatialRelIntersects')
        attrfilter = esri.AttribsFilterParams("descr='werwre'")
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter, attrfilter)
        txt = simplejson.dumps(res, ensure_ascii=False, sort_keys=True, indent=2, use_decimal=True, default=mfslib.jsonify)
#        with open('tmp.json', 'wb') as fh:
#            fh.write(txt.encode(CP))
        self.assertIn(u'"descr": "werwre"', txt)
        self.assertNotIn(u'"testtimestamp": null', txt)

        res = layerdata.layerDataFilterByAttribs(ds, lyrinf, attrfilter)
        txt = simplejson.dumps(res, ensure_ascii=False, sort_keys=True, indent=2, use_decimal=True, default=mfslib.jsonify)
#        with open('tmp.json', 'wb') as fh:
#            fh.write(txt.encode(CP))
        self.assertIn(u'"descr": "werwre"', txt)
        self.assertNotIn(u'"testtimestamp": null', txt)
Esempio n. 2
0
    def testLayerDataAttribsFilter(self):
        """ functions layerdata.layerDataFilterBy* with 'where' clause
        returns filtered layer data as dictionary according to
        http://resources.arcgis.com/en/help/rest/apiref/fslayer.html
        http://resources.arcgis.com/en/help/rest/apiref/fsquery.html
        """
        import layerdata, esri, mapfs_controller, postgis, mfslib

        ds = postgis.DataSource(self.conn)
        lyrinf = mapfs_controller.getLayerConfig('0')
        spfilter = esri.SpatialFilterParams(
            102100,
            '{"xmin":57850.1,"ymin":4009328.1,"xmax":11328948.1,"ymax":9410063.1,"spatialReference":{"wkid":102100}}',
            'esriGeometryEnvelope', 'esriSpatialRelIntersects')
        attrfilter = esri.AttribsFilterParams("descr='werwre'")
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter, attrfilter)
        txt = simplejson.dumps(res,
                               ensure_ascii=False,
                               sort_keys=True,
                               indent=2,
                               use_decimal=True,
                               default=mfslib.jsonify)
        #        with open('tmp.json', 'wb') as fh:
        #            fh.write(txt.encode(CP))
        self.assertIn(u'"descr": "werwre"', txt)
        self.assertNotIn(u'"testtimestamp": null', txt)

        res = layerdata.layerDataFilterByAttribs(ds, lyrinf, attrfilter)
        txt = simplejson.dumps(res,
                               ensure_ascii=False,
                               sort_keys=True,
                               indent=2,
                               use_decimal=True,
                               default=mfslib.jsonify)
        #        with open('tmp.json', 'wb') as fh:
        #            fh.write(txt.encode(CP))
        self.assertIn(u'"descr": "werwre"', txt)
        self.assertNotIn(u'"testtimestamp": null', txt)
Esempio n. 3
0
    def testLayerDataSpatialFilter(self):
        """ function layerdata.layerDataFilterByGeom returns filtered layer data
        as dictionary according to
        http://resources.arcgis.com/en/help/rest/apiref/fslayer.html
        http://resources.arcgis.com/en/help/rest/apiref/fsquery.html

        example:
        http://vags101.algis.com/arcgis/rest/services/PATHING/FeatureServer/0/query?returnGeometry=true&geometryType=esriGeometryEnvelope&geometry={%22xmin%22%3a-7182265.21424325%2c%22ymin%22%3a-1567516.84684806%2c%22xmax%22%3a17864620.2142433%2c%22ymax%22%3a14321601.0968481%2c%22spatialReference%22%3a{%22wkid%22%3a102100}}&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson
        http://vags101.algis.com/arcgis/rest/services/flyzone/FeatureServer/3/query?returnGeometry=true&geometryType=esriGeometryPolygon&geometry=%7b%22spatialReference%22%3a%7b%22wkid%22%3a102100%7d%2c%22rings%22%3a%5b%5b%5b-3580921.90110393%2c-273950.309374072%5d%2c%5b-3580921.90110393%2c15615167.6343221%5d%2c%5b20037508.3427892%2c15615167.6343221%5d%2c%5b20037508.3427892%2c-273950.309374072%5d%2c%5b-3580921.90110393%2c-273950.309374072%5d%5d%2c%5b%5b-20037508.3427892%2c-273950.309374072%5d%2c%5b-20037508.3427892%2c15615167.6343221%5d%2c%5b-18609053.1581958%2c15615167.6343221%5d%2c%5b-18609053.1581958%2c-273950.309374072%5d%2c%5b-20037508.3427892%2c-273950.309374072%5d%5d%5d%7d&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson

        TODO: replace QueryByBox tests; add query by polygon
        """
        import layerdata, esri, mapfs_controller, postgis, mfslib

        # select by box from 'patching'
        ds = postgis.DataSource(self.conn)
        lyrinf = mapfs_controller.getLayerConfig('0')
        spfilter = esri.SpatialFilterParams(
            102100,
            '{"xmin":3907314.1268439,"ymin":6927697.68990079,"xmax":3996369.71947852,"ymax":7001516.67745022,"spatialReference":{"wkid":102100}}',
            'esriGeometryEnvelope', 'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res,
                               ensure_ascii=False,
                               sort_keys=True,
                               indent=2,
                               use_decimal=True,
                               default=mfslib.jsonify)
        #        with open('layerdata.test1.json', 'wb') as fh:
        #            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test1.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)

        # empty recordset for seismoprofiles
        lyrinf = mapfs_controller.getLayerConfig('1')
        spfilter = esri.SpatialFilterParams(
            102100,
            '{"xmin":3907314.1268439,"ymin":6927697.68990079,"xmax":3996369.71947852,"ymax":7001516.67745022,"spatialReference":{"wkid":102100}}',
            'esriGeometryEnvelope', 'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        dct = {
            "objectIdFieldName": lyrinf.oidfield,
            "globalIdFieldName": "",
            "features": []
        }
        self.assertDictEqual(dct, res)

        # sample recordset for seismoprofiles
        # http://vags101.algis.com/arcgis/rest/services/seisprofiles/FeatureServer/1/query?returnGeometry=true&geometryType=esriGeometryEnvelope&geometry={"xmin":6593024.93074047,"ymin":10538006.415246,"xmax":6641944.62884298,"ymax":10569039.8487298,"spatialReference":{"wkid":102100}}&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson
        lyrinf = mapfs_controller.getLayerConfig('1')
        spfilter = esri.SpatialFilterParams(
            102100,
            '{"xmin":6593024.93074047,"ymin":10538006.415246,"xmax":6641944.62884298,"ymax":10569039.8487298,"spatialReference":{"wkid":102100}}',
            'esriGeometryEnvelope', 'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res,
                               ensure_ascii=False,
                               sort_keys=True,
                               indent=2,
                               use_decimal=True)
        #        with open('layerdata.test2.json', 'wb') as fh:
        #            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test2.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)

        # sample recordset for flyzone
        # http://vags101.algis.com/arcgis/rest/services/flyzone/FeatureServer/2/query?returnGeometry=true&geometryType=esriGeometryEnvelope&geometry=%7b%22xmin%22%3a4103424.83887823%2c%22ymin%22%3a7491699.58654681%2c%22xmax%22%3a4494782.42369833%2c%22ymax%22%3a7726819.88555201%2c%22spatialReference%22%3a%7b%22wkid%22%3a102100%7d%7d&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson
        lyrinf = mapfs_controller.getLayerConfig('2')
        spfilter = esri.SpatialFilterParams(
            102100,
            '{"xmin":4103424.83887823,"ymin":7491699.58654681,"xmax":4494782.42369833,"ymax":7726819.88555201,"spatialReference":{"wkid":102100}}',
            'esriGeometryEnvelope', 'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res,
                               ensure_ascii=False,
                               sort_keys=True,
                               indent=2,
                               use_decimal=True)
        #        with open('layerdata.test3.json', 'wb') as fh:
        #            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test3.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)

        # get by polygon from patching
        # /0/query?geometryType=esriGeometryPolygon&geometry={"spatialReference":{"wkid":102100},"rings":[[[-3580921.90110393,-273950.309374072],[-3580921.90110393,15615167.6343221],[20037508.3427892,15615167.6343221],[20037508.3427892,-273950.309374072],[-3580921.90110393,-273950.309374072]],[[-20037508.3427892,-273950.309374072],[-20037508.3427892,15615167.6343221],[-18609053.1581958,15615167.6343221],[-18609053.1581958,-273950.309374072],[-20037508.3427892,-273950.309374072]]]}&f=pjson
        lyrinf = mapfs_controller.getLayerConfig('0')
        spfilter = esri.SpatialFilterParams(
            '',
            '{"spatialReference":{"wkid":102100},"rings":[[[-3580921.90110393,-273950.309374072],[-3580921.90110393,15615167.6343221],[20037508.3427892,15615167.6343221],[20037508.3427892,-273950.309374072],[-3580921.90110393,-273950.309374072]],[[-20037508.3427892,-273950.309374072],[-20037508.3427892,15615167.6343221],[-18609053.1581958,15615167.6343221],[-18609053.1581958,-273950.309374072],[-20037508.3427892,-273950.309374072]]]}',
            'esriGeometryPolygon', '')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res,
                               ensure_ascii=False,
                               sort_keys=True,
                               indent=2,
                               use_decimal=True,
                               default=mfslib.jsonify)
        #        with open('layerdata.test1p.json', 'wb') as fh:
        #            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test1p.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)
Esempio n. 4
0
    def testLayerDataSpatialFilter(self):
        """ function layerdata.layerDataFilterByGeom returns filtered layer data
        as dictionary according to
        http://resources.arcgis.com/en/help/rest/apiref/fslayer.html
        http://resources.arcgis.com/en/help/rest/apiref/fsquery.html

        example:
        http://vags101.algis.com/arcgis/rest/services/PATHING/FeatureServer/0/query?returnGeometry=true&geometryType=esriGeometryEnvelope&geometry={%22xmin%22%3a-7182265.21424325%2c%22ymin%22%3a-1567516.84684806%2c%22xmax%22%3a17864620.2142433%2c%22ymax%22%3a14321601.0968481%2c%22spatialReference%22%3a{%22wkid%22%3a102100}}&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson
        http://vags101.algis.com/arcgis/rest/services/flyzone/FeatureServer/3/query?returnGeometry=true&geometryType=esriGeometryPolygon&geometry=%7b%22spatialReference%22%3a%7b%22wkid%22%3a102100%7d%2c%22rings%22%3a%5b%5b%5b-3580921.90110393%2c-273950.309374072%5d%2c%5b-3580921.90110393%2c15615167.6343221%5d%2c%5b20037508.3427892%2c15615167.6343221%5d%2c%5b20037508.3427892%2c-273950.309374072%5d%2c%5b-3580921.90110393%2c-273950.309374072%5d%5d%2c%5b%5b-20037508.3427892%2c-273950.309374072%5d%2c%5b-20037508.3427892%2c15615167.6343221%5d%2c%5b-18609053.1581958%2c15615167.6343221%5d%2c%5b-18609053.1581958%2c-273950.309374072%5d%2c%5b-20037508.3427892%2c-273950.309374072%5d%5d%5d%7d&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson

        TODO: replace QueryByBox tests; add query by polygon
        """
        import layerdata, esri, mapfs_controller, postgis, mfslib

        # select by box from 'patching'
        ds = postgis.DataSource(self.conn)
        lyrinf = mapfs_controller.getLayerConfig('0')
        spfilter = esri.SpatialFilterParams(102100,
                                            '{"xmin":3907314.1268439,"ymin":6927697.68990079,"xmax":3996369.71947852,"ymax":7001516.67745022,"spatialReference":{"wkid":102100}}',
                                             'esriGeometryEnvelope',
                                             'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res, ensure_ascii=False, sort_keys=True, indent=2, use_decimal=True, default=mfslib.jsonify)
#        with open('layerdata.test1.json', 'wb') as fh:
#            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test1.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)

        # empty recordset for seismoprofiles
        lyrinf = mapfs_controller.getLayerConfig('1')
        spfilter = esri.SpatialFilterParams(102100,
                                            '{"xmin":3907314.1268439,"ymin":6927697.68990079,"xmax":3996369.71947852,"ymax":7001516.67745022,"spatialReference":{"wkid":102100}}',
                                             'esriGeometryEnvelope',
                                             'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        dct = {"objectIdFieldName": lyrinf.oidfield, "globalIdFieldName": "", "features": []}
        self.assertDictEqual(dct, res)

        # sample recordset for seismoprofiles
        # http://vags101.algis.com/arcgis/rest/services/seisprofiles/FeatureServer/1/query?returnGeometry=true&geometryType=esriGeometryEnvelope&geometry={"xmin":6593024.93074047,"ymin":10538006.415246,"xmax":6641944.62884298,"ymax":10569039.8487298,"spatialReference":{"wkid":102100}}&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson
        lyrinf = mapfs_controller.getLayerConfig('1')
        spfilter = esri.SpatialFilterParams(102100,
                                            '{"xmin":6593024.93074047,"ymin":10538006.415246,"xmax":6641944.62884298,"ymax":10569039.8487298,"spatialReference":{"wkid":102100}}',
                                             'esriGeometryEnvelope',
                                             'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res, ensure_ascii=False, sort_keys=True, indent=2, use_decimal=True)
#        with open('layerdata.test2.json', 'wb') as fh:
#            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test2.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)

        # sample recordset for flyzone
        # http://vags101.algis.com/arcgis/rest/services/flyzone/FeatureServer/2/query?returnGeometry=true&geometryType=esriGeometryEnvelope&geometry=%7b%22xmin%22%3a4103424.83887823%2c%22ymin%22%3a7491699.58654681%2c%22xmax%22%3a4494782.42369833%2c%22ymax%22%3a7726819.88555201%2c%22spatialReference%22%3a%7b%22wkid%22%3a102100%7d%7d&inSR=102100&spatialRel=esriSpatialRelIntersects&outSR=102100&outFields=*&f=pjson
        lyrinf = mapfs_controller.getLayerConfig('2')
        spfilter = esri.SpatialFilterParams(102100,
                                            '{"xmin":4103424.83887823,"ymin":7491699.58654681,"xmax":4494782.42369833,"ymax":7726819.88555201,"spatialReference":{"wkid":102100}}',
                                             'esriGeometryEnvelope',
                                             'esriSpatialRelIntersects')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res, ensure_ascii=False, sort_keys=True, indent=2, use_decimal=True)
#        with open('layerdata.test3.json', 'wb') as fh:
#            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test3.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)

        # get by polygon from patching
        # /0/query?geometryType=esriGeometryPolygon&geometry={"spatialReference":{"wkid":102100},"rings":[[[-3580921.90110393,-273950.309374072],[-3580921.90110393,15615167.6343221],[20037508.3427892,15615167.6343221],[20037508.3427892,-273950.309374072],[-3580921.90110393,-273950.309374072]],[[-20037508.3427892,-273950.309374072],[-20037508.3427892,15615167.6343221],[-18609053.1581958,15615167.6343221],[-18609053.1581958,-273950.309374072],[-20037508.3427892,-273950.309374072]]]}&f=pjson
        lyrinf = mapfs_controller.getLayerConfig('0')
        spfilter = esri.SpatialFilterParams('',
                                            '{"spatialReference":{"wkid":102100},"rings":[[[-3580921.90110393,-273950.309374072],[-3580921.90110393,15615167.6343221],[20037508.3427892,15615167.6343221],[20037508.3427892,-273950.309374072],[-3580921.90110393,-273950.309374072]],[[-20037508.3427892,-273950.309374072],[-20037508.3427892,15615167.6343221],[-18609053.1581958,15615167.6343221],[-18609053.1581958,-273950.309374072],[-20037508.3427892,-273950.309374072]]]}',
                                             'esriGeometryPolygon',
                                             '')
        res = layerdata.layerDataFilterByGeom(ds, lyrinf, spfilter)
        txt = simplejson.dumps(res, ensure_ascii=False, sort_keys=True, indent=2, use_decimal=True, default=mfslib.jsonify)
#        with open('layerdata.test1p.json', 'wb') as fh:
#            fh.write(txt.encode(CP))
        res = simplejson.loads(txt, use_decimal=True)
        with open('layerdata.test1p.json') as fh:
            txt = fh.read().strip().decode(CP)
            dct = simplejson.loads(txt, use_decimal=True)
        self.assertDictEqual(dct, res)