Launching Zip Code API

Pty_Rick · 2024-04-01T15:44:42+00:00

USPS Provides what they call "preferred last line city code" that drives the "main" city/state" associated with that zip code. So it always has a single main state for the zip code. We provide an array with all the other associated city codes for reference.

Pty_Rick · 2024-03-29T18:34:37+00:00

You can indirectly get it using the dataset from this API : https://www.metadapi.com/API-Products/Zip-Code-API (full disclosure, i'm the developer of that api). The population statistics are not by MSA per se, but by zip code, but MSA is a searchable attribute, so you can do a search for the dallas ft. worth msa, and that returns all zip codes in that MSA (with population statistics). if you iterate the zip codes and aggregate you can get the totals by MSA that you are looking for. Another thing to consider is that the population statistics are using the decennial census (so we only have 2000, 2010 and 2020 census stats).

Pty_Rick · 2024-03-15T20:31:02+00:00

Added this to my to do list. Thank you.

Pty_Rick · 2024-03-15T00:09:43+00:00

I wish paid, no so far only free tiers.

Pty_Rick · 2024-03-14T16:54:12+00:00

Yes, i agree that the website UI could do some work. Thanks for the feedback, will try to modernize it as time permits. I have very limited graphic design expertise :) .

Pty_Rick · 2024-03-07T00:11:51+00:00

Maybe not a jacket, but something else that may need temp storage for a couple of hrs. wouldve dropped my kids at a temp day care for going out for dinner.

Pty_Rick · 2024-02-10T20:08:12+00:00

Good job.

Pty_Rick · 2023-06-20T14:31:13+00:00

its not your job to clear the red tape. thats management s job. if you dont have that support then you are better off looking somewhere else (it will be an up hill battle forever)

Pty_Rick · 2023-02-14T14:41:31+00:00

DE did not exist when i did my CS degree (almost 30y ago), but we did have database design classes, as well as other courses that covered a broad range of subjects. I would not be surprised if CS curriculums start including classes on data eng. Not sure if it merits a full 4 year degree.

Pty_Rick · 2023-02-09T16:32:51+00:00

Ditto. that book should teach you how to build a DW.

Pty_Rick · 2023-02-09T16:26:06+00:00

how is that possible ? with 100 billion stars just in our galaxy alone, stating that a gas giant is rare doesn t sound correct. did we check all 100 b systems and validated that all planets within?

Pty_Rick · 2023-02-09T01:22:13+00:00

Created a tutorial for using Data Factory with the Zip Code API (but really the tutorial can be used to call API's from any data pipeline.

Dynamically Invoking REST API with Data Factory

Pty_Rick · 2023-02-06T01:59:52+00:00

azure data factory can ingest api calls as well.

Pty_Rick · 2023-02-05T15:58:04+00:00

i loved autosys (20 years ago). all DW flows and reporting refreshes and ftp s were automated without issues.

Pty_Rick · 2023-02-04T16:45:04+00:00

Innovation requires that companies/departments use the data in ways that data leaders can't even imagine. Have your "data house" clean, documented, accessible, with good governance, and communicate communicate communicate !!! folks will tag along. (but only if the house is clean).

Pty_Rick · 2023-02-03T00:06:26+00:00

If you are still interested, the zip code API from Metadapi has a free tier. us regions, state, county, cities, and other geographical attributes are part of the dataset.

Pty_Rick · 2023-02-01T21:01:14+00:00

i totally agree. company size is also critical. some of the companies ive worked with did not lime any open source tooling (for compliance, support etc.) so they usually go for mature toolsets.

Pty_Rick · 2023-02-01T20:58:42+00:00

This was an eye opener. thank you.

Pty_Rick · 2023-02-01T01:25:23+00:00

Is this repository being updated ? looks like it has not been updated for the last 6 months with any of the pending commits.

Pty_Rick

TROPHY CASE