Comments (2)
cseppan
commented on August 30, 2024
Follow-up messages from James:
The correct calculation is:
(county pop in grid cell) / (total county pop)The way it is now is:
(county pop in grid cell) / (county pop within domain)
This was showing up with all surrogates for the 1NJ1 finescale domain. Population (100) is the test case we worked off of when tracing down the issue:
| REGION | SURROGATE | SURROGATE CODE | DATA SHAPEFILE | DATA ATTRIBUTE | WEIGHT SHAPEFILE | WEIGHT ATTRIBUTE | WEIGHT FUNCTION | FILTER FUNCTION | MERGE FUNCTION | SECONDARY SURROGATE | TERTIARY SURROGATE | QUARTERNARY SURROGATE | DETAILS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USA | Population | 100 | cb_2017_us_county_500k | geoid | acs2016_5yr_bg | pop2016 | Total population from Census 2014 blocks |
This uses the template_polygon_noFF_withWA template.
The grid is defined as '2018_1NJ1'
'LAM_40N97W', 1788000, 72000, 1000, 1000, 156, 360, 1
Chris noticed the issue in FIPS 36103, which only has a small fraction within the domain.
I manually stepped through the SQL and saw that the denominator calculation is done from the “wp_cty_cell…” table. This table only has the fraction of the value within the domain.
We can workaround by enlarging the surrogate domain to completely cover all of the counties in the modeling domain.
from surrogatetoolsdb.
cseppan
commented on August 30, 2024
Fix released as part of v1.3
from surrogatetoolsdb.
Related Issues (19)
- Add ellipsoid to surrogate header
- Update surrogate_specification_pg.csv for 2017 surrogates
- Create utility to set up projection and grid table based on GRIDDESC
- Support SQLite + SpatiaLite as alternative to Postgres
- review calculations for numerator and denominator fields in output files
- add How-Tos: change shapefiles, how to run gapfilling and merging
- simplify projection and grid configuration
- errors running load_shapefile_reproject_multi.2017.csh HOT 4
- restrict surrogate fraction output to 20 characters
- point geometries need to be promoted to multipoint HOT 1
- errors generating 2017 surrogates HOT 1
- add error checking when loading shapefiles
- add error checking when generating surrogates
- existing surrogate tables didn't get deleted
- Run ./load_shapefile_reproject_multi.quickstart.csh failed with SQL error HOT 1
- fix issue with previous run data not being cleaned up
- error loading FEMA shapefile with GDAL 3.0.4
- list of currently used library and software versions
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from surrogatetoolsdb.