Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
trr_charge Table id serial 10 √ nextval('trr_charge_id_seq'::regclass)
trr_trr Table officer_unit_detail_id int4 10 √ null
data_allegation Table incident_date timestamptz 35 √ null
data_investigatorallegation Table id serial 10 √ nextval('data_investigatorallegation_id_seq'::regclass)
trr_actionresponse Table force_type varchar 64 √ null
data_salary Table officer_id int4 10 null
data_salary Table spp_date date 13 √ null
trr_trr Table notify_DET_division bool 1 √ null
data_officer Table tags _varchar 20 null
trr_trr Table notify_OP_command bool 1 √ null
trr_trr Table officer_rank varchar 32 √ null
geometry_columns View f_table_catalog varchar 256 √ null
data_attachmentrequest Table status bool 1 null
trr_trr Table subject_race varchar 32 √ null
trr_weapondischarge Table sight_used bool 1 √ null
trr_weapondischarge Table weapon_type varchar 32 √ null
data_award Table ceremony_date date 13 √ null
trr_trrattachmentrequest Table status bool 1 null
spatial_ref_sys Table srid int4 10 null
data_investigator Table suffix_name varchar 5 √ null
data_pipeline_appliedfixture Table file_name varchar 255 null
trr_actionresponse Table id serial 10 √ nextval('trr_actionresponse_id_seq'::regclass)
data_attachmentrequest Table timestamp timestamptz 35 null
data_involvement Table allegation_id int4 10 null
trr_charge Table subject_no int4 10 √ null
data_allegationcategory Table category varchar 255 null
raster_columns View spatial_index bool 1 √ null
trr_weapondischarge Table protective_cover_used varchar 32 √ null
data_area Table commander_id int4 10 √ null
trr_trrattachmentrequest Table email varchar 255 null
data_attachmentfile Table title varchar 255 √ null
raster_columns View same_alignment bool 1 √ null
trr_actionresponse Table other_description varchar 64 √ null
data_allegation Table beat_id int4 10 √ null
data_salary Table employee_status varchar 32 null
trr_subjectweapon Table weapon_type varchar 64 √ null
trr_trr Table lighting_condition varchar 32 √ null
data_area Table name varchar 100 null
trr_weapondischarge Table object_struck_of_discharge varchar 32 √ null
raster_columns View r_table_schema name 2147483647 √ null
data_versioning_changelog Table source jsonb 2147483647 null
data_complainant Table age int4 10 √ null
trr_trr Table subject_alleged_injury bool 1 √ null
geometry_columns View srid int4 10 √ null
trr_trr Table officer_in_uniform bool 1 √ null
data_victim Table allegation_id int4 10 null
data_linearea Table linearea_type varchar 30 null
raster_overviews View r_raster_column name 2147483647 √ null
data_attachmentfile Table file_type varchar 10 null
data_salary Table age_at_hire int2 5 √ null
data_investigator Table officer_id int4 10 √ null
data_award Table id serial 10 √ nextval('data_award_id_seq'::regclass)
trr_charge Table trr_id int4 10 null
data_officer Table civilian_allegation_percentile numeric 6 √ null
data_attachmentrequest Table email varchar 255 null
raster_columns View scale_x float8 17 √ null
trr_trr Table notify_OEMC bool 1 √ null
data_officerallegation Table officer_age int4 10 √ null
data_allegation_areas Table area_id int4 10 null
data_award Table end_date date 13 √ null
data_officeralias Table new_officer_id int4 10 null
data_investigatorallegation Table allegation_id int4 10 null
data_officer Table last_name varchar 255 null
data_officerbadgenumber Table current bool 1 null
data_investigator Table last_name varchar 255 √ null
trr_weapondischarge Table firearm_barrel_length varchar 16 √ null
data_complainant Table race varchar 50 null
data_allegation_line_areas Table allegation_id int4 10 null
data_involvement Table full_name varchar 50 null
trr_trr Table beat int2 5 √ null
data_allegationcategory Table allegation_name varchar 255 null
geography_columns View f_table_name name 2147483647 √ null
data_investigator Table race varchar 50 null
data_officerhistory Table end_date date 13 √ null
trr_trrattachmentrequest Table trr_id int4 10 null
trr_actionresponse Table member_action varchar 64 √ null
data_policewitness Table allegation_id int4 10 √ null
data_investigatorallegation Table current_unit_id int4 10 √ null
trr_trr Table direction varchar 8 √ null
data_allegation_areas Table id serial 10 √ nextval('data_allegation_areas_id_seq'::regclass)
data_allegation Table city varchar 255 null
data_award Table rank varchar 100 null
data_salary Table year int2 5 null
raster_columns View r_table_name name 2147483647 √ null
data_officerallegation Table officer_id int4 10 √ null
trr_weapondischarge Table number_of_catdridge_reloaded int2 5 √ null
geometry_columns View f_table_schema name 2147483647 √ null
spatial_ref_sys Table auth_srid int4 10 √ null
data_involvement Table involved_type varchar 25 null
data_investigator Table appointed_date date 13 √ null
data_officer Table suffix_name varchar 5 √ null
raster_overviews View o_table_catalog name 2147483647 √ null
trr_weapondischarge Table handgun_worn_type varchar 32 √ null
trr_trr Table total_number_of_shots int2 5 √ null
data_officer Table first_name varchar 255 null
data_area Table alderman varchar 255 √ null
raster_overviews View r_table_name name 2147483647 √ null
spatial_ref_sys Table proj4text varchar 2048 √ null
trr_weapondischarge Table discharge_position varchar 32 √ null
data_attachmentfile Table tag varchar 50 null
trr_charge Table description varchar 64 √ null
trr_weapondischarge Table firearm_make varchar 64 √ null
trr_weapondischarge Table handgun_drawn_type varchar 32 √ null
raster_columns View scale_y float8 17 √ null
trr_trr Table street varchar 64 √ null
raster_columns View r_table_catalog name 2147483647 √ null
data_officerhistory Table id serial 10 √ nextval('data_officerhistory_id_seq'::regclass)
data_officer Table trr_percentile numeric 6 √ null
data_officerallegation Table start_date date 13 √ null
data_allegation_areas Table allegation_id int4 10 null
data_policeunit Table tags _varchar 20 null
trr_trr Table trr_datetime timestamptz 35 √ null
data_award Table requester_full_name varchar 255 √ null
raster_columns View pixel_types _text 2147483647 √ null
data_involvement Table race varchar 50 null
data_policeunit Table unit_name varchar 5 null
data_racepopulation Table race varchar 255 null
data_allegation Table add2 varchar 255 null
raster_columns View blocksize_y int4 10 √ null
data_victim Table id serial 10 √ nextval('data_victim_id_seq'::regclass)
data_allegation Table summary text 2147483647 null
data_racepopulation Table count int4 10 null
trr_subjectweapon Table weapon_description varchar 64 √ null
data_complainant Table gender varchar 1 null
trr_charge Table statute varchar 64 √ null
data_officerallegation Table recc_outcome varchar 32 null
data_officer Table middle_initial2 varchar 5 √ null
data_officer Table appointed_date date 13 √ null
data_versioning_changelog Table id serial 10 √ nextval('data_versioning_changelog_id_seq'::regclass)
data_versioning_changelog Table target_model varchar 255 null
data_salary Table salary int4 10 null
data_investigatorallegation Table investigator_id int4 10 null
geography_columns View f_table_schema name 2147483647 √ null
data_involvement Table officer_id int4 10 √ null
data_allegation Table source varchar 20 null
data_officerhistory Table unit_id int4 10 √ null
raster_columns View r_raster_column name 2147483647 √ null
data_officerbadgenumber Table id serial 10 √ nextval('data_officerbadgenumber_id_seq'::regclass)
trr_trr Table number_of_weapons_discharged int2 5 √ null
data_allegationcategory Table on_duty bool 1 null
raster_overviews View o_table_schema name 2147483647 √ null
raster_columns View regular_blocking bool 1 √ null
raster_overviews View o_table_name name 2147483647 √ null
geography_columns View coord_dimension int4 10 √ null
trr_trr Table officer_injured bool 1 √ null
data_salary Table pay_grade varchar 16 null
data_officer Table internal_allegation_percentile numeric 6 √ null
trr_actionresponse Table action_sub_category varchar 3 √ null
trr_trr Table officer_id int4 10 √ null
raster_columns View srid int4 10 √ null
trr_weapondischarge Table id serial 10 √ nextval('trr_weapondischarge_id_seq'::regclass)
raster_columns View extent geometry 2147483647 √ null
data_allegation Table add1 varchar 16 null
data_pipeline_appliedfixture Table id serial 10 √ nextval('data_pipeline_appliedfixture_id_seq'::regclass)
trr_actionresponse Table resistance_type varchar 32 √ null
spatial_ref_sys Table auth_name varchar 256 √ null
trr_weapondischarge Table discharge_distance varchar 16 √ null
data_racepopulation Table area_id int4 10 null
data_allegation_line_areas Table id serial 10 √ nextval('data_allegation_line_areas_id_seq'::regclass)
trr_trrstatus Table age int2 5 √ null
trr_trr Table number_of_officers_using_firearm int2 5 √ null
data_officerallegation Table disciplined bool 1 √ null
geometry_columns View f_table_name name 2147483647 √ null
data_investigatorallegation Table investigator_type varchar 32 √ null
raster_columns View blocksize_x int4 10 √ null
trr_trr Table location_recode varchar 64 √ null
trr_trr Table taser bool 1 √ null
data_attachmentfile Table last_updated timestamptz 35 √ null
data_policeunit Table active bool 1 √ null
data_area Table median_income varchar 100 √ null
data_officer Table race varchar 50 null
trr_trr Table subject_gender varchar 1 √ null
geography_columns View f_table_catalog name 2147483647 √ null
raster_columns View num_bands int4 10 √ null
trr_trr Table subject_id int4 10 √ null
trr_weapondischarge Table firearm_reloaded bool 1 √ null
data_victim Table birth_year int4 10 √ null
data_allegation Table id serial 10 √ nextval('data_allegation_id_seq'::regclass)
data_allegation Table point geometry 2147483647 √ null
trr_weapondischarge Table method_used_to_reload varchar 64 √ null
data_allegation Table old_complaint_address varchar 255 √ null
data_investigator Table middle_initial varchar 5 √ null
data_officer Table resignation_date date 13 √ null
trr_weapondischarge Table total_number_of_shots int2 5 √ null
data_policewitness Table id serial 10 √ nextval('data_policewitness_id_seq'::regclass)
trr_trr Table subject_age int2 5 √ null
data_pipeline_appliedfixture Table created date 13 null
data_victim Table race varchar 50 null
data_attachmentfile Table url varchar 255 null
data_officerallegation Table end_date date 13 √ null
data_allegation Table crid varchar 30 null
data_allegation Table is_officer_complaint bool 1 null
data_award Table award_type varchar 255 null
raster_overviews View r_table_schema name 2147483647 √ null
trr_trrstatus Table officer_id int4 10 √ null
trr_trr Table location varchar 64 √ null
data_officeralias Table id serial 10 √ nextval('data_officeralias_id_seq'::regclass)
data_policeunit Table description varchar 255 √ null
data_racepopulation Table id serial 10 √ nextval('data_racepopulation_id_seq'::regclass)
trr_trr Table party_fired_first varchar 16 √ null
data_investigatorallegation Table current_star varchar 10 √ null
data_investigator Table first_name varchar 255 √ null
trr_trr Table subject_injured bool 1 √ null
data_allegation Table location varchar 64 null
trr_trr Table officer_on_duty bool 1 √ null
trr_weapondischarge Table firearm_model varchar 32 √ null
data_linearea Table geom geometry 2147483647 null
data_area Table id serial 10 √ nextval('data_area_id_seq'::regclass)
trr_subjectweapon Table firearm_caliber varchar 16 √ null
trr_subjectweapon Table trr_id int4 10 null
data_officer Table middle_initial varchar 5 √ null
data_complainant Table birth_year int4 10 √ null
data_involvement Table id serial 10 √ nextval('data_involvement_id_seq'::regclass)
trr_trrstatus Table id serial 10 √ nextval('trr_trrstatus_id_seq'::regclass)
data_salary Table org_hire_date date 13 √ null
geography_columns View type text 2147483647 √ null
data_officer Table birth_year int4 10 √ null
raster_overviews View r_table_catalog name 2147483647 √ null
trr_subjectweapon Table id serial 10 √ nextval('trr_subjectweapon_id_seq'::regclass)
data_investigatorallegation Table current_rank varchar 100 √ null
spatial_ref_sys Table srtext varchar 2048 √ null
data_versioning_changelog Table created timestamptz 35 null
trr_trr Table officer_assigned_beat varchar 16 √ null
trr_weapondischarge Table weapon_type_description varchar 32 √ null
trr_trr Table id serial 10 √ nextval('trr_trr_id_seq'::regclass)
data_area Table police_hq_id int4 10 √ null
data_attachmentfile Table additional_info jsonb 2147483647 null
data_award Table last_promotion_date date 13 √ null
trr_trr Table officer_unit_id int4 10 √ null
data_involvement Table gender varchar 1 √ null
data_attachmentrequest Table allegation_id int4 10 null
data_victim Table gender varchar 1 null
data_officerallegation Table allegation_id int4 10 √ null
data_attachmentfile Table allegation_id int4 10 null
geometry_columns View type varchar 30 √ null
raster_overviews View o_raster_column name 2147483647 √ null
data_allegationcategory Table id serial 10 √ nextval('data_allegationcategory_id_seq'::regclass)
data_linearea Table name varchar 100 null
geography_columns View srid int4 10 √ null
geometry_columns View coord_dimension int4 10 √ null
trr_weapondischarge Table trr_id int4 10 null
data_versioning_changelog Table object_pk int4 10 √ null
data_award Table officer_id int4 10 null
trr_actionresponse Table person varchar 16 √ null
trr_trr Table indoor_or_outdoor varchar 8 √ null
data_attachmentfile Table created_at timestamptz 35 √ null
trr_actionresponse Table action varchar 64 √ null
data_attachmentfile Table id serial 10 √ nextval('data_attachmentfile_id_seq'::regclass)
geography_columns View f_geography_column name 2147483647 √ null
trr_trr Table firearm_used bool 1 √ null
data_complainant Table allegation_id int4 10 √ null
data_officer Table honorable_mention_percentile numeric 6 √ null
data_officerallegation Table allegation_category_id int4 10 √ null
data_attachmentrequest Table id serial 10 √ nextval('data_attachmentrequest_id_seq'::regclass)
trr_trrattachmentrequest Table id serial 10 √ nextval('trr_trrattachmentrequest_id_seq'::regclass)
trr_trrstatus Table trr_id int4 10 null
data_area Table area_type varchar 30 null
trr_trrstatus Table status_datetime timestamptz 35 √ null
data_officeralias Table old_officer_id int4 10 null
trr_actionresponse Table action_category varchar 1 √ null
data_officerallegation Table recc_finding varchar 2 null
trr_trr Table subject_armed bool 1 √ null
raster_overviews View overview_factor int4 10 √ null
data_officer Table rank varchar 100 null
data_linearea Table id serial 10 √ nextval('data_linearea_id_seq'::regclass)
data_officerhistory Table effective_date date 13 √ null
trr_weapondischarge Table firearm_caliber varchar 16 √ null
trr_trrstatus Table status varchar 16 √ null
data_salary Table rank varchar 64 √ null
trr_trr Table notify_district_sergeant bool 1 √ null
trr_trr Table subject_birth_year int2 5 √ null
data_investigator Table id serial 10 √ nextval('data_investigator_id_seq'::regclass)
trr_trr Table point geometry 2147483647 √ null
data_officerbadgenumber Table officer_id int4 10 √ null
raster_columns View nodata_values _float8 17 √ null
data_allegation_line_areas Table linearea_id int4 10 null
geometry_columns View f_geometry_column name 2147483647 √ null
data_area Table description varchar 255 √ null
data_complainant Table id serial 10 √ nextval('data_complainant_id_seq'::regclass)
data_officer Table active varchar 10 null
data_attachmentfile Table original_url varchar 255 null
data_area Table tags _varchar 20 null
data_officerallegation Table final_outcome varchar 32 null
data_salary Table id serial 10 √ nextval('data_salary_id_seq'::regclass)
trr_trr Table weather_condition varchar 32 √ null
data_area Table polygon geometry 2147483647 √ null
data_investigator Table gender varchar 1 null
trr_trrstatus Table rank varchar 16 √ null
data_award Table current_status varchar 20 null
data_versioning_changelog Table log_type int4 10 null
data_victim Table age int4 10 √ null
data_award Table request_date date 13 null
data_policeunit Table id serial 10 √ nextval('data_policeunit_id_seq'::regclass)
data_allegationcategory Table category_code varchar 255 null
data_policewitness Table officer_id int4 10 √ null
data_versioning_changelog Table content jsonb 2147483647 null
data_attachmentfile Table preview_image_url varchar 255 √ null
data_officerbadgenumber Table star varchar 10 null
data_officer Table gender varchar 1 null
data_involvement Table age int4 10 √ null
trr_trrstatus Table star varchar 10 √ null
data_officerallegation Table final_outcome_class varchar 20 null
data_officer Table complaint_percentile numeric 6 √ null
trr_actionresponse Table resistance_level varchar 16 √ null
data_officerhistory Table officer_id int4 10 √ null
data_award Table tracking_no varchar 255 √ null
trr_trr Table block varchar 8 √ null
data_salary Table start_date date 13 √ null
data_allegationcategory Table citizen_dept varchar 50 null
raster_columns View out_db _bool 1 √ null
trr_charge Table sr_no int4 10 √ null
trr_actionresponse Table trr_id int4 10 null
data_officerallegation Table final_finding varchar 2 null
data_award Table start_date date 13 √ null
data_officerallegation Table id serial 10 √ nextval('data_officerallegation_id_seq'::regclass)
data_officer Table id serial 10 √ nextval('data_officer_id_seq'::regclass)