This template maps fields from the (DRAFT) Federal Project Schema to the WWlison Crowdsourcing Map/Form... this template/mapping allows us to feed projects to and from databases in realtime or by bulk download... only fields NOT mapped = zip, street_address_2

federalprojectschema_mappingTo_WoodrowWillsonCrowdsourcingMap.json

{
  "title": "project_name",
  "description": "project_description",
  "status": "options",
  "categories": "options",
  "keywords": [
    {
      "keyword": "keywords"
    }
  ],
  "accessLevel": "",
  "publisher": "",
  "publishedURL": "project_url",
  "contacts": [
    {
      "contactType": "options",
      "contactRole": "options",
      "name": "project_contact",
      "email": "email",
      "office": "affiliation",
      "description": ""
    },
    {
      "contactType": "options",
      "contactRole": "options",
      "name": "agency_sponsor",
      "email": "",
      "office": "",
      "description": ""
    },
    {
      "contactType": "options",
      "contactRole": "options",
      "name": "agency_partner",
      "email": "",
      "office": "",
      "description": ""
    }  
  ],
  "spatial": [
    {
      "name": "geographic_scope",
      "geojson": "",
      "address": "street_address",
      "city": "city",
      "state": "state"
    }
  ],
  "temporal": [
    {
      "activityType": "options",
      "name": "start_date",
      "description": "",
      "to": "",
      "from": "",
      "estimated": "",
      "modified": "",
      "contactId": "",
      "isPublic": true,
      "tasks": []
    },
    {
      "activityType": "options",
      "name": "created_at",
      "description": "",
      "to": "",
      "from": "",
      "estimated": "",
      "modified": "",
      "contactId": "",
      "isPublic": true,
      "tasks": [
        {
          "milestoneType": "options",
          "name": "participation_tasks",
          "description": "",
          "to": "",
          "from": "",
          "estimated": "",
          "modified": "",
          "contactId": "",
          "pause": true,
          "isPublic": true,
          "isWanted": true
        }
      ]
    },
    {
      "activityType": "options",
      "name": "updated_at",
      "description": "",
      "to": "",
      "from": "",
      "estimated": "",
      "modified": "",
      "contactId": "",
      "isPublic": true,
      "tasks": []
    },
    {
      "activityType": "options",
      "name": "approved",
      "description": "",
      "to": "",
      "from": "",
      "estimated": "",
      "modified": "",
      "contactId": "",
      "isPublic": true,
      "tasks": []
    }
  ],
  "media": [],
  "resources": [],
  "federalData": [],
  "data": [],
  "isPartof": [],
  "conformsTo": "https://some.website/projects/1.0/schema",
  "describedBy": "https://some.website/projects/category/v1.0/schema.json",
  "UUID": "32842252-2dcc-4c8b-9f20-4f4165a8a0f0",
  "extended": [
    {
      "additional": "project_topic",
      "fields": ""
    },
    {
      "additional": "participant_age",
      "fields": ""
    },
    {
      "additional": "intended_outcomes",
      "fields": ""
    },
    {
      "additional": "agency_partner",
      "fields": ""
    },
    {
      "additional": "agency_sponsor",
      "fields": ""
    },
    {
      "additional": "scistarter",
      "fields": ""
    },
    {
      "additional": "agency_sponsor_other",
      "fields": ""
    },
    {
      "additional": "cartodb_georef_status",
      "fields": ""
    }
  ]
}