{ "currentVersion": 10.22, "id": 42, "name": "fpfgis.SDE.B4_Foundation", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SITE_NAME", "typeIdField": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SITE_NAME", "type": "esriFieldTypeString", "alias": "SITE_NAME", "length": 50, "domain": null }, { "name": "TableID", "type": "esriFieldTypeInteger", "alias": "Table ID", "domain": null }, { "name": "Inspected", "type": "esriFieldTypeString", "alias": "Inspected?", "length": 5, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "Foundation_Type", "type": "esriFieldTypeString", "alias": "Foundation Type", "length": 50, "domain": { "type": "codedValue", "name": "FoundType", "codedValues": [ { "name": "Poured Concrete", "code": "1" }, { "name": "Concrete Block", "code": "2" }, { "name": "Rock", "code": "3" }, { "name": "Other", "code": "4" } ] } }, { "name": "Visible", "type": "esriFieldTypeString", "alias": "Visible", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "SlobOnGrade", "type": "esriFieldTypeString", "alias": "Slab on Grade", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "MinorCracks", "type": "esriFieldTypeString", "alias": "Minor Cracks", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "MinorCracks_Loc", "type": "esriFieldTypeString", "alias": "Minor Cracks Location", "length": 50, "domain": null }, { "name": "MajorCracks", "type": "esriFieldTypeString", "alias": "Major Cracks", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "MajorCracks_Loc", "type": "esriFieldTypeString", "alias": "Major Cracks Location", "length": 50, "domain": null }, { "name": "SeparationCracks", "type": "esriFieldTypeString", "alias": "Separation Cracks", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "SeparationCracks_Loc", "type": "esriFieldTypeString", "alias": "Separation Cracks Location", "length": 50, "domain": null }, { "name": "PoorDrainage", "type": "esriFieldTypeString", "alias": "Poor Drainage", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "PoorDrainage_Loc", "type": "esriFieldTypeString", "alias": "Poor Drainage Location", "length": 50, "domain": null }, { "name": "PreviouslyRepaired", "type": "esriFieldTypeString", "alias": "Previously Repaired", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "Comments_Condition", "type": "esriFieldTypeString", "alias": "Comments_Condition", "length": 250, "domain": null }, { "name": "FoundationVents_Presence", "type": "esriFieldTypeString", "alias": "Foundation Vents Exists", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "FoundationVents_Qty", "type": "esriFieldTypeString", "alias": "Vents Quantity", "length": 50, "domain": null }, { "name": "FoundationVents_NominalSize", "type": "esriFieldTypeDouble", "alias": "Nominal Size", "domain": null }, { "name": "FoundationVents_Condition", "type": "esriFieldTypeInteger", "alias": "Vents Condition", "domain": { "type": "codedValue", "name": "ConditionVent", "codedValues": [ { "name": "Adequate", "code": 1 }, { "name": "Inadequate", "code": 2 } ] } }, { "name": "FoundationVents_Situation", "type": "esriFieldTypeString", "alias": "Vents Situation", "length": 50, "domain": { "type": "codedValue", "name": "OpenClosed", "codedValues": [ { "name": "Generally Open", "code": "1" }, { "name": "Some Closed", "code": "2" }, { "name": "All Closed", "code": "3" } ] } }, { "name": "None", "type": "esriFieldTypeString", "alias": "None (Finished Basement)", "length": 50, "domain": { "type": "codedValue", "name": "YesNo_6", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ] } }, { "name": "Comments_Vents", "type": "esriFieldTypeString", "alias": "Comments - Foundation Vents", "length": 250, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "relationships": [ { "id": 71, "name": "Building", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "SITE_NAME", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true }