Layers:

Layer: Dam Locations (0)

Name: Dam Locations

Display Field: dam_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -1.081851816918504E7
YMin: 5332096.093056434
XMax: -9979929.576467315
YMax: 6284691.025938173
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: owner_type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Other
UniqueValueInfos:
• Value: Federal
  Label: Federal
  Description: N/A
  Symbol:
  
• Value: Local Govt
  Label: Local Govt
  Description: N/A
  Symbol:
  
• Value: Private
  Label: Private
  Description: N/A
  Symbol:
  
• Value: State
  Label: State
  Description: N/A
  Symbol:
  
• Value: Utilities
  Label: Utilities
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• dam_name ( type: esriFieldTypeString, alias: dam_name, length: 100 )
• nid_id ( type: esriFieldTypeString, alias: nid_id, length: 7 )
• county ( type: esriFieldTypeString, alias: county, length: 25 , Coded Values: [Aitkin: Aitkin] , [Anoka: Anoka] , [Becker: Becker] , ...84 more... )
• links ( type: esriFieldTypeString, alias: links, length: 250 )
• hazard ( type: esriFieldTypeString, alias: hazard, length: 20 , Coded Values: [High: High] , [Low: Low] , [No Hazard: No Hazard] , ...1 more... )
• status_of_dam ( type: esriFieldTypeString, alias: status_of_dam, length: 25 , Coded Values: [Active: Active] , [Check: Check] , [Inactive: Inactive] )
• status_description ( type: esriFieldTypeString, alias: status_description, length: 50 , Coded Values: [< 6 feet: < 6 feet] , [<15 AF: <15 AF] , [Federal: Federal] , ...5 more... )
• state_reg ( type: esriFieldTypeString, alias: state_reg, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• comments ( type: esriFieldTypeString, alias: comments, length: 400 )
• owner_type ( type: esriFieldTypeString, alias: owner_type, length: 25 , Coded Values: [Federal: Federal] , [Local Govt: Local Govt] , [Private: Private] , ...2 more... )
• permitting_auth ( type: esriFieldTypeString, alias: permitting_auth, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• inspection_auth ( type: esriFieldTypeString, alias: inspection_auth, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• enforcement_auth ( type: esriFieldTypeString, alias: enforcement_auth, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• nonfed_dam ( type: esriFieldTypeString, alias: nonfed_dam, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• state_agency ( type: esriFieldTypeString, alias: state_agency, length: 9 )
• other_dam_name ( type: esriFieldTypeString, alias: other_dam_name, length: 100 )
• dam_former ( type: esriFieldTypeString, alias: dam_former, length: 100 )
• date_entered ( type: esriFieldTypeDate, alias: date_entered, length: 8 )
• development ( type: esriFieldTypeString, alias: development, length: 10 , Coded Values: [High: High] , [Low: Low] , [Moderate: Moderate] )
• utmx ( type: esriFieldTypeInteger, alias: utmx )
• utmy ( type: esriFieldTypeInteger, alias: utmy )
• sect_town ( type: esriFieldTypeString, alias: sect_town, length: 25 )
• river ( type: esriFieldTypeString, alias: river, length: 100 )
• dnr_area ( type: esriFieldTypeInteger, alias: dnr_area )
• dnr_region ( type: esriFieldTypeSmallInteger, alias: dnr_region , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• near_city ( type: esriFieldTypeString, alias: near_city, length: 50 )
• dist_city ( type: esriFieldTypeSingle, alias: dist_city )
• longitude_x ( type: esriFieldTypeDouble, alias: longitude_x )
• latitude_y ( type: esriFieldTypeDouble, alias: latitude_y )
• year_completed ( type: esriFieldTypeInteger, alias: year_completed )
• present_purpose ( type: esriFieldTypeString, alias: present_purpose, length: 50 , Coded Values: [Diversion: Diversion] , [Fish and Wildlife: Fish and Wildlife] , [Fish barrier: Fish barrier] , ...9 more... )
• top_dam_elev ( type: esriFieldTypeDouble, alias: top_dam_elev , Range: [0, 3000] )
• prin_spill_elev ( type: esriFieldTypeDouble, alias: prin_spill_elev , Range: [0, 3000] )
• datum_elev ( type: esriFieldTypeString, alias: datum_elev, length: 50 , Coded Values: [1912 MSL: 1912 MSL] , [1929 NGVD: 1929 NGVD] , [1988 NAVD: 1988 NAVD] , ...2 more... )
• top_dam_hgt ( type: esriFieldTypeSingle, alias: top_dam_hgt , Range: [0, 500] )
• prin_spill_hgt ( type: esriFieldTypeSingle, alias: prin_spill_hgt , Range: [0, 500] )
• dam_type ( type: esriFieldTypeString, alias: dam_type, length: 20 , Coded Values: [CB: CB] , [CN: CN] , [ER: ER] , ...10 more... )
• struct_hgt ( type: esriFieldTypeSingle, alias: struct_hgt , Range: [0, 500] )
• nid_height ( type: esriFieldTypeSingle, alias: nid_height )
• core ( type: esriFieldTypeString, alias: core, length: 3 , Coded Values: [FAK: FAK] , [FAZ: FAZ] , [FCK: FCK] , ...46 more... )
• foundation ( type: esriFieldTypeString, alias: foundation, length: 3 , Coded Values: [RK: RK] , [RSK: RSK] , [RSU: RSU] , ...7 more... )
• dam_length ( type: esriFieldTypeInteger, alias: dam_length , Range: [0, 100000] )
• rock_weir ( type: esriFieldTypeString, alias: rock_weir, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• spill_type ( type: esriFieldTypeString, alias: spill_type, length: 1 , Coded Values: [C: C] , [N: N] , [U: U] )
• spill_width ( type: esriFieldTypeSingle, alias: spill_width , Range: [0, 1000] )
• outlet_gate ( type: esriFieldTypeString, alias: outlet_gate, length: 100 )
• volume ( type: esriFieldTypeInteger, alias: volume )
• max_store ( type: esriFieldTypeDouble, alias: max_store )
• norm_store ( type: esriFieldTypeDouble, alias: norm_store )
• kittle_num ( type: esriFieldTypeString, alias: kittle_num, length: 50 )
• dowlknum ( type: esriFieldTypeString, alias: dowlknum, length: 50 )
• watershed_num ( type: esriFieldTypeInteger, alias: watershed_num )
• nid_storage ( type: esriFieldTypeDouble, alias: nid_storage )
• max_discharge ( type: esriFieldTypeInteger, alias: max_discharge )
• surface_area ( type: esriFieldTypeDouble, alias: surface_area )
• drainage_area ( type: esriFieldTypeDouble, alias: drainage_area )
• eap ( type: esriFieldTypeString, alias: eap, length: 3 , Coded Values: [No: No] , [NR: NR] , [Yes: Yes] )
• eap_organizations_contacts_guid ( type: esriFieldTypeGUID, alias: eap_organizations_contacts_guid, length: 38 )
• eap_organizations_contacts_text ( type: esriFieldTypeString, alias: eap_organizations_contacts_text, length: 100 )
• eap_last_revised ( type: esriFieldTypeDate, alias: eap_last_revised, length: 8 )
• flood_gate_operational ( type: esriFieldTypeString, alias: flood_gate_operational, length: 10 , Coded Values: [No: No] , [Unsure: Unsure] , [Yes: Yes] )
• flood_gate_operational_comment ( type: esriFieldTypeString, alias: flood_gate_operational_comment, length: 50 )
• low_head_dam ( type: esriFieldTypeString, alias: low_head_dam, length: 10 , Coded Values: [No: No] , [Unsure: Unsure] , [Yes: Yes] )
• hydraulic_roller ( type: esriFieldTypeString, alias: hydraulic_roller, length: 10 , Coded Values: [No: No] , [Unsure: Unsure] , [Yes: Yes] )
• hydraulic_roller_removed ( type: esriFieldTypeString, alias: hydraulic_roller_removed, length: 10 , Coded Values: [No: No] , [Unsure: Unsure] , [Yes: Yes] )
• dam_retrofit ( type: esriFieldTypeString, alias: dam_retrofit, length: 50 )
• dam_retrofit_year ( type: esriFieldTypeInteger, alias: dam_retrofit_year )
• luther_rpt_num ( type: esriFieldTypeSmallInteger, alias: luther_rpt_num )
• known_deaths ( type: esriFieldTypeSmallInteger, alias: known_deaths )
• accident_type ( type: esriFieldTypeString, alias: accident_type, length: 50 )
• injury_rescue ( type: esriFieldTypeSmallInteger, alias: injury_rescue )
• number_of_signs ( type: esriFieldTypeSmallInteger, alias: number_of_signs )
• are_signs_needed ( type: esriFieldTypeString, alias: are_signs_needed, length: 10 , Coded Values: [No: No] , [Unsure: Unsure] , [Yes: Yes] )

Relationships:

• repairs (0) -- Related To: Repairs (7)
• dam_designs (2) -- Related To: Dam Designs (2)
• inspections (3) -- Related To: Inspections (3)
• mn_nid_owners (1) -- Related To: mn_nid_owners (4)

Tables:

Table: Contacts (1)

Name: Contacts

Display Field: last_name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• last_name ( type: esriFieldTypeString, alias: last_name, length: 50 )
• first_name ( type: esriFieldTypeString, alias: first_name, length: 50 )
• job_title ( type: esriFieldTypeString, alias: job_title, length: 50 )
• email ( type: esriFieldTypeString, alias: email, length: 50 )
• phone_contact ( type: esriFieldTypeString, alias: phone_contact, length: 15 )
• phone_extension ( type: esriFieldTypeString, alias: phone_extension, length: 10 )
• phone_cell ( type: esriFieldTypeString, alias: phone_cell, length: 15 )
• notes ( type: esriFieldTypeString, alias: notes, length: 300 )
• date_entered ( type: esriFieldTypeDate, alias: date_entered, length: 8 )

Relationships:

• organizations_contacts (4) -- Related To: organizations_contacts (6)

Table: Dam Designs (2)

Name: Dam Designs

Display Field: creator

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• mn_nid_guid ( type: esriFieldTypeGUID, alias: mn_nid_guid, length: 38 )
• organizations_contacts_guid ( type: esriFieldTypeGUID, alias: organizations_contacts_guid, length: 38 )
• organizations_contacts_text ( type: esriFieldTypeString, alias: organizations_contacts_text, length: 100 )
• dam_desig_old ( type: esriFieldTypeString, alias: dam_desig_old, length: 50 )
• year ( type: esriFieldTypeInteger, alias: year )
• year_mod ( type: esriFieldTypeString, alias: year_mod, length: 20 )
• permit_id ( type: esriFieldTypeString, alias: permit_id, length: 10 )
• permit ( type: esriFieldTypeString, alias: permit, length: 10 )
• old_permit ( type: esriFieldTypeString, alias: old_permit, length: 50 )
• signed_date ( type: esriFieldTypeDate, alias: signed_date, length: 8 )
• rec_dwg_recd ( type: esriFieldTypeDate, alias: rec_dwg_recd, length: 8 )
• o_m_plan ( type: esriFieldTypeString, alias: o_m_plan, length: 50 )
• dam_name ( type: esriFieldTypeString, alias: dam_name, length: 100 )

Relationships:

• mn_nid (2) -- Related To: Dam Locations (0)

Table: Inspections (3)

Name: Inspections

Display Field: creator

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• mn_nid_guid ( type: esriFieldTypeGUID, alias: mn_nid_guid, length: 38 )
• inspecting_group ( type: esriFieldTypeString, alias: inspecting_group, length: 50 , Coded Values: [BIA: BIA] , [Check: Check] , [DamSafety: DamSafety] , ...9 more... )
• next_insp_year ( type: esriFieldTypeInteger, alias: next_insp_year , Coded Values: [1111: 1111] , [2017: 2017] , [2018: 2018] , ...14 more... )
• insp_date ( type: esriFieldTypeDate, alias: insp_date, length: 8 )
• rpt_writer_assi ( type: esriFieldTypeString, alias: rpt_writer_assi, length: 25 , Coded Values: [Consultant: Consultant] , [Dan Zwilling: Dan Zwilling] , [Dana Dostert: Dana Dostert] , ...4 more... )
• insp_rpt_comp_date ( type: esriFieldTypeDate, alias: insp_rpt_comp_date, length: 8 )
• condition_date ( type: esriFieldTypeDate, alias: condition_date, length: 8 )
• condition_assessment ( type: esriFieldTypeString, alias: condition_assessment, length: 50 , Coded Values: [Fair: Fair] , [Not Rated: Not Rated] , [Poor: Poor] , ...2 more... )
• operationalstatus ( type: esriFieldTypeString, alias: operationalstatus, length: 50 , Coded Values: [Enforcement Pending/Ongoing: Enforcement Pending/Ongoing] , [Normal Operations: Normal Operations] , [Not Applicable: Not Applicable] , ...2 more... )
• insp_freq ( type: esriFieldTypeSmallInteger, alias: insp_freq , Coded Values: [1: 1] , [10: 10] , [4: 4] , ...1 more... )
• initial_inspection_year ( type: esriFieldTypeSmallInteger, alias: initial_inspection_year )
• pre_inspection_comments ( type: esriFieldTypeString, alias: pre_inspection_comments, length: 300 )
• inspection_notice_date_sent ( type: esriFieldTypeDate, alias: inspection_notice_date_sent, length: 8 )
• inspection_notice_action ( type: esriFieldTypeString, alias: inspection_notice_action, length: 30 , Coded Values: [Call: Call] , [Inspection by Others: Inspection by Others] , [Mining: Mining] , ...3 more... )
• dam_name ( type: esriFieldTypeString, alias: dam_name, length: 100 )

Relationships:

• mn_nid (3) -- Related To: Dam Locations (0)

Table: mn_nid_owners (4)

Name: mn_nid_owners

Display Field: creator

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• mn_nid_guid ( type: esriFieldTypeGUID, alias: mn_nid_guid, length: 38 )
• organizations_contacts_guid ( type: esriFieldTypeGUID, alias: organizations_contacts_guid, length: 38 )
• organizations_contacts_text ( type: esriFieldTypeString, alias: organizations_contacts_text, length: 100 )
• dam_name ( type: esriFieldTypeString, alias: dam_name, length: 100 )

Relationships:

• mn_nid (1) -- Related To: Dam Locations (0)
• organizations_contacts (5) -- Related To: organizations_contacts (6)

Table: Organizations (5)

Name: Organizations

Display Field: creator

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• company ( type: esriFieldTypeString, alias: company, length: 100 )
• type ( type: esriFieldTypeString, alias: type, length: 25 )
• address_1 ( type: esriFieldTypeString, alias: address_1, length: 100 )
• address_2 ( type: esriFieldTypeString, alias: address_2, length: 100 )
• city ( type: esriFieldTypeString, alias: city, length: 50 )
• state_prov ( type: esriFieldTypeString, alias: state_prov, length: 50 )
• zip_code ( type: esriFieldTypeString, alias: zip_code, length: 10 )
• phone_business ( type: esriFieldTypeString, alias: phone_business, length: 15 )
• fax ( type: esriFieldTypeString, alias: fax, length: 15 )
• email ( type: esriFieldTypeString, alias: email, length: 50 )
• web_page ( type: esriFieldTypeString, alias: web_page, length: 100 )
• comments ( type: esriFieldTypeString, alias: comments, length: 300 )
• year_of_last_update ( type: esriFieldTypeSmallInteger, alias: year_of_last_update )
• date_entered ( type: esriFieldTypeDate, alias: date_entered, length: 8 )
• is_designer ( type: esriFieldTypeString, alias: is_designer, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• is_repair_company ( type: esriFieldTypeString, alias: is_repair_company, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• is_eap ( type: esriFieldTypeString, alias: is_eap, length: 3 , Coded Values: [No: No] , [Yes: Yes] )
• is_owner ( type: esriFieldTypeString, alias: is_owner, length: 3 , Coded Values: [No: No] , [Yes: Yes] )

Relationships:

• organizations_contacts (6) -- Related To: organizations_contacts (6)

Table: organizations_contacts (6)

Name: organizations_contacts

Display Field: creator

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• organization_guid ( type: esriFieldTypeGUID, alias: organization_guid, length: 38 )
• contact_guid ( type: esriFieldTypeGUID, alias: contact_guid, length: 38 )
• text ( type: esriFieldTypeString, alias: text, length: 100 )

Relationships:

• mn_nid_owners (5) -- Related To: mn_nid_owners (4)
• contacts (4) -- Related To: Contacts (1)
• organizations (6) -- Related To: Organizations (5)

Table: Repairs (7)

Name: Repairs

Display Field: creator

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: globalid, length: 38 )
• creator ( type: esriFieldTypeString, alias: creator, length: 255 )
• created ( type: esriFieldTypeDate, alias: created, length: 8 )
• editor ( type: esriFieldTypeString, alias: editor, length: 255 )
• edited ( type: esriFieldTypeDate, alias: edited, length: 8 )
• mn_nid_guid ( type: esriFieldTypeGUID, alias: mn_nid_guid, length: 38 )
• listed_on ( type: esriFieldTypeDate, alias: listed_on, length: 8 )
• urgency ( type: esriFieldTypeString, alias: urgency, length: 20 , Coded Values: [Completed: Completed] , [Future: Future] , [Immediate: Immediate] , ...1 more... )
• type ( type: esriFieldTypeString, alias: type, length: 20 , Coded Values: [Concrete: Concrete] , [Conduit: Conduit] , [debris/bog removal: debris/bog removal] , ...8 more... )
• description ( type: esriFieldTypeString, alias: description, length: 20 )
• repaired_on ( type: esriFieldTypeDate, alias: repaired_on, length: 8 )
• cost_estimate ( type: esriFieldTypeDouble, alias: cost_estimate )
• cost_actual ( type: esriFieldTypeDouble, alias: cost_actual )
• organizations_contacts_guid ( type: esriFieldTypeGUID, alias: organizations_contacts_guid, length: 38 )
• organizations_contacts_text ( type: esriFieldTypeString, alias: organizations_contacts_text, length: 100 )
• dam_name ( type: esriFieldTypeString, alias: dam_name, length: 100 )

Relationships:

• mn_nid (0) -- Related To: Dam Locations (0)

Table: vw_organizations_contacts (8)

Name: vw_organizations_contacts

Display Field: globalid

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65f8cd541a2942b1822c0403a0ac187e

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• objectid ( type: esriFieldTypeInteger, alias: objectid )
• globalid ( type: esriFieldTypeString, alias: globalid, length: 38 )
• organization_guid ( type: esriFieldTypeString, alias: organization_guid, length: 38 )
• contact_guid ( type: esriFieldTypeString, alias: contact_guid, length: 38 )
• text ( type: esriFieldTypeString, alias: text, length: 100 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• is_designer ( type: esriFieldTypeString, alias: is_designer, length: 3 )
• is_repair_company ( type: esriFieldTypeString, alias: is_repair_company, length: 3 )
• is_eap ( type: esriFieldTypeString, alias: is_eap, length: 3 )
• is_owner ( type: esriFieldTypeString, alias: is_owner, length: 3 )