{ "layers": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 0, "name": "GMIS Project Details", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "extent": { "xmin": -122.41250000149012, "ymin": 0, "xmax": 1.03182738325E7, "ymax": 3836984.2386000007, "spatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102100, "latestWkid": 3857, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 49, 142, 32, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "objectid", "globalIdField": "", "displayField": "project_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "project_mis_id", "type": "esriFieldTypeString", "alias": "Project MIS ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_mis_id" }, { "name": "project_name", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_name" }, { "name": "project_detail", "type": "esriFieldTypeString", "alias": "Project Detail", "domain": null, "editable": true, "nullable": true, "length": 2047, "defaultValue": null, "modelName": "project_detail" }, { "name": "project_start_date", "type": "esriFieldTypeDate", "alias": "Project Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "project_start_date" }, { "name": "project_end_date", "type": "esriFieldTypeDate", "alias": "Project End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "project_end_date" }, { "name": "state_name", "type": "esriFieldTypeString", "alias": "State Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "state_name" }, { "name": "district_name", "type": "esriFieldTypeString", "alias": "District Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "district_name" }, { "name": "ulb_name", "type": "esriFieldTypeString", "alias": "ULB Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ulb_name" }, { "name": "project_category", "type": "esriFieldTypeString", "alias": "Project Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_category" }, { "name": "sector", "type": "esriFieldTypeString", "alias": "Sector", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sector" }, { "name": "project_taken_by", "type": "esriFieldTypeString", "alias": "Project Taken By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_taken_by" }, { "name": "implementing_agency", "type": "esriFieldTypeString", "alias": "Implementing Agency Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "implementing_agency" }, { "name": "central_share", "type": "esriFieldTypeDouble", "alias": "Central Share", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "central_share" }, { "name": "state_share", "type": "esriFieldTypeDouble", "alias": "State Share", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "state_share" }, { "name": "ulb_share", "type": "esriFieldTypeDouble", "alias": "ULB Share", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "ulb_share" }, { "name": "dpr_cost_est_cost", "type": "esriFieldTypeDouble", "alias": "DPR Cost / Estimated Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "dpr_cost_est_cost" }, { "name": "cost_as_per_wo", "type": "esriFieldTypeDouble", "alias": "Cost as per Work Order", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "cost_as_per_wo" }, { "name": "actual_cost", "type": "esriFieldTypeDouble", "alias": "Actual Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "actual_cost" }, { "name": "expired_flag", "type": "esriFieldTypeString", "alias": "Expired Flag", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": "N", "modelName": "expired_flag" }, { "name": "created_by", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_by" }, { "name": "updated_by", "type": "esriFieldTypeString", "alias": "Updated By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "updated_by" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "project_proposal_id", "type": "esriFieldTypeInteger", "alias": "Project Proposal ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "project_proposal_id" }, { "name": "proposal_unique_id", "type": "esriFieldTypeString", "alias": "Proposal Unique ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "proposal_unique_id" }, { "name": "other_share", "type": "esriFieldTypeDouble", "alias": "Other Share", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "other_share" }, { "name": "project_unique_id", "type": "esriFieldTypeString", "alias": "Project Unique ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_unique_id" }, { "name": "stcode", "type": "esriFieldTypeString", "alias": "State Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "stcode" }, { "name": "distcode", "type": "esriFieldTypeString", "alias": "District Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "distcode" }, { "name": "ulbcode", "type": "esriFieldTypeString", "alias": "ULB Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ulbcode" }, { "name": "physical_progress_percentage", "type": "esriFieldTypeDouble", "alias": "Physical Progress Percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "physical_progress_percentage" }, { "name": "financial_detail", "type": "esriFieldTypeDouble", "alias": "Financial Detail", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "financial_detail" }, { "name": "land_notalloted_date", "type": "esriFieldTypeDate", "alias": "Land not Allotted Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "land_notalloted_date" }, { "name": "land_allotted_date", "type": "esriFieldTypeDate", "alias": "Land Allotted Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "land_allotted_date" }, { "name": "dpr_underpreparation_date", "type": "esriFieldTypeDate", "alias": "DPR Underpreparation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "dpr_underpreparation_date" }, { "name": "dprapproved_date", "type": "esriFieldTypeDate", "alias": "DPR Approved Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "dprapproved_date" }, { "name": "tender_underpreparation_date", "type": "esriFieldTypeDate", "alias": "Tender Underpreparation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "tender_underpreparation_date" }, { "name": "tender_published_date", "type": "esriFieldTypeDate", "alias": "Tender Published Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "tender_published_date" }, { "name": "contract_awarded_date", "type": "esriFieldTypeDate", "alias": "Contract Awarded Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "contract_awarded_date" }, { "name": "under_construction_date", "type": "esriFieldTypeDate", "alias": "Under Construction Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "under_construction_date" }, { "name": "construction_completed_date", "type": "esriFieldTypeDate", "alias": "Construction Completed Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "construction_completed_date" }, { "name": "project_status", "type": "esriFieldTypeString", "alias": "Project Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_status" }, { "name": "cswap_plant_type", "type": "esriFieldTypeString", "alias": "CSWAP Plant Type", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "cswap_plant_type" }, { "name": "cswap_plant_sub_type", "type": "esriFieldTypeString", "alias": "CSWAP Plant Sub Type", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "cswap_plant_sub_type" }, { "name": "cswap_cap_approved_plan", "type": "esriFieldTypeString", "alias": "CSWAP CAP APP PLAN", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "cswap_cap_approved_plan" }, { "name": "cswap_cap_current_plan", "type": "esriFieldTypeString", "alias": "CSWAP CAP CURR PLAN", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "cswap_cap_current_plan" }, { "name": "csap_type", "type": "esriFieldTypeString", "alias": "CSAP TYPE", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "csap_type" }, { "name": "csap_toi_no", "type": "esriFieldTypeDouble", "alias": "CSAP TOI No", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_toi_no" }, { "name": "csap_wt_subtype", "type": "esriFieldTypeString", "alias": "CSAP WT SUBTYPE", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "csap_wt_subtype" }, { "name": "csap_wt_length_km", "type": "esriFieldTypeDouble", "alias": "CSAP LT KM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_length_km" }, { "name": "csap_wt_stp_plant_no", "type": "esriFieldTypeDouble", "alias": "CSAP WT PLANT NO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_stp_plant_no" }, { "name": "csap_wt_stp_design_cap", "type": "esriFieldTypeString", "alias": "CSAP WTSTP DESIGN", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "csap_wt_stp_design_cap" }, { "name": "csap_wt_desludge_vehicles_no", "type": "esriFieldTypeDouble", "alias": "CSAP VEH NO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_desludge_vehicles_no" }, { "name": "csap_wt_desludge_cap", "type": "esriFieldTypeString", "alias": "CSAP WT DE CAP", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "csap_wt_desludge_cap" }, { "name": "csap_wt_sewer_equipment_no", "type": "esriFieldTypeDouble", "alias": "CSAP WT SEWER No", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_sewer_equipment_no" }, { "name": "csap_toi_no_current", "type": "esriFieldTypeDouble", "alias": "CSAP TOI NO CURR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_toi_no_current" }, { "name": "csap_wat_length_km_current", "type": "esriFieldTypeDouble", "alias": "CSAP WAT LT KM CURR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wat_length_km_current" }, { "name": "csap_wt_stp_plant_no_current", "type": "esriFieldTypeDouble", "alias": "CSAP WT STP PLANT NO CURR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_stp_plant_no_current" }, { "name": "csap_wt_stp_design_cap_curren", "type": "esriFieldTypeString", "alias": "CSAP WT STP DES CAP CURR", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "csap_wt_stp_design_cap_curren" }, { "name": "csap_wt_desludge_veh_no_curre", "type": "esriFieldTypeDouble", "alias": "CSAP WT DESLUDGE VEH NO CURR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_desludge_veh_no_curre" }, { "name": "csap_wt_desludge_cap_current", "type": "esriFieldTypeString", "alias": "CSAP WT DESLUDGE CAP CURR", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "csap_wt_desludge_cap_current" }, { "name": "csap_wt_sewer_equip_no_curr", "type": "esriFieldTypeDouble", "alias": "CSAP WT SEWER EQUIP NO CURR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "csap_wt_sewer_equip_no_curr" } ], "geometryField": { "name": "shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "shape" }, "indexes": [ { "name": "r58_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "a43_ix1", "fields": "shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GMIS Project Details", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "4a03d1023cbc4e42977c9f4366445f35" } ], "tables": [ { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 1, "name": "GMIS Project Imp Dates", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "project_object_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "project_object_id", "type": "esriFieldTypeInteger", "alias": "Project Object ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "project_object_id" }, { "name": "project_mis_id", "type": "esriFieldTypeString", "alias": "Project MIS ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_mis_id" }, { "name": "project_imp_type", "type": "esriFieldTypeString", "alias": "Project Implementation Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_imp_type" }, { "name": "expired_flag", "type": "esriFieldTypeString", "alias": "Expired Flag", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": "N", "modelName": "expired_flag" }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "start_date" }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "end_date" }, { "name": "created_by", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_by" }, { "name": "updated_by", "type": "esriFieldTypeString", "alias": "Updated By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "updated_by" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "r59_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GMIS Project Imp Dates", "description": "", "prototype": { "attributes": { "updated_by": null, "created_by": null, "project_object_id": null, "project_mis_id": null, "project_imp_type": null, "expired_flag": "N", "start_date": null, "end_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "4a03d1023cbc4e42977c9f4366445f35" }, { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 2, "name": "GMIS Project Progress Detail", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "project_object_id", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "project_object_id", "type": "esriFieldTypeInteger", "alias": "Project Object ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "project_object_id" }, { "name": "project_mis_id", "type": "esriFieldTypeString", "alias": "Project MIS ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_mis_id" }, { "name": "progress_report_date", "type": "esriFieldTypeDate", "alias": "Progress Report Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "progress_report_date" }, { "name": "milestone", "type": "esriFieldTypeString", "alias": "Milestone", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "milestone" }, { "name": "financial_detail", "type": "esriFieldTypeDouble", "alias": "Financial Detail", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "financial_detail" }, { "name": "physcial_progress_percentage", "type": "esriFieldTypeDouble", "alias": "Physcial Progress Percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "physcial_progress_percentage" }, { "name": "expired_flag", "type": "esriFieldTypeString", "alias": "Expired Flag", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": "N", "modelName": "expired_flag" }, { "name": "created_by", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_by" }, { "name": "updated_by", "type": "esriFieldTypeString", "alias": "Updated By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "updated_by" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "r60_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_60", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GMIS Project Progress Detail", "description": "", "prototype": { "attributes": { "updated_by": null, "created_by": null, "project_object_id": null, "project_mis_id": null, "progress_report_date": null, "milestone": null, "financial_detail": 0, "physcial_progress_percentage": null, "expired_flag": "N" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "attachmentid", "isEnabled": true }, { "name": "globalId", "fieldName": "globalid", "isEnabled": true }, { "name": "name", "fieldName": "att_name", "isEnabled": true }, { "name": "size", "fieldName": "data_size", "isEnabled": true }, { "name": "contentType", "fieldName": "content_type", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "attachmentid", "type": "esriFieldTypeOID", "alias": "attachmentid", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "att_name", "type": "esriFieldTypeString", "alias": "att_name", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "data_size", "type": "esriFieldTypeInteger", "alias": "data_size", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "content_type", "type": "esriFieldTypeString", "alias": "content_type", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "4a03d1023cbc4e42977c9f4366445f35" }, { "currentVersion": 10.9, "cimVersion": "2.7.0", "id": 3, "name": "Category Selector", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "objectid", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "category_type", "type": "esriFieldTypeString", "alias": "category_type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "category_type" }, { "name": "category_sub_type", "type": "esriFieldTypeString", "alias": "category_sub_type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "category_sub_type" }, { "name": "expired_flag", "type": "esriFieldTypeString", "alias": "expired_flag", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "expired_flag" } ], "indexes": [ { "name": "r62_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Category Selector", "description": "", "prototype": { "attributes": { "category_sub_type": null, "expired_flag": null, "category_type": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "4a03d1023cbc4e42977c9f4366445f35" } ] }