{ "layers": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Certificate_of_Compliance_Asset_List", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 145, 95, 30, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 5.6843418860808015E-14, "ymin": 5.6843418860808015E-14, "xmax": 5.6843418860808015E-14, "ymax": 5.6843418860808015E-14, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "firm_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "business_number", "type": "esriFieldTypeString", "alias": "Business Account Number:", "length": 255, "domain": null }, { "name": "firm_name", "type": "esriFieldTypeString", "alias": "Legal Name of Firm/Agency:", "length": 255, "domain": null }, { "name": "status_num", "type": "esriFieldTypeInteger", "alias": "status number", "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "email", "type": "esriFieldTypeString", "alias": "email", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R30_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_30", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S6_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.ComplianceAssets", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "globalid", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C7015CF6-73B2-4498-AA2E-3DF37CC9D3B2}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Compliance_Form", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 137, 57, 96, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 5.6843418860808015E-14, "ymin": 5.6843418860808015E-14, "xmax": 5.6843418860808015E-14, "ymax": 5.6843418860808015E-14, "spatialReference": { "wkid": 4326, "latestWkid": 4326, "xyTolerance": 8.983152841195215E-9, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "xyUnits": 9.999999999999999E8, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "firm_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "firm_name", "type": "esriFieldTypeString", "alias": "Legal Name of Firm/Agency:", "length": 255, "domain": null }, { "name": "firm_struct", "type": "esriFieldTypeString", "alias": "Business Structure:", "length": 255, "domain": null }, { "name": "firm_phone", "type": "esriFieldTypeString", "alias": "Phone:", "length": 255, "domain": null }, { "name": "firm_url", "type": "esriFieldTypeString", "alias": "Website:", "length": 255, "domain": null }, { "name": "phys_address", "type": "esriFieldTypeString", "alias": "Address:", "length": 255, "domain": null }, { "name": "phys_suite", "type": "esriFieldTypeString", "alias": "Suite:", "length": 255, "domain": null }, { "name": "phys_city", "type": "esriFieldTypeString", "alias": "City:", "length": 255, "domain": null }, { "name": "phys_state", "type": "esriFieldTypeString", "alias": "State:", "length": 255, "domain": null }, { "name": "phys_zip", "type": "esriFieldTypeString", "alias": "Zip:", "length": 255, "domain": null }, { "name": "same_add", "type": "esriFieldTypeString", "alias": "Is the Physical Address the same as your mailing?", "length": 255, "domain": null }, { "name": "mail_address", "type": "esriFieldTypeString", "alias": "Address:", "length": 255, "domain": null }, { "name": "mail_suite", "type": "esriFieldTypeString", "alias": "Suite:", "length": 255, "domain": null }, { "name": "mail_city", "type": "esriFieldTypeString", "alias": "City:", "length": 255, "domain": null }, { "name": "mail_state", "type": "esriFieldTypeString", "alias": "State:", "length": 255, "domain": null }, { "name": "mail_zip", "type": "esriFieldTypeString", "alias": "Zip:", "length": 255, "domain": null }, { "name": "title1", "type": "esriFieldTypeString", "alias": "Title:", "length": 255, "domain": null }, { "name": "firstname1", "type": "esriFieldTypeString", "alias": "First Name:", "length": 255, "domain": null }, { "name": "lastname1", "type": "esriFieldTypeString", "alias": "Last Name:", "length": 255, "domain": null }, { "name": "contact_phone1", "type": "esriFieldTypeString", "alias": "Phone:", "length": 255, "domain": null }, { "name": "contact_email1", "type": "esriFieldTypeString", "alias": "Email:", "length": 255, "domain": null }, { "name": "title2", "type": "esriFieldTypeString", "alias": "Alternative Contact Title:", "length": 255, "domain": null }, { "name": "firstname2", "type": "esriFieldTypeString", "alias": "Alternative Contact First Name:", "length": 255, "domain": null }, { "name": "lastname2", "type": "esriFieldTypeString", "alias": "Alternative Contact Last Name:", "length": 255, "domain": null }, { "name": "contact_phone2", "type": "esriFieldTypeString", "alias": "Alternative Contact Phone:", "length": 255, "domain": null }, { "name": "contact_email2", "type": "esriFieldTypeString", "alias": "Alternative Contact Email:", "length": 255, "domain": null }, { "name": "primary_activities", "type": "esriFieldTypeString", "alias": "Please provide a description of your firm's/agency's primary activities and services or products:", "length": 255, "domain": null }, { "name": "jackson_residency", "type": "esriFieldTypeString", "alias": "Is this firm/agency located in Jackson County:", "length": 255, "domain": null }, { "name": "jackson_taxroll", "type": "esriFieldTypeString", "alias": "Firm/agency is on Jackson County Tax Roll:", "length": 255, "domain": null }, { "name": "recent_contract", "type": "esriFieldTypeString", "alias": "Has your Firm/Agency held a contract with Jackson County within the last 3 years?", "length": 255, "domain": null }, { "name": "minority_city", "type": "esriFieldTypeString", "alias": "City of Kansas City, Missouri:", "length": 255, "domain": null }, { "name": "minority_state", "type": "esriFieldTypeString", "alias": "State of Missouri:", "length": 255, "domain": null }, { "name": "minority_other", "type": "esriFieldTypeString", "alias": "Other:", "length": 255, "domain": null }, { "name": "women_city", "type": "esriFieldTypeString", "alias": "City of Kansas City, Missouri:", "length": 255, "domain": null }, { "name": "women_state", "type": "esriFieldTypeString", "alias": "State of Missouri:", "length": 255, "domain": null }, { "name": "woment_other", "type": "esriFieldTypeString", "alias": "Other:", "length": 255, "domain": null }, { "name": "veteran_cert", "type": "esriFieldTypeString", "alias": "Veteran Business Enterprise certification:", "length": 255, "domain": null }, { "name": "veteran_authorities", "type": "esriFieldTypeString", "alias": "If yes, please list the issuing authority", "length": 255, "domain": null }, { "name": "app_type", "type": "esriFieldTypeString", "alias": "What type of application is this?", "length": 255, "domain": null }, { "name": "pending_deadline", "type": "esriFieldTypeDate", "alias": "Is there a pending deadline to have this issued by?", "length": 8, "precision": 1, "domain": null }, { "name": "true_statement1", "type": "esriFieldTypeString", "alias": "By entering your name you attest this is a true statement:", "length": 255, "domain": null }, { "name": "true_statement2", "type": "esriFieldTypeString", "alias": "By entering your name you attest this is a true statement:", "length": 255, "domain": null }, { "name": "Total_employees", "type": "esriFieldTypeString", "alias": "Total Number of Employees", "length": 255, "domain": null }, { "name": "self_identify", "type": "esriFieldTypeString", "alias": "Do you ask your employees to voluntarily self-identify in the areas of race, ethnicity, gender identity and sexual orientation?", "length": 255, "domain": null }, { "name": "minority_percent", "type": "esriFieldTypeDouble", "alias": "Minority", "domain": null }, { "name": "women_percent", "type": "esriFieldTypeDouble", "alias": "women", "domain": null }, { "name": "lgbtq_percent", "type": "esriFieldTypeDouble", "alias": "LGBTQ", "domain": null }, { "name": "veteran_percent", "type": "esriFieldTypeDouble", "alias": "Veteran", "domain": null }, { "name": "app_prep_title", "type": "esriFieldTypeString", "alias": "Application Preparer's Title:", "length": 255, "domain": null }, { "name": "app_prep_name", "type": "esriFieldTypeString", "alias": "Application Preparer's Name:", "length": 255, "domain": null }, { "name": "collections1", "type": "esriFieldTypeString", "alias": "Were taxes paid:", "length": 255, "domain": null }, { "name": "assessment1_notes", "type": "esriFieldTypeString", "alias": "Assessment Notes:", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "precision": 1, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "precision": 1, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "send_assessment", "type": "esriFieldTypeString", "alias": "Does this need to be sent to the Assessment Department?", "length": 256, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "business_number", "type": "esriFieldTypeString", "alias": "business_number", "length": 255, "domain": null }, { "name": "multiple_number", "type": "esriFieldTypeString", "alias": "multiple_number", "length": 255, "domain": null }, { "name": "status_num", "type": "esriFieldTypeString", "alias": "status_num", "length": 255, "domain": null }, { "name": "taxes_owed", "type": "esriFieldTypeDouble", "alias": "taxes_owed", "domain": null }, { "name": "account_creation", "type": "esriFieldTypeString", "alias": "account_creation", "length": 255, "domain": null }, { "name": "assets_updated", "type": "esriFieldTypeString", "alias": "assets_updated", "length": 255, "domain": null }, { "name": "multi_accounts", "type": "esriFieldTypeString", "alias": "Multiple Accounts", "length": 255, "domain": null }, { "name": "auditors_notes", "type": "esriFieldTypeString", "alias": "auditors_notes", "length": 255, "domain": null }, { "name": "auditor_reviewed", "type": "esriFieldTypeString", "alias": "auditor_reviewed", "length": 255, "domain": null }, { "name": "account_needed", "type": "esriFieldTypeString", "alias": "account_needed", "length": 255, "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R29_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_29", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S5_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [ { "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 3, "name": "ComplianceAssets", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OBJECTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "parglobal", "type": "esriFieldTypeGUID", "alias": "parglobal", "length": 38, "domain": null }, { "name": "item_name", "type": "esriFieldTypeString", "alias": "item_name", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "purchase_year", "type": "esriFieldTypeDate", "alias": "purchase_year", "length": 8, "domain": null }, { "name": "purchase_price", "type": "esriFieldTypeDouble", "alias": "purchase_price", "domain": null }, { "name": "item_loc", "type": "esriFieldTypeString", "alias": "item_loc", "length": 255, "domain": null }, { "name": "business_number1", "type": "esriFieldTypeString", "alias": "business_number1", "length": 255, "domain": null } ], "indexes": [ { "name": "R33_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_33", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "DBO.Certificate_of_Compliance_Asset_List", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "parglobal", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C7015CF6-73B2-4498-AA2E-3DF37CC9D3B2}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }