You will have to get the location data from CostQuest which they will only provide if you are a provider with facilities in that area. Then you can use your tool of choice ( excel does fine) to match up the location ID with the address/coords from the location data and then map that in a GIS software.
On Thu, Nov 13, 2025 at 9:23 AM Mike Hammett <[email protected]> wrote: > > Ugh, the CSV is meaningless without the location data. I'll see what IOB will > produce. > > > > > -- > Mike Hammett > > ----- Original Message ----- > From: "Josh Luthman" <[email protected]> > To: "AnimalFarm Microwave Users Group" <[email protected]> > Sent: Thursday, November 13, 2025 7:27:32 AM > Subject: Re: [AFMUG] converting BEAD awards map > > > > Here are the BEAD locations: > https://dceo.illinois.gov/content/dam/soi/en/web/dceo/broadband/documents/fp_locations.csv > > > Intersect those location unique ID with coordinates. Then you can just KML or > QGIS to see them on your own map. What are you using for your current fiber > deployments/planning? > > > On Wed, Nov 12, 2025 at 6:58 PM Ken Hohhof < [email protected] > wrote: > > > > > > > > This? > > https://www.illinoisbead.org/#/ > > > > > From: AF < [email protected] > On Behalf Of Steve Jones > Sent: Wednesday, November 12, 2025 5:42 PM > To: AnimalFarm Microwave Users Group < [email protected] > > Subject: Re: [AFMUG] converting BEAD awards map > > > > > Got a link to this? > > > > > > On Wed, Nov 12, 2025, 5:03 PM Ken Hohhof < [email protected] > wrote: > > > > > > I’ve got what should be a simple project but my graphics skills and AI skills > are minimal and I can’t figure out how to do it. Or maybe it isn’t a simple > project and I should forget about it. > > > > The Illinois BEAD provisional awards map has dots that you can make different > colors by technology, green for fiber, red for satellite, etc. You can filter > to just show one provider (awardee) if you want. Unfortunately, the > background is almost black, so even just printing a paper copy on a color > laser printer doesn’t work very well. And using the color picker and then the > eraser to replace the background with or white or transparent doesn’t work > because topographic details make the color a slightly different shade of > black so it doesn’t get replaced. > > > > Ideally what I’d like is to overlay the fiber awards onto a regular map of my > service area, basically to know where I’m screwed in 4 years, vs. maybe not > screwed. The map would need major towns and roads for reference. An outline > or fill would be fine, I don’t actually need all the locations as dots. It > would be used for planning purposes, invest only where I’m not getting > overbuilt with fiber. I’m significantly less afraid of competing with Amazon > Kuiper. > > > > With all the hype about AI, this seems like something ChatGTP could do for me > with a couple prompts. Am I dreaming? Or too old to use AI? > > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com > > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com > > > -- > AF mailing list > [email protected] > http://af.afmug.com/mailman/listinfo/af_af.afmug.com -- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
