Display Name: Summary Statistics
Description: Geoprocessing tool that calculates summary statistics for field(s) in a table.
Category:
Help URL: https://maps.london.gov.uk/gla/rest/directories/arcgisoutput/Statistics_GPServer/Statistics/Statistics.htm
Execution Type: esriExecutionTypeAsynchronous
Parameters:
Parameter: in_table
Data Type: GPFeatureRecordSetLayer
Display Name Input Table
Description: The input table containing the field(s) that will be used to calculate statistics. The input can be an INFO table, a dBASE table, an OLE DB table, a VPF table, or a feature class.
Direction: esriGPParameterDirectionInput
Default Value:
Geometry Type: esriGeometryPoint
HasZ: false
HasM: false
Spatial Reference: 102100
(3857)
Fields:
-
objectid
(
type: esriFieldTypeString
, alias: objectid
, length: 1073741822
)
-
permission_id
(
type: esriFieldTypeString
, alias: permission_id
, length: 50
)
-
appref
(
type: esriFieldTypeString
, alias: appref
, length: 50
)
-
namenumber
(
type: esriFieldTypeString
, alias: namenumber
, length: 200
)
-
street
(
type: esriFieldTypeString
, alias: street
, length: 200
)
-
postcode
(
type: esriFieldTypeString
, alias: postcode
, length: 8
)
-
borough
(
type: esriFieldTypeString
, alias: borough
, length: 50
)
-
ward
(
type: esriFieldTypeString
, alias: ward
, length: 100
)
-
permissiondate
(
type: esriFieldTypeString
, alias: permissiondate
, length: 200
)
-
status
(
type: esriFieldTypeString
, alias: status
, length: 50
)
-
permtype
(
type: esriFieldTypeString
, alias: permtype
, length: 120
)
-
description
(
type: esriFieldTypeString
, alias: description
, length: 4096
)
-
easting
(
type: esriFieldTypeInteger
, alias: easting
)
-
northing
(
type: esriFieldTypeInteger
, alias: northing
)
-
proposed_res
(
type: esriFieldTypeString
, alias: proposed_res
, length: 1
)
-
proposed_nonres
(
type: esriFieldTypeString
, alias: proposed_nonres
, length: 1
)
-
mapclass
(
type: esriFieldTypeString
, alias: mapclass
, length: 2048
)
-
apptype
(
type: esriFieldTypeString
, alias: apptype
, length: 2048
)
-
lod
(
type: esriFieldTypeString
, alias: lod
, length: 200
)
-
wheelchair_acc_homes_total
(
type: esriFieldTypeInteger
, alias: wheelchair_acc_homes_total
)
-
lifetime_homes_total
(
type: esriFieldTypeInteger
, alias: lifetime_homes_total
)
-
_matched_records
(
type: esriFieldTypeString
, alias: _matched_records
, length: 200
)
-
_timestamp
(
type: esriFieldTypeString
, alias: _timestamp
, length: 8
)
-
street_2
(
type: esriFieldTypeString
, alias: street_2
, length: 100
)
-
town
(
type: esriFieldTypeString
, alias: town
, length: 50
)
-
prim_add_obj_name
(
type: esriFieldTypeString
, alias: prim_add_obj_name
, length: 100
)
-
ESRI_OID
(
type: esriFieldTypeOID
, alias: ESRI_OID
)
Features: None.
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: out_table
Data Type: GPRecordSet
Display Name Output Table
Description: The output dBASE or geodatabase table that will store the calculated statistics.
Direction: esriGPParameterDirectionOutput
Default Value:
Fields:
-
FREQUENCY
(
type: esriFieldTypeInteger
, alias: FREQUENCY
)
-
COUNT_objectid
(
type: esriFieldTypeInteger
, alias: COUNT_objectid
)
-
ObjectId
(
type: esriFieldTypeOID
, alias: ObjectId
)
Features: None.
Parameter Type: esriGPParameterTypeRequired
Category:
Parameter: case_field
Data Type: GPMultiValue:GPString
Display Name Case field
Description: The fields in the Input Table used to calculate statistics separately for each unique attribute value (or combination of attribute values when multiple fields are specified).
Direction: esriGPParameterDirectionInput
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:
Choice List: [ objectid, permission_id, appref, namenumber, street, postcode, borough, ward, permissiondate, status, permtype, description, easting, northing, proposed_res, proposed_nonres, mapclass, apptype, lod, wheelchair_acc_homes_total, lifetime_homes_total, _matched_records, _timestamp, street_2, town, prim_add_obj_name, geom, ESRI_OID ]
Supported Operations:
Submit Job