Skip to content

Instantly share code, notes, and snippets.

@Imisrael

Imisrael/block3. Secret

Created February 18, 2021 19:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Imisrael/3db4c6991912c75ee163da070efa507a to your computer and use it in GitHub Desktop.
Save Imisrael/3db4c6991912c75ee163da070efa507a to your computer and use it in GitHub Desktop.
{
"type" : "record",
"name" : "outputRecord",
"fields" : [
{ "name" : "CMPLNT_NUM", "type" : "int"},
{ "name" : "CMPLNT_FR_DT", "type" : "string"},
{ "name" : "CMPLNT_FR_TM", "type" : "string"},
{ "name" : "CMPLNT_TO_DT", "type" : "string"},
{ "name" : "CMPLNT_TO_TM", "type" : "string"},
{ "name" : "ADDR_PCT_CD", "type" : "int"},
{ "name" : "RPT_DT", "type" : "string"},
{ "name" : "KY_CD", "type" : "int"},
{ "name" : "OFNS_DESC", "type" : "string"},
{ "name" : "PD_CD", "type" : "int"},
{ "name" : "PD_DESC", "type" : "string"},
{ "name" : "CRM_ATPT_CPTD_CD", "type" : "string"},
{ "name" : "LAW_CAT_CD", "type" : "string"},
{ "name" : "BORO_NM", "type" : "string"},
{ "name" : "LOC_OF_OCCUR_DESC", "type" : "string"},
{ "name" : "PREM_TYP_DESC", "type" : "string"},
{ "name" : "JURIS_DESC", "type" : "string"},
{ "name" : "JURISDICTION_CODE", "type" : "int"},
{ "name" : "PARKS_NM", "type" : "string"},
{ "name" : "HADEVELOPT", "type" : "string"},
{ "name" : "HOUSING_PSA", "type" : "string"},
{ "name" : "X_COORD_CD", "type" : "int"},
{ "name" : "Y_COORD_CD", "type" : "int"},
{ "name" : "SUSP_AGE_GROUP", "type" : "string"},
{ "name" : "SUSP_RACE", "type" : "string"},
{ "name" : "SUSP_SEX", "type" : "string"},
{ "name" : "TRANSIT_DISTRICT", "type" : "int"},
{ "name" : "Latitude", "type" : "float"},
{ "name" : "Longitude", "type" : "float"},
{ "name" : "Lat_Lon", "type" : "string"},
{ "name" : "PATROL_BORO", "type" : "string"},
{ "name" : "STATION_NAME", "type" : "string"},
{ "name" : "VIC_AGE_GROUP", "type" : "string"},
{ "name" : "VIC_RACE", "type" : "string"},
{ "name" : "VIC_SEX", "type" : "string"},
{ "name" : "CMPLNT_FR", "type" : { "type": "long", "logicalType" : "timestamp-millis"} },
{ "name" : "CMPLNT_TO", "type" : { "type": "long", "logicalType" : "timestamp-millis"} }
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment