Skip to content

Instantly share code, notes, and snippets.

@dbouwman

dbouwman/dataset.json

Created May 7, 2015 20:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dbouwman/e669054377fc7b65ec6c to your computer and use it in GitHub Desktop.
Save dbouwman/e669054377fc7b65ec6c to your computer and use it in GitHub Desktop.
Download ZIP
Dataset Fields output
Raw
dataset.json
{
"_id" : ObjectId("554bc5addebd6e3428f8d5ae"),
"advanced_query_capabilities" : {
"supportsPagination" : "true",
"supportsQueryWithDistance" : "true",
"supportsReturningQueryExtent" : "true",
"supportsStatistics" : "true",
"supportsOrderBy" : "true",
"supportsDistinct" : "true"
},
"arcgis_online_item_url" : "",
"created_at" : "2014-12-08T20:18:16.000Z",
"current_version" : "10.3",
"description" : "",
"display_field" : "",
"extent" : {
"coordinates" : [
[
"-79.23943727866606",
"40.71597558256163"
],
[
"-77.5977604164186",
"42.003119482785245"
]
]
},
"fields" : [
{
"name" : "FID",
"type" : "esriFieldTypeInteger",
"actualType" : "int",
"alias" : "FID",
"sqlType" : "sqlTypeInteger",
"nullable" : "false",
"editable" : "false",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "385.77975499999957",
"sum" : "2514403",
"avg" : "1121",
"count" : "2242",
"min" : "1",
"max" : "2242",
"stddev" : "647.353973237723",
"var" : "419067.166666667"
}
},
{
"name" : "ST_RT_NO",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "ST_RT_NO",
"sqlType" : "sqlTypeNVarchar",
"length" : "4",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "0219",
"count" : "113"
},
{
"value" : "0036",
"count" : "58"
},
{
"value" : "0006",
"count" : "51"
},
{
"value" : "0053",
"count" : "42"
},
{
"value" : "0322",
"count" : "40"
},
{
"value" : "4005",
"count" : "40"
},
{
"value" : "0120",
"count" : "39"
},
{
"value" : "0044",
"count" : "35"
},
{
"value" : "0949",
"count" : "33"
},
{
"value" : "0879",
"count" : "32"
}
],
"count" : "-1",
"duration" : "187.38278100000025"
}
},
{
"name" : "CTY_CODE",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "CTY_CODE",
"sqlType" : "sqlTypeNVarchar",
"length" : "2",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "17",
"count" : "741"
},
{
"value" : "33",
"count" : "585"
},
{
"value" : "42",
"count" : "310"
},
{
"value" : "52",
"count" : "291"
},
{
"value" : "24",
"count" : "261"
},
{
"value" : "12",
"count" : "54"
}
],
"count" : "-1",
"duration" : "251.53337099999953"
}
},
{
"name" : "DISTRICT_N",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "DISTRICT_N",
"sqlType" : "sqlTypeNVarchar",
"length" : "2",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "02",
"count" : "1657"
},
{
"value" : "10",
"count" : "585"
}
],
"count" : "-1",
"duration" : "178.6378080000004"
}
},
{
"name" : "JURIS",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "JURIS",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "1",
"count" : "1965"
},
{
"value" : "8",
"count" : "234"
},
{
"value" : "5",
"count" : "43"
}
],
"count" : "-1",
"duration" : "199.3258369999994"
}
},
{
"name" : "SEG_BGN",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "SEG_BGN",
"sqlType" : "sqlTypeNVarchar",
"length" : "4",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "0010",
"count" : "678"
},
{
"value" : "0020",
"count" : "94"
},
{
"value" : "0030",
"count" : "87"
},
{
"value" : "0050",
"count" : "76"
},
{
"value" : "0040",
"count" : "75"
},
{
"value" : "0070",
"count" : "62"
},
{
"value" : "0060",
"count" : "51"
},
{
"value" : "0090",
"count" : "50"
},
{
"value" : "0080",
"count" : "48"
},
{
"value" : "0100",
"count" : "42"
}
],
"count" : "-1",
"duration" : "187.58690899999965"
}
},
{
"name" : "OFFSET_BGN",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "OFFSET_BGN",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "466.0937409999997",
"sum" : "391840",
"avg" : "174.772524531668",
"count" : "2242",
"min" : "0",
"max" : "3551",
"stddev" : "518.313080862932",
"var" : "268648.449793624"
}
},
{
"name" : "SEG_END",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "SEG_END",
"sqlType" : "sqlTypeNVarchar",
"length" : "4",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "0010",
"count" : "350"
},
{
"value" : "0020",
"count" : "131"
},
{
"value" : "0030",
"count" : "108"
},
{
"value" : "0040",
"count" : "101"
},
{
"value" : "0050",
"count" : "98"
},
{
"value" : "0070",
"count" : "80"
},
{
"value" : "0060",
"count" : "71"
},
{
"value" : "0080",
"count" : "65"
},
{
"value" : "0090",
"count" : "58"
},
{
"value" : "0100",
"count" : "51"
}
],
"count" : "-1",
"duration" : "317.5463579999996"
}
},
{
"name" : "OFFSET_END",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "OFFSET_END",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "346.0385439999991",
"sum" : "1993855",
"avg" : "889.319803746655",
"count" : "2242",
"min" : "0",
"max" : "9999",
"stddev" : "1372.12593395283",
"var" : "1882729.57862593"
}
},
{
"name" : "SEG_LNGTH_",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "SEG_LNGTH_",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "368.39192600000024",
"sum" : "14761842.8",
"avg" : "6584.22961641392",
"count" : "2242",
"min" : "4",
"max" : "195832",
"stddev" : "11142.6610138668",
"var" : "124158894.469948"
}
},
{
"name" : "SEG_PT_BGN",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "SEG_PT_BGN",
"sqlType" : "sqlTypeNVarchar",
"length" : "8",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "00100000",
"count" : "664"
},
{
"value" : "00200000",
"count" : "70"
},
{
"value" : "00300000",
"count" : "67"
},
{
"value" : "00400000",
"count" : "61"
},
{
"value" : "00500000",
"count" : "57"
},
{
"value" : "00700000",
"count" : "49"
},
{
"value" : "00900000",
"count" : "40"
},
{
"value" : "00600000",
"count" : "39"
},
{
"value" : "00800000",
"count" : "36"
},
{
"value" : "01000000",
"count" : "36"
}
],
"count" : "-1",
"duration" : "399.4947570000004"
}
},
{
"name" : "SEG_PT_END",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "SEG_PT_END",
"sqlType" : "sqlTypeNVarchar",
"length" : "8",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "00400000",
"count" : "55"
},
{
"value" : "00300000",
"count" : "55"
},
{
"value" : "00200000",
"count" : "50"
},
{
"value" : "00500000",
"count" : "46"
},
{
"value" : "00700000",
"count" : "43"
},
{
"value" : "01000000",
"count" : "32"
},
{
"value" : "00900000",
"count" : "32"
},
{
"value" : "00600000",
"count" : "32"
},
{
"value" : "00800000",
"count" : "31"
},
{
"value" : "02500000",
"count" : "30"
}
],
"count" : "-1",
"duration" : "369.4723180000001"
}
},
{
"name" : "SEQ_NO",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "SEQ_NO",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "192.7063820000003",
"sum" : "10305",
"avg" : "4.59634255129349",
"count" : "2242",
"min" : "1",
"max" : "46",
"stddev" : "5.99038684038938",
"var" : "35.8847344975103"
}
},
{
"name" : "MAINT_FUNC",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "MAINT_FUNC",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "D",
"count" : "824"
},
{
"value" : "E",
"count" : "408"
},
{
"value" : "C",
"count" : "382"
},
{
"value" : " ",
"count" : "277"
},
{
"value" : "B",
"count" : "236"
},
{
"value" : "F",
"count" : "109"
},
{
"value" : "A",
"count" : "6"
}
],
"count" : "-1",
"duration" : "275.1853289999999"
}
},
{
"name" : "POST_BOND_",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "POST_BOND_",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : " ",
"count" : "1807"
},
{
"value" : "P",
"count" : "387"
},
{
"value" : "B",
"count" : "48"
}
],
"count" : "-1",
"duration" : "193.87194799999997"
}
},
{
"name" : "FED_AID_SY",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "FED_AID_SY",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "0",
"count" : "1045"
},
{
"value" : "2",
"count" : "952"
},
{
"value" : "1",
"count" : "245"
}
],
"count" : "-1",
"duration" : "406.44789499999933"
}
},
{
"name" : "FED_AID_UR",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "FED_AID_UR",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "1",
"count" : "1916"
},
{
"value" : "2",
"count" : "326"
}
],
"count" : "-1",
"duration" : "465.0319780000009"
}
},
{
"name" : "FUNC_CLS",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "FUNC_CLS",
"sqlType" : "sqlTypeNVarchar",
"length" : "2",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "09",
"count" : "569"
},
{
"value" : "07",
"count" : "391"
},
{
"value" : "08",
"count" : "369"
},
{
"value" : "06",
"count" : "303"
},
{
"value" : "02",
"count" : "203"
},
{
"value" : "16",
"count" : "98"
},
{
"value" : "17",
"count" : "93"
},
{
"value" : "19",
"count" : "73"
},
{
"value" : "01",
"count" : "53"
},
{
"value" : "14",
"count" : "36"
}
],
"count" : "-1",
"duration" : "457.19285200000013"
}
},
{
"name" : "FED_ID",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "FED_ID",
"sqlType" : "sqlTypeNVarchar",
"length" : "4",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : " ",
"count" : "1785"
},
{
"value" : "0049",
"count" : "28"
},
{
"value" : "0077",
"count" : "16"
},
{
"value" : "0111",
"count" : "12"
},
{
"value" : "0066",
"count" : "12"
},
{
"value" : "0110",
"count" : "12"
},
{
"value" : "0599",
"count" : "9"
},
{
"value" : "0043",
"count" : "7"
},
{
"value" : "0105",
"count" : "6"
},
{
"value" : "0587",
"count" : "6"
}
],
"count" : "-1",
"duration" : "299.16326599999957"
}
},
{
"name" : "FED_AID_S1",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "FED_AID_S1",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "1",
"count" : "1205"
},
{
"value" : "8",
"count" : "801"
},
{
"value" : "0",
"count" : "234"
},
{
"value" : "9",
"count" : "2"
}
],
"count" : "-1",
"duration" : "299.40969700000096"
}
},
{
"name" : "MSLINK",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "MSLINK",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "195.68754199999967",
"sum" : "175765713",
"avg" : "78396.8389830509",
"count" : "2242",
"min" : "11458",
"max" : "119964",
"stddev" : "21688.2361724232",
"var" : "470379588.270805"
}
},
{
"name" : "MAPID",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "MAPID",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "241.3857820000012",
"sum" : "0",
"avg" : "0",
"count" : "2242",
"min" : "0",
"max" : "0",
"stddev" : "0",
"var" : "0"
}
},
{
"name" : "NLF_ID",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "NLF_ID",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "185.5385839999999",
"sum" : "18745917",
"avg" : "8361.24754683319",
"count" : "2242",
"min" : "-1",
"max" : "76466",
"stddev" : "12253.5245256633",
"var" : "150148863.301031"
}
},
{
"name" : "SIDE_IND",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "SIDE_IND",
"sqlType" : "sqlTypeNVarchar",
"length" : "1",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "1",
"count" : "2203"
},
{
"value" : "2",
"count" : "39"
}
],
"count" : "-1",
"duration" : "181.52757999999994"
}
},
{
"name" : "NLF_CNTL_B",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "NLF_CNTL_B",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "278.98362199999974",
"sum" : "51671641",
"avg" : "23047.1190900981",
"count" : "2242",
"min" : "0",
"max" : "247548",
"stddev" : "39267.8153602992",
"var" : "1541961323.17055"
}
},
{
"name" : "NLF_CNTL_E",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "NLF_CNTL_E",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "196.37964400000055",
"sum" : "66432692.8",
"avg" : "29630.995896521",
"count" : "2242",
"min" : "4",
"max" : "263321",
"stddev" : "41086.5613541259",
"var" : "1688105523.90635"
}
},
{
"name" : "CUM_OFFSET",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "CUM_OFFSET",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "315.6623989999989",
"sum" : "68999099",
"avg" : "30775.6909009813",
"count" : "2242",
"min" : "0",
"max" : "272400",
"stddev" : "48105.6019203115",
"var" : "2314148936.11548"
}
},
{
"name" : "CUM_OFFSE1",
"type" : "esriFieldTypeDouble",
"actualType" : "float",
"alias" : "CUM_OFFSE1",
"sqlType" : "sqlTypeFloat",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"duration" : "213.2365690000006",
"sum" : "83760941.8",
"avg" : "37359.9205173952",
"count" : "2242",
"min" : "9",
"max" : "274573",
"stddev" : "49820.0691633024",
"var" : "2482039291.43623"
}
},
{
"name" : "RECORD_UPD",
"type" : "esriFieldTypeString",
"actualType" : "nvarchar",
"alias" : "RECORD_UPD",
"sqlType" : "sqlTypeNVarchar",
"length" : "8",
"nullable" : "true",
"editable" : "true",
"domain" : "",
"defaultValue" : "",
"statistics" : {
"values" : [
{
"value" : "20090930",
"count" : "1469"
},
{
"value" : "20111009",
"count" : "160"
},
{
"value" : "20110828",
"count" : "133"
},
{
"value" : "20140413",
"count" : "104"
},
{
"value" : "20111225",
"count" : "63"
},
{
"value" : "20120304",
"count" : "28"
},
{
"value" : "20131027",
"count" : "24"
},
{
"value" : "20130210",
"count" : "21"
},
{
"value" : "20130512",
"count" : "16"
},
{
"value" : "20141123",
"count" : "15"
}
],
"count" : "-1",
"duration" : "182.14312400000017"
}
}
],
"geometry_type" : "esriGeometryPolyline",
"id" : "e395be6080914a1996fdaeb3f9e58cc9_0",
"item_name" : "North_Central_December_2014",
"item_type" : "Feature Service",
"landing_page" : "https://www.arcgis.com/home/item.html?id=e395be6080914a1996fdaeb3f9e58cc9",
"license" : "None.",
"max_record_count" : "2000",
"name" : "Notth_Central_December_2014",
"object_id_field" : "FID",
"owner" : "jgrugan",
"record_count" : "2242",
"supported_extensions" : "",
"supports_advanced_queries" : "true",
"tags" : [
"North Central",
"PennDOT"
],
"thumbnail_url" : "https://www.arcgis.com/sharing/rest/content/items/e395be6080914a1996fdaeb3f9e58cc9/info/thumbnail/",
"title" : "North_Central_December_2014",
"type" : "Feature Service",
"updated_at" : "2014-12-08T20:22:35.000Z",
"url" : "http://services.arcgis.com/78O0yuTc8iXckoJc/arcgis/rest/services/Notth_Central_December_2014/FeatureServer/0",
"use_standardized_queries" : "false"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment