18 Apr 2024 |
techdude1996 | If I need to make all the fields in an existing table be made lowercase, what's the best/recommended route? | 19:41:12 |
Regina Obe | In reply to @techdude1996:osgeo.org If I need to make all the fields in an existing table be made lowercase, what's the best/recommended route? I use information_schema.columns to generate the sql to rename something like SELECT string_agg('ALTER TABLE ' || quote_ident(table_schema) || '.' || quote_ident(table_name) || ' RENAME ' || quote_ident(column_name ) || ' TO ' || quote_ident(lower(column_name)), ';') FROM information_schema.columns WHERE table_schema = 'schema here' AND table_name = 'table here' table_schema = 'staging' AND table_name = 'comps_rollup' AND column_name != lower(column_name); | 19:50:44 |
Regina Obe | In reply to @techdude1996:osgeo.org If I need to make all the fields in an existing table be made lowercase, what's the best/recommended route? * I use information_schema.columns to generate the sql to rename something like SELECT string_agg('ALTER TABLE ' || quote_ident(table_schema) || '.' || quote_ident(table_name) || ' RENAME ' || quote_ident(column_name ) || ' TO ' || quote_ident(lower(column_name)), ';') FROM information_schema.columns WHERE table_schema = 'schema here' AND table_name = 'table here' AND column_name != lower(column_name); | 19:51:10 |
Regina Obe | you can put the string in a DO command, but I like to do it that way, so I can see what will run before it runs, and perhaps take out some I don't want run | 19:51:59 |
Regina Obe | In reply to @darkblueb:osgeo.org mr komzpa has to deal with serious language issues every day.. I can see the temptation to use a machine for the human translations part, and for thoroughness.. but .. #postgis ? caution Mr. Komzpa command of english is way better than mine. I suspect I need a human translator way more than he does. | 20:23:53 |
Regina Obe | In reply to @_slack_osgeo_UJM07FH5H:matrix.org Huh, not from my perspective. Most issues filed are legit problems. Yah luckily PostGIS, GEOS, and JTS aren't so important yet that people will waste tokens posting frivolous bogus bug reports. | 20:25:14 |
Regina Obe | In reply to @latot:matrix.org IIRC here the AI is a problem too, GrayShade also said there is a lot of reports that are a waste of time? or was Regina Obe ? Probably me -- with the Curl complaints and my husband Leo whining about how all his students put their text into an ChatGPT translator and what he gets back is dialog he knows is not there's and is much much longer | 20:26:50 |
GrayShade | In reply to @robe:osgeo.org Probably me -- with the Curl complaints and my husband Leo whining about how all his students put their text into an ChatGPT translator and what he gets back is dialog he knows is not there's and is much much longer Theirs? 😛 | 20:28:56 |
Regina Obe | Reminds me of a cartoon I saw recently was very funny now I can't find it | 20:29:25 |
Regina Obe | In reply to @grayshade:dend.ro Theirs? 😛 Damn these non-english speakers correcting my english grammar. Don't you have something better to do with your time? | 20:29:57 |
GrayShade | In reply to @robe:osgeo.org Damn these non-english speakers correcting my english grammar. Don't you have something better to do with your time? Well, I should be sleeping.. | 20:30:32 |
Regina Obe | But it's more fun to correct my grammar | 20:30:56 |
GrayShade | In reply to @robe:osgeo.org But it's more fun to correct my grammar I had to, after your previous remark 😛 | 20:32:05 |
darkblueb | the nice PhD woman I just talked to claims to have US Census, American Community Survey details, and relationship to public transportation.. supplied to their AWS crunchy setup | 20:50:30 |
darkblueb | thats a lot of data !! curious who is a vendor for that | 20:50:52 |
Regina Obe | Why do you need a vendor? Isn't it all publically available data or you mean the packaging of it? | 20:52:03 |
darkblueb | the ACS details are hundreds of columns, with secret-sauce linkage | 20:52:30 |
Regina Obe | secret source linkage? | 20:52:48 |
darkblueb | yes, the tables are encoded in a certain way.. | 20:53:02 |
Regina Obe | I just download all that stuff from their website. What secret sauce am I missing? or is it just secret bullshit | 20:53:18 |
darkblueb | hmm "stuff" ? | 20:53:45 |
Regina Obe | :) | 20:54:08 |
Regina Obe | Yah sorry for my fowl language. Guess I'm in a bit of a foul mood today | 20:54:27 |
darkblueb | this is a spatial JOIN on the Table 60 population ACS data https://paste.debian.net/1314498/ | 20:58:06 |
darkblueb | logrecno and acs20125_seq_metadata are "secret-sauce linkage" | 20:58:55 |
darkblueb | .. restrict to a census geometry called '05000US06001' | 20:59:49 |
darkblueb | .. the number of characters in that ID says what geo level it is | 21:00:06 |
darkblueb | that is .. US State of California (06 ) and county ID 1 | 21:00:38 |
darkblueb | that "stuff" :-) | 21:00:51 |
darkblueb | .. I wrote that by hand long ago, these people got a contract to do that and appear to be maintaining it .. (the PhD woman did not care to mention the name of the company she buys this from ) https://github.com/censusreporter/census-postgres | 21:09:57 |