{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 52, "name": "CONDORELATE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "SSL", "type": "esriFieldTypeString", "alias": "SSL", "length": 20, "domain": null }, { "name": "REGIME", "type": "esriFieldTypeString", "alias": "REGIME", "length": 6, "domain": null }, { "name": "COMPLEX", "type": "esriFieldTypeString", "alias": "COMPLEX", "length": 20, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 30, "domain": null }, { "name": "REC_LOT", "type": "esriFieldTypeString", "alias": "REC_LOT", "length": 9, "domain": null }, { "name": "UNDER_REC", "type": "esriFieldTypeDouble", "alias": "UNDER_REC", "domain": null }, { "name": "TAX_LOT", "type": "esriFieldTypeString", "alias": "TAX_LOT", "length": 9, "domain": null }, { "name": "UNDER_TAX", "type": "esriFieldTypeDouble", "alias": "UNDER_TAX", "domain": null }, { "name": "CONDO_BK", "type": "esriFieldTypeString", "alias": "CONDO_BK", "length": 11, "domain": null }, { "name": "CONDO_PG", "type": "esriFieldTypeString", "alias": "CONDO_PG", "length": 11, "domain": null }, { "name": "REC_LOT2", "type": "esriFieldTypeString", "alias": "REC_LOT2", "length": 200, "domain": null }, { "name": "SQUARE", "type": "esriFieldTypeString", "alias": "SQUARE", "length": 10, "domain": null }, { "name": "SUFFIX", "type": "esriFieldTypeString", "alias": "SUFFIX", "length": 1, "domain": null }, { "name": "LOT", "type": "esriFieldTypeString", "alias": "LOT", "length": 5, "domain": null }, { "name": "MAT_SSL", "type": "esriFieldTypeString", "alias": "MAT_SSL", "length": 12, "domain": null }, { "name": "ACT_LOT", "type": "esriFieldTypeDouble", "alias": "ACT_LOT", "domain": null }, { "name": "REGIME_ID", "type": "esriFieldTypeDouble", "alias": "REGIME_ID", "domain": null }, { "name": "UNITNUM", "type": "esriFieldTypeString", "alias": "UNITNUM", "length": 10, "domain": null }, { "name": "DOC_DATE", "type": "esriFieldTypeDate", "alias": "DOC_DATE", "length": 8, "domain": null }, { "name": "O_LOTS", "type": "esriFieldTypeString", "alias": "O_LOTS", "length": 200, "domain": null }, { "name": "BK_PG", "type": "esriFieldTypeString", "alias": "BK_PG", "length": 16, "domain": null }, { "name": "UNUM_OWN", "type": "esriFieldTypeString", "alias": "UNUM_OWN", "length": 30, "domain": null }, { "name": "UID_", "type": "esriFieldTypeInteger", "alias": "UID_", "domain": null }, { "name": "MARUNITNUM", "type": "esriFieldTypeString", "alias": "MARUNITNUM", "length": 20, "domain": null }, { "name": "AIR_LOT", "type": "esriFieldTypeString", "alias": "AIR_LOT", "length": 150, "domain": null }, { "name": "UNDER_AIR", "type": "esriFieldTypeDouble", "alias": "UNDER_AIR", "domain": null }, { "name": "ASSESSMENT", "type": "esriFieldTypeDouble", "alias": "ASSESSMENT", "domain": null }, { "name": "OLDTOTAL", "type": "esriFieldTypeDouble", "alias": "OLDTOTAL", "domain": null }, { "name": "NEWTOTAL", "type": "esriFieldTypeDouble", "alias": "NEWTOTAL", "domain": null }, { "name": "OWNERNAME", "type": "esriFieldTypeString", "alias": "OWNERNAME", "length": 70, "domain": null }, { "name": "OWNNAME2", "type": "esriFieldTypeString", "alias": "OWNNAME2", "length": 70, "domain": null }, { "name": "CAREOFNAME", "type": "esriFieldTypeString", "alias": "CAREOFNAME", "length": 40, "domain": null }, { "name": "ADDRESS1", "type": "esriFieldTypeString", "alias": "ADDRESS1", "length": 40, "domain": null }, { "name": "ADDRESS2", "type": "esriFieldTypeString", "alias": "ADDRESS2", "length": 40, "domain": null }, { "name": "CITYSTZIP", "type": "esriFieldTypeString", "alias": "CITYSTZIP", "length": 40, "domain": null }, { "name": "LANDAREA", "type": "esriFieldTypeDouble", "alias": "LANDAREA", "domain": null }, { "name": "HSTDCODE", "type": "esriFieldTypeString", "alias": "HSTDCODE", "length": 1, "domain": null }, { "name": "CY1YEAR", "type": "esriFieldTypeString", "alias": "CY1YEAR", "length": 50, "domain": null }, { "name": "CAPCURR", "type": "esriFieldTypeDouble", "alias": "CAPCURR", "domain": null }, { "name": "PHASELAND", "type": "esriFieldTypeDouble", "alias": "PHASELAND", "domain": null }, { "name": "PHASEBUILD", "type": "esriFieldTypeDouble", "alias": "PHASEBUILD", "domain": null }, { "name": "CAPPROP", "type": "esriFieldTypeDouble", "alias": "CAPPROP", "domain": null }, { "name": "NEWLAND", "type": "esriFieldTypeDouble", "alias": "NEWLAND", "domain": null }, { "name": "NEWIMPR", "type": "esriFieldTypeDouble", "alias": "NEWIMPR", "domain": null }, { "name": "SALEPRICE", "type": "esriFieldTypeDouble", "alias": "SALEPRICE", "domain": null }, { "name": "SALEDATE", "type": "esriFieldTypeDate", "alias": "SALEDATE", "length": 8, "domain": null }, { "name": "ACCEPTCODE", "type": "esriFieldTypeString", "alias": "ACCEPTCODE", "length": 25, "domain": null }, { "name": "VACLNDUSE", "type": "esriFieldTypeString", "alias": "VACLNDUSE", "length": 1, "domain": null }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "WARD", "length": 6, "domain": null }, { "name": "MAR_ID", "type": "esriFieldTypeDouble", "alias": "MAR_ID", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "CONDORELATE_IX1", "fields": "SSL,CONDO_BK,CONDO_PG", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_28559_MAT_SS", "fields": "MAT_SSL", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_28559_REGIME", "fields": "REGIME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R4108_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 32, "name": "DCGIS.CAMA_SALES_HISTORY", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "SSL", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 34, "name": "ITSPE", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "SSL", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 36, "name": "DCGIS.SURDOCS", "relatedTableId": 69, "role": "esriRelRoleOrigin", "keyField": "SSL", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 35, "name": "ITSPE_FACTS", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "SSL", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "CONDOLOTPLY", "relatedTableId": 44, "role": "esriRelRoleDestination", "keyField": "MAT_SSL", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "OwnerPLY", "relatedTableId": 40, "role": "esriRelRoleDestination", "keyField": "REGIME", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "OwnerPLY", "relatedTableId": 49, "role": "esriRelRoleDestination", "keyField": "REGIME", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 25, "name": "OwnerPLY", "relatedTableId": 50, "role": "esriRelRoleDestination", "keyField": "REGIME", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }