{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472442465}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicenseFeeWaivers", "relatedTableId": 26, "id": 16, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "CodeEnforcementCases", "relatedTableId": 18, "id": 20, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "Complaints", "relatedTableId": 24, "id": 22, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicenseEnforcements", "relatedTableId": 25, "id": 15, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "RightOfWayImprovementPermits", "relatedTableId": 8, "id": 25, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 11, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 28, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Contacts", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "isvalidated": null, "isself": null, "licensenumber": null, "iduser": null, "firstname": null, "inform": null, "idprofessionallicense": null, "alternateemail": null, "licensepin": null, "city": null, "isactive": null, "licensestate": null, "idproject": null, "projectassociationstatus": null, "modifieddate": null, "ts_from": null, "profilename": null, "streetaddress": null, "company": null, "state": null, "fax": null, "email": null, "islicenseactive": null, "zip": null, "idcreator": null, "title1": null, "dateend": null, "title2": null, "expirationdate": null, "isprimary": null, "idprofilelineage": null, "lastname": null, "datestart": null, "unit": null, "licensestatus": null, "phone": null, "companyname": null, "isremoved": null, "requirevalidation": null, "requireprofessionallicense": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Contacts", "displayField": "profilename", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "projectassociationstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectassociationstatus", "length": 2048, "alias": "projectAssociationStatus", "type": "esriFieldTypeString" }, { "modelName": "isprimary", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isprimary", "alias": "isPrimary", "type": "esriFieldTypeSmallInteger" }, { "modelName": "inform", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inform", "alias": "inForm", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "idprofilelineage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idprofilelineage", "alias": "idProfileLineage", "type": "esriFieldTypeInteger" }, { "modelName": "idprofessionallicense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idprofessionallicense", "alias": "idProfessionalLicense", "type": "esriFieldTypeInteger" }, { "modelName": "idcreator", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idcreator", "alias": "idCreator", "type": "esriFieldTypeInteger" }, { "modelName": "profilename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "profilename", "length": 128, "alias": "profileName", "type": "esriFieldTypeString" }, { "modelName": "streetaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetaddress", "length": 255, "alias": "streetAddress", "type": "esriFieldTypeString" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 64, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 8, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "modelName": "email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 128, "alias": "email", "type": "esriFieldTypeString" }, { "modelName": "phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 16, "alias": "phone", "type": "esriFieldTypeString" }, { "modelName": "fax", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fax", "length": 16, "alias": "fax", "type": "esriFieldTypeString" }, { "modelName": "datestart", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datestart", "length": 29, "alias": "dateStart", "type": "esriFieldTypeDate" }, { "modelName": "dateend", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateend", "length": 29, "alias": "dateEnd", "type": "esriFieldTypeDate" }, { "modelName": "company", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "company", "length": 128, "alias": "company", "type": "esriFieldTypeString" }, { "modelName": "isremoved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isremoved", "alias": "isRemoved", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isvalidated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isvalidated", "alias": "isValidated", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isself", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isself", "alias": "isSelf", "type": "esriFieldTypeSmallInteger" }, { "modelName": "iduser", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iduser", "alias": "idUser", "type": "esriFieldTypeInteger" }, { "modelName": "alternateemail", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alternateemail", "length": 128, "alias": "alternateEmail", "type": "esriFieldTypeString" }, { "modelName": "firstname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firstname", "length": 64, "alias": "firstName", "type": "esriFieldTypeString" }, { "modelName": "lastname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lastname", "length": 64, "alias": "lastName", "type": "esriFieldTypeString" }, { "modelName": "title1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title1", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "title2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title2", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "requireprofessionallicense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requireprofessionallicense", "alias": "requireProfessionalLicense", "type": "esriFieldTypeSmallInteger" }, { "modelName": "licensenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensenumber", "length": 128, "alias": "licenseNumber", "type": "esriFieldTypeString" }, { "modelName": "licensestate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensestate", "length": 8, "alias": "licenseState", "type": "esriFieldTypeString" }, { "modelName": "companyname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "companyname", "length": 128, "alias": "companyName", "type": "esriFieldTypeString" }, { "modelName": "licensestatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensestatus", "length": 128, "alias": "licenseStatus", "type": "esriFieldTypeString" }, { "modelName": "islicenseactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "islicenseactive", "alias": "isLicenseActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "expirationdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "expirationdate", "length": 29, "alias": "expirationDate", "type": "esriFieldTypeDate" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "licensepin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensepin", "alias": "licensePin", "type": "esriFieldTypeInteger" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "requirevalidation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requirevalidation", "alias": "requireValidation", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g928idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r398_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_398", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472445931}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "RightOfWayImprovementPermits", "relatedTableId": 8, "id": 27, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "CodeEnforcementCases", "relatedTableId": 18, "id": 19, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 8, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 12, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Fees", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "totaloverride": null, "notes": null, "isactive": null, "idproject": null, "description": null, "discountpercent": null, "title": null, "feetypetitle": null, "ts_from": null, "total": null, "balance": null, "discountamount": null, "unitpriceoverride": null, "isunit": null, "unitvariable": null, "fixedamount": null, "phase": null, "quantity": null, "accountnumber": null, "isformula": null, "matrixformula": null, "isfixed": null, "minimumvalue": null, "paid": null, "formula": null, "feeunitprice": null, "idfee": null, "ismatrix": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Fees", "displayField": "description", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idfee", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idfee", "alias": "idFee", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "total", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total", "alias": "total", "type": "esriFieldTypeDouble" }, { "modelName": "feeunitprice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feeunitprice", "alias": "feeUnitPrice", "type": "esriFieldTypeDouble" }, { "modelName": "quantity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quantity", "alias": "quantity", "type": "esriFieldTypeDouble" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 128, "alias": "notes", "type": "esriFieldTypeString" }, { "modelName": "discountamount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "discountamount", "alias": "discountAmount", "type": "esriFieldTypeDouble" }, { "modelName": "discountpercent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "discountpercent", "length": 16, "alias": "discountPercent", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "totaloverride", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "totaloverride", "alias": "totalOverride", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unitpriceoverride", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitpriceoverride", "alias": "unitPriceOverride", "type": "esriFieldTypeSmallInteger" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "minimumvalue", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "minimumvalue", "alias": "minimumValue", "type": "esriFieldTypeDouble" }, { "modelName": "fixedamount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fixedamount", "alias": "fixedAmount", "type": "esriFieldTypeDouble" }, { "modelName": "unitvariable", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitvariable", "length": 128, "alias": "unitVariable", "type": "esriFieldTypeString" }, { "modelName": "matrixformula", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "matrixformula", "length": 128, "alias": "matrixFormula", "type": "esriFieldTypeString" }, { "modelName": "formula", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "formula", "length": 2048, "alias": "formula", "type": "esriFieldTypeString" }, { "modelName": "accountnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accountnumber", "length": 32, "alias": "accountNumber", "type": "esriFieldTypeString" }, { "modelName": "isfixed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isfixed", "alias": "isFixed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isunit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isunit", "alias": "isUnit", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isformula", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isformula", "alias": "isFormula", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ismatrix", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ismatrix", "alias": "isMatrix", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "feetypetitle", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetypetitle", "length": 128, "alias": "feeTypeTitle", "type": "esriFieldTypeString" }, { "modelName": "paid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paid", "alias": "paid", "type": "esriFieldTypeDouble" }, { "modelName": "balance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "balance", "alias": "balance", "type": "esriFieldTypeDouble" }, { "modelName": "phase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phase", "length": 40, "alias": "phase", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g929idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r399_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_399", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472437923}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 10, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "CodeEnforcementCases", "relatedTableId": 18, "id": 17, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "RightOfWayImprovementPermits", "relatedTableId": 8, "id": 28, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 15, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Inspections", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "inspectioncomponent": null, "iscomplete": null, "notes": null, "idtask": null, "referenceno": null, "d_actualdateend": null, "inspectionconditions": null, "idproject": null, "description": null, "d_actualduration": null, "title": null, "istimesensitive": null, "contactname": null, "ts_from": null, "duration": null, "idinspection": null, "ispm": null, "state": null, "email": null, "isrequest": null, "comments": null, "datecompleted": null, "isam": null, "hasreview": null, "dateend": null, "datecreated": null, "inspector": null, "datestart": null, "allday": null, "phone": null, "isread": null, "idcompletedbyuser": null, "actualdatestart": null, "files": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Inspections", "displayField": "description", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idinspection", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idinspection", "alias": "idInspection", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "idtask", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idtask", "alias": "idTask", "type": "esriFieldTypeInteger" }, { "modelName": "contactname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contactname", "length": 128, "alias": "contactName", "type": "esriFieldTypeString" }, { "modelName": "email", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "email", "length": 128, "alias": "email", "type": "esriFieldTypeString" }, { "modelName": "phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 16, "alias": "phone", "type": "esriFieldTypeString" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 2048, "alias": "notes", "type": "esriFieldTypeString" }, { "modelName": "actualdatestart", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "actualdatestart", "length": 29, "alias": "actualDateStart", "type": "esriFieldTypeDate" }, { "modelName": "d_actualduration", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_actualduration", "alias": "D_actualDuration", "type": "esriFieldTypeInteger" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 128, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "d_actualdateend", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "d_actualdateend", "length": 29, "alias": "D_actualDateEnd", "type": "esriFieldTypeDate" }, { "modelName": "inspectionconditions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectionconditions", "length": 255, "alias": "inspectionConditions", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "isam", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isam", "alias": "isAM", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ispm", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ispm", "alias": "isPM", "type": "esriFieldTypeSmallInteger" }, { "modelName": "istimesensitive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "istimesensitive", "alias": "isTimeSensitive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isrequest", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isrequest", "alias": "isRequest", "type": "esriFieldTypeSmallInteger" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 255, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "datestart", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datestart", "length": 29, "alias": "dateStart", "type": "esriFieldTypeDate" }, { "modelName": "dateend", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateend", "length": 29, "alias": "dateEnd", "type": "esriFieldTypeDate" }, { "modelName": "datecompleted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecompleted", "length": 29, "alias": "dateCompleted", "type": "esriFieldTypeDate" }, { "modelName": "duration", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "duration", "alias": "duration", "type": "esriFieldTypeInteger" }, { "modelName": "idcompletedbyuser", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idcompletedbyuser", "alias": "idCompletedByUser", "type": "esriFieldTypeInteger" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 64, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "iscomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iscomplete", "alias": "isComplete", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isread", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isread", "alias": "isRead", "type": "esriFieldTypeSmallInteger" }, { "modelName": "hasreview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasreview", "alias": "hasReview", "type": "esriFieldTypeSmallInteger" }, { "modelName": "allday", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "allday", "alias": "allDay", "type": "esriFieldTypeSmallInteger" }, { "modelName": "inspector", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspector", "length": 80, "alias": "inspector", "type": "esriFieldTypeString" }, { "modelName": "files", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "files", "length": 6000, "alias": "files", "type": "esriFieldTypeString" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 14000, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "inspectioncomponent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectioncomponent", "length": 800, "alias": "inspectionComponent", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g927idinspection", "isUnique": false, "description": "", "fields": "idinspection", "isAscending": true }, { "name": "g927idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r397_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_397", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472448205}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "RightOfWayImprovementPermits", "relatedTableId": 8, "id": 24, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 6, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 27, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Issuances", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "ts_from": null, "iscomplete": null, "idconditionsetinstance": null, "datecompleted": null, "conditions_notcomplete": null, "idprojectissuance": null, "conditions_iscomplete": null, "files": null, "idproject": null, "statusname": null, "title": null, "idfolder": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Issuances", "displayField": "statusname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idprojectissuance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idprojectissuance", "alias": "idProjectIssuance", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "idfolder", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idfolder", "alias": "idFolder", "type": "esriFieldTypeInteger" }, { "modelName": "datecompleted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecompleted", "length": 29, "alias": "dateCompleted", "type": "esriFieldTypeDate" }, { "modelName": "idconditionsetinstance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idconditionsetinstance", "alias": "idConditionSetInstance", "type": "esriFieldTypeInteger" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "iscomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iscomplete", "alias": "isComplete", "type": "esriFieldTypeSmallInteger" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "statusname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statusname", "length": 128, "alias": "statusName", "type": "esriFieldTypeString" }, { "modelName": "conditions_iscomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditions_iscomplete", "length": 255, "alias": "conditions_isComplete", "type": "esriFieldTypeString" }, { "modelName": "conditions_notcomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conditions_notcomplete", "length": 255, "alias": "conditions_notComplete", "type": "esriFieldTypeString" }, { "modelName": "files", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "files", "length": 7000, "alias": "files", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g930idconditions", "isUnique": false, "description": "", "fields": "idconditionsetinstance", "isAscending": true }, { "name": "g930idfolder", "isUnique": false, "description": "", "fields": "idfolder", "isAscending": true }, { "name": "g930idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r400_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_400", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472450617}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "CodeEnforcementCases", "relatedTableId": 18, "id": 18, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 23, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Notices", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "ts_from": null, "comments": null, "idtemplateinstancedata": null, "issuedby": null, "idproject": null, "dateissued": null, "datecreated": null, "title": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Notices", "displayField": "idtemplateinstancedata", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idtemplateinstancedata", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idtemplateinstancedata", "alias": "idTemplateInstanceData", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 2048, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "dateissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateissued", "length": 29, "alias": "dateIssued", "type": "esriFieldTypeDate" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "issuedby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issuedby", "length": 100, "alias": "issuedBy", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g932idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r402_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_402", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472449979}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "RightOfWayImprovementPermits", "relatedTableId": 8, "id": 23, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 13, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 19, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Receipts", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "receivedby": null, "ispending": null, "isvoid": null, "idproject": null, "paidtoname": null, "idcashieringstation": null, "isrefund": null, "receiptnotes": null, "ts_from": null, "receivedbyid": null, "idreceipt": null, "paid": null, "paymentdescription": null, "transactiondataraw": null, "isfailed": null, "receiptnumber": null, "transactionnumber": null, "datepaid": null, "transactioninfo": null, "paymentmethod": null, "paidbyname": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Receipts", "displayField": "idreceipt", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idreceipt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idreceipt", "alias": "idReceipt", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "paid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paid", "alias": "paid", "type": "esriFieldTypeDouble" }, { "modelName": "receiptnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "receiptnumber", "length": 128, "alias": "receiptNumber", "type": "esriFieldTypeString" }, { "modelName": "paymentmethod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paymentmethod", "length": 128, "alias": "paymentMethod", "type": "esriFieldTypeString" }, { "modelName": "datepaid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datepaid", "length": 29, "alias": "datePaid", "type": "esriFieldTypeDate" }, { "modelName": "receiptnotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "receiptnotes", "length": 128, "alias": "receiptNotes", "type": "esriFieldTypeString" }, { "modelName": "paidbyname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paidbyname", "length": 128, "alias": "paidByName", "type": "esriFieldTypeString" }, { "modelName": "receivedbyid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "receivedbyid", "alias": "receivedById", "type": "esriFieldTypeInteger" }, { "modelName": "transactionnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transactionnumber", "alias": "transactionNumber", "type": "esriFieldTypeInteger" }, { "modelName": "paidtoname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paidtoname", "length": 128, "alias": "paidToName", "type": "esriFieldTypeString" }, { "modelName": "paymentdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paymentdescription", "length": 128, "alias": "paymentDescription", "type": "esriFieldTypeString" }, { "modelName": "transactioninfo", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transactioninfo", "length": 2048, "alias": "transactionInfo", "type": "esriFieldTypeString" }, { "modelName": "transactiondataraw", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "transactiondataraw", "length": 2048, "alias": "transactionDataRaw", "type": "esriFieldTypeString" }, { "modelName": "idcashieringstation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idcashieringstation", "alias": "idCashieringStation", "type": "esriFieldTypeInteger" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "isvoid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isvoid", "alias": "isVoid", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ispending", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ispending", "alias": "isPending", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isfailed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isfailed", "alias": "isFailed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isrefund", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isrefund", "alias": "isRefund", "type": "esriFieldTypeSmallInteger" }, { "modelName": "receivedby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "receivedby", "length": 60, "alias": "receivedBy", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g931idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r401_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_401", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472453550}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 12, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 20, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Reviews", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "iscomplete": null, "idreviewresult": null, "iduser": null, "idtask": null, "referenceno": null, "faultstudyarea": null, "idproject": null, "description": null, "liquefaction": null, "overpressure": null, "title": null, "isrequiredstatus": null, "idreviewtype": null, "requiresinspection": null, "floodplain": null, "isout": null, "landuseform": null, "comments": null, "datecompleted": null, "dateout": null, "hasreview": null, "idreview": null, "datecreated": null, "reviewer": null, "landslide": null, "idfolder": null, "datestart": null, "idreviewitem": null, "allday": null, "groundwaterprotectionzone": null, "isread": null, "idgroup": null, "files": null, "avalanche": null, "isaccepted": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Reviews", "displayField": "title", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idreview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idreview", "alias": "idReview", "type": "esriFieldTypeInteger" }, { "modelName": "idtask", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idtask", "alias": "idTask", "type": "esriFieldTypeInteger" }, { "modelName": "idfolder", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idfolder", "alias": "idFolder", "type": "esriFieldTypeInteger" }, { "modelName": "idreviewtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idreviewtype", "alias": "idReviewType", "type": "esriFieldTypeInteger" }, { "modelName": "dateout", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateout", "length": 29, "alias": "dateOut", "type": "esriFieldTypeDate" }, { "modelName": "idreviewresult", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idreviewresult", "alias": "idReviewResult", "type": "esriFieldTypeInteger" }, { "modelName": "idreviewitem", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idreviewitem", "alias": "idReviewItem", "type": "esriFieldTypeInteger" }, { "modelName": "isaccepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isaccepted", "alias": "isAccepted", "type": "esriFieldTypeSmallInteger" }, { "modelName": "iscomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iscomplete", "alias": "isComplete", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isout", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isout", "alias": "isOut", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isrequiredstatus", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isrequiredstatus", "alias": "isRequiredStatus", "type": "esriFieldTypeSmallInteger" }, { "modelName": "idgroup", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idgroup", "alias": "idGroup", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "iduser", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iduser", "alias": "idUser", "type": "esriFieldTypeInteger" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 255, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "datestart", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datestart", "length": 29, "alias": "dateStart", "type": "esriFieldTypeDate" }, { "modelName": "datecompleted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecompleted", "length": 29, "alias": "dateCompleted", "type": "esriFieldTypeDate" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 64, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "isread", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isread", "alias": "isRead", "type": "esriFieldTypeSmallInteger" }, { "modelName": "hasreview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasreview", "alias": "hasReview", "type": "esriFieldTypeSmallInteger" }, { "modelName": "allday", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "allday", "alias": "allDay", "type": "esriFieldTypeSmallInteger" }, { "modelName": "reviewer", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reviewer", "length": 60, "alias": "reviewer", "type": "esriFieldTypeString" }, { "modelName": "avalanche", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "avalanche", "alias": "avalanche", "type": "esriFieldTypeSmallInteger" }, { "modelName": "faultstudyarea", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "faultstudyarea", "alias": "faultStudyArea", "type": "esriFieldTypeSmallInteger" }, { "modelName": "floodplain", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "floodplain", "alias": "floodPlain", "type": "esriFieldTypeSmallInteger" }, { "modelName": "landslide", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landslide", "alias": "landslide", "type": "esriFieldTypeSmallInteger" }, { "modelName": "groundwaterprotectionzone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "groundwaterprotectionzone", "alias": "groundwaterProtectionZone", "type": "esriFieldTypeSmallInteger" }, { "modelName": "liquefaction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "liquefaction", "length": 32, "alias": "liquefaction", "type": "esriFieldTypeString" }, { "modelName": "overpressure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "overpressure", "length": 32, "alias": "overpressure", "type": "esriFieldTypeString" }, { "modelName": "requiresinspection", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requiresinspection", "alias": "requiresInspection", "type": "esriFieldTypeSmallInteger" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 2048, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "landuseform", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landuseform", "alias": "landuseform", "type": "esriFieldTypeSmallInteger" }, { "modelName": "files", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "files", "length": 4200, "alias": "files", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g933idfolder", "isUnique": false, "description": "", "fields": "idfolder", "isAscending": true }, { "name": "g933idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "g933idreview", "isUnique": false, "description": "", "fields": "idreview", "isAscending": true }, { "name": "r403_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_403", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472458268}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "RightOfWayImprovementPermits", "relatedTableId": 8, "id": 26, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BusinessLicense", "relatedTableId": 7, "id": 14, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "CodeEnforcementCases", "relatedTableId": 18, "id": 21, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 21, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Submittals", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "reviewsaccepted": null, "iscomplete": null, "iduser": null, "datecompleted": null, "hasreview": null, "idsubmittal": null, "description": null, "idproject": null, "datecreated": null, "source": null, "sequencenumber": null, "title": null, "idfolder": null, "reviewscompleted": null, "idsubmittalphase": null, "files": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Submittals", "displayField": "title", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idsubmittal", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idsubmittal", "alias": "idSubmittal", "type": "esriFieldTypeInteger" }, { "modelName": "sequencenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sequencenumber", "alias": "sequenceNumber", "type": "esriFieldTypeSmallInteger" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 64, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "iduser", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iduser", "alias": "idUser", "type": "esriFieldTypeInteger" }, { "modelName": "idfolder", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idfolder", "alias": "idFolder", "type": "esriFieldTypeInteger" }, { "modelName": "idsubmittalphase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idsubmittalphase", "alias": "idSubmittalPhase", "type": "esriFieldTypeInteger" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "datecompleted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecompleted", "length": 29, "alias": "dateCompleted", "type": "esriFieldTypeDate" }, { "modelName": "iscomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iscomplete", "alias": "isComplete", "type": "esriFieldTypeSmallInteger" }, { "modelName": "hasreview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasreview", "alias": "hasReview", "type": "esriFieldTypeSmallInteger" }, { "modelName": "reviewsaccepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reviewsaccepted", "alias": "reviewsAccepted", "type": "esriFieldTypeSmallInteger" }, { "modelName": "reviewscompleted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reviewscompleted", "alias": "reviewsCompleted", "type": "esriFieldTypeSmallInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "source", "length": 64, "alias": "source", "type": "esriFieldTypeString" }, { "modelName": "files", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "files", "length": 61000, "alias": "files", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g934idfolder", "isUnique": false, "description": "", "fields": "idfolder", "isAscending": true }, { "name": "g934idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r404_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_404", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472459804}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleDestination", "composite": false, "name": "BuildingPermits", "relatedTableId": 4, "id": 7, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 29, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Valuations", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "phase": null, "totaloverride": null, "quantity": null, "notes": null, "isformula": null, "isactive": null, "idproject": null, "description": null, "title": null, "feetypetitle": null, "ts_from": null, "total": null, "unitpriceoverride": null, "isunit": null, "formula": null, "feeunitprice": null, "unitvariable": null, "idfee": null, "fixedamount": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.5, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Valuations", "displayField": "idfee", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "idfee", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idfee", "alias": "idFee", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "total", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total", "alias": "total", "type": "esriFieldTypeDouble" }, { "modelName": "feeunitprice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feeunitprice", "alias": "feeUnitPrice", "type": "esriFieldTypeDouble" }, { "modelName": "quantity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "quantity", "alias": "quantity", "type": "esriFieldTypeDouble" }, { "modelName": "notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notes", "length": 128, "alias": "notes", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "totaloverride", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "totaloverride", "alias": "totalOverride", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unitpriceoverride", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitpriceoverride", "alias": "unitPriceOverride", "type": "esriFieldTypeSmallInteger" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "fixedamount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fixedamount", "alias": "fixedAmount", "type": "esriFieldTypeDouble" }, { "modelName": "unitvariable", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unitvariable", "length": 128, "alias": "unitVariable", "type": "esriFieldTypeString" }, { "modelName": "formula", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "formula", "length": 2048, "alias": "formula", "type": "esriFieldTypeString" }, { "modelName": "isunit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isunit", "alias": "isUnit", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isformula", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isformula", "alias": "isFormula", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "feetypetitle", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetypetitle", "length": 128, "alias": "feeTypeTitle", "type": "esriFieldTypeString" }, { "modelName": "phase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phase", "length": 40, "alias": "phase", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "g935idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r405_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_405", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsLod": false, "supportsSpatialAggregationStatistics": 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": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 7335089.367633477, "xmin": 1443735.835828632, "ymax": 7486810.214453638, "xmax": 1621222.7311822176, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472425578}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Receipts", "relatedTableId": 19, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Submittals", "relatedTableId": 21, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Fees", "relatedTableId": 12, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Inspections", "relatedTableId": 15, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Reviews", "relatedTableId": 20, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Issuances", "relatedTableId": 27, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Valuations", "relatedTableId": 29, "id": 7, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 4, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "BuildingPermits", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "licensedcontractor": null, "addr_type": null, "multiplekitchens": null, "stcoords": null, "certificateoccupancydescription": null, "idproject": null, "numfurnaces": null, "occupantload": null, "startdate": null, "match_addr": null, "score": null, "finishingsquarefeet": null, "numwatersofteners": null, "kilowatts": null, "groupdivision": null, "numwindows": null, "supplementphaseid": null, "valuationverified": null, "state": null, "applicationapprovedby": null, "apn": null, "zip": null, "firesprinklers": null, "projectname": null, "hascardfile": null, "completedissuances": null, "datecreated": null, "feetfencing": null, "notestoapplicant": null, "enddate": null, "numhumidifiers": null, "status": null, "referenceno": null, "roofingsquarefeet": null, "city": null, "d_paidfees": null, "lastsubmitted": null, "fcoz": null, "isactive": null, "isforestserviceproperty": null, "projectlength": null, "modifieddate": null, "datepermitissued": null, "siteapn": null, "match_type": null, "additionalcircuits": null, "roofsheath": null, "exteriorfinishtype": null, "affirmapplicant": null, "address": null, "ownerbuilder": null, "applicationsubmitted": null, "numstories": null, "certifyapplication": null, "dwellingunits": null, "tempmeters": null, "communitycouncil": null, "detaileddescription": null, "siteaddress": null, "hassepticsystem": null, "ts_from": null, "descriptioncomplete": null, "ispudzone": null, "reviews": null, "zone": null, "reentrystate": null, "addressverified": null, "septicandbedrooms": null, "numwaterheaters": null, "inspectionregion": null, "submittalapproved": null, "newmeters": null, "landuseauthorizationnumber": null, "idorganization": null, "totalsquarefootage": null, "numaircleaners": null, "specialconditions": null, "applicationaccepted": null, "d_wasrejected": null, "datecooissued": null, "isoveracre": null, "numacunits": null, "hasincludeddocs": null, "upgradedmeters": null, "description": null, "isclosed": null, "footprintchange": null, "numboilers": null, "title": null, "typeofconstruction": null, "d_totalpaid": null, "cooapprovedby": null, "projecttype": null, "comments": null, "d_applicant": null, "d_paiddeposits": null, "feetretwall": null, "isspecialzone": null, "rcoz": null, "expirationdate": null, "requireslandusereview": null, "reviewedundercode": null, "permitnumber": null, "autoroute": null, "occupancychange": null, "projectvaluation": null, "township": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "BuildingPermits", "allowTrueCurvesUpdates": false, "displayField": "projectname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 1, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "score", "alias": "Score", "type": "esriFieldTypeDouble" }, { "modelName": "match_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_type", "length": 2, "alias": "Match_type", "type": "esriFieldTypeString" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "addr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addr_type", "length": 20, "alias": "Addr_type", "type": "esriFieldTypeString" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "d_applicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_applicant", "length": 255, "alias": "D_applicant", "type": "esriFieldTypeString" }, { "modelName": "siteaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteaddress", "length": 255, "alias": "siteAddress", "type": "esriFieldTypeString" }, { "modelName": "siteapn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteapn", "length": 255, "alias": "siteApn", "type": "esriFieldTypeString" }, { "modelName": "projectname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectname", "length": 128, "alias": "projectName", "type": "esriFieldTypeString" }, { "modelName": "projecttype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projecttype", "length": 255, "alias": "projectType", "type": "esriFieldTypeString" }, { "modelName": "detaileddescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "detaileddescription", "length": 2048, "alias": "detailedDescription", "type": "esriFieldTypeString" }, { "modelName": "projectvaluation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectvaluation", "alias": "projectValuation", "type": "esriFieldTypeDouble" }, { "modelName": "numstories", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numstories", "alias": "numStories", "type": "esriFieldTypeInteger" }, { "modelName": "totalsquarefootage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "totalsquarefootage", "alias": "totalSquareFootage", "type": "esriFieldTypeDouble" }, { "modelName": "hassepticsystem", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hassepticsystem", "alias": "hasSepticSystem", "type": "esriFieldTypeInteger" }, { "modelName": "hasincludeddocs", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasincludeddocs", "alias": "hasIncludedDocs", "type": "esriFieldTypeInteger" }, { "modelName": "isoveracre", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isoveracre", "alias": "isOverAcre", "type": "esriFieldTypeInteger" }, { "modelName": "dwellingunits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dwellingunits", "alias": "dwellingUnits", "type": "esriFieldTypeInteger" }, { "modelName": "numwindows", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numwindows", "alias": "numWindows", "type": "esriFieldTypeInteger" }, { "modelName": "roofingsquarefeet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roofingsquarefeet", "alias": "roofingSquareFeet", "type": "esriFieldTypeDouble" }, { "modelName": "exteriorfinishtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exteriorfinishtype", "length": 255, "alias": "exteriorFinishType", "type": "esriFieldTypeString" }, { "modelName": "finishingsquarefeet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "finishingsquarefeet", "alias": "finishingSquareFeet", "type": "esriFieldTypeDouble" }, { "modelName": "newmeters", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "newmeters", "alias": "newMeters", "type": "esriFieldTypeInteger" }, { "modelName": "upgradedmeters", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upgradedmeters", "alias": "upgradedMeters", "type": "esriFieldTypeInteger" }, { "modelName": "tempmeters", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tempmeters", "alias": "tempMeters", "type": "esriFieldTypeInteger" }, { "modelName": "additionalcircuits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "additionalcircuits", "alias": "additionalCircuits", "type": "esriFieldTypeInteger" }, { "modelName": "numfurnaces", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numfurnaces", "alias": "numFurnaces", "type": "esriFieldTypeInteger" }, { "modelName": "numacunits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numacunits", "alias": "numACUnits", "type": "esriFieldTypeInteger" }, { "modelName": "numhumidifiers", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numhumidifiers", "alias": "numHumidifiers", "type": "esriFieldTypeInteger" }, { "modelName": "numaircleaners", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numaircleaners", "alias": "numAirCleaners", "type": "esriFieldTypeInteger" }, { "modelName": "numwaterheaters", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numwaterheaters", "alias": "numWaterHeaters", "type": "esriFieldTypeInteger" }, { "modelName": "numwatersofteners", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numwatersofteners", "alias": "numWaterSofteners", "type": "esriFieldTypeInteger" }, { "modelName": "numboilers", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numboilers", "alias": "numBoilers", "type": "esriFieldTypeInteger" }, { "modelName": "feetfencing", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetfencing", "alias": "feetFencing", "type": "esriFieldTypeInteger" }, { "modelName": "feetretwall", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetretwall", "alias": "feetRetWall", "type": "esriFieldTypeInteger" }, { "modelName": "kilowatts", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "kilowatts", "alias": "kilowatts", "type": "esriFieldTypeDouble" }, { "modelName": "footprintchange", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "footprintchange", "alias": "footprintChange", "type": "esriFieldTypeInteger" }, { "modelName": "septicandbedrooms", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "septicandbedrooms", "alias": "septicAndBedrooms", "type": "esriFieldTypeInteger" }, { "modelName": "multiplekitchens", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multiplekitchens", "alias": "multipleKitchens", "type": "esriFieldTypeInteger" }, { "modelName": "occupancychange", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupancychange", "alias": "occupancyChange", "type": "esriFieldTypeInteger" }, { "modelName": "roofsheath", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "roofsheath", "alias": "roofSheath", "type": "esriFieldTypeInteger" }, { "modelName": "licensedcontractor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensedcontractor", "alias": "licensedContractor", "type": "esriFieldTypeInteger" }, { "modelName": "ownerbuilder", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerbuilder", "alias": "ownerBuilder", "type": "esriFieldTypeInteger" }, { "modelName": "affirmapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "affirmapplicant", "alias": "affirmApplicant", "type": "esriFieldTypeInteger" }, { "modelName": "certifyapplication", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "certifyapplication", "alias": "certifyApplication", "type": "esriFieldTypeInteger" }, { "modelName": "notestoapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notestoapplicant", "length": 2048, "alias": "notesToApplicant", "type": "esriFieldTypeString" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 2048, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "reviews", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reviews", "alias": "reviews", "type": "esriFieldTypeInteger" }, { "modelName": "d_paiddeposits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_paiddeposits", "alias": "D_paidDeposits", "type": "esriFieldTypeInteger" }, { "modelName": "d_paidfees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_paidfees", "alias": "D_paidFees", "type": "esriFieldTypeInteger" }, { "modelName": "d_wasrejected", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_wasrejected", "alias": "D_wasRejected", "type": "esriFieldTypeInteger" }, { "modelName": "completedissuances", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completedissuances", "alias": "completedIssuances", "type": "esriFieldTypeInteger" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "applicationsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationsubmitted", "length": 29, "alias": "applicationSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "applicationaccepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationaccepted", "length": 29, "alias": "applicationAccepted", "type": "esriFieldTypeDate" }, { "modelName": "lastsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastsubmitted", "length": 29, "alias": "lastSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "submittalapproved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "submittalapproved", "length": 29, "alias": "submittalApproved", "type": "esriFieldTypeDate" }, { "modelName": "datepermitissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datepermitissued", "length": 29, "alias": "datePermitIssued", "type": "esriFieldTypeDate" }, { "modelName": "datecooissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecooissued", "length": 29, "alias": "dateCoOIssued", "type": "esriFieldTypeDate" }, { "modelName": "permitnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitnumber", "length": 128, "alias": "permitNumber", "type": "esriFieldTypeString" }, { "modelName": "applicationapprovedby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationapprovedby", "length": 128, "alias": "applicationApprovedBy", "type": "esriFieldTypeString" }, { "modelName": "stcoords", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stcoords", "length": 128, "alias": "stCoords", "type": "esriFieldTypeString" }, { "modelName": "projectlength", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "projectlength", "length": 128, "alias": "projectLength", "type": "esriFieldTypeString" }, { "modelName": "hascardfile", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hascardfile", "alias": "hasCardFile", "type": "esriFieldTypeInteger" }, { "modelName": "addressverified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addressverified", "alias": "addressVerified", "type": "esriFieldTypeInteger" }, { "modelName": "descriptioncomplete", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "descriptioncomplete", "alias": "descriptionComplete", "type": "esriFieldTypeInteger" }, { "modelName": "valuationverified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "valuationverified", "alias": "valuationVerified", "type": "esriFieldTypeInteger" }, { "modelName": "isspecialzone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isspecialzone", "alias": "isSpecialZone", "type": "esriFieldTypeInteger" }, { "modelName": "ispudzone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ispudzone", "alias": "isPUDZone", "type": "esriFieldTypeInteger" }, { "modelName": "rcoz", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rcoz", "length": 128, "alias": "RCOZ", "type": "esriFieldTypeString" }, { "modelName": "fcoz", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fcoz", "length": 128, "alias": "FCOZ", "type": "esriFieldTypeString" }, { "modelName": "isforestserviceproperty", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isforestserviceproperty", "alias": "isForestServiceProperty", "type": "esriFieldTypeInteger" }, { "modelName": "requireslandusereview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requireslandusereview", "alias": "requiresLandUseReview", "type": "esriFieldTypeInteger" }, { "modelName": "inspectionregion", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectionregion", "length": 128, "alias": "inspectionRegion", "type": "esriFieldTypeString" }, { "modelName": "zone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zone", "length": 128, "alias": "zone", "type": "esriFieldTypeString" }, { "modelName": "communitycouncil", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "communitycouncil", "length": 128, "alias": "communityCouncil", "type": "esriFieldTypeString" }, { "modelName": "township", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "township", "length": 128, "alias": "township", "type": "esriFieldTypeString" }, { "modelName": "autoroute", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "autoroute", "alias": "autoRoute", "type": "esriFieldTypeInteger" }, { "modelName": "landuseauthorizationnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landuseauthorizationnumber", "length": 128, "alias": "landUseAuthorizationNumber", "type": "esriFieldTypeString" }, { "modelName": "cooapprovedby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cooapprovedby", "length": 128, "alias": "CoOApprovedBy", "type": "esriFieldTypeString" }, { "modelName": "groupdivision", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "groupdivision", "length": 128, "alias": "groupDivision", "type": "esriFieldTypeString" }, { "modelName": "occupantload", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupantload", "length": 128, "alias": "occupantLoad", "type": "esriFieldTypeString" }, { "modelName": "firesprinklers", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "firesprinklers", "alias": "fireSprinklers", "type": "esriFieldTypeInteger" }, { "modelName": "typeofconstruction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "typeofconstruction", "length": 2048, "alias": "typeOfConstruction", "type": "esriFieldTypeString" }, { "modelName": "specialconditions", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "specialconditions", "length": 2048, "alias": "specialConditions", "type": "esriFieldTypeString" }, { "modelName": "d_totalpaid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_totalpaid", "length": 2048, "alias": "D_totalPaid", "type": "esriFieldTypeString" }, { "modelName": "supplementphaseid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "supplementphaseid", "alias": "supplementPhaseId", "type": "esriFieldTypeInteger" }, { "modelName": "reviewedundercode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reviewedundercode", "length": 64, "alias": "reviewedUnderCode", "type": "esriFieldTypeString" }, { "modelName": "certificateoccupancydescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "certificateoccupancydescription", "length": 255, "alias": "certificateOccupancyDescription", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 64, "alias": "apn", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 64, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "idorganization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idorganization", "alias": "idOrganization", "type": "esriFieldTypeInteger" }, { "modelName": "expirationdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "expirationdate", "length": 29, "alias": "expirationDate", "type": "esriFieldTypeDate" }, { "modelName": "reentrystate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reentrystate", "length": 64, "alias": "reentryState", "type": "esriFieldTypeString" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isclosed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isclosed", "alias": "isClosed", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g920idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r390_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_390", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a189_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 170, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7335488.083371475, "xmin": 1443743.8358126432, "ymax": 7475495.726583973, "xmax": 1618162.4676177204, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472428692}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Fees", "relatedTableId": 12, "id": 8, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Issuances", "relatedTableId": 27, "id": 9, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Inspections", "relatedTableId": 15, "id": 10, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 11, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Reviews", "relatedTableId": 20, "id": 12, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Receipts", "relatedTableId": 19, "id": 13, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Submittals", "relatedTableId": 21, "id": 14, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 7, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "BusinessLicense", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "businessemail": null, "datelicenseissued": null, "idproject": null, "startdate": null, "landuseapprovalzone": null, "score": null, "convictedabuse": null, "issolicitor": null, "businessorganizationtype": null, "usestatusverificationsystem": null, "chargedabuse": null, "supplementphaseid": null, "beerserved": null, "dategrantedextension": null, "state": null, "apn": null, "idlicensepredecessor": null, "isgunammoexplosives": null, "dopllicenseholderdob": null, "chargedassault": null, "corporateaddress": null, "datecreated": null, "skipreviews": null, "solicitorotherphone": null, "enoughparking": null, "eventlength": null, "disturbneighborhood": null, "isnonprofit": null, "liquor": null, "seekingexemption": null, "siteapn": null, "sendrenewalto": null, "beeroffpremises": null, "isfoodestablishment": null, "isrenewal": null, "processeswaste": null, "match_type": null, "businessfax": null, "violentconduct": null, "address": null, "isoutcallservice": null, "corporationemail": null, "responsibleparty": null, "certifyapplication": null, "issexorientedbusiness": null, "occupancyverifiedby": null, "communitycouncil": null, "certifyclose": null, "isalarmbusiness": null, "identificationnumber": null, "occupancyclassification": null, "isexpedited": null, "isleasedspace": null, "numemployeesfamily": null, "ts_from": null, "foodserved": null, "businessweb": null, "businessdescription": null, "identificationexplanation": null, "formernames": null, "solicitorhaircolor": null, "selltobacco": null, "naicstitle": null, "dateofbirth": null, "requesteduse": null, "submittalapproved": null, "idorganization": null, "arrestwarrant": null, "isreiki": null, "applicationaccepted": null, "convictedwithintenyears": null, "idlicensesuccessor": null, "isgrocerystore": null, "dateactivityceases": null, "description": null, "isclosed": null, "title": null, "solicitorheight": null, "requesttype": null, "eventzip": null, "datelicenseexpiration": null, "numchildrenmax": null, "convictedassault": null, "ispublicswimspa": null, "d_paiddeposits": null, "naicsyear": null, "ismedicaldentaloffice": null, "mailingaddress": null, "eventweb": null, "applicationacceptedby": null, "dateeventstart": null, "currentowneraddress": null, "eventlicensetype": null, "closecommentsapplicant": null, "identificationtype": null, "sellsproduct": null, "isfireworksold": null, "businessaddress": null, "township": null, "addr_type": null, "isinternetbar": null, "match_addr": null, "streetover80ftwide": null, "ishomedaycare": null, "paroleprobation": null, "occupancyverified": null, "ishazmat": null, "solicitorweight": null, "solicitormailaddress": null, "alcohollicensetype": null, "zip": null, "salestaxnumber": null, "licensetype": null, "completedissuances": null, "primarilyresidence": null, "identificationcountry": null, "certifytobacco": null, "appointmentonly": null, "notestoapplicant": null, "enddate": null, "numunits": null, "dabclicenseholderdob": null, "applicationtype": null, "status": null, "islargescaleevent": null, "bakingcookingprepfoodinhome": null, "referenceno": null, "city": null, "d_paidfees": null, "lastsubmitted": null, "isactive": null, "dateeventend": null, "chargedhomicide": null, "moralturptitude": null, "modifieddate": null, "bankruptcy": null, "attendancenum": null, "identificationstate": null, "occupancyverifieddate": null, "ispawnshop": null, "providesinternetaccess": null, "hasdoorcharge": null, "istattoobusiness": null, "majorinterioralteration": null, "applicationsubmitted": null, "nonresidentemployee": null, "requireoutsidestorage": null, "naicscode": null, "chargedsubstances": null, "ismassage": null, "iswastehaulers": null, "nameplatesign": null, "subjecttoprotectiveorder": null, "isdrycarpetclean": null, "landuseapprovaluse": null, "closecommentsoffice": null, "licensenumber": null, "alcoholsale": null, "verifyoccupancy": null, "exceedspacelimitations": null, "convictedsubstances": null, "employsnonbusinessowner": null, "corporationname": null, "solicitornoticesaddress": null, "incarceratedwithinfiveyears": null, "corporationcell": null, "pin": null, "licenseaction": null, "zone": null, "nolargevehicles": null, "isautobodyrepair": null, "alcoholserved": null, "convictedhomicide": null, "unit": null, "wineserved": null, "fraud": null, "isschool": null, "remodelhome": null, "exemptionexplanation": null, "businessname": null, "d_wasrejected": null, "eventemail": null, "isevent": null, "employeridentificationnumber": null, "d_totalpaid": null, "corporationofficer3": null, "corporationofficer2": null, "corporationofficer4": null, "isbodyartsalon": null, "businessphone": null, "corporationofficer1": null, "requiremechanicalelectricalequi": null, "licenseofficialnotes": null, "isrestaurantordeli": null, "eventlocation": null, "comments": null, "tobaccousenum": null, "numemployees": null, "currentphone": null, "corporationphone": null, "solicitoreyecolor": null, "civicenterpriserecommendation": null, "primaryresidence": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "BusinessLicense", "allowTrueCurvesUpdates": false, "displayField": "businessname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 1, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "score", "alias": "Score", "type": "esriFieldTypeDouble" }, { "modelName": "match_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_type", "length": 2, "alias": "Match_type", "type": "esriFieldTypeString" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "addr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addr_type", "length": 20, "alias": "Addr_type", "type": "esriFieldTypeString" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "licenseaction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licenseaction", "length": 64, "alias": "licenseAction", "type": "esriFieldTypeString" }, { "modelName": "applicationtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationtype", "alias": "applicationType", "type": "esriFieldTypeInteger" }, { "modelName": "isrenewal", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isrenewal", "alias": "isRenewal", "type": "esriFieldTypeSmallInteger" }, { "modelName": "communitycouncil", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "communitycouncil", "length": 128, "alias": "communityCouncil", "type": "esriFieldTypeString" }, { "modelName": "siteapn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "siteapn", "length": 128, "alias": "siteApn", "type": "esriFieldTypeString" }, { "modelName": "zone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zone", "length": 128, "alias": "zone", "type": "esriFieldTypeString" }, { "modelName": "applicationacceptedby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationacceptedby", "length": 128, "alias": "applicationAcceptedBy", "type": "esriFieldTypeString" }, { "modelName": "requesttype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requesttype", "alias": "requestType", "type": "esriFieldTypeInteger" }, { "modelName": "businessname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessname", "length": 255, "alias": "businessName", "type": "esriFieldTypeString" }, { "modelName": "businessweb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessweb", "length": 255, "alias": "businessWeb", "type": "esriFieldTypeString" }, { "modelName": "businessemail", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessemail", "length": 128, "alias": "businessEmail", "type": "esriFieldTypeString" }, { "modelName": "businessphone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessphone", "length": 16, "alias": "businessPhone", "type": "esriFieldTypeString" }, { "modelName": "businessfax", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessfax", "length": 16, "alias": "businessFax", "type": "esriFieldTypeString" }, { "modelName": "numemployees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numemployees", "alias": "numEmployees", "type": "esriFieldTypeInteger" }, { "modelName": "businessdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessdescription", "length": 2048, "alias": "businessDescription", "type": "esriFieldTypeString" }, { "modelName": "usestatusverificationsystem", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "usestatusverificationsystem", "alias": "useStatusVerificationSystem", "type": "esriFieldTypeSmallInteger" }, { "modelName": "corporationname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationname", "length": 255, "alias": "corporationName", "type": "esriFieldTypeString" }, { "modelName": "corporationofficer1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationofficer1", "length": 255, "alias": "corporationOfficer1", "type": "esriFieldTypeString" }, { "modelName": "corporationofficer2", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationofficer2", "length": 255, "alias": "corporationOfficer2", "type": "esriFieldTypeString" }, { "modelName": "corporationofficer3", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationofficer3", "length": 255, "alias": "corporationOfficer3", "type": "esriFieldTypeString" }, { "modelName": "corporationofficer4", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationofficer4", "length": 255, "alias": "corporationOfficer4", "type": "esriFieldTypeString" }, { "modelName": "corporateaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporateaddress", "length": 512, "alias": "corporateAddress", "type": "esriFieldTypeString" }, { "modelName": "corporationphone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationphone", "length": 16, "alias": "corporationPhone", "type": "esriFieldTypeString" }, { "modelName": "corporationcell", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationcell", "length": 16, "alias": "corporationCell", "type": "esriFieldTypeString" }, { "modelName": "corporationemail", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "corporationemail", "length": 128, "alias": "corporationEmail", "type": "esriFieldTypeString" }, { "modelName": "dabclicenseholderdob", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dabclicenseholderdob", "length": 29, "alias": "DABCLicenseHolderDOB", "type": "esriFieldTypeDate" }, { "modelName": "dopllicenseholderdob", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dopllicenseholderdob", "length": 29, "alias": "DOPLLicenseHolderDOB", "type": "esriFieldTypeDate" }, { "modelName": "tobaccousenum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tobaccousenum", "length": 32, "alias": "tobaccoUseNum", "type": "esriFieldTypeString" }, { "modelName": "sendrenewalto", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sendrenewalto", "length": 128, "alias": "sendRenewalTo", "type": "esriFieldTypeString" }, { "modelName": "certifyapplication", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "certifyapplication", "alias": "certifyApplication", "type": "esriFieldTypeSmallInteger" }, { "modelName": "salestaxnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "salestaxnumber", "length": 128, "alias": "salesTaxNumber", "type": "esriFieldTypeString" }, { "modelName": "employeridentificationnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "employeridentificationnumber", "length": 128, "alias": "employerIdentificationNumber", "type": "esriFieldTypeString" }, { "modelName": "occupancyclassification", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupancyclassification", "length": 255, "alias": "occupancyClassification", "type": "esriFieldTypeString" }, { "modelName": "isalarmbusiness", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isalarmbusiness", "alias": "isAlarmBusiness", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isautobodyrepair", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isautobodyrepair", "alias": "isAutoBodyRepair", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isbodyartsalon", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isbodyartsalon", "alias": "isBodyArtSalon", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ismedicaldentaloffice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ismedicaldentaloffice", "alias": "isMedicalDentalOffice", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isdrycarpetclean", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isdrycarpetclean", "alias": "isDryCarpetClean", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isfireworksold", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isfireworksold", "alias": "isFireworkSold", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isfoodestablishment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isfoodestablishment", "alias": "isFoodEstablishment", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isgrocerystore", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isgrocerystore", "alias": "isGroceryStore", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isgunammoexplosives", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isgunammoexplosives", "alias": "isGunAmmoExplosives", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ishazmat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ishazmat", "alias": "isHazMat", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isinternetbar", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isinternetbar", "alias": "isInternetBar", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ismassage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ismassage", "alias": "isMassage", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isoutcallservice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isoutcallservice", "alias": "isOutCallService", "type": "esriFieldTypeSmallInteger" }, { "modelName": "providesinternetaccess", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "providesinternetaccess", "alias": "providesInternetAccess", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ispublicswimspa", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ispublicswimspa", "alias": "isPublicSwimSpa", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isreiki", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isreiki", "alias": "isReiki", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isschool", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isschool", "alias": "isSchool", "type": "esriFieldTypeSmallInteger" }, { "modelName": "issexorientedbusiness", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issexorientedbusiness", "alias": "isSexOrientedBusiness", "type": "esriFieldTypeSmallInteger" }, { "modelName": "istattoobusiness", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "istattoobusiness", "alias": "isTattooBusiness", "type": "esriFieldTypeSmallInteger" }, { "modelName": "selltobacco", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "selltobacco", "alias": "sellTobacco", "type": "esriFieldTypeSmallInteger" }, { "modelName": "iswastehaulers", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iswastehaulers", "alias": "isWasteHaulers", "type": "esriFieldTypeSmallInteger" }, { "modelName": "employsnonbusinessowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "employsnonbusinessowner", "alias": "employsNonBusinessOwner", "type": "esriFieldTypeSmallInteger" }, { "modelName": "processeswaste", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "processeswaste", "alias": "processesWaste", "type": "esriFieldTypeSmallInteger" }, { "modelName": "bakingcookingprepfoodinhome", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bakingcookingprepfoodinhome", "alias": "bakingCookingPrepFoodinHome", "type": "esriFieldTypeSmallInteger" }, { "modelName": "liquor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "liquor", "alias": "liquor", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ishomedaycare", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ishomedaycare", "alias": "isHomeDayCare", "type": "esriFieldTypeSmallInteger" }, { "modelName": "requesteduse", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requesteduse", "length": 255, "alias": "requestedUse", "type": "esriFieldTypeString" }, { "modelName": "numemployeesfamily", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numemployeesfamily", "alias": "numEmployeesFamily", "type": "esriFieldTypeInteger" }, { "modelName": "primarilyresidence", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primarilyresidence", "alias": "primarilyResidence", "type": "esriFieldTypeSmallInteger" }, { "modelName": "primaryresidence", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "primaryresidence", "alias": "primaryResidence", "type": "esriFieldTypeSmallInteger" }, { "modelName": "nonresidentemployee", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nonresidentemployee", "alias": "nonResidentEmployee", "type": "esriFieldTypeSmallInteger" }, { "modelName": "streetover80ftwide", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetover80ftwide", "alias": "streetOver80FtWide", "type": "esriFieldTypeSmallInteger" }, { "modelName": "appointmentonly", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appointmentonly", "alias": "appointmentOnly", "type": "esriFieldTypeSmallInteger" }, { "modelName": "remodelhome", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "remodelhome", "alias": "remodelHome", "type": "esriFieldTypeSmallInteger" }, { "modelName": "majorinterioralteration", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "majorinterioralteration", "alias": "majorInteriorAlteration", "type": "esriFieldTypeSmallInteger" }, { "modelName": "exceedspacelimitations", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exceedspacelimitations", "alias": "exceedSpaceLimitations", "type": "esriFieldTypeSmallInteger" }, { "modelName": "requireoutsidestorage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requireoutsidestorage", "alias": "requireOutsideStorage", "type": "esriFieldTypeSmallInteger" }, { "modelName": "disturbneighborhood", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "disturbneighborhood", "alias": "disturbNeighborhood", "type": "esriFieldTypeSmallInteger" }, { "modelName": "enoughparking", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enoughparking", "alias": "enoughParking", "type": "esriFieldTypeSmallInteger" }, { "modelName": "nameplatesign", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nameplatesign", "alias": "nameplateSign", "type": "esriFieldTypeSmallInteger" }, { "modelName": "nolargevehicles", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "nolargevehicles", "alias": "noLargeVehicles", "type": "esriFieldTypeSmallInteger" }, { "modelName": "eventlength", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventlength", "alias": "eventLength", "type": "esriFieldTypeDouble" }, { "modelName": "dateeventstart", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateeventstart", "length": 29, "alias": "dateEventStart", "type": "esriFieldTypeDate" }, { "modelName": "dateeventend", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateeventend", "length": 29, "alias": "dateEventEnd", "type": "esriFieldTypeDate" }, { "modelName": "eventlocation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventlocation", "length": 255, "alias": "eventLocation", "type": "esriFieldTypeString" }, { "modelName": "eventzip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventzip", "length": 64, "alias": "eventZip", "type": "esriFieldTypeString" }, { "modelName": "eventweb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventweb", "length": 255, "alias": "eventWeb", "type": "esriFieldTypeString" }, { "modelName": "eventemail", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventemail", "length": 128, "alias": "eventEmail", "type": "esriFieldTypeString" }, { "modelName": "alcoholsale", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alcoholsale", "alias": "alcoholSale", "type": "esriFieldTypeSmallInteger" }, { "modelName": "alcoholserved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alcoholserved", "alias": "alcoholServed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "beerserved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "beerserved", "alias": "beerServed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "wineserved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wineserved", "alias": "wineServed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "hasdoorcharge", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasdoorcharge", "alias": "hasDoorCharge", "type": "esriFieldTypeSmallInteger" }, { "modelName": "attendancenum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "attendancenum", "alias": "attendanceNum", "type": "esriFieldTypeInteger" }, { "modelName": "foodserved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "foodserved", "alias": "foodServed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "landuseapprovaluse", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landuseapprovaluse", "length": 128, "alias": "landUseApprovalUse", "type": "esriFieldTypeString" }, { "modelName": "landuseapprovalzone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "landuseapprovalzone", "length": 128, "alias": "landUseApprovalZone", "type": "esriFieldTypeString" }, { "modelName": "formernames", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "formernames", "length": 255, "alias": "formerNames", "type": "esriFieldTypeString" }, { "modelName": "dateofbirth", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateofbirth", "length": 29, "alias": "dateOfBirth", "type": "esriFieldTypeDate" }, { "modelName": "identificationnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "identificationnumber", "length": 128, "alias": "identificationNumber", "type": "esriFieldTypeString" }, { "modelName": "identificationstate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "identificationstate", "length": 128, "alias": "identificationState", "type": "esriFieldTypeString" }, { "modelName": "solicitormailaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitormailaddress", "length": 512, "alias": "solicitorMailAddress", "type": "esriFieldTypeString" }, { "modelName": "responsibleparty", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "responsibleparty", "length": 255, "alias": "responsibleParty", "type": "esriFieldTypeString" }, { "modelName": "solicitorotherphone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitorotherphone", "length": 16, "alias": "solicitorOtherPhone", "type": "esriFieldTypeString" }, { "modelName": "solicitornoticesaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitornoticesaddress", "length": 512, "alias": "solicitorNoticesAddress", "type": "esriFieldTypeString" }, { "modelName": "convictedhomicide", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convictedhomicide", "alias": "convictedHomicide", "type": "esriFieldTypeSmallInteger" }, { "modelName": "convictedabuse", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convictedabuse", "alias": "convictedAbuse", "type": "esriFieldTypeSmallInteger" }, { "modelName": "convictedsubstances", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convictedsubstances", "alias": "convictedSubstances", "type": "esriFieldTypeSmallInteger" }, { "modelName": "convictedassault", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convictedassault", "alias": "convictedAssault", "type": "esriFieldTypeSmallInteger" }, { "modelName": "chargedhomicide", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chargedhomicide", "alias": "chargedHomicide", "type": "esriFieldTypeSmallInteger" }, { "modelName": "chargedabuse", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chargedabuse", "alias": "chargedAbuse", "type": "esriFieldTypeSmallInteger" }, { "modelName": "chargedsubstances", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chargedsubstances", "alias": "chargedSubstances", "type": "esriFieldTypeSmallInteger" }, { "modelName": "chargedassault", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "chargedassault", "alias": "chargedAssault", "type": "esriFieldTypeSmallInteger" }, { "modelName": "convictedwithintenyears", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "convictedwithintenyears", "alias": "convictedWithinTenYears", "type": "esriFieldTypeSmallInteger" }, { "modelName": "incarceratedwithinfiveyears", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "incarceratedwithinfiveyears", "alias": "incarceratedWithinFiveYears", "type": "esriFieldTypeSmallInteger" }, { "modelName": "moralturptitude", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "moralturptitude", "alias": "moralTurptitude", "type": "esriFieldTypeSmallInteger" }, { "modelName": "violentconduct", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "violentconduct", "alias": "violentConduct", "type": "esriFieldTypeSmallInteger" }, { "modelName": "subjecttoprotectiveorder", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subjecttoprotectiveorder", "alias": "subjectToProtectiveOrder", "type": "esriFieldTypeSmallInteger" }, { "modelName": "fraud", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fraud", "alias": "fraud", "type": "esriFieldTypeSmallInteger" }, { "modelName": "bankruptcy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bankruptcy", "alias": "bankruptcy", "type": "esriFieldTypeSmallInteger" }, { "modelName": "paroleprobation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "paroleprobation", "alias": "paroleProbation", "type": "esriFieldTypeSmallInteger" }, { "modelName": "arrestwarrant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "arrestwarrant", "alias": "arrestWarrant", "type": "esriFieldTypeSmallInteger" }, { "modelName": "solicitorheight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitorheight", "length": 128, "alias": "solicitorHeight", "type": "esriFieldTypeString" }, { "modelName": "solicitorweight", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitorweight", "length": 128, "alias": "solicitorWeight", "type": "esriFieldTypeString" }, { "modelName": "solicitorhaircolor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitorhaircolor", "length": 128, "alias": "solicitorHairColor", "type": "esriFieldTypeString" }, { "modelName": "solicitoreyecolor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "solicitoreyecolor", "length": 128, "alias": "solicitorEyeColor", "type": "esriFieldTypeString" }, { "modelName": "notestoapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notestoapplicant", "length": 2048, "alias": "notesToApplicant", "type": "esriFieldTypeString" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 2048, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "d_paiddeposits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_paiddeposits", "alias": "D_paidDeposits", "type": "esriFieldTypeSmallInteger" }, { "modelName": "d_paidfees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_paidfees", "alias": "D_paidFees", "type": "esriFieldTypeSmallInteger" }, { "modelName": "d_wasrejected", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_wasrejected", "alias": "D_wasRejected", "type": "esriFieldTypeSmallInteger" }, { "modelName": "completedissuances", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completedissuances", "alias": "completedIssuances", "type": "esriFieldTypeSmallInteger" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "applicationsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationsubmitted", "length": 29, "alias": "applicationSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "applicationaccepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationaccepted", "length": 29, "alias": "applicationAccepted", "type": "esriFieldTypeDate" }, { "modelName": "lastsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastsubmitted", "length": 29, "alias": "lastSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "submittalapproved", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "submittalapproved", "length": 29, "alias": "submittalApproved", "type": "esriFieldTypeDate" }, { "modelName": "datelicenseissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datelicenseissued", "length": 29, "alias": "dateLicenseIssued", "type": "esriFieldTypeDate" }, { "modelName": "licensenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensenumber", "length": 128, "alias": "licenseNumber", "type": "esriFieldTypeString" }, { "modelName": "d_totalpaid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_totalpaid", "length": 2048, "alias": "D_totalPaid", "type": "esriFieldTypeString" }, { "modelName": "occupancyverifiedby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupancyverifiedby", "length": 255, "alias": "occupancyVerifiedBy", "type": "esriFieldTypeString" }, { "modelName": "occupancyverifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "occupancyverifieddate", "length": 29, "alias": "occupancyVerifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "verifyoccupancy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "verifyoccupancy", "alias": "verifyOccupancy", "type": "esriFieldTypeSmallInteger" }, { "modelName": "occupancyverified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupancyverified", "alias": "occupancyVerified", "type": "esriFieldTypeSmallInteger" }, { "modelName": "licensetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensetype", "alias": "licenseType", "type": "esriFieldTypeInteger" }, { "modelName": "alcohollicensetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alcohollicensetype", "alias": "alcoholLicenseType", "type": "esriFieldTypeInteger" }, { "modelName": "eventlicensetype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "eventlicensetype", "alias": "eventLicenseType", "type": "esriFieldTypeInteger" }, { "modelName": "isexpedited", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isexpedited", "alias": "isExpedited", "type": "esriFieldTypeSmallInteger" }, { "modelName": "certifytobacco", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "certifytobacco", "alias": "certifyTobacco", "type": "esriFieldTypeSmallInteger" }, { "modelName": "pin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pin", "length": 8, "alias": "pin", "type": "esriFieldTypeString" }, { "modelName": "certifyclose", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "certifyclose", "alias": "certifyClose", "type": "esriFieldTypeSmallInteger" }, { "modelName": "currentowneraddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "currentowneraddress", "length": 512, "alias": "currentOwnerAddress", "type": "esriFieldTypeString" }, { "modelName": "currentphone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "currentphone", "length": 16, "alias": "currentPhone", "type": "esriFieldTypeString" }, { "modelName": "dateactivityceases", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dateactivityceases", "length": 29, "alias": "dateActivityCeases", "type": "esriFieldTypeDate" }, { "modelName": "idlicensesuccessor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idlicensesuccessor", "alias": "idLicenseSuccessor", "type": "esriFieldTypeInteger" }, { "modelName": "idlicensepredecessor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idlicensepredecessor", "alias": "idLicensePredecessor", "type": "esriFieldTypeInteger" }, { "modelName": "numunits", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numunits", "alias": "numUnits", "type": "esriFieldTypeInteger" }, { "modelName": "datelicenseexpiration", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datelicenseexpiration", "length": 29, "alias": "dateLicenseExpiration", "type": "esriFieldTypeDate" }, { "modelName": "naicscode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naicscode", "alias": "NAICSCode", "type": "esriFieldTypeInteger" }, { "modelName": "isnonprofit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isnonprofit", "alias": "isNonprofit", "type": "esriFieldTypeSmallInteger" }, { "modelName": "businessorganizationtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessorganizationtype", "length": 255, "alias": "businessOrganizationType", "type": "esriFieldTypeString" }, { "modelName": "naicstitle", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naicstitle", "length": 255, "alias": "NAICSTitle", "type": "esriFieldTypeString" }, { "modelName": "naicsyear", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "naicsyear", "alias": "NAICSYear", "type": "esriFieldTypeInteger" }, { "modelName": "isrestaurantordeli", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isrestaurantordeli", "alias": "isRestaurantOrDeli", "type": "esriFieldTypeSmallInteger" }, { "modelName": "numchildrenmax", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numchildrenmax", "alias": "numChildrenMax", "type": "esriFieldTypeInteger" }, { "modelName": "sellsproduct", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sellsproduct", "alias": "sellsProduct", "type": "esriFieldTypeSmallInteger" }, { "modelName": "businessaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessaddress", "length": 512, "alias": "businessAddress", "type": "esriFieldTypeString" }, { "modelName": "seekingexemption", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "seekingexemption", "alias": "seekingExemption", "type": "esriFieldTypeSmallInteger" }, { "modelName": "exemptionexplanation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exemptionexplanation", "length": 2048, "alias": "exemptionExplanation", "type": "esriFieldTypeString" }, { "modelName": "township", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "township", "length": 128, "alias": "township", "type": "esriFieldTypeString" }, { "modelName": "supplementphaseid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "supplementphaseid", "alias": "supplementPhaseId", "type": "esriFieldTypeInteger" }, { "modelName": "islargescaleevent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "islargescaleevent", "alias": "isLargeScaleEvent", "type": "esriFieldTypeSmallInteger" }, { "modelName": "dategrantedextension", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "dategrantedextension", "length": 29, "alias": "dateGrantedExtension", "type": "esriFieldTypeDate" }, { "modelName": "closecommentsapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closecommentsapplicant", "length": 2048, "alias": "closeCommentsApplicant", "type": "esriFieldTypeString" }, { "modelName": "closecommentsoffice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closecommentsoffice", "length": 2048, "alias": "closeCommentsOffice", "type": "esriFieldTypeString" }, { "modelName": "mailingaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailingaddress", "length": 512, "alias": "mailingAddress", "type": "esriFieldTypeString" }, { "modelName": "skipreviews", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "skipreviews", "alias": "skipReviews", "type": "esriFieldTypeSmallInteger" }, { "modelName": "licenseofficialnotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licenseofficialnotes", "length": 2048, "alias": "licenseOfficialNotes", "type": "esriFieldTypeString" }, { "modelName": "beeroffpremises", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "beeroffpremises", "alias": "beerOffPremises", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ispawnshop", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ispawnshop", "alias": "isPawnShop", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isleasedspace", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isleasedspace", "alias": "isLeasedSpace", "type": "esriFieldTypeSmallInteger" }, { "modelName": "civicenterpriserecommendation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "civicenterpriserecommendation", "length": 128, "alias": "civicEnterpriseRecommendation", "type": "esriFieldTypeString" }, { "modelName": "identificationtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "identificationtype", "length": 128, "alias": "identificationType", "type": "esriFieldTypeString" }, { "modelName": "identificationcountry", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "identificationcountry", "length": 128, "alias": "identificationCountry", "type": "esriFieldTypeString" }, { "modelName": "identificationexplanation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "identificationexplanation", "length": 128, "alias": "identificationExplanation", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "isevent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isevent", "alias": "isEvent", "type": "esriFieldTypeSmallInteger" }, { "modelName": "issolicitor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issolicitor", "alias": "isSolicitor", "type": "esriFieldTypeSmallInteger" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 64, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "idorganization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idorganization", "alias": "idOrganization", "type": "esriFieldTypeInteger" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isclosed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isclosed", "alias": "isClosed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 64, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 64, "alias": "apn", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "modelName": "requiremechanicalelectricalequi", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "requiremechanicalelectricalequi", "alias": "requireMechanicalElectricalEquipment", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g922idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r392_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_392", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a191_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 0, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7339578.049600974, "xmin": 1443743.8358126432, "ymax": 7473502.1232877225, "xmax": 1618162.4676177204, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472429593}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 15, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 25, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "BusinessLicenseEnforcements", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "licensenumber": null, "businessowner": null, "addr_type": null, "referenceno": null, "city": null, "isactive": null, "datelicenseissued": null, "idproject": null, "description": null, "modifieddate": null, "extensionlength": null, "citationfee": null, "isactive_1": null, "isclosed": null, "title": null, "startdate": null, "hasnolicense": null, "match_addr": null, "ts_from": null, "score": null, "businessdescription": null, "businessphone": null, "match_type": null, "state": null, "inspectornotes": null, "relevantinformation": null, "apn": null, "zip": null, "enforcementaction": null, "address": null, "idorganization": null, "applicationsubmitted": null, "idlicenseinspector": null, "datecreated": null, "idpredecessorproject": null, "autocreated": null, "unit": null, "licenseinspector": null, "enddate": null, "datenoticeissued": null, "businessname": null, "businessaddress": null, "applicationtype": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "BusinessLicenseEnforcements", "allowTrueCurvesUpdates": false, "displayField": "businessname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 1, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "score", "alias": "Score", "type": "esriFieldTypeDouble" }, { "modelName": "match_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_type", "length": 2, "alias": "Match_type", "type": "esriFieldTypeString" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "addr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addr_type", "length": 20, "alias": "Addr_type", "type": "esriFieldTypeString" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "idlicenseinspector", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idlicenseinspector", "alias": "idLicenseInspector", "type": "esriFieldTypeInteger" }, { "modelName": "licenseinspector", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licenseinspector", "length": 255, "alias": "licenseInspector", "type": "esriFieldTypeString" }, { "modelName": "enforcementaction", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "enforcementaction", "length": 32, "alias": "enforcementAction", "type": "esriFieldTypeString" }, { "modelName": "extensionlength", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "extensionlength", "alias": "extensionLength", "type": "esriFieldTypeInteger" }, { "modelName": "inspectornotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inspectornotes", "length": 2048, "alias": "inspectorNotes", "type": "esriFieldTypeString" }, { "modelName": "citationfee", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "citationfee", "alias": "citationFee", "type": "esriFieldTypeDouble" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "autocreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "autocreated", "alias": "autoCreated", "type": "esriFieldTypeSmallInteger" }, { "modelName": "hasnolicense", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasnolicense", "alias": "hasNoLicense", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "licensenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensenumber", "length": 128, "alias": "licenseNumber", "type": "esriFieldTypeString" }, { "modelName": "businessname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessname", "length": 255, "alias": "businessName", "type": "esriFieldTypeString" }, { "modelName": "applicationsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationsubmitted", "length": 29, "alias": "applicationSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "businessowner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessowner", "length": 255, "alias": "businessOwner", "type": "esriFieldTypeString" }, { "modelName": "datenoticeissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datenoticeissued", "length": 29, "alias": "dateNoticeIssued", "type": "esriFieldTypeDate" }, { "modelName": "businessphone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessphone", "length": 16, "alias": "businessPhone", "type": "esriFieldTypeString" }, { "modelName": "datelicenseissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datelicenseissued", "length": 29, "alias": "dateLicenseIssued", "type": "esriFieldTypeDate" }, { "modelName": "relevantinformation", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "relevantinformation", "length": 2048, "alias": "relevantInformation", "type": "esriFieldTypeString" }, { "modelName": "businessaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessaddress", "length": 512, "alias": "businessAddress", "type": "esriFieldTypeString" }, { "modelName": "idpredecessorproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idpredecessorproject", "alias": "idPredecessorProject", "type": "esriFieldTypeInteger" }, { "modelName": "applicationtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "applicationtype", "alias": "applicationType", "type": "esriFieldTypeInteger" }, { "modelName": "businessdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessdescription", "length": 2048, "alias": "businessDescription", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 64, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "idorganization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idorganization", "alias": "idOrganization", "type": "esriFieldTypeInteger" }, { "modelName": "isactive_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive_1", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isclosed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isclosed", "alias": "isClosed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 64, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 64, "alias": "apn", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g923idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r393_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_393", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a192_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 0, 197, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7373872.137180641, "xmin": 1471802.0178851336, "ymax": 7428390.650846809, "xmax": 1545742.8896881342, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472431171}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 16, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 26, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "BusinessLicenseFeeWaivers", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "waiveramount": null, "licensenumber": null, "addr_type": null, "referenceno": null, "city": null, "isactive": null, "waiverrequestnumber": null, "idproject": null, "techrecommendations": null, "description": null, "modifieddate": null, "acceptrequest": null, "title": null, "startdate": null, "match_addr": null, "reasonforrequest": null, "ts_from": null, "score": null, "match_type": null, "state": null, "apn": null, "zip": null, "address": null, "techcompleted": null, "waiveramounttype": null, "datecreated": null, "notestoapplicant": null, "unit": null, "enddate": null, "agencyreview": null, "businessname": null, "businessaddress": null, "idrecord": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "BusinessLicenseFeeWaivers", "allowTrueCurvesUpdates": false, "displayField": "businessname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 1, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "score", "alias": "Score", "type": "esriFieldTypeDouble" }, { "modelName": "match_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_type", "length": 2, "alias": "Match_type", "type": "esriFieldTypeString" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "addr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addr_type", "length": 20, "alias": "Addr_type", "type": "esriFieldTypeString" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "acceptrequest", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "acceptrequest", "alias": "acceptRequest", "type": "esriFieldTypeSmallInteger" }, { "modelName": "notestoapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notestoapplicant", "length": 2048, "alias": "notesToApplicant", "type": "esriFieldTypeString" }, { "modelName": "techrecommendations", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "techrecommendations", "length": 2048, "alias": "techRecommendations", "type": "esriFieldTypeString" }, { "modelName": "agencyreview", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "agencyreview", "length": 2048, "alias": "agencyReview", "type": "esriFieldTypeString" }, { "modelName": "waiveramount", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waiveramount", "alias": "waiverAmount", "type": "esriFieldTypeDouble" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "techcompleted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "techcompleted", "length": 29, "alias": "techCompleted", "type": "esriFieldTypeDate" }, { "modelName": "licensenumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "licensenumber", "length": 128, "alias": "licenseNumber", "type": "esriFieldTypeString" }, { "modelName": "businessname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessname", "length": 255, "alias": "businessName", "type": "esriFieldTypeString" }, { "modelName": "businessaddress", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "businessaddress", "length": 512, "alias": "businessAddress", "type": "esriFieldTypeString" }, { "modelName": "reasonforrequest", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reasonforrequest", "length": 2048, "alias": "reasonForRequest", "type": "esriFieldTypeString" }, { "modelName": "waiveramounttype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waiveramounttype", "length": 32, "alias": "waiverAmountType", "type": "esriFieldTypeString" }, { "modelName": "waiverrequestnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "waiverrequestnumber", "length": 32, "alias": "waiverRequestNumber", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 64, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 64, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "idrecord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idrecord", "alias": "idRecord", "type": "esriFieldTypeInteger" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 64, "alias": "apn", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g925idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r395_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_395", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a194_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 255, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7335484.204770312, "xmin": 1443727.835844636, "ymax": 7481442.116265982, "xmax": 1618527.2395259738, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472432184}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Inspections", "relatedTableId": 15, "id": 17, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Notices", "relatedTableId": 23, "id": 18, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Fees", "relatedTableId": 12, "id": 19, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 20, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Submittals", "relatedTableId": 21, "id": 21, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 18, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "CodeEnforcementCases", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "addr_type": null, "referenceno": null, "city": null, "casedescription": null, "isactive": null, "idproject": null, "description": null, "modifieddate": null, "isclosed": null, "title": null, "startdate": null, "match_addr": null, "ts_from": null, "score": null, "match_type": null, "reentrystate": null, "state": null, "apn": null, "zip": null, "address": null, "codeenforcementcasecyclesequenc": null, "idorganization": null, "datecreated": null, "unit": null, "enddate": null, "closecasereason": null, "streetcoordinates": null, "idcodeenforcementcaseprocess": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "CodeEnforcementCases", "allowTrueCurvesUpdates": false, "displayField": "status", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 1, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "score", "alias": "Score", "type": "esriFieldTypeDouble" }, { "modelName": "match_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_type", "length": 2, "alias": "Match_type", "type": "esriFieldTypeString" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "addr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addr_type", "length": 20, "alias": "Addr_type", "type": "esriFieldTypeString" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 128, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "streetcoordinates", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetcoordinates", "length": 128, "alias": "streetCoordinates", "type": "esriFieldTypeString" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "idcodeenforcementcaseprocess", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idcodeenforcementcaseprocess", "alias": "idCodeEnforcementCaseProcess", "type": "esriFieldTypeInteger" }, { "modelName": "closecasereason", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closecasereason", "length": 2048, "alias": "closeCaseReason", "type": "esriFieldTypeString" }, { "modelName": "casedescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "casedescription", "length": 2048, "alias": "caseDescription", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "idorganization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idorganization", "alias": "idOrganization", "type": "esriFieldTypeInteger" }, { "modelName": "reentrystate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reentrystate", "length": 64, "alias": "reentryState", "type": "esriFieldTypeString" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isclosed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isclosed", "alias": "isClosed", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 64, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 64, "alias": "apn", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "modelName": "codeenforcementcasecyclesequenc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "codeenforcementcasecyclesequenc", "alias": "codeEnforcementCaseCycleSequence", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g926idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r396_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_396", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a195_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 0, 112, 255, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7339380.457804561, "xmin": 1443727.835844636, "ymax": 7479249.503525227, "xmax": 1618527.2395259738, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472426806}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 22, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 24, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Complaints", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "issubmitted": null, "elevatedto": null, "addr_type": null, "referenceno": null, "complainttype": null, "city": null, "isactive": null, "idproject": null, "description": null, "modifieddate": null, "title": null, "startdate": null, "match_addr": null, "ts_from": null, "hasuploads": null, "score": null, "idcase": null, "match_type": null, "managername": null, "state": null, "isanonymous": null, "apn": null, "zip": null, "idmanager": null, "address": null, "datereviewed": null, "d_idapplicant": null, "reasonforclose": null, "d_applicantname": null, "datecreated": null, "idcomplaint": null, "datesubmitted": null, "unit": null, "enddate": null, "complaintdescription": null, "originofcomplaint": null, "idrecord": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "Complaints", "allowTrueCurvesUpdates": false, "displayField": "d_applicantname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 1, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "score", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "score", "alias": "Score", "type": "esriFieldTypeDouble" }, { "modelName": "match_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_type", "length": 2, "alias": "Match_type", "type": "esriFieldTypeString" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "addr_type", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "addr_type", "length": 20, "alias": "Addr_type", "type": "esriFieldTypeString" }, { "modelName": "idcomplaint", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idcomplaint", "alias": "idComplaint", "type": "esriFieldTypeInteger" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "referenceno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "referenceno", "length": 128, "alias": "referenceNo", "type": "esriFieldTypeString" }, { "modelName": "d_idapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_idapplicant", "alias": "D_idApplicant", "type": "esriFieldTypeInteger" }, { "modelName": "d_applicantname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_applicantname", "length": 128, "alias": "D_applicantName", "type": "esriFieldTypeString" }, { "modelName": "idmanager", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idmanager", "alias": "idManager", "type": "esriFieldTypeInteger" }, { "modelName": "managername", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "managername", "length": 128, "alias": "managerName", "type": "esriFieldTypeString" }, { "modelName": "complaintdescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "complaintdescription", "length": 2048, "alias": "complaintDescription", "type": "esriFieldTypeString" }, { "modelName": "complainttype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "complainttype", "length": 255, "alias": "complaintType", "type": "esriFieldTypeString" }, { "modelName": "idcase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idcase", "alias": "idCase", "type": "esriFieldTypeInteger" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "datesubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datesubmitted", "length": 29, "alias": "dateSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "datereviewed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datereviewed", "length": 29, "alias": "dateReviewed", "type": "esriFieldTypeDate" }, { "modelName": "originofcomplaint", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "originofcomplaint", "length": 128, "alias": "originOfComplaint", "type": "esriFieldTypeString" }, { "modelName": "reasonforclose", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "reasonforclose", "length": 2048, "alias": "reasonForClose", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "isanonymous", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isanonymous", "alias": "isAnonymous", "type": "esriFieldTypeSmallInteger" }, { "modelName": "hasuploads", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasuploads", "alias": "hasUploads", "type": "esriFieldTypeSmallInteger" }, { "modelName": "issubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issubmitted", "alias": "isSubmitted", "type": "esriFieldTypeSmallInteger" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 64, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "idrecord", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idrecord", "alias": "idRecord", "type": "esriFieldTypeInteger" }, { "modelName": "address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "address", "type": "esriFieldTypeString" }, { "modelName": "apn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "apn", "length": 64, "alias": "apn", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 64, "alias": "city", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 64, "alias": "zip", "type": "esriFieldTypeString" }, { "modelName": "elevatedto", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "elevatedto", "length": 100, "alias": "elevatedTo", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g921idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r391_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_391", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a190_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 197, 0, 255, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 7373082.540006563, "xmin": 1471916.4612258077, "ymax": 7434306.01171948, "xmax": 1610184.3172354698, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1772472430428}, "relationships": [ { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Receipts", "relatedTableId": 19, "id": 23, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Issuances", "relatedTableId": 27, "id": 24, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Contacts", "relatedTableId": 28, "id": 25, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Submittals", "relatedTableId": 21, "id": 26, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Fees", "relatedTableId": 12, "id": 27, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "idproject", "role": "esriRelRoleOrigin", "composite": false, "name": "Inspections", "relatedTableId": 15, "id": 28, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.5.0", "isDataArchived": false, "id": 8, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3566, "zTolerance": 0.001, "wkid": 102743, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "RightOfWayImprovementPermits", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "feetapproaches": null, "existingcurb": null, "numapproaches": null, "d_paidfees": null, "lastsubmitted": null, "existingapproaches": null, "isactive": null, "installapproaches": null, "idproject": null, "description": null, "modifieddate": null, "isclosed": null, "datepermitissued": null, "title": null, "startdate": null, "match_addr": null, "lot": null, "ts_from": null, "installsidewalk": null, "block": null, "state": null, "completedissuances": null, "d_applicant": null, "idorganization": null, "applicationsubmitted": null, "privatesurveyor": null, "datecreated": null, "feetcurbgutter": null, "certifyapplication": null, "feetsidewalk": null, "notestoapplicant": null, "enddate": null, "permitnumber": null, "existingsidewalk": null, "applicationaccepted": null, "installcurb": null, "detaileddescription": null, "crossstreet": null, "d_wasrejected": null, "location": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.5, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "hasContingentValuesDefinition": false, "name": "RightOfWayImprovementPermits", "allowTrueCurvesUpdates": false, "displayField": "match_addr", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "match_addr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "match_addr", "length": 500, "alias": "Match_addr", "type": "esriFieldTypeString" }, { "modelName": "idproject", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idproject", "alias": "idProject", "type": "esriFieldTypeInteger" }, { "modelName": "d_applicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_applicant", "length": 255, "alias": "D_applicant", "type": "esriFieldTypeString" }, { "modelName": "detaileddescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "detaileddescription", "length": 2048, "alias": "detailedDescription", "type": "esriFieldTypeString" }, { "modelName": "certifyapplication", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "certifyapplication", "alias": "certifyApplication", "type": "esriFieldTypeSmallInteger" }, { "modelName": "numapproaches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "numapproaches", "alias": "numApproaches", "type": "esriFieldTypeInteger" }, { "modelName": "feetapproaches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetapproaches", "alias": "feetApproaches", "type": "esriFieldTypeDouble" }, { "modelName": "feetcurbgutter", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetcurbgutter", "alias": "feetCurbGutter", "type": "esriFieldTypeDouble" }, { "modelName": "feetsidewalk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "feetsidewalk", "alias": "feetSidewalk", "type": "esriFieldTypeDouble" }, { "modelName": "d_wasrejected", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_wasrejected", "alias": "D_wasRejected", "type": "esriFieldTypeSmallInteger" }, { "modelName": "notestoapplicant", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notestoapplicant", "length": 2048, "alias": "notesToApplicant", "type": "esriFieldTypeString" }, { "modelName": "d_paidfees", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "d_paidfees", "alias": "D_paidFees", "type": "esriFieldTypeSmallInteger" }, { "modelName": "completedissuances", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completedissuances", "alias": "completedIssuances", "type": "esriFieldTypeSmallInteger" }, { "modelName": "permitnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "permitnumber", "length": 128, "alias": "permitNumber", "type": "esriFieldTypeString" }, { "modelName": "datecreated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datecreated", "length": 29, "alias": "dateCreated", "type": "esriFieldTypeDate" }, { "modelName": "applicationsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationsubmitted", "length": 29, "alias": "applicationSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "applicationaccepted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "applicationaccepted", "length": 29, "alias": "applicationAccepted", "type": "esriFieldTypeDate" }, { "modelName": "lastsubmitted", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "lastsubmitted", "length": 29, "alias": "lastSubmitted", "type": "esriFieldTypeDate" }, { "modelName": "datepermitissued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "datepermitissued", "length": 29, "alias": "datePermitIssued", "type": "esriFieldTypeDate" }, { "modelName": "existingcurb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "existingcurb", "alias": "existingCurb", "type": "esriFieldTypeSmallInteger" }, { "modelName": "existingsidewalk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "existingsidewalk", "alias": "existingSidewalk", "type": "esriFieldTypeSmallInteger" }, { "modelName": "existingapproaches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "existingapproaches", "alias": "existingApproaches", "type": "esriFieldTypeSmallInteger" }, { "modelName": "installcurb", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installcurb", "alias": "installCurb", "type": "esriFieldTypeSmallInteger" }, { "modelName": "installsidewalk", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installsidewalk", "alias": "installSidewalk", "type": "esriFieldTypeSmallInteger" }, { "modelName": "installapproaches", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installapproaches", "alias": "installApproaches", "type": "esriFieldTypeSmallInteger" }, { "modelName": "privatesurveyor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "privatesurveyor", "alias": "privateSurveyor", "type": "esriFieldTypeSmallInteger" }, { "modelName": "location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 255, "alias": "location", "type": "esriFieldTypeString" }, { "modelName": "crossstreet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "crossstreet", "length": 255, "alias": "crossStreet", "type": "esriFieldTypeString" }, { "modelName": "block", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block", "length": 32, "alias": "block", "type": "esriFieldTypeString" }, { "modelName": "lot", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot", "length": 32, "alias": "lot", "type": "esriFieldTypeString" }, { "modelName": "ts_from", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "ts_from", "length": 29, "alias": "TS_FROM", "type": "esriFieldTypeDate" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 64, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "title", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "title", "length": 128, "alias": "title", "type": "esriFieldTypeString" }, { "modelName": "description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 128, "alias": "description", "type": "esriFieldTypeString" }, { "modelName": "startdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "startdate", "length": 29, "alias": "startDate", "type": "esriFieldTypeDate" }, { "modelName": "enddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "enddate", "length": 29, "alias": "endDate", "type": "esriFieldTypeDate" }, { "modelName": "modifieddate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "modifieddate", "length": 29, "alias": "modifiedDate", "type": "esriFieldTypeDate" }, { "modelName": "idorganization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "idorganization", "alias": "idOrganization", "type": "esriFieldTypeInteger" }, { "modelName": "isactive", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isactive", "alias": "isActive", "type": "esriFieldTypeSmallInteger" }, { "modelName": "isclosed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "isclosed", "alias": "isClosed", "type": "esriFieldTypeSmallInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "sourceSpatialReference": { "wkt": "PROJCS[\"NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",1640416.666666667],PARAMETER[\"False_Northing\",6561666.666666666],PARAMETER[\"Central_Meridian\",-111.5],PARAMETER[\"Standard_Parallel_1\",39.01666666666667],PARAMETER[\"Standard_Parallel_2\",40.65],PARAMETER[\"Latitude_Of_Origin\",38.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]", "falseM": -100000, "mUnits": 10000, "zUnits": 10000, "zTolerance": 0.001, "wkid": 3566, "xyUnits": 3048.0060960121928, "mTolerance": 0.001, "falseX": -119796900, "falseY": -89212200, "falseZ": -100000 }, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "g924idproject", "isUnique": false, "description": "", "fields": "idproject", "isAscending": true }, { "name": "r394_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_394", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a193_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportsFirstDayOfWeek": false, "supportedNormalizationTypes": [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ], "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsNormalization": true, "supportsSnapToData": true, "supportsFixedIntervalBin": true, "supportsStackBy": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true, "supportsSplitBy": true, "supportsReturnFullIntervalBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsOperator": true, "supportsSearchOperator": true }, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "d6abb16dfcf843be8c414392f527601c", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,imageCollection,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 255, 255, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }