Inspiration

Since the creation of the grassroots Wyoming Blockchain Coalition a few years ago, it has become a recurring theme of integrating the web 3.0 ecosystem throughout the entire state of Wyoming. The intersection of government and business is within the wheelhouse of the Secretary of State. It has been the desire of all interested parties of our coordinated efforts to make this intersection include tech, specifically web 3 integration, yet somehow it has not happened. We have all tried to involve the SOS to engage in this new evolution and it seems to continually fall on deaf ears. Even with newly created legislation requiring to move the SOS more towards an open solution has failed. For me personally this all culminated in the recent May select committee testimony by Ms. Wheeler of the SOS where she stated that an open API is going to be very far away, very difficult, very expensive, etc. With the web 3.0 still in its infancy our emerging community, it is still in desperate need of base level of infrastructure. It is imperative for Wyoming to move forward being the center of this movement and provide the basic tools necessary for further economic development in the business world. Meanwhile Delaware is moving forward with this type of technology and as a Wyoming native, I do not want to see a repeat of the 1970s where we lose out for a lack of effort to finalize the details.

What it does

This proof of concept allows for basic functionality of searching the public database of businesses registered in the State of Wyoming and allows API connectivity for others to access this portal much easier.

How we built it

The Wyoming SOS provides the ability to download the entries for all business-related entries as CSV files. We created a quick database parser service that would download the CSV files provided, imported them into a PostgreSQL database, and connected a Hasura Engine to provide a GraphQL API interface. To showcase the integration, we created a React-based front-end using Apollo Client to create extendable queries ready to be used within a website.

Challenges we ran into

In addition to the overall challenge of evolving the legacy gate keepers at the Secretary of State, the Database provided by the SOS required extensive cleaning and polishing before being able to be imported into our PostgreSQL database. Multiple parsing scripts had to clean and re-clean the database for duplicated entries, rows with invalid data (e.g. empty private keys), and plain wrong formatted values. Albeit a schema is provided, foreign and public keys can't be enforced due to these requirements.

Accomplishments that we're proud of

The database is about 1GB of data, which would require some expensive infrastructure and databases to query and play with. We set up most of the open project using inexpensive cloud infrastructure (AWS) as well as open-source technologies (Hasura) which anyone run.

We hope we will be able to move the ball forward with automating facets of government that add savings and speed while being able to reduce government error and bureaucracy.

What we learned

Extending government-based technology and data isn't an easy task, particularly when legacy systems and closed-source infrastructure is the norm. However, with proper knowledge and an open view to future-facing technology, anyone can create services and technologies on top of what is already existing.

What's next for SOS API

Hopefully, the ability for registered agents to create new entities live on chain via an API that have been authenticated by the Secretary of State. That small move would then allow for a myriad of other applications like UCC filings, to further spur economic development and make Wyoming THE state of the art jurisdiction when coupled with Wyoming's newly founded Chancery Court.

-

Thank you for your consideration.

Share this project:

Updates

posted an update

The way to implement the API locally can now be seen in the source repo upon request from the judges, apologies for not having share those before! Added some additional instructions and source code for all shell scripts/commands used for cleaning up database/schema.

Log in or sign up for Devpost to join the conversation.