{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Review", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "project_scope_of_work": null, "project_construction_on_schedul": null, "actual_s_1": null, "current_status_notes": null, "total_project_budget": null, "contractual_substantial_complet": null, "anticipated_substantial_complet": null, "budget_needed": null, "completion_date__end_of_closeou": null, "project_name": null, "project__1": null, "actual_phase_completion_date": null, "construction_ntp": null, "final_completion_actual_substan": null, "actual_final_completion_date": null, "geocoded_address": null, "risks_in_current_phase": null, "actual_substantial_completion_d": null, "anticipated_final_completion_da": null, "fiscal_year": null, "funding_source": null, "multiple_bid_packages": null, "project_design_on_schedule": null, "funded_budget": null, "contractual_bid_advertisement_d": null, "start_date__planning_phase_": null, "project_manager": null, "city_associated_cost": null, "phase": null, "funded_budget_notes": null, "dcm_portolio": null, "design_and_construction_contrac": null, "actual_completion_date": null, "federal_associated_cost": null, "total_project_on_schedule": null, "anticipated_planning_completion": null, "planning_phase_initiation_date": null, "current_phase_completion_date": null, "anticipated_bid_advertisement_d": null, "project_number": null, "actual_bid_advertisement_date": null, "current_phase_notes": null, "client_department": null, "current_status": null, "project_planning_on_schedule": null, "contractual_design_ntp": null, "edit_tracking_information": null, "county_associated_cost": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Review", "displayField": "project_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "project_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_name", "length": 255, "alias": "Project Name", "type": "esriFieldTypeString" }, { "modelName": "project_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_number", "length": 255, "alias": "Project Number", "type": "esriFieldTypeString" }, { "modelName": "project_manager", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_manager", "length": 255, "alias": "Project Manager", "type": "esriFieldTypeString" }, { "modelName": "project_scope_of_work", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_scope_of_work", "length": 825, "alias": "Project Scope of Work", "type": "esriFieldTypeString" }, { "modelName": "multiple_bid_packages", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multiple_bid_packages", "length": 255, "alias": "Multiple Bid Packages", "type": "esriFieldTypeString" }, { "modelName": "dcm_portolio", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dcm_portolio", "length": 255, "alias": "DCM Portolio", "type": "esriFieldTypeString" }, { "modelName": "current_status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_status", "length": 703, "alias": "Current Status", "type": "esriFieldTypeString" }, { "modelName": "current_status_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_status_notes", "length": 1685, "alias": "Current Status Notes", "type": "esriFieldTypeString" }, { "modelName": "risks_in_current_phase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "risks_in_current_phase", "length": 385, "alias": "Risks in current phase", "type": "esriFieldTypeString" }, { "modelName": "phase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phase", "length": 255, "alias": "Phase", "type": "esriFieldTypeString" }, { "modelName": "current_phase_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_phase_notes", "length": 255, "alias": "Current Phase Notes", "type": "esriFieldTypeString" }, { "modelName": "current_phase_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_phase_completion_date", "length": 255, "alias": "Current Phase Completion Date", "type": "esriFieldTypeString" }, { "modelName": "anticipated_final_completion_da", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_final_completion_da", "length": 255, "alias": "Anticipated Final Completion Date", "type": "esriFieldTypeString" }, { "modelName": "fiscal_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fiscal_year", "length": 255, "alias": "Fiscal Year", "type": "esriFieldTypeString" }, { "modelName": "funding_source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funding_source", "length": 255, "alias": "Funding Source", "type": "esriFieldTypeString" }, { "modelName": "total_project_budget", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_project_budget", "length": 255, "alias": "Total Project Budget", "type": "esriFieldTypeString" }, { "modelName": "funded_budget", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funded_budget", "alias": "Funded Budget", "type": "esriFieldTypeInteger" }, { "modelName": "funded_budget_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funded_budget_notes", "length": 255, "alias": "Funded Budget Notes", "type": "esriFieldTypeString" }, { "modelName": "budget_needed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "budget_needed", "length": 255, "alias": "Budget Needed ", "type": "esriFieldTypeString" }, { "modelName": "city_associated_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city_associated_cost", "alias": "City Associated Cost", "type": "esriFieldTypeDouble" }, { "modelName": "county_associated_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county_associated_cost", "length": 255, "alias": "County Associated Cost", "type": "esriFieldTypeString" }, { "modelName": "federal_associated_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_associated_cost", "alias": "Federal Associated Cost", "type": "esriFieldTypeDouble" }, { "modelName": "client_department", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "client_department", "length": 255, "alias": "Client Department ", "type": "esriFieldTypeString" }, { "modelName": "planning_phase_initiation_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planning_phase_initiation_date", "length": 255, "alias": "Planning Phase Initiation Date", "type": "esriFieldTypeString" }, { "modelName": "design_and_construction_contrac", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "design_and_construction_contrac", "length": 255, "alias": "Design and Construction Contract Start Date", "type": "esriFieldTypeString" }, { "modelName": "anticipated_planning_completion", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_planning_completion", "length": 255, "alias": "Anticipated Planning Completion Date", "type": "esriFieldTypeString" }, { "modelName": "actual_phase_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_phase_completion_date", "length": 255, "alias": "Actual Phase Completion Date", "type": "esriFieldTypeString" }, { "modelName": "project_planning_on_schedule", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_planning_on_schedule", "length": 255, "alias": "Project Planning On Schedule", "type": "esriFieldTypeString" }, { "modelName": "contractual_design_ntp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractual_design_ntp", "length": 255, "alias": "Contractual Design NTP", "type": "esriFieldTypeString" }, { "modelName": "contractual_bid_advertisement_d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractual_bid_advertisement_d", "length": 255, "alias": "Contractual Bid Advertisement Date ", "type": "esriFieldTypeString" }, { "modelName": "anticipated_bid_advertisement_d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_bid_advertisement_d", "length": 255, "alias": "Anticipated Bid Advertisement Date", "type": "esriFieldTypeString" }, { "modelName": "actual_bid_advertisement_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_bid_advertisement_date", "length": 255, "alias": "Actual Bid Advertisement Date", "type": "esriFieldTypeString" }, { "modelName": "project_design_on_schedule", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_design_on_schedule", "length": 255, "alias": "Project Design On Schedule", "type": "esriFieldTypeString" }, { "modelName": "construction_ntp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "construction_ntp", "length": 255, "alias": "Construction NTP", "type": "esriFieldTypeString" }, { "modelName": "contractual_substantial_complet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractual_substantial_complet", "length": 255, "alias": "Contractual Substantial Completion date", "type": "esriFieldTypeString" }, { "modelName": "anticipated_substantial_complet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_substantial_complet", "length": 255, "alias": "Anticipated Substantial Completion Date", "type": "esriFieldTypeString" }, { "modelName": "actual_substantial_completion_d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_substantial_completion_d", "length": 255, "alias": "Actual Substantial Completion Date", "type": "esriFieldTypeString" }, { "modelName": "project_construction_on_schedul", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_construction_on_schedul", "length": 255, "alias": "Project Construction On Schedule", "type": "esriFieldTypeString" }, { "modelName": "actual_s_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_s_1", "length": 255, "alias": "Actual Substantial Completion Date", "type": "esriFieldTypeString" }, { "modelName": "final_completion_actual_substan", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "final_completion_actual_substan", "length": 255, "alias": "Final Completion Actual Substantial Completion 60 Days", "type": "esriFieldTypeString" }, { "modelName": "actual_final_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_final_completion_date", "length": 255, "alias": "Actual Final Completion Date", "type": "esriFieldTypeString" }, { "modelName": "project__1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project__1", "length": 255, "alias": "Project Construction On Schedule", "type": "esriFieldTypeString" }, { "modelName": "start_date__planning_phase_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_date__planning_phase_", "length": 255, "alias": "Start Date (Planning Phase)", "type": "esriFieldTypeString" }, { "modelName": "completion_date__end_of_closeou", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completion_date__end_of_closeou", "length": 255, "alias": "Completion date (End of closeout)", "type": "esriFieldTypeString" }, { "modelName": "actual_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_completion_date", "length": 255, "alias": "Actual Completion Date", "type": "esriFieldTypeString" }, { "modelName": "total_project_on_schedule", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_project_on_schedule", "length": 255, "alias": "Total Project On Schedule", "type": "esriFieldTypeString" }, { "modelName": "edit_tracking_information", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edit_tracking_information", "length": 255, "alias": "Edit Tracking Information", "type": "esriFieldTypeString" }, { "modelName": "geocoded_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geocoded_address", "length": 255, "alias": "Geocoded Address", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "indexes": [ { "name": "r1227_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_1227", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "5cfa8160768a440b8ca987fdecb9604f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Uploads,Sync", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": "NaN", "xmin": "NaN", "ymax": "NaN", "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "New Feature", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "project_construction_on_schedul": null, "actual_s_1": null, "total_project_budget": null, "bldgnum": null, "anticipated_substantial_complet": null, "completion_date__end_of_closeou": null, "project_name": null, "project__1": null, "actual_phase_completion_date": null, "suitenum": null, "anticipated_final_completion_da": null, "fiscal_year": null, "funding_source": null, "project_design_on_schedule": null, "start_date__planning_phase_": null, "project_manager": null, "city_associated_cost": null, "longitude": null, "phase": null, "funded_budget_notes": null, "total_project_on_schedule": null, "anticipated_planning_completion": null, "planning_phase_initiation_date": null, "zipcode": null, "anticipated_bid_advertisement_d": null, "actual_bid_advertisement_date": null, "current_phase_notes": null, "client_department": null, "current_status": null, "contractual_design_ntp": null, "county_associated_cost": null, "project_scope_of_work": null, "city": null, "current_status_notes": null, "contractual_substantial_complet": null, "latitude": null, "budget_needed": null, "atimestamp": null, "construction_ntp": null, "final_completion_actual_substan": null, "actual_final_completion_date": null, "risks_in_current_phase": null, "actual_substantial_completion_d": null, "geocoded_address": null, "multiple_bid_packages": null, "funded_budget": null, "contractual_bid_advertisement_d": null, "dcm_portolio": null, "actual_completion_date": null, "design_and_construction_contrac": null, "address": null, "federal_associated_cost": null, "current_phase_completion_date": null, "project_number": null, "project_planning_on_schedule": null, "edit_tracking_information": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Sheet1", "allowTrueCurvesUpdates": false, "displayField": "project_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "project_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_name", "length": 255, "alias": "Project Name", "type": "esriFieldTypeString" }, { "modelName": "project_number", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_number", "length": 255, "alias": "Project Number", "type": "esriFieldTypeString" }, { "modelName": "project_manager", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_manager", "length": 255, "alias": "Project Manager", "type": "esriFieldTypeString" }, { "modelName": "project_scope_of_work", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_scope_of_work", "length": 825, "alias": "Project Scope of Work", "type": "esriFieldTypeString" }, { "modelName": "multiple_bid_packages", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "multiple_bid_packages", "length": 255, "alias": "Multiple Bid Packages", "type": "esriFieldTypeString" }, { "modelName": "dcm_portolio", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dcm_portolio", "length": 255, "alias": "DCM Portolio", "type": "esriFieldTypeString" }, { "modelName": "current_status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_status", "length": 703, "alias": "Current Status", "type": "esriFieldTypeString" }, { "modelName": "current_status_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_status_notes", "length": 1685, "alias": "Current Status Notes", "type": "esriFieldTypeString" }, { "modelName": "risks_in_current_phase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "risks_in_current_phase", "length": 385, "alias": "Risks in current phase", "type": "esriFieldTypeString" }, { "modelName": "phase", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phase", "length": 255, "alias": "Phase", "type": "esriFieldTypeString" }, { "modelName": "current_phase_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_phase_notes", "length": 255, "alias": "Current Phase Notes", "type": "esriFieldTypeString" }, { "modelName": "current_phase_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "current_phase_completion_date", "length": 255, "alias": "Current Phase Completion Date", "type": "esriFieldTypeString" }, { "modelName": "anticipated_final_completion_da", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_final_completion_da", "length": 255, "alias": "Anticipated Final Completion Date", "type": "esriFieldTypeString" }, { "modelName": "fiscal_year", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "fiscal_year", "length": 255, "alias": "Fiscal Year", "type": "esriFieldTypeString" }, { "modelName": "funding_source", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funding_source", "length": 255, "alias": "Funding Source", "type": "esriFieldTypeString" }, { "modelName": "total_project_budget", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_project_budget", "length": 255, "alias": "Total Project Budget", "type": "esriFieldTypeString" }, { "modelName": "funded_budget", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funded_budget", "alias": "Funded Budget", "type": "esriFieldTypeInteger" }, { "modelName": "funded_budget_notes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "funded_budget_notes", "length": 255, "alias": "Funded Budget Notes", "type": "esriFieldTypeString" }, { "modelName": "budget_needed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "budget_needed", "length": 255, "alias": "Budget Needed ", "type": "esriFieldTypeString" }, { "modelName": "city_associated_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city_associated_cost", "alias": "City Associated Cost", "type": "esriFieldTypeDouble" }, { "modelName": "county_associated_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county_associated_cost", "length": 255, "alias": "County Associated Cost", "type": "esriFieldTypeString" }, { "modelName": "federal_associated_cost", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "federal_associated_cost", "alias": "Federal Associated Cost", "type": "esriFieldTypeDouble" }, { "modelName": "client_department", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "client_department", "length": 255, "alias": "Client Department ", "type": "esriFieldTypeString" }, { "modelName": "planning_phase_initiation_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planning_phase_initiation_date", "length": 255, "alias": "Planning Phase Initiation Date", "type": "esriFieldTypeString" }, { "modelName": "design_and_construction_contrac", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "design_and_construction_contrac", "length": 255, "alias": "Design and Construction Contract Start Date", "type": "esriFieldTypeString" }, { "modelName": "anticipated_planning_completion", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_planning_completion", "length": 255, "alias": "Anticipated Planning Completion Date", "type": "esriFieldTypeString" }, { "modelName": "actual_phase_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_phase_completion_date", "length": 255, "alias": "Actual Phase Completion Date", "type": "esriFieldTypeString" }, { "modelName": "project_planning_on_schedule", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_planning_on_schedule", "length": 255, "alias": "Project Planning On Schedule", "type": "esriFieldTypeString" }, { "modelName": "contractual_design_ntp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractual_design_ntp", "length": 255, "alias": "Contractual Design NTP", "type": "esriFieldTypeString" }, { "modelName": "contractual_bid_advertisement_d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractual_bid_advertisement_d", "length": 255, "alias": "Contractual Bid Advertisement Date ", "type": "esriFieldTypeString" }, { "modelName": "anticipated_bid_advertisement_d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_bid_advertisement_d", "length": 255, "alias": "Anticipated Bid Advertisement Date", "type": "esriFieldTypeString" }, { "modelName": "actual_bid_advertisement_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_bid_advertisement_date", "length": 255, "alias": "Actual Bid Advertisement Date", "type": "esriFieldTypeString" }, { "modelName": "project_design_on_schedule", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_design_on_schedule", "length": 255, "alias": "Project Design On Schedule", "type": "esriFieldTypeString" }, { "modelName": "construction_ntp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "construction_ntp", "length": 255, "alias": "Construction NTP", "type": "esriFieldTypeString" }, { "modelName": "contractual_substantial_complet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contractual_substantial_complet", "length": 255, "alias": "Contractual Substantial Completion date", "type": "esriFieldTypeString" }, { "modelName": "anticipated_substantial_complet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "anticipated_substantial_complet", "length": 255, "alias": "Anticipated Substantial Completion Date", "type": "esriFieldTypeString" }, { "modelName": "actual_substantial_completion_d", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_substantial_completion_d", "length": 255, "alias": "Actual Substantial Completion Date", "type": "esriFieldTypeString" }, { "modelName": "project_construction_on_schedul", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project_construction_on_schedul", "length": 255, "alias": "Project Construction On Schedule", "type": "esriFieldTypeString" }, { "modelName": "actual_s_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_s_1", "length": 255, "alias": "Actual Substantial Completion Date", "type": "esriFieldTypeString" }, { "modelName": "final_completion_actual_substan", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "final_completion_actual_substan", "length": 255, "alias": "Final Completion Actual Substantial Completion 60 Days", "type": "esriFieldTypeString" }, { "modelName": "actual_final_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_final_completion_date", "length": 255, "alias": "Actual Final Completion Date", "type": "esriFieldTypeString" }, { "modelName": "project__1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project__1", "length": 255, "alias": "Project Construction On Schedule", "type": "esriFieldTypeString" }, { "modelName": "start_date__planning_phase_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "start_date__planning_phase_", "length": 255, "alias": "Start Date (Planning Phase)", "type": "esriFieldTypeString" }, { "modelName": "completion_date__end_of_closeou", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "completion_date__end_of_closeou", "length": 255, "alias": "Completion date (End of closeout)", "type": "esriFieldTypeString" }, { "modelName": "actual_completion_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "actual_completion_date", "length": 255, "alias": "Actual Completion Date", "type": "esriFieldTypeString" }, { "modelName": "total_project_on_schedule", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "total_project_on_schedule", "length": 255, "alias": "Total Project On Schedule", "type": "esriFieldTypeString" }, { "modelName": "edit_tracking_information", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "edit_tracking_information", "length": 255, "alias": "Edit Tracking Information", "type": "esriFieldTypeString" }, { "modelName": "geocoded_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geocoded_address", "length": 255, "alias": "Geocoded Address", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "editable": true, "defaultValue": null, "name": "address", "length": 256, "alias": "Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "bldgnum", "length": 100, "alias": "Suite Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 20, "alias": "City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "zipcode", "length": 10, "alias": "Zip Code", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "suitenum", "length": 100, "alias": "Suite Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "atimestamp", "length": 29, "alias": "Submission Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r1226_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a1012_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_1226", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "5cfa8160768a440b8ca987fdecb9604f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Uploads,Sync", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 }, "color": [ 88, 166, 0, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint" } ] }