pamelafox

<div class="control-group">
   <label class="control-label">Location</label>
   <div class="controls">
     <input name="location" type="text" placeholder="City, State, Country" value=""> 
     <input name="location_city" type="hidden" value="">
     <input name="location_state" type="hidden" value="">
     <input name="location_country" type="hidden" value="">
     <input name="location_lat" type="hidden">
     <input name="location_lng" type="hidden">
    </div>

jazzido

WITH votos_summary AS
  (SELECT ve.mesa_desde,
          ve.mesa_hasta,
          SUM(total) AS total_parcodigo,
          ve.vot_parcodigo,
          ve.dne_distri,
          ve.dne_seccio,
          row_number() over(partition BY ve.mesa_desde,ve.mesa_hasta
                            ORDER BY sum(total) DESC) AS rk
   FROM votos_establecimiento_octubre ve

fvanderbiest

<?xml version="1.0" encoding="UTF-8"?>
<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2" service="CSW" version="2.0.2" resultType="results" maxRecords="100" xmlns:gmd="http://www.isotc211.org/2005/gmd">
    <csw:Query typeNames="csw:Record">
        <csw:ElementSetName>full</csw:ElementSetName>
        <csw:Constraint version="1.1.0">
            <ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
                <ogc:PropertyIsEqualTo matchCase="true">
                    <ogc:PropertyName>subject</ogc:PropertyName>
                    <ogc:Literal>Bâtiments</ogc:Literal>
                </ogc:PropertyIsEqualTo>

craftdelivery

Overview

Goal is to migrate a database from Heroku to Google Cloud

Issues

• recreate extensions
• skip copying postgis spatial ref table

Environment Variables

palewire

How to push tagged Docker releases to Google Artifact Registry with a GitHub Action

Here's how I configured a GitHub Action so that a new version issued by GitHub's release interface will build a Dockerfile, tag it with the version number and upload it to Google Artifact Registry.

Before you attempt the steps below, you need the following:

• A GitHub repository that contains a working Dockerfile
• The Google Cloud SDK tool gcloud installed and authenticated

Create a Workload Identity Federation