{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 107, "name": "Unidades de Alum. Público", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": "SUBTYPE", "subtypeFieldName": "SUBTYPE", "subtypeField": "SUBTYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SUBTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Subtipo", "domain": null }, { "name": "CUSTOM_ID", "type": "esriFieldTypeString", "alias": "Custom ID", "length": 15, "domain": null }, { "name": "LEGACY_ID", "type": "esriFieldTypeString", "alias": "ID Sistema Anterior", "length": 50, "domain": null }, { "name": "PREDESIGN_ID", "type": "esriFieldTypeString", "alias": "ID Prediseño", "length": 15, "domain": null }, { "name": "SERIAL_NUMBER", "type": "esriFieldTypeString", "alias": "Número Serial", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Matricula", "length": 50, "domain": null }, { "name": "ALIAS", "type": "esriFieldTypeString", "alias": "Matricula Alternativa", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Descripcion", "length": 250, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Propietario", "length": 5, "domain": { "type": "codedValue", "name": "RED003", "description": "Propietarios [Text]", "codedValues": [ { "name": "OPERADOR DE RED", "code": "OR" }, { "name": "TERCERO PARTICULAR", "code": "TP" }, { "name": "TERCERO OFICIAL", "code": "TO" }, { "name": "MIXTO O.R. Y OFICIAL", "code": "MORF" }, { "name": "MIXTO O.R. Y PARCULAR", "code": "MORP" }, { "name": "MIXTO PARTICULAR Y OFICIAL", "code": "MPF" }, { "name": "PLATAFORMA DE INVERSION CAOBA", "code": "PKOBA" }, { "name": "PLATAFORMA DE INVERSION TESORITO", "code": "PTSTO" }, { "name": "PLATAFORMA DE INVERSION CUBICO", "code": "PCUBO" }, { "name": "PLATAFORMA DE INVERSION LAUREL", "code": "PLRL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNER_NAME", "type": "esriFieldTypeString", "alias": "Nombre del Propietario", "length": 50, "domain": null }, { "name": "LAMP_TYPE", "type": "esriFieldTypeString", "alias": "Tipo de Luminaria", "length": 10, "domain": { "type": "codedValue", "name": "RED032", "description": "Tipo de Luminaria [Text]", "codedValues": [ { "name": "AHORRADOR", "code": "PS" }, { "name": "CMH", "code": "CMH" }, { "name": "FLUORECENTE", "code": "FL" }, { "name": "HALOGENA", "code": "HL" }, { "name": "INCANDESCENTE", "code": "INC" }, { "name": "LED", "code": "LED" }, { "name": "LUZ DIA (NEON)", "code": "NE" }, { "name": "MERCURIO", "code": "HG" }, { "name": "METAL HALIDE", "code": "MH" }, { "name": "MIXTA", "code": "MX" }, { "name": "SODIO", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACTIVE_POWER", "type": "esriFieldTypeDouble", "alias": "Potencia Activa (W)", "domain": null }, { "name": "REACTIVE_POWER", "type": "esriFieldTypeDouble", "alias": "Potencia Reactiva (VAR)", "domain": null }, { "name": "PHASES_SEQUENCE", "type": "esriFieldTypeString", "alias": "Secuencia de Fases", "length": 5, "domain": { "type": "codedValue", "name": "RED013", "description": "Secuencia de Fases [Text]", "codedValues": [ { "name": "FASE R [A]", "code": "R" }, { "name": "FASE S [B]", "code": "S" }, { "name": "FASE T [C]", "code": "T" }, { "name": "FASES RS [AB]", "code": "RS" }, { "name": "FASES SR [BA]", "code": "SR" }, { "name": "FASES RT [AC]", "code": "RT" }, { "name": "FASES TR [CA]", "code": "TR" }, { "name": "FASES ST [BC]", "code": "ST" }, { "name": "FASES TS [CB]", "code": "TS" }, { "name": "FASES RST [ABC]", "code": "RST" }, { "name": "FASES RTS [ACB]", "code": "RTS" }, { "name": "FASES SRT [BAC]", "code": "SRT" }, { "name": "FASES STR [BCA]", "code": "STR" }, { "name": "FASES TSR [CBA]", "code": "TSR" }, { "name": "FASES TRS [CAB]", "code": "TRS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MANUFACTURE_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Fabricacion", "length": 8, "domain": null }, { "name": "INSTALLATION_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Instalacion", "length": 8, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Observaciones y Comentarios", "length": 1000, "domain": null }, { "name": "PUBLIC_LIGHT_ID", "type": "esriFieldTypeString", "alias": "ID Alumbrado Publico", "length": 15, "domain": null }, { "name": "LEGACY_VERSION", "type": "esriFieldTypeString", "alias": "Versión Sistema Anterior", "length": 15, "domain": null }, { "name": "HYPERLINK", "type": "esriFieldTypeString", "alias": "Hipervínculo", "length": 1000, "domain": null }, { "name": "CREATOR_USER", "type": "esriFieldTypeString", "alias": "Usuario de Alta", "length": 30, "domain": null }, { "name": "CREATION_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Alta", "length": 8, "domain": null }, { "name": "EDITOR_USER", "type": "esriFieldTypeString", "alias": "Usuario de Modificacion", "length": 30, "domain": null }, { "name": "EDITION_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Modificacion", "length": 8, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "FRAME_TYPE", "type": "esriFieldTypeString", "alias": "Tipo de Estructura Iluminacion", "length": 5, "domain": { "type": "codedValue", "name": "RED090", "description": "Tipo Alumbrado Publico [Text]", "codedValues": [ { "name": "FAROL", "code": "LTR" }, { "name": "LUMINARIA", "code": "LLG" }, { "name": "PROYECTOR", "code": "PLG" }, { "name": "REFLECTOR", "code": "SLG" }, { "name": "SEMAFORO", "code": "TLG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GLOBALID", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I121PUBLIC_LIGHT", "fields": "PUBLIC_LIGHT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I121PREDESIGN_ID", "fields": "PREDESIGN_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I121NAME", "fields": "NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I121LEGACY_ID", "fields": "LEGACY_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I121CUSTOM_ID", "fields": "CUSTOM_ID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "OWNER": {"type": "inherited"}, "LAMP_TYPE": {"type": "inherited"}, "PHASES_SEQUENCE": {"type": "inherited"}, "FRAME_TYPE": {"type": "inherited"} }, "id": 1, "name": "LUMINARIA" } ], "subtypes": [ { "domains": { "OWNER": {"type": "inherited"}, "LAMP_TYPE": {"type": "inherited"}, "PHASES_SEQUENCE": {"type": "inherited"}, "FRAME_TYPE": {"type": "inherited"} }, "defaultValues": { "SUBTYPE": null, "CUSTOM_ID": null, "LEGACY_ID": null, "PREDESIGN_ID": null, "SERIAL_NUMBER": "SIN INFORMACIÓN", "NAME": null, "ALIAS": null, "DESCRIPTION": null, "OWNER": "TO", "OWNER_NAME": null, "LAMP_TYPE": null, "ACTIVE_POWER": null, "REACTIVE_POWER": null, "PHASES_SEQUENCE": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "PUBLIC_LIGHT_ID": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "FRAME_TYPE": null }, "code": 1, "name": "LUMINARIA" } ], "relationships": [ { "id": 117, "name": "Alumbrado Público", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "PUBLIC_LIGHT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{ECE037E0-51BF-497F-B920-1F926C2152E1}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "8ecf11c35f0c405abf6c59cc0c0676b7" }