About this Dataset

SeeClickFix Public Service Requests

This dataset consists of a point layer representing the location of public service requests made via the SeeClickFix system as managed and monitored by the Town of Chapel Hill Public Works Department.
Organization: Town of Chapel Hill, North Carolina
Last updated: 2024-02-09T14:54:44.590993
Tags: chapel-hill, government, north-carolina, open-data, orange-county, planning, public-works, seeclickfix, service-requests, town-of-chapel-hill

Tables

Table 1

@usgov.town_of_chapel_hill_north_caro_seeclickfix_public_serv_215b72ef.table_1

2.02 MB
7,121 rows
20 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "globalid" VARCHAR,
  "id" BIGINT,
  "summary" VARCHAR,
  "description" VARCHAR,
  "status" VARCHAR,
  "address" VARCHAR,
  "category" VARCHAR,
  "source" VARCHAR,
  "agency" VARCHAR,
  "comments_count" BIGINT,
  "image_url" VARCHAR,
  "image_square_url" VARCHAR,
  "url" VARCHAR,
  "created_at" TIMESTAMP,
  "acknowledged_at" TIMESTAMP,
  "closed_at" TIMESTAMP,
  "reopened_at" TIMESTAMP
);