Sign in to your account



This field is required


forgot your password?


New to the site? Create an account →

Aug 20th, 2018 at 3:16:17 pm

tcr! · Aug 20, 2018 at 3:16 pm

Writing a valid, functional, and strict MySQL regular expression for latitudes and longitudes is much harder than I thought it would be. Note that I said “MySQL” because they have their own regex engine apparently.

#devhell #mysql

keamoose keamoose · Aug 20, 2018 at 3:29 pm

I hope you only have to do it once; look at all of the different versions they had to implement for GNWT!

tcr! tcr! · Aug 20, 2018 at 4:08 pm

What is this devil worship?

keamoose keamoose · Aug 20, 2018 at 4:10 pm

Government + committee + engineers = devil. Actually it works pretty well. https://www.maps.geomatics.gov.nt.ca/HTML5Viewer_Prod/index.html?viewer=ATLAS

tcr! tcr! · Aug 20, 2018 at 5:40 pm

Ah nice! I see that you can search for parcels.

keamoose keamoose · Aug 20, 2018 at 6:43 pm

You can search for more or less anything if you have the right permissions on your login. Like, the property assessment guys can search by the names of homeowners. I can’t imagine what the database must look like. I mostly use it for air photos and land tenure (e.g. to see if an area is owned by the territorial government or by the municipality). It has some nice features; I always feel appreciative of the programmers when I use it. 😊

Reply

It’d be better if you signed in before commenting


Post

Add a comment

It’d be better if you signed in before commenting


Post



Latest articles for #mysql

This Is About Answering Questions

This Is About Answering Questions

Feb 14, 2013 at 1:21 pm

mysql - how to mysqldump remote db from local machine -1, cause this…

MySQL Date/Time fields vs Integers

MySQL Date/Time fields vs Integers

Aug 30, 2011 at 5:41 pm

The more I think about passwords and data types, the more I started…

🎙 Listen now →