{ "currentVersion": 10.71, "id": 39, "name": "repo.GTZ.BMP_Info", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SiteName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ObjectIDPTD", "type": "esriFieldTypeInteger", "alias": "ObjectIDPTD", "domain": null }, { "name": "InventoryDate", "type": "esriFieldTypeDate", "alias": "Inventory Date", "length": 8, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 50, "domain": null }, { "name": "UpDated", "type": "esriFieldTypeDate", "alias": "Updated", "length": 8, "domain": null }, { "name": "SiteName", "type": "esriFieldTypeString", "alias": "Site Name", "length": 50, "domain": null }, { "name": "TaxMap", "type": "esriFieldTypeString", "alias": "Tax Map", "length": 50, "domain": null }, { "name": "NumbStruct", "type": "esriFieldTypeInteger", "alias": "Number of BMPs on Site", "domain": null }, { "name": "MailAd2", "type": "esriFieldTypeString", "alias": "Secondary Mail Address Type", "length": 1073741822, "domain": null }, { "name": "MailAd2No", "type": "esriFieldTypeString", "alias": "Secondary Mail Address Number", "length": 1073741822, "domain": null }, { "name": "CityMail", "type": "esriFieldTypeString", "alias": "Mailing Address City", "length": 50, "domain": null }, { "name": "StateMail", "type": "esriFieldTypeString", "alias": "Mailing Address State", "length": 50, "domain": null }, { "name": "ZipMail", "type": "esriFieldTypeString", "alias": "Mailing Address Zip Code", "length": 50, "domain": null }, { "name": "Contact", "type": "esriFieldTypeString", "alias": "Point of Contact", "length": 50, "domain": null }, { "name": "CoCompany", "type": "esriFieldTypeString", "alias": "Company Responsible for BMP", "length": 1073741822, "domain": null }, { "name": "Installed", "type": "esriFieldTypeString", "alias": "Installed", "length": 50, "domain": null }, { "name": "BMPComments", "type": "esriFieldTypeString", "alias": "BMP Comments", "length": 1073741822, "domain": null }, { "name": "BMPLn2Type", "type": "esriFieldTypeString", "alias": "BMPLn2Type", "length": 1073741822, "domain": null }, { "name": "BMPLn2No", "type": "esriFieldTypeString", "alias": "BMPLn2No", "length": 1073741822, "domain": null }, { "name": "BMPCity", "type": "esriFieldTypeString", "alias": "BMPCity", "length": 1073741822, "domain": null }, { "name": "BMPState", "type": "esriFieldTypeString", "alias": "BMPState", "length": 1073741822, "domain": null }, { "name": "BMPZip", "type": "esriFieldTypeString", "alias": "BMPZip", "length": 1073741822, "domain": null }, { "name": "BMPPermit", "type": "esriFieldTypeString", "alias": "BMPPermit", "length": 1073741822, "domain": null }, { "name": "BMPID", "type": "esriFieldTypeString", "alias": "BMPID", "length": 50, "domain": null }, { "name": "GID", "type": "esriFieldTypeInteger", "alias": "GID", "domain": null }, { "name": "Contact1N", "type": "esriFieldTypeString", "alias": "Contact1N", "length": 1073741822, "domain": null }, { "name": "Contact2N", "type": "esriFieldTypeString", "alias": "Contact2N", "length": 1073741822, "domain": null }, { "name": "PotentialOrphan", "type": "esriFieldTypeString", "alias": "Potential Orphan", "length": 1073741822, "domain": null }, { "name": "coords", "type": "esriFieldTypeString", "alias": "coords", "length": 50, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "Date_", "type": "esriFieldTypeDate", "alias": "Date", "length": 8, "domain": null }, { "name": "CrewID", "type": "esriFieldTypeString", "alias": "CrewID", "length": 1073741822, "domain": null }, { "name": "BMPIDWS", "type": "esriFieldTypeString", "alias": "BMPIDWS", "length": 1073741822, "domain": null }, { "name": "Watershed", "type": "esriFieldTypeString", "alias": "Watershed", "length": 1073741822, "domain": null }, { "name": "HUC14", "type": "esriFieldTypeString", "alias": "HUC14", "length": 1073741822, "domain": null }, { "name": "MailingAddress", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 250, "domain": null }, { "name": "PhysicalAddress", "type": "esriFieldTypeString", "alias": "PhysicalAddress", "length": 250, "domain": null }, { "name": "BMPID2", "type": "esriFieldTypeString", "alias": "BMPID", "length": 50, "domain": null } ], "indexes": [ { "name": "R94_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G121BMPID", "fields": "BMPID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "BioRetention", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 4, "name": "Cistern", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 6, "name": "Detention", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 11, "name": "Detention_Dry", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 12, "name": "Detention_Underground", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 13, "name": "Detention_Wet", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 14, "name": "EngineeredDevice", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 16, "name": "GreenRoof", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 18, "name": "InfiltrationTrench", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 20, "name": "InsertBMP", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 22, "name": "LevelSpreader", "relatedTableId": 18, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 25, "name": "OtherBMP", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 27, "name": "PermeablePavingSurface", "relatedTableId": 23, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 29, "name": "SandFilter", "relatedTableId": 29, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 32, "name": "StormwaterWetland", "relatedTableId": 31, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 33, "name": "Swales", "relatedTableId": 32, "role": "esriRelRoleDestination", "keyField": "BMPID", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }