Name: PRPP Signs Source 2

Display Field: parkname

Type: Table

Geometry Type: N/A

Description: Contains the information for signs that are attached to posts or fences and are maintained by the Parks, Recreation and Public Property (PRPP) department in the City of Omaha, NE. This data is attached to the "PRPP Posts" layer by a related table.

Service Item Id: 060df749f9084dbc84ed2bd0be04524a

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: false
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• sign_type ( nullable: true, editable: true, defaultValue: null, length: 75, type: esriFieldTypeString, modelName: SIGN_TYPE, alias: Sign Type )
• sign_size ( nullable: true, editable: true, defaultValue: null, length: 20, type: esriFieldTypeString, modelName: SIGN_SIZE, alias: Sign Size , Coded Values: [6x12: 6x12] , [6x18: 6x18] , [9x12: 9x12] , ...64 more... )
• direction ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, modelName: DIRECTION, alias: Direction Facing , Coded Values: [S: S] , [N: N] , [W: W] , ...5 more... )
• sign_id ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: SIGN_ID, alias: Sign ID )
• facilityid ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: FACILITYID, alias: Post ID )
• owned_by ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: OWNED_BY, alias: Owned By )
• maintained_by ( nullable: true, editable: true, defaultValue: null, length: 30, type: esriFieldTypeString, modelName: MAINTAINED_BY, alias: Maintained By )
• park_district ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: PARK_DISTRICT, alias: Park District )
• location ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: LOCATION, alias: LOCATION )
• parkname ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: PARKNAME, alias: Park Name )
• comments ( nullable: true, editable: true, defaultValue: null, length: 250, type: esriFieldTypeString, modelName: COMMENTS, alias: Comments )
• sign_condition ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SIGN_CONDITION, alias: Sign Condition , Coded Values: [GOOD: Good] , [FADING, BUT READABLE: Fading, but Readable] , [UNREADABLE: Unreadable] , ...4 more... )
• sign_material ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SIGN_MATERIAL, alias: Sign Material , Coded Values: [METAL: Metal] , [WOOD: Wood] , [PLASTIC: Plastic] , ...1 more... )
• sign_height_inches ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: SIGN_HEIGHT_INCHES, alias: Sign Height (inches) )
• createdby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: CREATEDBY, alias: Created By )
• lasteditedby ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: LASTEDITEDBY, alias: Last Edited By )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID )
• sign_subtype ( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: SIGN_SUBTYPE, alias: SIGN_SUBTYPE )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• lastediteddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: lastediteddate, alias: lastediteddate )
• createddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: createddate, alias: createddate )
• date_installed ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: date_installed, alias: date_installed )

Types:

ID: 0
Name: Bathroom
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Men (Bathroom Sign): Men (Bathroom Sign)] , [Women (Bathroom Sign): Women (Bathroom Sign)] , [Bathroom (Other - Define in Comments): Bathroom (Other - Define in Comments)]
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Bathroom
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 0
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 1
Name: Fishing
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Muskellunge - Norhtern Pike: Muskellunge - Norhtern Pike] , [Attention Anglers - 21 Inch Limit on Large Mouth Bass: Attention Anglers - 21 Inch Limit on Large Mouth Bass] , [Attention Anglers - Walleye, Sauger, Saugeye Daily Bag Limit: Attention Anglers - Walleye, Sauger, Saugeye Daily Bag Limit] , ...3 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Fishing
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 1
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Handicapped
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Handicapped (Wheel Chair Only): Handicapped (Wheel Chair Only)] , [Handicapped - Accessible Enterance ---->: Handicapped - Accessible Enterance ---->] , [Handicapped - Accessible Enterance <----: Handicapped - Accessible Enterance <----] , ...10 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Handicapped
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 2
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: No (Other)
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [No Public Restroom: No Public Restroom] , [No Sledding: No Sledding] , [No Sledding Allowed: No Sledding Allowed] , ...10 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: No (Other)
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 3
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: No Parking
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [No Parking - On Grass: No Parking - On Grass] , [No Parking - On Grass (Shows Tow Truck Hooked to Car): No Parking - On Grass (Shows Tow Truck Hooked to Car)] , [No Parking --->: No Parking --->] , ...17 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: No Parking
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 4
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Park Regulations
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Park Closed 1100 PM - 500 AM: Park Closed 1100 PM - 500 AM] , [Park Closed (Other Times): Park Closed (Other Times)] , [Park Rules: Park Rules] , ...1 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Park Regulations
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 5
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: Pet Sign
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Owners Must Remove Pets Waste: Owners Must Remove Pets Waste] , [Small Dog Area: Small Dog Area] , [All Dog Area: All Dog Area] , ...3 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Pet Sign
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 6
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: Pool
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [City Pool ---->: City Pool ---->] , [City Pool<----: City Pool<----] , [Emergency Exit: Emergency Exit] , ...1 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Pool
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 7
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
Name: Shelter
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Shelter Reservation/Reserved: Shelter Reservation/Reserved] , [Number (Labeling Field/Shelter): Number (Labeling Field/Shelter)] , [Shelter (Other - Define in Comments): Shelter (Other - Define in Comments)]
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Shelter
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 8
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 9
Name: Speed
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Speed Limit 5: Speed Limit 5] , [Speed Limit 10: Speed Limit 10] , [Speed Limit 15: Speed Limit 15] , ...3 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Speed
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 9
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 10
Name: Sports
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Player Enterance: Player Enterance] , [Scheduled Play Only: Scheduled Play Only] , [Spectator Enterance: Spectator Enterance] , ...6 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Sports
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 10
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 11
Name: Traffic Sign
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [One Way (Left): One Way (Left)] , [One Way (Right): One Way (Right)] , [Stop: Stop] , ...13 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Traffic Sign
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 11
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 12
Name: Trail
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [Trail Stop Sign: Trail Stop Sign] , [Caution - Open Water: Caution - Open Water] , [Bike Lane: Bike Lane] , ...1 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Trail
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 12
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 13
Name: Other
Domains:
• sign_size:
  Inherited
• sign_material:
  Inherited
• sign_type:
  Coded Values: [This Gate Shall Not be Locked While Occupied: This Gate Shall Not be Locked While Occupied] , [Reminder from the Omaha Police Dept:: Reminder from the Omaha Police Dept:] , [Pesticides Stored In Building: Pesticides Stored In Building] , ...6 more...
• sign_condition:
  Inherited
• direction:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  sign_size: null
  facilityid: null
  comments: null
  createddate: null
  sign_id: null
  maintained_by: null
  lasteditedby: null
  park_district: null
  owned_by: null
  parkname: null
  sign_material: null
  date_installed: null
  createdby: null
  sign_subtype: 13
  location: null
  sign_height_inches: null
  lastediteddate: null
  sign_type: null
  sign_condition: null
  direction: null
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• PRPP_Posts (0) -- Related To: PRPP Posts Source 2 (0)

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata