We are en environmental consultancy called EcoNomics, Inc. We work for several municipalities in California and ensure that they are in compliance with laws related to recycling. We are building a site audit tracking database that will be used to help set up new recycling programs in Orange County, CA.
I have been building out this system in house and am starting to need expert advise. I’ve built out the system 90% of the way and just need help with best practices for data base management. From the raw data collected in the field, i’ve added some calculations in airtable to create what i’d call “key data points”, which in a perfect world would feed into a dashboard for our clients. In particular, I want to build a dash board for each of our municipal clients using the mapping blocks, so you can click on the map pins and see specific data points (hitting a wall here). I want to do most of the heavy lifting but I already REALLY could use a 1 hour session talking through some of my design challenges.
While our team implements new food scrap (compost), food rescue, regular recycling programs, we extensively track several data points. In addition to 100’s of tons being diverted from the land fill each year as a result of our efforts, legislation requires that we VERY meticulously track progress. We want to make the best system we can to maximize the environmental outcomes and to tell our story to the State, who regulates our clients. Please e-mail me at Ian@economicsinc.net with replies. You may also feel free to reach out M-F (8-12) by phone (949) 293-9826.
Thank you very much