I live. I am alive. Winter was interesting. I measured a bit over 8 meters of snow during the nominal winter wet season, and was isolated in the trailer on the hill for a bit over four months. The road up here is not conductive to travel in inclimate weather, something I need to pay more than ten grand to fix. Problem is now that everyone that can spread gravel is making double what they were two years ago and are booked solid up to two or three years out. Fortunately I have a vehicle that can make it up and down the mountain as long as the road is mostly dry. We had a wet spring and it was not until late June that I was able to make a visit to civilization. There is no internet on the hillside. Anyone offering up Starlink as a solution can go sod off, and keep going to where ever you cunts huddle together, you shitheads. To the hells with that degenerate and his garbage companies. One of the first stops is the library to download books, then a quick look at the news. The librarian that worked here in the fall got a better job paying almost tripple librarian wages somewhere out of state. Good on her for getting the fuck out of here. My brief rundown of news since fall? The heavy snowfall I got this spring looks like it did a proper fuck of Yellowstone and that area. Jame Webb launched, so that was good, was wondering if they were going to make it or be delayed. First image is going to be Stephan's Quintet, one of my favorite visual targets. Looks like Russia is trying to rebuild the CCP, including waving commie flags on the ISS. People are still stupid about Covid. The election this year looks to be a shit show. Corporate profits are so high that they tanked the flow of capital, removed too much cash from the bottom of the economy and shot the stock market in the face. The democrats are exactly what you would expect them to be. Mostly Useless. Oh, and the supreme court says federal agents can kill you in your home and not face consequences. And they fucked over the EPA, along with the ability for government agencies to govern. And as a not off topic, Lake Meade is dying. But hey the liberal states cannot regulate CCW's anymore so FREEDOM! One of the cases not really being talked about is the case that murdered public education, then again education is no longer a priority in protestant murica so I'm not all that shocked. All this and I'm constantly accused of being the doom and gloom asshole needing perspective. OK perspective it is, for you cunts, let's look at the 538 election forecast shall we? Yeap, you're all fucked. Ukraine has until November to win the war else the incoming Treason Congress is going to start arming the Russians. I almost moved to the high desert of southern Utah or Nevada, and man, thank the fucks of my monkey brain for all the smarts of not moving to a desert. Lake Powell and Lake Meade are fucked to the point they have 5-10 years before then are no longer viable. Eat shit Arizona, maybe god will flood you sinners again. Fortunately for me, but bad for all you other suckers, nobody wants to fight the agriculture lobby so I can get all the water I want even if it means murdering the local aquifers. I kinda want to see what I can grow up here to accelerate the aquifer collapse, but I'm not sociopathic to actually do it. Story time. One of the first places I end up is the closest gas station, about an hour from the paved road turnoff to my place. Here, I had my first real laugh. I figured diesel would go up, and was right but man was not expecting that high. Fortunately, Diesel stores well, much better than gas, so next time down the mountain I'll have to grab an extra 60 gallons for the gear uphill. Nearby is the local post office. I've made arrangements to deal with mail. I was concerned that the same few people in the office last fall would either get smart and flee, get Covid and die, or otherwise move on. All of them are there now. I walk in and immediately, the guy at the counter yells to the people in the back "That NASA guy is here for his mail." This seemed ominous and not a good sign. Turns out all the work I did and submitted to researchers, the citizen science stuff I did with my old gear, and a few other projects I don't care to share on the internet? All that work came to fruition nearly at once. I'm now in almost two dozen scientific papers by name. I got some notes asking for help since I was a sucker once they figure they got me for life now. There were rumors that a few not-for-profits were going to give out some "atta-boys" and I received a couple of those. I chatted with the postal people for about an hour as I tossed the sales and maketing garbage into the recycle bin, chatted about space stuff a bit, and pulled all the tax paperwork I was expecting to the side. One of the people I helped a few years ago got their PhD and sent me a copy of their grad picture and a thank you, so I'll have to send them a congrats. I like to check in with the post office people because for at least a few brief moments, I can forget I live in a budding protestant theocratic shithole. Also in this run of mail was the final word on my journey home. My VISA and travel papers were rejected, again, and in a very final way. If I ever end up in Ireland, it will be in an urn for someone to dump my ashes unless the IRA takes the country back from the bandits. So, yay me. Speaking of the inevitable march of death, I checked in with the local hospital, gave blood, got weighed in. I now weigh less than at anytime since I was homeless a million years ago. When I wear a normal shirt my hips do not touch the fabric. I'm all arms, chest and legs now... the stretchmarks and saggy flesh from losing so much weight as an old bastard are all but gone. Ribs and hips are visible for the first time in decades. My face has hollowed out a bit and I now look like my relatives in the old pictures from when they escaped to America after being starved by the saxon barbarians in the 1850's. My internal shit is still not working like it should and I still should get treatmentes, and part of me wants to walk from this crap. But then I figured out that every time I walk into a hospital I cost two Gen Z kids and at least one millennial their retirement. So I'm back to bullshit again, timing multi-hour travel, multi-day adventures to go get prodded. The irony is that being off the internet these last few years have done more for my health and well-being than just about anything else I could have done. Turns out, for me at least, checking out of all ye all's bullshit is extending my life. They put me in a machine that should be banned as a war crime; I was able to maintain a 160BPM heart rate for 10 minutes for the first time in, fucking hell, maybe forever. Farm work is not easy, but evidently good for stamina and strength. And the longer I live the more I help implode this shithole country. While at the library, I looked at real estate prices in the general area. AHAHAHHAHAHAHHAHAH And once again I say yer all fucked if people are paying these prices for shit tier land out here. Everything has at least trippled. Rents are unsustainable, which is why every business has help wanted and shortened hours signs. Everyone under 30 with a brain and a tiny bit of ambition has run the ever loving fuck away from places like this. Everyone under 30 without a brain either joined the military or are working on the local farms and living in campers. This is something I did not notice at first, but there are no young people working the typical jobs that demographic would flood. The restaurant employees are all 40's and older. The gas station people are all retirees that came back to work to get out of the home. The post office people have been there since the 90's. The hospital has a contingent of college-age children working for school credit, or are there temporarily to pay off loans. Few if any of the people under 30 are the same when I return. Looking at rents in places people want to live? places even considered livable before the pandemic? Man, I'm glad I own this place. I'd not be able to sod off if I was making that choice now. If you are under 40 my advice is vote Republican cause they'll kill the unions and bail out the landlords and bankers that are keeping you poor and houseless. Seriously, however, it looks like at least one Amazon center unionized. Unions have until January to get their shit together before the traitors take the congress again. If they are not crushed into gravel, or have tanks rolled over them, or killed in no-knock raids, the new rise of unions is the one maybe bit of hope. I suggest reading about the mostly Irish people that unionize the mines and factories in the early 1900's to see what lays in front of you. The one bright spot in the last few years, if you believe it, has been the local bank. They have handled everything, and I am able to send bills to them for payment. Fortunately, the homestead is paid off, taxes are due in the summer, no water bill, no power bill. Turns out there are a whole community of people with property that don't come down to town regularly, and they have a business model around taking advantage of people like me. The one darker spot? The Sheriff's office. Since I am somewhat isolated, and still an outsider is a VERY rural area, I made the decision to introduce me, explain what I am doing, asked about gun ranges, hunting regs etc, and LARPED as a good, honest productive citizen. The Sheriff office still has Cuntface's picture as the US President, and at least one of the cops has a confederate tattoo. All police are vermin. It takes a special mentality to be a copper any more, stupid, easily let, aggressive, violent, asshole. No encounter with a cop is ever going to be good unless they think you are one of them. After every interaction in this office, I feel dirty and mentally unwell. Sometimes, even now, the correct decision is to eat shit and like it. I live. I am getting healthier, moving in the right direction. I am also alive. Not being in the center of the coming chaotic shit show, I'm looking forward to the next ten or so years. I've made a whole string of choices to get me to this point. Many of them I doubted. Even more were "wrong" in the sense that I might have been able to choose better. I'm going to be angry about not moving to Ireland when I had the change before the door was slammed in my face, and that mentality will be around forever. It would be nice to live in a first world country again. Still, I am alive. I am in a look of planning for things in the future. I chuckle at every disability check that hits my bank account and salute the sucking at the teat of the national treasury. I've even overcome the guilt of taking the checks since my retirement funds in the stock market are hurting. The only thing I am missing on my road to total nihilism is a MAGA hat and 10 of those big "I'm an uneducated fucking traitor asshole yeehaw" flags on my truck. At least my local gun store does not have confederate flags all over the place like some within driving distance, even if they are associated with the local shit-church with Gun totin' Jesus slogans on the walls. This post completes my promise to come back on the internet for a year. I've called the people I made this promise toward, told them this is about all I care to do or say online, except maybe a "I FUCKING TOLD YE CUNTS SO EAT SHIT" after the election in november, depending on weather. People like me do not belong in the new online world, and I don't. fucking. miss. this. shit. Yet still, that is not fair for a closing statement. Some of you will read this and think I am talking about a societal collapse. Fallout level desolation. that is not what is coming sooner than you think. What is going to happen is that the wealthy are going to do fine. The not wealthy are going to have to slug through a denser and more disgusting pudding of liquid shit every day. Health care is going to suck more as all the nurses quit. Roads won't get fixed and get worse. Food safety will falter. Air quality will get worse and worse. Fires in the summer will be bigger. But the lights will mostly stay on. Water will mostly be safe. Store shelves will mostly have goods for sale. Wages will be shit, rents will be uncontrolled, and buying a house as a normal person will become a memory fading into the rear view mirror. Retirement funds will be raided more and more. Social security will be allowed to fail because we have two parties that are owned by people pissed that trillions of dollars are out of their reach. Gains in environmental laws are already rolling back, and national parks will be turned into resource extraction zones. the rule of law will only mean anything if you have millions in the bank to defend yourself. But mostly, life will go on. Every step will be a bit deeper in an open sewer that never ends, but you will have the feeling of progress. Spending money and political capital on the policies to make things better will slog in our government halls, and what meager bullshit half measures that DO get passed will be nuked by the courts. America won't outright fail. You will simply continue to not rise to your obligations. Your allies will come to depend on you less and less until one day you put down your phones and take a look around and see nothing but shit. Civilization is a very complex, very fragile, very delicate thing that is currently being held together by cellophane tape, spare wire, hopes, and good feelings. America has two political parties. One fucking evil that wants to take a hammer to everything and sell off the pieces, and a part of wall street bankers afraid to do anything that is going to fuck with stock prices. And both parties are ruled over by old people that should have retired or died decades ago. I'm not going to call you stupid for having hope, but I am going to call you ignorant and not paying attention.
In the coldest hour, in the dark before the dawn, it is forecasted 82F and 60% humidity for the next week. We've had 12 days 100+ so far, and 6 more in forecasted in the next 8 days, and it's still early July. It's going to be a long hot summer. Planning to get a Synology NAS to replace the file share, backup server, and music server running off a first gen raspberry pi, and also move Plex to the NAS from a really loud desktop which can then hibernate most of the day. This decision comes after a laptop hard drive quit, promising to find some photos i digitized a decade ago that should still be around somewhere, and finding some old external backups had gone bad while sitting in a closet (dropped maybe?) all in the same week. The pi has been chugging along in the background syncing and snapshotting so I don't think I lost anything, it's just slowwww. I found the old photos at the bottom of something like ”/home/thurber/copy of Seagate drive/old backups/WD1TB/Dell laptop/old laptop recovery/..." which proves I've been doing backups wrong a lot longer than I've been doing them right. The company I'm at split and the half I'm in was sold, the official date was last week. It's been in the works for a year, from the limited information available it seems positive, too soon to say what effect it will have on the culture. The puppy has recovered from the fireworks now, she spent a lot of the weekend sheltering under furniture and climbing into open cabinets.
Are all 3 of them the 8 bay model you wrote about before? I'm pretty sure a 4bay DS420+ would be more than enough for a bunch of years. Wouldn't allow as much redundancy as a larger one ... Though I don't think the extra redundancy is necessary, I'm not doing anything critical and I've been using no redundancy for years. Have you been pushing the CPU or memory limits of yours? I don't think I'll be doing anything CPU intense.
Naah. It ate shit. Not before I put a cage extension on it for another five drives, though, thereby putting me in a frame size that doesn't integrate cleanly. I had a choice: buy another 8-bay and another 5-bay extension? Or go stupid. Fortunately some hospital in the midwest somewhere thought they were going that way and then changed their mind so I got it refurbed off newegg for like 50% off. It was still damn near $2k. I've had to rebuild SHR2 twice now. It's entirely drama-free. I have had hot-swap drives kick over and rebuild automatically. It has also been drama-free. I even had to move an entire array from one Synology to another (11 drives worth!!!) and it was surprisingly drama-free. Never even needed to get into command line. Rebuild speeds are hella faster, too. It'll cook over a 4TB in like a day. The 10TBs take like two and a half days. I'm nervous as shit while it does it? And I'll, like, disconnect it from the network so nothing can write to it while it's doing it? But I'm running a mix'n'match mishmash of horsepower that I think is good for 60TB and that doesn't include the two hot-swaps I have sitting in there. That's just the media monster, though, with all the samples and photos and work product on it. Every time I do a full backup of Plex it's 8TB. I've got a little 8-bay for video surveillance and laptop backup at work, and then I've got a little legacy 2-bay that I run Drive for, like, 12 computers on. I have opted to keep Plex off the Synology because Plex, in a real-life environment, does a lot of video transcoding. Synology does not do video. You can get a -Play or whatever but still, a legit video card is useful. The video card on the monster I'm running Plex on is like a 9-year-old 1730 or something and it doesn't like AVI files? But what I've seen of transcoding on Synology has kept me clear. Video surveillance will tax them. I was running eight HD cameras on the 2-bay guy and it was running at like 80%. 15 cameras on the 8-bay is like 8%. I have 4 cameras on this quad-core Xeon monstrosity and it could care less. Mostly it does backups all day every day and it does them with aplomb. I wholeheartedly recommend redundancy. The ability to go "hard drive crash, oh well, guess it's time to buy another drive" is entirely worth it. All the original drives in that array are now a RAID5 array sitting in my pro tools machine. I keep Plex on there. They've been going 24-7 for... more than 3000 days. I retired two of them for SMART status, and two of them crashed.
Hmmm. This is a case of anything-is-a-massive-step-forward vs more-is-more-better. I can't see myself needing your storage capacity, definitely not any time soon. I'd try Plex on it to see if it works, my Plex use is less intense too, 99% is to a Roku in the next room and the very few things which need transcoding i generated an optimized versions already... And if it's a disaster I can move it back. I could fit an 8 bay one in the budget, and having the drive bays for double redundancy and a hot swap is real tempting, but I'm also still pretty sure it'd be happy with the 4 bay. The main goal is making automated backups easier than my Frankenstein pi setup, and everything else is bonus.
The smart money runs Plex on an NVidia Shield. Play around here and see if four drives makes sense. I went bigger because in RAID5, you start hitting efficiencies at 5 drives and in RAID6, you start hitting efficiencies at 6 drives. I use Carbon Copy Cloner to back up Macs and Macrium Reflect to back up PCs.
Today 4 is fine. I need to sit on this decision a few days and weigh current size vs future expansion. Just found out that the model I mentioned isn't one that can be expanded though, their model numbering is a pain. Macrium Reflect looks good, thanks.
A couple considerations: - 8 drives is the number where Synology firmly separates "hobbyist" from "SOHO." 12 drives is where they separate "SOHO" from "Enterprise." - The numbers you care about are DS2-, DS4-, DS6-, DS7-, DS9-, DS15-, DS16-, and DS18-. That stands for "Disk Station" where 2, 4, 6 are basic-bitch with that many drives, 7 and 9 are value-add with expansion and 15, 16 and 18 are their SOHO sizes that expand a lot. The numbers after the dash (which is a convention I have added for simplicity) is generation number. Thus a DS214 is a 4th generation 2-drive model. A DS214 plus is a 4th generation 2-drive model with slight revision, like maybe a little more memory. Thus, the 1813 plus I was running is eight generations older than the 1821 plus they're currently selling, but they're both 8-drive, fully-expandable models. Things only get tricky when you buy expansion chassis, because some expansion chassis bridge generations but it's not obvious. - Synology, if they aren't dead, go for a lot used. It's like they're Macs or something. A 1621 is a thousand dollars off Amazon. A 1618, which is three generations old, is $700 rode hard put away wet on eBay with no pedigree. I sold my busted one for $250 (I think?). I sold the expansion, which I bought used, for more than I bought it used for, having used it for four years. DS214s go for around $150 used; I bought ours new for $179? $229? seven goddamn years ago.
I decided a DS15- fits a nice balance of doing everything I want without going wildly overkill, but I can expand it in the future if needed. I'll see if I can get the newer 22+ without too much backorder delay. Thanks for the help
Waiting to board our Eurostar back to the mainland after a surprisingly packed week away in London. It's done me quite well to (slowly, steadily) move a lot the past week. The city's hubski-friendly, although I forgot to bring any stickers!
It's been raining a lot here. The balcony above mine has started leaking onto mine. So now I get to deal with that. The person living in that apartment is a tenant, so I've sent the homeowners an email last night and am waiting to hear back. Don't know how it's going to go down but the tenant was nice so that was good at least. My job is glorified data entry and I'm treated like I don't know shit. Because of that motivation is out the window. Yesterday there was an exhilarating problem where the data I look up and upload was incorrect, it was by far the most exciting thing in this job to happen to me in months (with exception to the assisting writing the abstract). Took my colleagues all of an hour to figure it out and fix it. An old Portuguese friend of mine just moved to Belgrade to be closer to his girlfriend. Her cousin is the head of global human resources at AstraZeneca. He's going to poke and prod for me. We have a video call set up this weekend which should be nice. Beyond that, I've got nothing super exciting to report. Might shoot for a Hubski virtual meetup sometime next week, but that's about it.
I'm doing multiple Pubski-driftings here. Just to keep the current pub top-of-feed. Not much comment on the lower pay portion of yet - but assuming there's the already lower pay elsewhere, would that mean a significant amount less would be unlivable? Regarding healthcare, it would require saving up for the event of less pay... but I recommend reviewing 'travel insurance' as potentially interim health insurance.
Lower pay -- Highly Skilled Migrants over 30: 4840 Euro/month gross pay; under 30: 3549 Euro/month gross pay; Reduced per visa: 2543 Euro/month pay. It's a pretty significant drop and while it makes finding a job easier, it makes affording to live a lot harder. -- https://ind.nl/en/required-amounts-income-requirements As far as healthcare, I'm not sure if travel insurance would work since I'd be moving with a residency visa and not travelling for leisure. I'm sure they would fight it on those grounds. Not sure what other pitfalls may be as I haven't looked into it.
CLEARLY didn't eat my wheaties that morning. That's a simple google-search fact check... Will keep an eye out for something similar none-the-less if you haven't found something already as a possible route to insured healthcare.As far as healthcare, I'm not sure if travel insurance would work since I'd be moving with a residency visa and not travelling for leisure. I'm sure they would fight it on those grounds. Not sure what other pitfalls may be as I haven't looked into it.
Goals Short-Term: - Revive passion projects as way to learn PostGIS - Regain employment by September (absolute latest) Mid-Term: - Scope out feasible new countries of residence - Lose the COVID 60lbs #WorkIt Long-Term: - Finish setting up my office - Shell away more emergency money - Contingent on 2024 election outcome
veen Please excuse the delay. I've been in the middle of moving in with the S/O on top of a family visit that has thrown off my schedule without my full workstation... You've hit a loooooooooot of topics swirling on my mind for a few years now. Looking back on my certificate and MS in GIS. I've realized this profession could easily be taught in a trade school. A couple courses here (one on vector data and it's applications; followed by a course on raster), another there (types of data collection - in situ, remote sensing and its varieties). Maybe, just maybe some visualization via web dev (AGOL), storage/'big data' (SQL/PostGIS) or automation (ArcPy). That right there could get a solid 2 years' worth of 'full-time' schooling and be done with it. This isn't to say I'm happy to have a couple extra letters after my name, but - call it imposter syndrome if you want - I don't think the value of what I learned in grad. school significantly impacted the type of job or salary I got coming out. Even looking at the market now, there is very little in between from technician to developer work. From what I've found, most job descriptions don't have that much variation between Tech - Analyst - Specialist. Unless, of course, you're starting out as an imagery analyst. Which is a job that has its day's numbered. A shockingly small niche (over here at least) is the people who are good at writing queries and half-decent at GIS. PostGIS legitimately can replace 95% of the individual pre-made tools QGIS and ArcGIS has to offer. You can do much more complex things much faster. My largest project the past year ended up being 2300 lines of PostGIS/SQL code I wrote on my own. The first 30% is just data prep written in code - "make sure I properly join tables A thru G in the data type I want it to be without ever having to touch Field Mappings ever again". The rest is a bunch of clever geo-joins and a bunch of not clever regular joins of tables and features. Nothing special to anyone who already knows how to handle semi-long SQL queries; PostGIS is really just one new column type and a bunch of functions to do stuff with it. The tipping point at my last workplace was a senior GIS dev that replicated my 2 months of census analysis (via ArcGIS) under 2 weeks with PostGIS. Now, I adore this dev, they were the only mentor in that floor. It made me realize how much more there was out there in GIS (and how little I could contribute to the field with my current skillset). Most salient of the points made while watching said dev work was "You've done a great job grinding at this for the past two months, though QC'ing is not possible since ESRI writes fresh data every. step. of. the. way. Now scale that over the course of 2 months of troubleshooting, trial & error, etc." It's a no-brainer. Would you mind sharing the course you took by chance? My resources of yet are a couple textbooks by recommendation of the former GIS Dev co-worker, a 4 hour YT vid on PostgreSQL, and a coursera course on SQL.As a whole the GIS world is...surprisingly shallow. There are some technical niches for sure, but compared to what I've seen in other domains of engineering, one can get incredibly fast to a point where one can do 80% of all GIS work. Really, a basic GIS course combined with a modicum of data-wrangling chops and Google skills can get you very far. To speak from personal experience; I had 2 mandatory GIS courses at uni, took one PythonGIS elective
and learned enough on the job the past 4 years (all of ArcGIS Online PostGIS + ArcPy) that I can prolly apply for most senior GIS jobs out there. A lot of GIS work is just about getting the right input into the right GIS tool(s) and ✨presenting✨the result. I know people who have done nothing more than "load data into GIS, apply pre-made tools, visualize" for decades.
I learned Python/ArcGIS programming with the Zandbergen Esri Press book. PostGIS was a tailor-made course with some booklets that explain the most common hurdles that you'll run into going blind, but it was in Dutch so I don't think it'll be of much help. Honestly - there are likely a bunch of good free tutorials out there, and the rest you can learn by doing a lot of googling that starts with "postgis" followed by some geoprocessing function you already know how to use in ArcGIS. There's a lot of useful PG code on GIS Stack Exchange, but I would strongly recommend you put in the effort to figure out what all the puzzle pieces do in other people's code answers. PG for day to day GIS work is best learnt by doing. One piece of tribal knowledge: you can rename columns on the fly, simply by having any text after it. The official syntax is Basically, PostGIS is a big sack of useful functions and it's up to you to assemble them correctly. The biggest increases in productivity beyond basic operations, has been to understand a) how to cast data (e.g. '1234'::int becoming the int 1234), b) understanding when to use nested queries (mostly whenever your joins become too large for your memory to handle), and c) mastering the GROUP BY. The best learning tool for me has been to create one "Cheat Sheet" file. Every time I learn a new function or way of solving a problem, I add it to that file with a little one-line comment. Below a few useful ones for the most common geodata edits I keep at the top, which are the below. SELECT PostGIS_full_version(); --create column index create index idx_cbs_woonkernen_reistijd_weg_woonkern on bo_cbs.cbs_woonkernen_reistijd_weg using btree(woonkern); create index sidx_hx_tmp_geom ON hx_tmp USING gist(geom); --add primary key alter table bo_cbs.cbs_woonkernen_reistijd_weg add id serial primary key; --change coordinate system alter table bo_cbs.cbs_woonkernen_reistijd_weg alter column geom type geometry(polygon,28992) using st_transform(geom,28992); -- Set geometry type and drop z axis from points that have them alter table pr_dm_eindhoven_2022.deelautos_benchmark alter column geom type geometry(point,4326) using st_force2d(geom); -- alter geometry type ALTER TABLE my_table ALTER COLUMN geom TYPE geometry(MultiPoint,4326) USING ST_Multi(geom); ALTER TABLE pr_dm_heuvelrug_2019.tankstations ALTER COLUMN geom TYPE geometry(Point,28992); ALTER TABLE pr_dm_engie_2021.lms_wegen_2030 ALTER COLUMN wkb_geometry TYPE geometry(LineString,28992) using st_transform(st_setsrid(wkb_geometry, 4326),28992); select updategeometrysrid('pr_dm_engie_2021', 'lms_wegen_2030', 'wkb_geometry', 28992)
but the much more common lazy variant is to drop the 'as' and to use very short aliases for tables. So this is valid and common to see, because it's much faster to refer to a table by 1 letter even if it's harder to read for others: SELECT table.columname AS newcolumname, SELECT b.columname a FROM schema.table b -- find out your current PG version
Bookmarked this very comment. Thank you very much. It's been hard not to get distracted with shiny gadgets like qgis2threejs while messing around with personal projects. While I realize I've come a little farther than I expected in a matter of days, there's quite a lot to polish and a lot of resources out there. Appreciate the back and forth on the topic. Hard to find opensource GIS discussion IRL in my town.
I'm learning/using PostGIS atm. It amazes me what can be done. Tangentially, I have a very very basic Postgres question: Can you query Postgres and just get the value(s) from a row without JSON or any other formatting? i.e. ..and if v1 is "foo", it only returns "foo". Not a table or JSON array with "foo" in it, etc. SELECT v1 FROM things WHERE id = 3;
That's mostly likely a function of whatever thing / programme you're using to query. Through PGAdmin or QGIS I also always get a table back. But I get values back when I query via Python: psycopg's fetch functions return just the data in a semi-structured fashion.
Holy hell is my choice to live an interesting and full life exhausting. Lately I feel like every week counts for a month in terms of lessons, projects and the emotional rollercoaster of emotions. Like knowing myself and growing all the skills and competencies and communication over the years now just allows me to get more shit done faster. Thus taking on more responsibility and stress, wins and fails, connections and heartbreak. The range of space between éclosion and burnout is getting wider, scarier. Watching my friends finding great professional success or ending up in the mental hospital manic. Juggling a multitude of poly relations or life disrupting breakups. My own life right now is torn between some mind blowing and terrifying aspects I’m compartimentalising to push forward. Everything feels uncertain.
This is probably going to be my song of the summer. My ex is mostly moved out of this point, now I just need my toolkit back so I can start rebuilding my apartment which I'll be moving out of at the end of next month when the lease is up. Going to stay in the town I currently live in though is the thought right now, the amazing access to trail running, rock climbing, skiing in winter, etc. is too much to pass up. Just kind of throwing myself into climbing for the next 2-3 months and see what happens, could be a good opportunity to make some real unrestrained progress. Last night I went to the trail run club that I hadn't been going to in quite a while despite already having a couple of friends in it, hadn't been going too much because of my relationship. Had a great time, made a couple of hopefully new friends, and now have plans to rock climb with a couple of people from that group late next week. Lots of moving pieces, lots of opportunities to further define myself as individual.