Name: database_survey_join

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• project_name (type: esriFieldTypeString, alias: project_name, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• F2__State (type: esriFieldTypeString, alias: 2. State, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• F3__County (type: esriFieldTypeString, alias: 3. County, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• F4__City (type: esriFieldTypeString, alias: 4. City, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• F5__CWIS_Number (type: esriFieldTypeInteger, alias: 5. CWIS Number, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F6__River (type: esriFieldTypeInteger, alias: 6. River, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F7__River_Basin (type: esriFieldTypeInteger, alias: 7. River Basin, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F8__Type_of_FCW (type: esriFieldTypeInteger, alias: 8. Type of FCW, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F9__Other_Purpose (type: esriFieldTypeInteger, alias: 9. Other Purpose, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F10__Public_Sponsor (type: esriFieldTypeInteger, alias: 10. Public Sponsor, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F11__Point_of_Contact (type: esriFieldTypeInteger, alias: 11. Point of Contact, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F12__Public_Sponsor_s_Address_P (type: esriFieldTypeInteger, alias: F12__Public_Sponsor_s_Address_P, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F13__Owners_Percentage_of_Owner (type: esriFieldTypeInteger, alias: F13__Owners_Percentage_of_Owner, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F14__Dimensions (type: esriFieldTypeInteger, alias: 14. Dimensions, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F15__Material (type: esriFieldTypeInteger, alias: 15. Material, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F16__Drainage_Area (type: esriFieldTypeInteger, alias: 16. Drainage Area, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F17__Level_of_Protection (type: esriFieldTypeInteger, alias: 17. Level of Protection, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F18__Freeboard (type: esriFieldTypeInteger, alias: 18. Freeboard, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F19__Geotechnical (type: esriFieldTypeInteger, alias: 19. Geotechnical, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F20__Hydraulic_Design (type: esriFieldTypeInteger, alias: 20. Hydraulic Design, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F21__Gage_Locations (type: esriFieldTypeInteger, alias: 21. Gage Locations, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F22__Area_Protected (type: esriFieldTypeInteger, alias: 22. Area Protected, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F23__Land_Use_Value (type: esriFieldTypeInteger, alias: 23. Land Use/Value, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F24__Historic_Floods (type: esriFieldTypeInteger, alias: 24. Historic Floods, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F25__Previous_Repairs (type: esriFieldTypeInteger, alias: 25. Previous Repairs, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F26__Active_Inactive (type: esriFieldTypeInteger, alias: 26. Active/Inactive, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F27__1st_Inspection (type: esriFieldTypeInteger, alias: 27. 1st Inspection, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F28__Project_Condition (type: esriFieldTypeInteger, alias: 28. Project Condition, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F29__Dates_of_Later_Inspections (type: esriFieldTypeInteger, alias: 29. Dates of Later Inspections, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F30__Last_IEI (type: esriFieldTypeInteger, alias: 30. Last IEI, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F31__Deficiencies (type: esriFieldTypeInteger, alias: 31. Deficiencies, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F32__Inspectors (type: esriFieldTypeInteger, alias: 32. Inspectors, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F33_a_Inspections_Dates (type: esriFieldTypeInteger, alias: 33.a Inspections Dates, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F33_b__Inspections_Ratings (type: esriFieldTypeInteger, alias: 33.b. Inspections Ratings, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F33_c__Inspections_Results (type: esriFieldTypeInteger, alias: 33.c. Inspections Results, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Join_Count (type: esriFieldTypeInteger, alias: Join Count, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• objectID_1_1 (type: esriFieldTypeInteger, alias: objectID 1 1, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeString, alias: CreationDate, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• EditDate (type: esriFieldTypeString, alias: EditDate, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Date (type: esriFieldTypeString, alias: Date, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Corps_of_Engineers_Inspectors (type: esriFieldTypeString, alias: Corps_of_Engineers_Inspectors, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Public_Sponsor_Representatives (type: esriFieldTypeString, alias: Public_Sponsor_Representatives, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Is_this_an_Initial_Eligibility_ (type: esriFieldTypeString, alias: Is_this_an_Initial_Eligibility_, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Depressions (type: esriFieldTypeString, alias: Depressions, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Erosion (type: esriFieldTypeString, alias: Erosion, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Slope_Stability (type: esriFieldTypeString, alias: Slope Stability, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Cracking (type: esriFieldTypeString, alias: Cracking, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Animal_Control (type: esriFieldTypeString, alias: Animal Control, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Unwanted_Vegetation_Growth (type: esriFieldTypeString, alias: Unwanted Vegetation Growth, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Encroachments (type: esriFieldTypeString, alias: Encroachments, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Riprap_Revetments_Banks (type: esriFieldTypeString, alias: Riprap/Revetments/Banks, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Stability_of_Concrete_Structure (type: esriFieldTypeString, alias: Stability_of_Concrete_Structure, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Concrete_Surfaces (type: esriFieldTypeString, alias: Concrete Surfaces, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Structural_Foundations (type: esriFieldTypeString, alias: Structural Foundations, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Culverts (type: esriFieldTypeString, alias: Culverts, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Gates (type: esriFieldTypeString, alias: Gates, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Closure_Structures (type: esriFieldTypeString, alias: Closure Structures, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Motors (type: esriFieldTypeString, alias: Motors, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Power (type: esriFieldTypeString, alias: Power, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Metallic_Items (type: esriFieldTypeString, alias: Metallic Items, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Level_of_Protection (type: esriFieldTypeString, alias: Level of Protection, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Erosion_Control (type: esriFieldTypeString, alias: Erosion Control, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Embankment (type: esriFieldTypeString, alias: Embankment, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Foundation (type: esriFieldTypeString, alias: Foundation, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Structures (type: esriFieldTypeString, alias: Structures, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Does_this_project_have_a_pump_s (type: esriFieldTypeString, alias: Does_this_project_have_a_pump_s, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Pump_Station_Size (type: esriFieldTypeString, alias: Pump Station Size, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Operations_and_Maintenance_Manu (type: esriFieldTypeString, alias: Operations_and_Maintenance_Manu, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Operating_Log (type: esriFieldTypeString, alias: Operating Log, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Annual_Inspection (type: esriFieldTypeString, alias: Annual Inspection, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Plant_Building (type: esriFieldTypeString, alias: Plant Building, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Pumps (type: esriFieldTypeString, alias: Pumps, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Motors__Engines__and_Gear_Reduc (type: esriFieldTypeString, alias: Motors__Engines__and_Gear_Reduc, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Trash_Rakes (type: esriFieldTypeString, alias: Trash Rakes, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Other_Metallic_Items (type: esriFieldTypeString, alias: Other Metallic Items, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Insulation_and_Megger_Testing (type: esriFieldTypeString, alias: Insulation and Megger Testing, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Pump_Power (type: esriFieldTypeString, alias: Pump Power, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Pump_Control_System (type: esriFieldTypeString, alias: Pump Control System, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Sumps (type: esriFieldTypeString, alias: Sumps, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Intake_Discharge_Gates (type: esriFieldTypeString, alias: Intake/Discharge Gates, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Cranes (type: esriFieldTypeString, alias: Cranes, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Telephone_Communications (type: esriFieldTypeString, alias: Telephone Communications, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Safety (type: esriFieldTypeString, alias: Safety, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Remarks_for_Pump_station (type: esriFieldTypeString, alias: Remarks for Pump station, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Summary_of_Inspection (type: esriFieldTypeString, alias: Summary of Inspection, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeNVarchar, length: 255, nullable: true, editable: true)
• x (type: esriFieldTypeDouble, alias: x, SQL Type: sqlTypeDecimal, nullable: true, editable: true)
• y (type: esriFieldTypeDouble, alias: y, SQL Type: sqlTypeDecimal, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat