Attribute Schema

The tables below list the required schema and descriptions for the Parking Inventory Data.

Block Segments

Field Name

Description

OBJECTID

Esri Default field

BLOCK_SEGMENT_ID

Unique ID field for block segments, created by Attribute Rule

SEGMENT_ID

Unique ID field for TRANSPORTATION.street_segment, code this value from Segment ID in street segment feature class

FULL_STREET_NAME

Full Street Name of the street segment, code this from Full Street Name field in street segment feature class

RIGHT_FROM_ADDRESS

Right From Address of the street segment, code this value from Right From Address field in street segment feature class

BLOCK_DIRECTION

Curb that block segment is located on

BLOCK_NAME

Concatenated from Full Street Name, Right From Address, and Block Direction (do not add street type (ST), use acronym for block direction (NC)

TOTAL_SPACES

Total number of parking spaces on the block, should be the total spaces of all parking zones combined

BLOCK_STATUS

Null unless block segment is not available due to construction, proposed - new, special event, or temporary valet / relocate

COMMENTS

Free form text field for any comments that many need to be added

STATUS_TYPE

Field to mark block segment as being Active, Inactive or Retired (Active by default)

RETIRED_DATE

Date that block segment was Retired, null if block segment is Active

CREATED_BY

Editor Tracking Field (automatically updated)

CREATED_DATE

Editor Tracking Field (automatically updated)

MODIFIED_BY

Editor Tracking Field (automatically updated)

MODIFIED_DATE

Editor Tracking Field (automatically updated)

Parking Zones

Field Name

Description

OBJECTID

Esri Default field

PARKING_ZONE_ID

Unique ID field for parking zones, created by Attribute Rule

BLOCK_SEGMENT_ID

Unique ID field for block segments, field is used to create relationship class between parking zones and block segments

SEGMENT_ID

Unique ID field for TRANSPORTATION.street_segment, code this value from Segment ID in street segment feature class

MOBILE_PAY_ID

RESIDENTIAL_DISTRICT_ZONE

RESIDENTIAL_DISTRICT_ID

ZONE_DESCRIPTION

Zone that parking zone is located within

METER_ROUTE

Meter Route that parking zone is located within

PARKING_ORIENTATION

Vehicle parking orientation for parking zone

PARKING_SPACES

Total number of parking spaces for parking zone

TEMPORARY_PLATE_TALLY

ZONE_STATUS

Null unless parking zone is not available due to construction, proposed - new, special event, or temporary valet / relocate

COMMENTS

Free form text field for any comments that many need to be added

STATUS_TYPE

Field to mark parking zone as being Active, Inactive or Retired (Active by default)

RETIRED_DATE

Date that parking zone was Retired, null if parking zone is Active

CREATED_BY

Editor Tracking Field (automatically updated)

CREATED_DATE

Editor Tracking Field (automatically updated)

MODIFIED_BY

Editor Tracking Field (automatically updated)

MODIFIED_DATE

Editor Tracking Field (automatically updated)

Parking Restrictions

Field Name

Description

OBJECTID

Esri Default field

PARKING_RESTRICTION_ID

Unique ID field for parking restrictions, created by Attribute Rule

PARKING_ZONE_ID

Unique ID field for parking zones, field is used to create relationship class between parking restrictions and parking zones

PARKING_TYPE

Type of parking restriction assigned

RATE_COST

Rate cost for parking restriction based on rate duration (field to be removed)

RATE_DURATION

Unit of time per the rate cost

TIME_LIMIT

The length of time a vehicle can remain parked without renewing

HOURS_OF_OPERATION

All hours of operation for the parking restriction

MONDAY_HOURS

Total number of hours that the restriction is valid on Monday

TUESDAY_HOURS

Total number of hours that the restriction is valid on Tuesday

WEDNESDAY_HOURS

Total number of hours that the restriction is valid on Wednesday

THURSDAY_HOURS

Total number of hours that the restriction is valid on Thursday

FRIDAY_HOURS

Total number of hours that the restriction is valid on Friday

SATURDAY_HOURS

Total number of hours that the restriction is valid on Saturday

SUNDAY_HOURS

Total number of hours that the restriction is valid on Sunday

STATUS_TYPE

Field to mark parking restriction as being Active, Inactive or Retired (Active by default)

RETIRED_DATE

Date that parking restriction was Retired, null if parking restriction is Active

RATE

REGULATION

REGULATION

CREATED_BY

Editor Tracking Field (automatically updated)

CREATED_DATE

Editor Tracking Field (automatically updated)

MODIFIED_BY

Editor Tracking Field (automatically updated)

MODIFIED_DATE

Editor Tracking Field (automatically updated)

Parking Spaces

Field Name

Description

OBJECTID

Esri Default field

PARKING_SPACE_ID

Unique ID field for parking spaces, created by Attribute Rule

PARKING_ZONE_ID

Unique ID field for parking zones, field is used to create relationship class between parking spaces and parking zones

TEMPORARY_PLATE

SPACE_STATUS

Null unless parking space is not available due to construction, special event, or temporary valet / relocate

PARKING_BENEFIT_DISTRICT

PARKING_BENEFIT_DISTRICT_ID

PARKING_BENEFIT_DISTRICT_NAME

STATUS_TYPE

Field to mark parking space as being Active or Retired (Active by default)

RETIRED_DATE

Date that parking space was Retired, null if parking space is Active

CREATED_BY

Editor Tracking Field (automatically updated)

CREATED_DATE

Editor Tracking Field (automatically updated)

MODIFIED_BY

Editor Tracking Field (automatically updated)

MODIFIED_DATE

Editor Tracking Field (automatically updated)

Parking Meters

Field Name

Description

OBJECTID

Esri Default field

PARKING_METER_ID

Unique ID field for parking meters, created by Attribute Rule

JURISDICTION

SUB_JURISDICTION

STATION_NUMBER

Parking Meter number, field is used to create relationship class between parking meters and parking spaces

BLOCK_LOCATION

Location of parking meter in relation to the block

PAY_TYPE

Parking Meter

METER_STATUS

Null unless parking meter is not available due to construction, special event, or temporary valet / relocate

COMMENTS

Free form text field for any comments that many need to be added

STATUS_TYPE

Field to mark parking meter as being Active or Retired (Active by default)

RETIRED_DATE

Date that parking meter was Retired, null if parking meter is Active

CREATED_BY

Editor Tracking Field (automatically updated)

CREATED_DATE

Editor Tracking Field (automatically updated)

MODIFIED_BY

Editor Tracking Field (automatically updated)

MODIFIED_DATE

Editor Tracking Field (automatically updated)

Parking Pay Stations

Field Name

Description

OBJECTID

Esri Default field

PARKING_PAY_ID

Unique ID field for parking pay stations, created by Attribute Rule

JURISDICTION

SUB_JURISDICTION

STATION_NUMBER

Parking Pay Station number, field is used to create relationship class between parking pay stations and parking spaces

BLOCK_LOCATION

Location of parking pay station in relation to the block

PAY_TYPE

Pay Station

METER_STATUS

Null unless parking pay station is not available due to construction, special event, or temporary valet / relocate

COMMENTS

Free form text field for any comments that many need to be added

STATUS_TYPE

Field to mark parking pay station as being Active or Retired (Active by default)

RETIRED_DATE

Date that parking pay station was Retired, null if parking meter is Active

CREATED_BY

Editor Tracking Field (automatically updated)

CREATED_DATE

Editor Tracking Field (automatically updated)

MODIFIED_BY

Editor Tracking Field (automatically updated)

MODIFIED_DATE

Editor Tracking Field (automatically updated)

Last updated