Details

    • Type: New Feature New Feature
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 0.4.0
    • Fix Version/s: Future
    • Component/s: Storage - JSON
    • Labels:
      None
    • Target Version/s:

      Description

      Since there are a few databases (MongoDB ,CouchDB) that produce JSON via ReST APIs, and a host of other APIs too, it would be nice to have them as data sources.

      Some examples:

      1. CouchDB: a request like:
        curl -X GET "http://127.0.0.1:5984/drinks/_design/drinks/_view/byName"
        may generate:
        {"total_rows":4,"offset":0,"rows":[
        {"id":"3b510371b46c2f20cd7d72a527007e2a","key":"angler's cocktail","value":"Angler's Cocktail"},
        {"id":"3b510371b46c2f20cd7d72a52700af45","key":"manhattan","value":"Manhattan"},
        {"id":"3b510371b46c2f20cd7d72a527008dd5","key":"martini","value":"Martini"},
        {"id":"3b510371b46c2f20cd7d72a527009c27","key":"old fashioned","value":"Old Fashioned"}
        ]}
      2. A WFS query like:
        curl -X GET "https://geosrv.aurin.org.au/geoserver/grattan/ows?service=WFS&version=1.0.0&request=GetFeature&typeName=grattan:Grattan_Employ_Inc2011&maxFeatures=50&outputFormat=json&propertyName=SSC_NAME,SSC2011"
        may generate:
        {
            "type": "FeatureCollection",
            "features": [
                {
                    "type": "Feature",
                    "id": "Grattan_Employ_Inc2011.1",
                    "geometry": null,
                    "properties": {
                        "SSC_NAME": "Abbotsbury",
                        "SSC2011": 10001
                    }
                },
                {
                    "type": "Feature",
                    "id": "Grattan_Employ_Inc2011.2",
                    "geometry": null,
                    "properties": {
                        "SSC_NAME": "Abbotsford (NSW)",
                        "SSC2011": 10002
                    }
                },
                {
                    "type": "Feature",
                    "id": "Grattan_Employ_Inc2011.3",
                    "geometry": null,
                    "properties": {
                        "SSC_NAME": "Abercrombie",
                        "SSC2011": 10003
                    }
                },
                {
                    "type": "Feature",
                    "id": "Grattan_Employ_Inc2011.4",
                    "geometry": null,
                    "properties": {
                        "SSC_NAME": "Aberdare",
                        "SSC2011": 10004
                    }
                },
                {
                    "type": "Feature",
                    "id": "Grattan_Employ_Inc2011.5",
                    "geometry": null,
                    "properties": {
                        "SSC_NAME": "Aberdeen (NSW)",
                        "SSC2011": 10005
                    }
                },
                {
                    "type": "Feature",
                    "id": "Grattan_Employ_Inc2011.50",
                    "geometry": null,
                    "properties": {
                        "SSC_NAME": "Argents Hill",
                        "SSC2011": 10050
                    }
                }
            ]
        }

        Activity

        Hide
        Hanifi Gunes added a comment -

        Sounds interesting. I think implementing this with a generic streaming network storage plugin with multiple data formats supported would be nice to begin with.

        Show
        Hanifi Gunes added a comment - Sounds interesting. I think implementing this with a generic streaming network storage plugin with multiple data formats supported would be nice to begin with.
        Hide
        Venkata krishnan Sowrirajan added a comment -

        This looks interesting to me. I would like to know more about implementing this in drill. If you want me to do, an initial prototype or simpler working model, I can even work on that. It would be great if some one can point me to some resources where I can learn more on this and start working on it.

        Suggestions appreciated.

        Show
        Venkata krishnan Sowrirajan added a comment - This looks interesting to me. I would like to know more about implementing this in drill. If you want me to do, an initial prototype or simpler working model, I can even work on that. It would be great if some one can point me to some resources where I can learn more on this and start working on it. Suggestions appreciated.

          People

          • Assignee:
            Unassigned
            Reporter:
            Luca Morandini
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:

              Development