Skip to content

Instantly share code, notes, and snippets.

@haoliangyu
Last active March 4, 2024 01:40
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save haoliangyu/2f2762d7288ca13a1a64283d15ffb3ba to your computer and use it in GitHub Desktop.
Save haoliangyu/2f2762d7288ca13a1a64283d15ffb3ba to your computer and use it in GitHub Desktop.
Open Data API Comparison

ArcGIS Open Data

Example

http://open.fedmaps.opendata.arcgis.com/data.json

Result Example

{
  "dataset": [
      {
      "@type": "dcat:Dataset",
      "identifier": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3",
      "title": "Group Obstructions (< 1000 Ft AGL)",
      "description": "<p>This map layer, utilizing data from the Federal Aviation Administration (FAA), displays vertical obstructions within U.S. airspace. It reflects the FAA’s current Digital Obstruction File (DOF). The DOF is updated every 56 days. It describes all known obstacles of interest to aviation users in the U.S., with limited coverage of the Pacific, the Caribbean, Canada and Mexico. The obstacles are assigned unique numerical identifiers, accuracy codes and are listed in order by state.</p><p><img src=\"http://fedmaps.maps.arcgis.com/sharing/rest/content/items/837b91b8c61d48f29385468d01b17633/data\" /><br /></p><p><i>FAA Vertical Obstructions</i></p><div>Data currency: March 27, 2017</div><div>Data source: <a href=\"http://www.faa.gov/air_traffic/flight_info/aeronav/digital_products/dof/\" target=\"_blank\">Digital Obstruction File</a></div><div>For feedback please contact: <a href=\"mailto:ArcGIScomNationalMaps@esri.com\">ArcGIScomNationalMaps@esri.com</a></div><div><br /></div><div><i>Thumbnail image courtesy of: <a href=\"https://creativecommons.org/licenses/by-sa/2.0/\" target=\"_blank\">Doc Searls</a></i></div><div><div><i>_______________________________________________________</i>_____________________________________________________________________________________<br /></div><div><p>Other Federal User Community federally focused content that may interest you</p></div><div><img src=\"http://fedmaps.maps.arcgis.com/sharing/rest/content/items/e1a269aefa084e0fa6af7f44d3e03d4b/data\" /> <a href=\"http://fedmaps.maps.arcgis.com/home/search.html?q=owner%3AFederal_User_Community%20AND%20tags%3AUSDOT&amp;t=content&amp;restrict=false\" target=\"_blank\">Department of Transportation</a>                          <img src=\"http://fedmaps.maps.arcgis.com/sharing/rest/content/items/5d4fada51ec64b999191c7d9393f402a/data\" /> <a href=\"http://fedmaps.maps.arcgis.com/home/search.html?q=owner%3AFederal_User_Community%20AND%20tags%3AFAA&amp;t=content&amp;restrict=false\" target=\"_blank\">Federal Aviation Administration</a></div><div><br /></div><div><img src=\"http://fedmaps.maps.arcgis.com/sharing/rest/content/items/46785cfb399344a6af50d4514d6ef0f9/data\" /> <a href=\"http://open.fedmaps.opendata.arcgis.com/datasets?q=USDOT&amp;sort_by=relevance&amp;bbox=57.235318750048805%2C-6.735736650550092%2C-57.72561875010814%2C69.75418292033122\" target=\"_blank\">Open Data: USDOT</a>                                           <img src=\"http://fedmaps.maps.arcgis.com/sharing/rest/content/items/46785cfb399344a6af50d4514d6ef0f9/data\" /> <a href=\"http://open.fedmaps.opendata.arcgis.com/datasets?q=FAA&amp;sort_by=relevance&amp;bbox=57.480468750078444%2C-6.841799763362279%2C-57.480468750078444%2C69.71718843400745\" target=\"_blank\">Open Data: FAA</a></div></div>",
      "keyword": [
        "vertical obstructions",
        "obstructions",
        "FAA",
        "aeronautical",
        "aero",
        "obstacle",
        "Federal Aviation Administration",
        "DOF",
        "A16",
        "A16",
        "USDOT",
        "Department of Transportation",
        "airports",
        "US Department of Transportation",
        "air space",
        "Digital Obstruction File",
        "transportation",
        "DOT"
      ],
      "issued": "2013-05-13T13:39:07.000Z",
      "modified": "2017-05-19T15:28:20.402Z",
      "publisher": {
        "name": "U.S. Federal Maps and Apps"
      },
      "contactPoint": {
        "@type": "vcard:Contact",
        "fn": "Federal User Community",
        "hasEmail": "mailto:a2@esri.com"
      },
      "accessLevel": "public",
      "distribution": [
        {
          "@type": "dcat:Distribution",
          "title": "ArcGIS Open Dataset",
          "format": "Web page",
          "mediaType": "text/html",
          "accessURL": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3"
        },
        {
          "@type": "dcat:Distribution",
          "title": "Esri Rest API",
          "format": "Esri REST",
          "mediaType": "application/json",
          "accessURL": "http://maps6.arcgisonline.com/ArcGIS/rest/services/A-16/FAA_Obstacles/MapServer/3"
        },
        {
          "@type": "dcat:Distribution",
          "title": "GeoJSON",
          "format": "GeoJSON",
          "mediaType": "application/vnd.geo+json",
          "downloadURL": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3.geojson"
        },
        {
          "@type": "dcat:Distribution",
          "title": "CSV",
          "format": "CSV",
          "mediaType": "text/csv",
          "downloadURL": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3.csv"
        },
        {
          "@type": "dcat:Distribution",
          "title": "KML",
          "format": "KML",
          "mediaType": "application/vnd.google-earth.kml+xml",
          "downloadURL": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3.kml"
        },
        {
          "@type": "dcat:Distribution",
          "title": "Shapefile",
          "format": "ZIP",
          "mediaType": "application/zip",
          "downloadURL": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3.zip"
        }
      ],
      "landingPage": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3",
      "webService": "http://maps6.arcgisonline.com/ArcGIS/rest/services/A-16/FAA_Obstacles/MapServer/3",
      "license": "http://open-fedmaps.opendata.arcgis.com/datasets/2e5607e50b244138878e184d87a61d25_3/license.json",
      "spatial": "-110.03,33.066,-89.463,41.51",
      "theme": [
        "geospatial"
      ]
    }
  ]
}

