{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 11, "name": "PermitsPlus_Permits", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SiteAddress", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PID", "type": "esriFieldTypeString", "alias": "Parcel ID", "domain": null, "editable": true, "nullable": true, "length": 13, "defaultValue": null, "modelName": "PID" }, { "name": "SiteAddress", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 62, "defaultValue": null, "modelName": "SiteAddress" }, { "name": "Expr1", "type": "esriFieldTypeString", "alias": "Expr1", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "Expr1" }, { "name": "NUMBER_KEY", "type": "esriFieldTypeString", "alias": "Permit Number", "domain": null, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "NUMBER_KEY" }, { "name": "DATA_LEVEL", "type": "esriFieldTypeString", "alias": "DATA_LEVEL", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DATA_LEVEL" }, { "name": "COMP_TYPE", "type": "esriFieldTypeString", "alias": "COMP_TYPE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "COMP_TYPE" }, { "name": "VERSION", "type": "esriFieldTypeSmallInteger", "alias": "VERSION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VERSION" }, { "name": "DATA_STATUS", "type": "esriFieldTypeString", "alias": "DATA_STATUS", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATA_STATUS" }, { "name": "TYPE_TITLE", "type": "esriFieldTypeString", "alias": "Permit Type", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "TYPE_TITLE" }, { "name": "TYPE_CAT", "type": "esriFieldTypeString", "alias": "TYPE_CAT", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "TYPE_CAT" }, { "name": "TYPE_CLASS", "type": "esriFieldTypeString", "alias": "TYPE_CLASS", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TYPE_CLASS" }, { "name": "SUB_TYPE", "type": "esriFieldTypeString", "alias": "SUB_TYPE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SUB_TYPE" }, { "name": "PERC_COMP", "type": "esriFieldTypeSmallInteger", "alias": "PERC_COMP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PERC_COMP" }, { "name": "CONST_TYPE", "type": "esriFieldTypeString", "alias": "Construction Type", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "CONST_TYPE" }, { "name": "CLASS", "type": "esriFieldTypeString", "alias": "CLASS", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CLASS" }, { "name": "INSP_AREA", "type": "esriFieldTypeString", "alias": "INSP_AREA", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSP_AREA" }, { "name": "OCC", "type": "esriFieldTypeString", "alias": "OCC", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OCC" }, { "name": "USE_", "type": "esriFieldTypeString", "alias": "USE_", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "USE_" }, { "name": "HOUSE_CNT", "type": "esriFieldTypeSmallInteger", "alias": "HOUSE_CNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HOUSE_CNT" }, { "name": "BLD_CNT", "type": "esriFieldTypeSmallInteger", "alias": "BLD_CNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BLD_CNT" }, { "name": "PUB_OWN", "type": "esriFieldTypeString", "alias": "PUB_OWN", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PUB_OWN" }, { "name": "NO_STORIES", "type": "esriFieldTypeSmallInteger", "alias": "NO_STORIES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NO_STORIES" }, { "name": "ENTERED_DATE", "type": "esriFieldTypeDate", "alias": "ENTERED_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ENTERED_DATE" }, { "name": "DATE_A", "type": "esriFieldTypeDate", "alias": "Date Issued", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_A" }, { "name": "DATE_B", "type": "esriFieldTypeDate", "alias": "DATE_B", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_B" }, { "name": "DATE_C", "type": "esriFieldTypeDate", "alias": "DATE_C", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_C" }, { "name": "DATE_D", "type": "esriFieldTypeDate", "alias": "DATE_D", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_D" }, { "name": "DATE_E", "type": "esriFieldTypeDate", "alias": "DATE_E", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_E" }, { "name": "DATE_F", "type": "esriFieldTypeDate", "alias": "DATE_F", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_F" }, { "name": "DATE_L", "type": "esriFieldTypeDate", "alias": "DATE_L", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_L" }, { "name": "DATE_N", "type": "esriFieldTypeDate", "alias": "Finaled Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATE_N" }, { "name": "CALC_FEES", "type": "esriFieldTypeDouble", "alias": "CALC_FEES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CALC_FEES" }, { "name": "ADDL_FEES", "type": "esriFieldTypeDouble", "alias": "ADDL_FEES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADDL_FEES" }, { "name": "EXTRA_FEES", "type": "esriFieldTypeDouble", "alias": "EXTRA_FEES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXTRA_FEES" }, { "name": "TOT_FEE", "type": "esriFieldTypeDouble", "alias": "Total Fee", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOT_FEE" }, { "name": "VAL_TOTAL", "type": "esriFieldTypeDouble", "alias": "Valuation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VAL_TOTAL" }, { "name": "SQUARE_FT", "type": "esriFieldTypeDouble", "alias": "SQUARE_FT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SQUARE_FT" }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "LOCATION" }, { "name": "TITLE", "type": "esriFieldTypeString", "alias": "TITLE", "domain": null, "editable": true, "nullable": true, "length": 128, "defaultValue": null, "modelName": "TITLE" }, { "name": "STATUS_TABLE", "type": "esriFieldTypeString", "alias": "STATUS_TABLE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "STATUS_TABLE" }, { "name": "PRIMARY_ADDR", "type": "esriFieldTypeString", "alias": "PRIMARY_ADDR", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PRIMARY_ADDR" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "STREET_NAME" }, { "name": "STREET_DIRECTION", "type": "esriFieldTypeString", "alias": "STREET_DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "STREET_DIRECTION" }, { "name": "STREET_NO", "type": "esriFieldTypeDouble", "alias": "STREET_NO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STREET_NO" }, { "name": "ADDR_FRACTION", "type": "esriFieldTypeString", "alias": "ADDR_FRACTION", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "ADDR_FRACTION" }, { "name": "UNIT_ID", "type": "esriFieldTypeString", "alias": "UNIT_ID", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UNIT_ID" }, { "name": "Description2", "type": "esriFieldTypeString", "alias": "Work Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Description2" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Source" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R20159_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G39960NUMBER_KEY", "fields": "NUMBER_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PID", "fields": "PID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PermitsPlus_Permits", "description": "", "prototype": { "attributes": { "Source": null, "PID": null, "SiteAddress": null, "Expr1": " ", "NUMBER_KEY": " ", "DATA_LEVEL": null, "COMP_TYPE": null, "VERSION": null, "DATA_STATUS": null, "TYPE_TITLE": null, "TYPE_CAT": null, "TYPE_CLASS": null, "SUB_TYPE": null, "PERC_COMP": null, "CONST_TYPE": null, "CLASS": null, "INSP_AREA": null, "OCC": null, "USE_": null, "HOUSE_CNT": null, "BLD_CNT": null, "PUB_OWN": null, "NO_STORIES": null, "ENTERED_DATE": null, "DATE_A": null, "DATE_B": null, "DATE_C": null, "DATE_D": null, "DATE_E": null, "DATE_F": null, "DATE_L": null, "DATE_N": null, "CALC_FEES": null, "ADDL_FEES": null, "EXTRA_FEES": null, "TOT_FEE": null, "VAL_TOTAL": null, "SQUARE_FT": null, "LOCATION": null, "TITLE": null, "STATUS_TABLE": null, "PRIMARY_ADDR": null, "STREET_NAME": null, "STREET_DIRECTION": null, "STREET_NO": null, "ADDR_FRACTION": null, "UNIT_ID": null, "Description2": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "88a85d97f48c43e59bd3e5d28c0094a0" }