{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportedContingentValuesFormats": "JSON, PBF", "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "BPTable", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "fldtwsp": null, "fldsection": null, "flddateentered": null, "fldamenddate": null, "fldconstructioncost": null, "fld_comments": null, "estval_improv": null, "fld_setback_front": null, "flddateyear": null, "fldcamanum_1_txt": null, "fldaccessapplic": null, "fld_contractoraddy": null, "fldnonaddy": null, "fldrwd": null, "fldrwd_txt": null, "fld_issuedtoaddy": null, "agexempt": null, "fldpermitnum": null, "fld_setback_back": null, "flddatemonth": null, "fldamend": 0, "fldaddyflag": null, "fld_setback_side": null, "fld_for": null, "fldnotes": null, "fld_permitdate": null, "fldstructuretypeid": null, "fld_issuedtoname": null, "fldcamanum_1": null, "fldcamanum_2": null, "fld_contractorname": null, "fldnamelast": null, "fldtownship": null, "fld_physicaladdress": null, "fldnewrebuild": null, "fld_esn": null, "fldlegaldescription": null, "fldrange": null, "bpfees": null, "fld_physicaladdressstatus": null, "fppermit": null, "fldzoningdistrictsid": null, "fldww": null, "fldcamanum_2_txt": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.2, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": true, "name": "BPTable", "displayField": "fld_issuedtoname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "fld_permitdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "fld_permitdate", "length": 29, "alias": "fld_PermitDate", "type": "esriFieldTypeDate" }, { "modelName": "fldpermitnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldpermitnum", "alias": "fldPermitNum", "type": "esriFieldTypeInteger" }, { "modelName": "fld_issuedtoname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_issuedtoname", "length": 100, "alias": "fld_IssuedToName", "type": "esriFieldTypeString" }, { "modelName": "fld_issuedtoaddy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_issuedtoaddy", "length": 100, "alias": "fld_IssuedToAddy", "type": "esriFieldTypeString" }, { "modelName": "fld_contractorname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_contractorname", "length": 100, "alias": "fld_ContractorName", "type": "esriFieldTypeString" }, { "modelName": "fld_contractoraddy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_contractoraddy", "length": 100, "alias": "fld_ContractorAddy", "type": "esriFieldTypeString" }, { "modelName": "fld_for", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_for", "length": 2147483647, "alias": "fld_For", "type": "esriFieldTypeString" }, { "modelName": "fldlegaldescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldlegaldescription", "length": 500, "alias": "fldLegalDescription", "type": "esriFieldTypeString" }, { "modelName": "fldtwsp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldtwsp", "alias": "fldTwsp", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fldsection", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldsection", "alias": "fldSection", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fldtownship", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldtownship", "alias": "fldTownship", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fldrange", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldrange", "alias": "fldRange", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fld_setback_front", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_setback_front", "alias": "fld_setback_front", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fld_setback_side", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_setback_side", "alias": "fld_setback_Side", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fld_setback_back", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_setback_back", "alias": "fld_setback_Back", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fldrwd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldrwd", "alias": "fldRWD", "type": "esriFieldTypeInteger" }, { "modelName": "fldww", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldww", "alias": "fldWW", "type": "esriFieldTypeInteger" }, { "modelName": "fld_physicaladdressstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_physicaladdressstatus", "alias": "fld_PhysicalAddressStatus", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fld_physicaladdress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_physicaladdress", "length": 200, "alias": "fld_PhysicalAddress", "type": "esriFieldTypeString" }, { "modelName": "fldcamanum_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldcamanum_1", "alias": "fldCamaNum_1", "type": "esriFieldTypeDouble" }, { "modelName": "fldcamanum_1_txt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldcamanum_1_txt", "length": 16, "alias": "fldCamaNum_1_txt", "type": "esriFieldTypeString" }, { "modelName": "fldcamanum_2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldcamanum_2", "alias": "fldCamaNum_2", "type": "esriFieldTypeDouble" }, { "modelName": "fldcamanum_2_txt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldcamanum_2_txt", "length": 16, "alias": "fldCamaNum_2_txt", "type": "esriFieldTypeString" }, { "modelName": "fldaccessapplic", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldaccessapplic", "length": 10, "alias": "fldAccessApplic", "type": "esriFieldTypeString" }, { "modelName": "fldstructuretypeid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldstructuretypeid", "alias": "fldStructureTypeID", "type": "esriFieldTypeInteger" }, { "modelName": "fldconstructioncost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldconstructioncost", "alias": "fldConstructionCost", "type": "esriFieldTypeDouble" }, { "modelName": "fldzoningdistrictsid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldzoningdistrictsid", "alias": "fldZoningDistrictsID", "type": "esriFieldTypeInteger" }, { "modelName": "fldnewrebuild", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldnewrebuild", "alias": "fldNewRebuild", "type": "esriFieldTypeSmallInteger" }, { "modelName": "flddateentered", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "flddateentered", "length": 29, "alias": "fldDateEntered", "type": "esriFieldTypeDate" }, { "modelName": "fldAmend", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "fldamend", "alias": "fldAmend", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fldamenddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldamenddate", "length": 10, "alias": "fldAmendDate", "type": "esriFieldTypeString" }, { "modelName": "fldnonaddy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldnonaddy", "length": 255, "alias": "fldNonAddy", "type": "esriFieldTypeString" }, { "modelName": "fldaddyflag", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldaddyflag", "alias": "fldAddyFlag", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fld_comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_comments", "length": 2147483647, "alias": "fld_Comments", "type": "esriFieldTypeString" }, { "modelName": "fldnamelast", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldnamelast", "length": 50, "alias": "fldNameLast", "type": "esriFieldTypeString" }, { "modelName": "flddatemonth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flddatemonth", "length": 10, "alias": "fldDateMonth", "type": "esriFieldTypeString" }, { "modelName": "flddateyear", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "flddateyear", "length": 10, "alias": "fldDateYear", "type": "esriFieldTypeString" }, { "modelName": "fld_esn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fld_esn", "alias": "fld_ESN", "type": "esriFieldTypeInteger" }, { "modelName": "fldrwd_txt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldrwd_txt", "length": 2147483647, "alias": "fldRWD_txt", "type": "esriFieldTypeString" }, { "modelName": "fldnotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fldnotes", "length": 2147483647, "alias": "fldNotes", "type": "esriFieldTypeString" }, { "modelName": "estVal_Improv", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "estval_improv", "alias": "estVal_Improv", "type": "esriFieldTypeDouble" }, { "modelName": "BPFees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bpfees", "alias": "BPFees", "type": "esriFieldTypeDouble" }, { "modelName": "agExempt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "agexempt", "length": 50, "alias": "agExempt", "type": "esriFieldTypeString" }, { "modelName": "fppermit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fppermit", "length": 50, "alias": "fpPermit", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": false, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "supportsTruncate": true, "indexes": [ { "name": "g36fld_issuedton", "isUnique": false, "description": "", "fields": "fld_issuedtoname", "isAscending": true }, { "name": "g36fldcamanum_1", "isUnique": false, "description": "", "fields": "fldcamanum_1", "isAscending": true }, { "name": "g36fldcamanum_1_", "isUnique": false, "description": "", "fields": "fldcamanum_1_txt", "isAscending": true }, { "name": "r48_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_48", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryNumericBins": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "92a872700cac42a0b5695c620146b860", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Editing,Sync,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [] }