CKAN

Example

https://open.alberta.ca/api/3/action/package_search?rows=200&start=0

Parameter

  • rows (int)

    the number of matching rows to return. There is a hard limit of 1000 datasets per query.

  • start (int)

    the offset in the complete result for where the set of returned datasets should begin.

Dataset Information

  • title
  • type
  • version
  • email
  • sensitivity
  • creator
  • author
  • author email
  • maintainer
  • maintainer email
  • license title
  • audience
  • resources
    • title
    • name
    • description
    • format
    • created
    • date modified
    • url
  • tags
    • name
    • state
  • spatial coverage
  • created date
  • topic
  • organization
    • title
    • created
    • state
  • language
  • notes
  • contact
  • pubtype

Result Example

{
  "help": "http://open.alberta.ca/api/3/action/help_show?name=package_search",
  "success": true,
  "result": {
    "count": 9577,
    "sort": "score desc, metadata_modified desc",
    "facets": {},
    "results": [
      {
        "license_title": "Alberta Queens Printer Terms of Use",
        "maintainer": null,
        "contactother": "780-427-4952",
        "creator": [
          "Government of Alberta"
        ],
        "relationships_as_object": [],
        "sensitivity": "unrestricted",
        "private": false,
        "maintainer_email": null,
        "num_tags": 4,
        "identifier-ISBN-print": "9780779784158",
        "issuedate": "2014-12-17 00:00:00",
        "id": "e001ce44-3f3f-4cac-82ec-58e2fe026344",
        "metadata_created": "2017-02-01T16:53:53.463197",
        "metadata_modified": "2017-02-08T00:33:24.726402",
        "author": null,
        "author_email": null,
        "isopen": true,
        "audience": [
          "General Public",
          "Government",
          "Legal and Law Enforcement Professionals"
        ],
        "placeofpub": "Edmonton",
        "state": "active",
        "version": null,
        "creator_user_id": "2d73937b-632c-4451-b74f-1c95a37a6e63",
        "type": "publications",
        "email": "qp@gov.ab.ca",
        "resources": [
          {
            "cache_last_updated": null,
            "package_id": "e001ce44-3f3f-4cac-82ec-58e2fe026344",
            "webstore_last_updated": null,
            "id": "6e2b6149-873d-4334-9eae-482d24ccaf4b",
            "size": null,
            "title": "Youth Justice Act",
            "state": "active",
            "hash": "",
            "description": "This act deals with procedures in Youth Court for contraventions of provincial laws and municipal bylaws, and provides for enforcement.",
            "format": "HTML",
            "time_coverage_from": "2014-12-17",
            "tracking_summary": {
              "total": 0,
              "recent": 0
            },
            "mimetype_inner": null,
            "url_type": null,
            "mimetype": null,
            "cache_url": null,
            "name": "Youth Justice Act",
            "created": "2017-02-07T17:33:24.783180",
            "url": "http://www.qp.alberta.ca/570.cfm?frm_isbn=9780779784158&search_by=link",
            "date_modified": "2014-12-17",
            "webstore_url": null,
            "last_modified": null,
            "position": 0,
            "revision_id": "eefa979a-7a54-4c66-a08a-31b5500ebd00",
            "resource_type": null
          },
          {
            "cache_last_updated": null,
            "package_id": "e001ce44-3f3f-4cac-82ec-58e2fe026344",
            "webstore_last_updated": null,
            "id": "86b57f4e-0615-476f-9767-d5899250c294",
            "size": null,
            "title": "Rules of Youth Court (Provincial Offences) Regulation",
            "state": "active",
            "hash": "",
            "description": "This act deals with procedures in Youth Court for contraventions of provincial laws and municipal bylaws, and provides for enforcement.",
            "format": "HTML",
            "time_coverage_from": "1988-10-20",
            "tracking_summary": {
              "total": 0,
              "recent": 0
            },
            "mimetype_inner": null,
            "url_type": null,
            "mimetype": null,
            "cache_url": null,
            "name": "Rules of Youth Court (Provincial Offences) Regulation",
            "created": "2017-02-07T17:33:24.783202",
            "url": "http://www.qp.alberta.ca/570.cfm?frm_isbn=0773262830&search_by=link",
            "date_modified": "1988-10-20",
            "webstore_url": null,
            "last_modified": null,
            "position": 1,
            "revision_id": "eefa979a-7a54-4c66-a08a-31b5500ebd00",
            "resource_type": null
          },
          {
            "cache_last_updated": null,
            "package_id": "e001ce44-3f3f-4cac-82ec-58e2fe026344",
            "webstore_last_updated": null,
            "id": "9509daa3-30c7-4467-b1b9-1cae9983e1ab",
            "size": null,
            "title": "Rules of Youth Court Regulation",
            "state": "active",
            "hash": "",
            "description": "This regulation deals with procedures in Youth Court for matters under the Youth Criminal Justice Act (Canada).",
            "format": "HTML",
            "time_coverage_from": "1988-10-20",
            "tracking_summary": {
              "total": 0,
              "recent": 0
            },
            "mimetype_inner": null,
            "url_type": null,
            "mimetype": null,
            "cache_url": null,
            "name": "Rules of Youth Court Regulation",
            "created": "2017-02-07T17:33:24.783208",
            "url": "http://www.qp.alberta.ca/570.cfm?frm_isbn=0773262822&search_by=link",
            "date_modified": "1988-10-20",
            "webstore_url": null,
            "last_modified": null,
            "position": 2,
            "revision_id": "eefa979a-7a54-4c66-a08a-31b5500ebd00",
            "resource_type": null
          },
          {
            "cache_last_updated": null,
            "package_id": "e001ce44-3f3f-4cac-82ec-58e2fe026344",
            "webstore_last_updated": null,
            "id": "c2981703-b05b-4894-9e89-8a78be2e622d",
            "size": null,
            "title": "Youth Justice Designation Regulation",
            "state": "active",
            "hash": "",
            "description": "This regulation designates who is considered to be a \"provincial director\" or a \"youth worker\" under the federal Youth Criminal Justice Act and Alberta’s Youth Justice Act.  It also defines levels of custody for youth in Alberta, specifies places where youth may be held in custody, and sets out the percentage of fines that may be used to support victims of crime.  It also designates the Minister of Justice and Solicitor General as holding specific responsibilities related to Youth Justice Committees and conferences under the federal Youth Criminal Justice Act.",
            "format": "HTML",
            "time_coverage_from": "2012-10-17",
            "tracking_summary": {
              "total": 0,
              "recent": 0
            },
            "mimetype_inner": null,
            "url_type": null,
            "mimetype": null,
            "cache_url": null,
            "name": "Youth Justice Designation Regulation",
            "created": "2017-02-07T17:33:24.783213",
            "url": "http://www.qp.alberta.ca/570.cfm?frm_isbn=9780779767656&search_by=link",
            "date_modified": "2012-10-17",
            "webstore_url": null,
            "last_modified": null,
            "position": 3,
            "revision_id": "eefa979a-7a54-4c66-a08a-31b5500ebd00",
            "resource_type": null
          }
        ],
        "updatefrequency": "Irregular",
        "spatialcoverage": "Alberta",
        "num_resources": 4,
        "tags": [
          {
            "vocabulary_id": null,
            "state": "active",
            "display_name": "Administration of Justice",
            "id": "7f870cba-144e-4650-a1c0-c7f341009152",
            "name": "Administration of Justice"
          },
          {
            "vocabulary_id": null,
            "state": "active",
            "display_name": "Law",
            "id": "85b94d3d-b179-4ee5-967e-b8326a0ca30a",
            "name": "Law"
          },
          {
            "vocabulary_id": null,
            "state": "active",
            "display_name": "Legislation",
            "id": "7450f556-2e1b-4aab-855c-023ae8f2c0c8",
            "name": "Legislation"
          },
          {
            "vocabulary_id": null,
            "state": "active",
            "display_name": "QP",
            "id": "7cc1bb6a-b564-4e09-971e-ad2262496c6c",
            "name": "QP"
          }
        ],
        "createdate": "2014-12-17",
        "time_coverage_from": "2014-12-17 00:00:00",
        "tracking_summary": {
          "total": 0,
          "recent": 0
        },
        "groups": [],
        "license_id": "QPTU",
        "relationships_as_subject": [],
        "topic": [
          "Families and Children",
          "Laws and Justice"
        ],
        "organization": {
          "description": "",
          "created": "2015-07-17T15:55:58.455966",
          "title": "Queen's Printer",
          "name": "queensprinter",
          "is_organization": true,
          "state": "active",
          "image_url": "",
          "revision_id": "e23cd3af-6f98-4569-951c-39dd44a45c2e",
          "type": "organization",
          "id": "09d2bf68-7eb8-40bb-96f6-9b6b1b050b10",
          "approval_status": "approved"
        },
        "name": "y01",
        "language": [
          "en-CA [default]"
        ],
        "date_modified": "2014-12-17",
        "url": null,
        "notes": "This act deals with procedures in Youth Court for contraventions of provincial laws and municipal bylaws, and provides for enforcement.",
        "owner_org": "09d2bf68-7eb8-40bb-96f6-9b6b1b050b10",
        "pubtype": [
          "Legislation and Regulations"
        ],
        "contact": "Alberta Queen's Printer",
        "license_url": "http://www.qp.alberta.ca/copyright.cfm",
        "title": "Youth Justice Act",
        "revision_id": "eefa979a-7a54-4c66-a08a-31b5500ebd00"
      }
    ],
    "search_facets": {}
  }
}

DKAN

Example

http://demo.getdkan.com/data.json

Note

DKAN API doesn't return the dataset's portal site, and we can use the search page instead:

https://data.nal.usda.gov/search/type/dataset?query=Data+from%3A+Solving+the+Robot-World+Hand-Eye%28s%29+Calibration+Problem+with+Iterative+Methods

Dataset Information

  • title
  • description
  • keyword
  • distribution
    • downloadURL
    • format
    • description
    • title
  • accessLevel
  • modified
  • issued
  • publisher
    • name
  • contactPoint
    • fn
    • hasEmail
  • spatial
  • license

Result Example

{
  "@context": "https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld",
  "@id": "http://demo.getdkan.com/data.json",
  "@type": "dcat:Catalog",
  "conformsTo": "https://project-open-data.cio.gov/v1.1/schema",
  "describedBy": "https://project-open-data.cio.gov/v1.1/schema/catalog.json",
  "dataset": [
    {
      "@type": "dcat:Dataset",
      "accessLevel": "public",
      "contactPoint": {
        "fn": "Gray, Stefanie",
        "hasEmail": "mailto:datademo@nucivic.com"
      },
      "description": "<p>This data created by the National Democratic Institute (NDI) in partnership with Development Seed, a Washington, D.C.-based online communications consultancy, is designed to make data from the August 20, 2009, Afghanistan presidential election accessible and transparent. We have provided this csv file as there is no download for the whole dataset. There are many more files on the website.</p>\n",
      "distribution": [
        {
          "@type": "dcat:Distribution",
          "downloadURL": "http://demo.getdkan.com/sites/default/files/district_centerpoints_0.csv",
          "mediaType": "text/csv",
          "format": "csv",
          "description": "<p>You can see this data plotted on a map, by clicking on 'Map' below. Individual data records can be seen by clicking on each point.</p>\n",
          "title": "District Names"
        }
      ],
      "identifier": "c9e2d352-e24c-4051-9158-f48127aa5692",
      "issued": "2012-10-30",
      "keyword": [
        "country-afghanistan",
        "election",
        "politics",
        "transparency"
      ],
      "license": "http://opendefinition.org/licenses/odc-by/",
      "modified": "2017-01-13",
      "publisher": {
        "@type": "org:Organization",
        "name": "Committee on International Affairs"
      },
      "spatial": "POLYGON ((60.8642578125 29.878755346038, 61.787109375 30.977609093349, 61.7431640625 31.391157522825, 60.7763671875 31.653381399664, 60.8642578125 32.361403315275, 60.556640625 33.137551192346, 60.908203125 33.578014746144, 60.5126953125 33.614619292334, 60.5126953125 34.307143856288, 60.8642578125 34.343436068483, 61.3037109375 35.603718740697, 62.666015625 35.353216101238, 64.5556640625 36.421282443649, 64.86328125 37.195330582801, 65.654296875 37.195330582801, 65.654296875 37.474858084971, 67.9833984375 37.055177106661, 68.7744140625 37.265309955619, 69.345703125 37.125286284967, 69.697265625 37.683820326694, 70.3125 37.683820326694, 70.3125 38.065392351332, 71.0595703125 38.582526159353, 71.279296875 37.78808138412, 71.7626953125 37.926867601481, 71.4990234375 37.405073750177, 71.630859375 36.738884124394, 73.3447265625 37.474858084971, 73.7841796875 37.474858084971, 73.7841796875 37.265309955619, 74.7509765625 37.335224359306, 74.9267578125 37.160316546737, 74.1357421875 36.809284702059, 72.9931640625 36.949891786813, 71.54296875 36.315125147481, 71.2353515625 36.066862132579, 71.5869140625 35.460669951495, 71.54296875 34.813803317113, 71.103515625 34.560859367084, 71.1474609375 34.08906131585, 70.3125 33.979808728725, 69.873046875 33.979808728725, 70.2685546875 33.321348526699, 69.345703125 32.916485347314, 69.2578125 32.324275588877, 69.1259765625 31.802892586707, 68.7744140625 31.578535426473, 68.0712890625 31.802892586707, 67.67578125 31.615965936476, 67.8515625 31.353636941501, 67.4560546875 31.278550858947, 67.0166015625 31.278550858947, 66.4892578125 30.939924331023, 66.2255859375 30.334953881989, 66.357421875 29.91685223307, 65.0390625 29.535229562948, 64.248046875 29.611670115197, 64.2041015625 29.420460341013, 63.4130859375 29.458731185355, 62.6220703125 29.420460341013))",
      "title": "Afghanistan Election Districts"
    }
  ]
}

GeoNode

Example

http://geonode.state.gov/api/base/

Dataset Information

  • title
  • abstract
  • distribution_url
  • uuid
  • category__gn_description
  • date

Result Example

{
  "meta": {
    "limit": 0,
    "offset": 0,
    "total_count": 25
  },
  "objects": [
    {
      "abstract": "This is the detailed version of the detailed Large Scale International Boundaries (LSIB) dataset.\r\n\r\nThe boundary lines reflect all current US government policies on boundaries, boundary disputes, and sovereignty.\r\n\r\nThere are no restrictions on use of this public domain data. This dataset will be updated as needed and is current as of Jan 30, 2017.",
      "category__gn_description": "Boundaries",
      "csw_type": "dataset",
      "csw_wkt_geometry": "POLYGON((-141.0019559999999 -55.12502199499994,-141.0019559999999 69.64744868500009,48.001056000000176 69.64744868500009,48.001056000000176 -55.12502199499994,-141.0019559999999 -55.12502199499994))",
      "date": "2017-01-30T02:44:00",
      "detail_url": "/layers/geonode%3AAfrica_Americas_LSIB7a",
      "distribution_description": "Web address (URL)",
      "distribution_url": "http://geonode.state.gov/layers/geonode%3AAfrica_Americas_LSIB7a",
      "id": 50,
      "owner__username": "hiu",
      "popular_count": 105,
      "rating": 0,
      "share_count": 0,
      "srid": "EPSG:4326",
      "supplemental_information": "No information provided",
      "thumbnail_url": "http://geonode.state.gov/uploaded/thumbs/layer-57523940-e988-11e6-ae85-0a06d512a67a-thumb.png",
      "title": "Africa Americas LSIB Lines Detailed 2017Jan30",
      "uuid": "57523940-e988-11e6-ae85-0a06d512a67a"
    }
  ]
}

Junar

Example

http://api.data.cityofsacramento.org/api/v2/datasets/?auth_key=c2ec3f2208a504bc8c2f84ff47a26b889717cdcf&limit=1&offset=0

Parameters

  • auth_key (string)

    API authentication key.

  • offset (int)

    Initial starting point for paging (0 by default) Example: 0.

  • limit (int)

    Number of results to return (100 default/max)

Dataset Information

  • title
  • description
  • category_name
  • tags
  • created_at
  • modified_at
  • link

Result Example

{
  "count": 69,
  "next": "http://api.data.cityofsacramento.org/api/v2/datasets/?auth_key=c2ec3f2208a504bc8c2f84ff47a26b889717cdcf&limit=1&offset=1",
  "previous": null,
  "results": [
    {
      "result": null,
      "endpoint": "file://4575/0475/75487840637754682629754469421296137673",
      "description": "Annual Crime Statistics",
      "parameters": [],
      "tags": [
        ""
      ],
      "timestamp": 1486742469000,
      "created_at": 1486742469,
      "title": "Sacramento Annual Crime Statistics",
      "modified_at": 1486742469,
      "category_id": "38920",
      "link": "http://data.cityofsacramento.org/datasets/72416/sacramento-annual-crime-statistics/",
      "user": "sacramento",
      "guid": "SACRA-ANNUA-CRIME-STATI-90418",
      "category_name": "Public Safety"
    }
  ]
}
field ckan dkan socrata arcgis junar opendatasoft geonode
title Y Y Y Y Y Y Y
description Y Y Y Y Y Y Y
created Y Y Y Y Y
modified Y Y Y Y Y Y Y
data_type Y
link Y Y Y Y Y Y
data_link Y
geometry Y Y Y
ower/publisher Y Y Y Y
tags Y Y Y Y Y Y
categories Y Y Y Y Y
version Y
license Y Y Y Y
id Y Y Y Y Y Y Y

OpenDataSoft

Exampe

https://data.opendatasoft.com/api/v2/catalog/datasets?rows=10&start=0

Parameters

  • rows (int)

    the number of matching rows to return. There is a hard limit of 1000 datasets per query.

  • start (int)

    the offset in the complete result for where the set of returned datasets should begin.

Note

The actual data link is

https://{portal_domain}/explore/datasets/{dataset_id}

Dataset Information

  • publisher
  • description
  • license
  • modified
  • language
  • theme
  • keyword
  • fields
    • label
    • name
    • type
    • description

Result Example

{
  "total_count": 6253,
  "links": [
    {
      "href": "https://data.opendatasoft.com/api/v2/catalog/datasets?start=0&include_app_metas=False&rows=1&timezone=UTC",
      "rel": "self"
    },
    {
      "href": "https://data.opendatasoft.com/api/v2/catalog/datasets?start=0&include_app_metas=False&rows=1&timezone=UTC",
      "rel": "first"
    },
    {
      "href": "https://data.opendatasoft.com/api/v2/catalog/datasets?start=6252&include_app_metas=False&rows=1&timezone=UTC",
      "rel": "last"
    },
    {
      "href": "https://data.opendatasoft.com/api/v2/catalog/datasets?start=1&include_app_metas=False&rows=1&timezone=UTC",
      "rel": "next"
    }
  ],
  "datasets": [
    {
      "links": [
        {
          "href": "https://data.opendatasoft.com/api/v2/catalog/datasets/evolution_region_longueurs_circuits_files@rte",
          "rel": "self"
        },
        {
          "href": "https://data.opendatasoft.com/api/v2/catalog/datasets",
          "rel": "datasets"
        },
        {
          "href": "https://data.opendatasoft.com/api/v2/catalog/datasets/evolution_region_longueurs_circuits_files@rte/records",
          "rel": "records"
        },
        {
          "href": "https://data.opendatasoft.com/api/v2/catalog/datasets/evolution_region_longueurs_circuits_files@rte/exports",
          "rel": "exports"
        },
        {
          "href": "https://data.opendatasoft.com/api/v2/catalog/datasets/evolution_region_longueurs_circuits_files@rte/aggregates",
          "rel": "aggregate"
        }
      ],
      "dataset": {
        "fields": [
          {
            "name": "circ_sout_63_kv_km",
            "label": "Circ sout 63 kV (km)",
            "type": "double",
            "annotations": [],
            "description": "Circuit souterrain 63 kV en km\n63 kV underground circuit in km"
          }
        ],
        "dataset_id": "evolution_region_longueurs_circuits_files@rte",
        "has_records": true,
        "attachments": [],
        "data_visible": true,
        "metas": {
          "default": {
            "publisher": "RTE",
            "source_domain_address": "rte.opendatasoft.com",
            "license": "Licence Ouverte (Etalab)",
            "language": "fr",
            "records_count": 180,
            "source_domain": "rte",
            "source_dataset": "evolution_region_longueurs_circuits_files",
            "modified": "2016-07-04T12:28:31+00:00",
            "theme": [
              "Réseau",
              "Territoires et régions"
            ],
            "metadata_processed": "2016-09-02T11:52:16+00:00",
            "keyword": [
              "Electricité",
              "Circuit",
              "Réseau",
              "File de pylônes",
              "Territoire",
              "Région",
              "Bilan électrique"
            ],
            "source_domain_title": "OPEN DATA RTE",
            "data_processed": "2016-09-02T11:52:15+00:00",
            "title": "Evolutions régionales annuelles  des longueurs de circuits et files de pylônes du réseau de transport d'électricité (2013 à 2015)",
            "description": "<p>\n\tEvolution  régionale annuelle des longueurs (km) de files de pylônes et de circuits en exploitation du réseau de transport d’électricité par niveau de tension (63 kV, 90 kV, 225 kV, 400 kV, ...) et par nature d’évolution (nouvelle infrastructure, renouvellement, mise en souterrain, ferraillée, autres modifications). Données définitives.</p><p>\n\tLes natures d'évolution d'un tronçon sont :</p><ul>\n\t\n<li>Nouveau : quand l’installation du tronçon fait l’objet d’un nouveau tracé (une nouvelle liaison par exemple)</li>\t\n<li>Renouvelé : quand un tronçon aérien est remplacé par un tronçon aérien ou quand un tronçon souterrain est remplacé par un tronçon souterrain</li>\t\n<li>Mis en souterrain : quand un tronçon aérien est remplacé par un tronçon souterrain\t </li>\t\n<li>Ferraillé : quand le tronçon a été retiré physiquement du réseau\t </li>\t\n<li>Autres modifications : Ce sont toutes les variations de longueur non recensées dans les tronçons neufs et ferraillés. Cela concerne principalement les tronçons mis en réserve (déconnectés du réseau mais toujours en place) mais aussi les corrections d’erreur ou de longueur</li></ul><hr/><p>\n<strong>Regional changes in lengths of circuits and pylon line of the electricity transport network (2013 to 2015)</strong></p><p>Regional annual changes of lengths (km) of circuits and pylon line in operation on the electricity transport network, by voltage level (63 kV, 90 kV, 225 kV, 400 kV, ...) and by type of change (new infrastructure, renewal, underground laying, scrapped, other changes). Final data.</p><p>Types of changes to a section include : \n<ul> \n<li>New : when installation of the section is a new route (a new link for example) </li><li>Renewed : when an overhead section is replaced with an overhead section or when an underground section is replaced with an underground section </li><li>Buried : when an overhead section is replaced with an underground section </li><li>Scrapped : when the section is physically retired from the network </li><li>Other changes : These are all the unrecorded length variations in new and scrapped sections. These are mainly sections placed in reserve (disconnected from the network but still in place), but also corrections of errors and length </li></ul><p><strong>Keywords :</strong> Electricity, Circuit, Network, Annual electricty report</p></p>"
          }
        },
        "features": [
          "geo",
          "analyze",
          "timeserie"
        ]
      }
    }
  ]
}

Socrata

Example

http://api.us.socrata.com/api/catalog/v1?domains=data.seattle.gov&limit=2&offset=2

Parameters

  • domain (string)

    A comma separated list of cnames. Returns results restricted to only the domains in the list. When not present, searches the entire catalog. Example: data.seattle.gov,data.hawaii.gov.

  • offset (int)

    Initial starting point for paging (0 by default) Example: 0.

  • limit (int)

    Number of results to return (100 default/max) Example: 1000.

Dataset Information

  • resource
    • name
    • description
    • columns name
  • classification
    • categories
    • tags
    • domain_category
    • domain_tags
  • metadata
    • domain
  • permalink
  • link

Result Example

{
  "results": [
    {
      "resource": {
        "view_count": {
          "page_views_total": 3670365,
          "page_views_total_log": 21.807492501618096,
          "page_views_last_week_log": 1.5849625007211563,
          "page_views_last_month": 15,
          "page_views_last_week": 2,
          "page_views_last_month_log": 4
        },
        "obe_fxf": null,
        "description": "Calls for Service by computer aided dispatch (CAD) event type, date, time, location, statistical reporting area (SRA), and beat.",
        "name": "Howard County Police Department Call For Service - 2014 - 2015",
        "parent_fxf": null,
        "nbe_fxf": null,
        "attribution": null,
        "provenance": "official",
        "columns_field_name": [
          "statistical_reporting_area",
          "beat",
          "time_reported",
          "date_reported",
          "location",
          "computer_aided_dispatch_event_type"
        ],
        "download_count": 175,
        "columns_name": [
          "Statistical_Reporting_Area",
          "Beat",
          "Time_Reported",
          "Date_Reported",
          "Location",
          "Computer_Aided_Dispatch_Event_Type"
        ],
        "page_views": {
          "page_views_total": 3670365,
          "page_views_total_log": 21.807492501618096,
          "page_views_last_week_log": 1.5849625007211563,
          "page_views_last_month": 15,
          "page_views_last_week": 2,
          "page_views_last_month_log": 4
        },
        "updatedAt": "2016-03-24T17:56:41.000Z",
        "type": "dataset",
        "id": "qccx-65fg",
        "createdAt": "2015-05-04T15:33:31.000Z",
        "columns_description": [
          "",
          "",
          "",
          "",
          "",
          ""
        ]
      },
      "classification": {
        "categories": [],
        "tags": [],
        "domain_category": "Public Safety",
        "domain_tags": [
          "beat",
          "cad",
          "calls",
          "dispatch",
          "sra"
        ],
        "domain_metadata": [
          {
            "value": "Howard County, MD",
            "key": "Additional-Metadata_Publisher"
          },
          {
            "value": "2014",
            "key": "Additional-Metadata_Coverage"
          },
          {
            "value": "Police Department",
            "key": "Additional-Metadata_Contributor"
          },
          {
            "value": "Annually",
            "key": "Additional-Metadata_Frequency"
          }
        ]
      },
      "metadata": {
        "domain": "opendata.howardcountymd.gov"
      },
      "permalink": "https://opendata.howardcountymd.gov/d/qccx-65fg",
      "link": "https://opendata.howardcountymd.gov/Public-Safety/Howard-County-Police-Department-Call-For-Service-2/qccx-65fg"
    }
  ],
  "resultSetSize": 122910,
  "timings": {
    "serviceMillis": 50,
    "searchMillis": [
      26,
      16
    ]
  }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment