publish replication data
In O:\CCAODATA\output_data\socrata, save copies of the following data:
Before you export data:
-
In the AS400, some fields contain a 0 to denote a NULL. Socrata can encode NULL values as NULL. Wherever we pull a field in modeldata or assmntdata from the AS400 where 0s stand in for NULLs, we want to recode the 0s to NULL values. Please modify the SQL queries in 0_buil_200class_modeldata and ...._assmntdata to output NULLs rather than 0s.
Run the SQL query in modeldata and assmntdata to produce the following CSV files. Make sure the NULL values are output as blanks.
-
Model Data.CSV -
Assessment Data.CSV
Extract the fields dictionaried in ccao_dictionary_draft/valuationdata from each completed scope file and append them together to form:
-
Final Values.CSV
In addition, please save a copy of the neighborhood shape file:
-
Assessor Neighborhood Codes.shp
Also include
-
Latest version of the data dictionary
Edited by Robert Ross