upquark / medicost Goto Github PK

Description:
HCPCS code search needs to be implemented. This can be added as an additional layer of filtering, and hopefully accept WildCards. Could also include an additional feature for navigating HCPCS codes, in a window.

Two possible windows:

• One for a specific code, upon searching by that code, or upon selecting it in the CostTable.
• One for many codes, for getting a picture of what codes look like

• Wrangle and program the equation for converting a -within n miles parameter into a latitude / longitude range.

Process:

• Table MedicarePhysician2012_Addresses can be amended such that addressIDs are only applied to unique Lat/Lng pairings, rather than unique street addresses. Then the related sproc can do a select distinct.
• Alternately, we can create a new table of only distinct elements

Work:

• Amend MedicarePhysician2012_Addresses so that AddressID is unique only for unique lat/lng pairs
• Either amend stored procedure to deal with this (do a select distinct) or create a new distinct-only table.

Description:
Sort City by population, sort Specialty by frequency? Hcps codes should be searched from dictionary of both code and definition.

Process:
I'd like to have the TypeAhead fields sorted by some sort of good frequency measure, such that "New Boston" doesn't precede "Boston" / "West Los Angeles" precede "Los Angeles," etc.

Work

• City - assign each City in the table a priority value based on either 3rd party sourced population (hard) or simply # of costs in table for that city (easy).
• Specialty - sort by number of times specialty appears in list? Or just alphabetically
• HCPCS Code - will need to create a dictionary of codes matched with descriptions, and allow for searching based on that. Sorting can be alphabetically or based on frequency.