Locations

Locations

 
This table displays information on every location added to Blocks, regardless of type. You will see location names, addresses, types, registration form counts, notes and creation data.
 

Field
Type
Description
Notes
id
primary key (int)
unique location id
joins: location_id in shifts table, turn_in_location_id in deliveries table
name
text
name of location
unique to table
street_address
text
street address of location
unique to table
city
text
city of location
unique to table
state
text
state of location
unique to table
zipcode
integer
zip code of location
unique to table
county
text
county of location
unique to table
latitude
integer
latitude of location
unique to table
longitude
integer
longitude of location
unique to table
created_by_user_id
foreign key (int)
unique user id of user that created the location
joins: id in users table; created_by_user_id in shifts table, deliveries table, voter_registration_scan_batches table, canvassers table, registration_forms, and phone_verification_responses table; reviewed_by_user_id in voter_registration_scans table
location_type
integer
numerical representation of location_type; 0 - Hot Spot, 11 - Delivery Location
Unique to table
notes
text
any notes added to the location
unique to table
created_at
timestamp
date&time the location was created
unique to table
updated_at
timestamp
date&time the location was last updated
unique to table
turf_id
foreign key (int)
unique id of location turf
joins: id in turfs table; turf_id in users table and canvassers table
category
text
location category - configurable per tenant
ㅤ
delivery_point_barcode
integer
unique id provided by postal service through API connection
ㅤ