GovReady / odesurvey

Center for Open Data Enterprise website and Open Data Impact Survey
http://www.opendataenterprise.org
2 stars 2 forks source link

use_* fields are not being copied to arcgis_flatfile on record creation #242

Open gregelin opened 9 years ago

gregelin commented 9 years ago

It appears certain fields are not being copied to arcgis_flatfile when a new survey is completed. An example is "Quorum."

Fields that are suspect:

            "use_prod_srvc_desc":null,
            "use_org_opt_desc":null,
            "use_research_desc":null,
            "use_other_desc":null,

Full record sample:

        {
            "createdAt":"2015-09-21",
            "data_src_country_locode":"USA",
            "data_src_country_name":"United States",
            "data_src_gov_level":"National",
            "data_type":"Government operations",
            "industry_id":"Data\/information technology",
            "industry_other":"",
            "latitude":38.9016066,
            "longitude":-77.0404298,
            "no_org_url":false,
            "objectId":"psAKd85kNC",
            "org_description":"Quorum is an online legislative strategy platform that provides legislative professionals in Washington and all 50 states access to a comprehensive database of legislative information, with quantitative insights and modern project management tools making it easier to track legislation, build support, and take action.",
            "org_greatest_impact":"Governance",
            "org_greatest_impact_detail":"Quorum has aggregated the most comprehensive database of legislative information and has built a series of unique quantitative analytics that provide insights into Congress and all 50 state legislatures, automating many of the legislative tasks previously done by hand and making it easier to understand, explain, and influence the legislative process.",
            "org_hq_city":"Washington",
            "org_hq_city_locode":null,
            "org_hq_country":"United States",
            "org_hq_country_income":"High income",
            "org_hq_country_income_code":"HIC",
            "org_hq_country_locode":"US",
            "org_hq_country_region":"North America",
            "org_hq_country_region_code":"NAM",
            "org_hq_st_prov":"District of Columbia",
            "org_name":"Quorum",
            "org_open_corporates_id":null,
            "org_profile_category":"submitted survey",
            "org_profile_src":"survey",
            "org_profile_status":"publish",
            "org_profile_year":2015,
            "org_size_id":"11-50",
            "org_type":"For-profit",
            "org_type_other":null,
            "org_url":"https:\/\/www.quorum.us\/",
            "org_year_founded":2014,
            "profile_id":"VybGpsXuBG",
            "row_type":"data_use",
            "updatedAt":"2015-09-21",
            "use_advocacy":false,
            "use_advocacy_desc":"",
            "use_org_opt":true,
            "use_other":false,
            "use_prod_srvc":true,
            "use_research":false,
            "date_created":"2015-09-21",
            "date_modified":"2015-09-21",
            "eligibility":"YY",
            "use_prod_srvc_desc":null,
            "use_org_opt_desc":null,
            "use_research_desc":null,
            "use_other_desc":null,
            "org_additional":null,
            "org_confidence":0,
            "data_country_count":null
        },