Skip to content

Instantly share code, notes, and snippets.

View hhkaos's full-sized avatar
🏠
Working from home

Raul Jimenez Ortega hhkaos

🏠
Working from home
View GitHub Profile
@hhkaos
hhkaos / fake_rentals.json
Last active December 3, 2025 10:25
fake_rentals.json
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
/**
* Devuelve el color de fondo (hex) de una celda.
* Uso: =GETCOLOR("Hoja1!B2")
*/
function GETCOLOR(a1Address) {
if (typeof a1Address !== 'string') return '';
const ss = SpreadsheetApp.getActiveSpreadsheet();
let sheetName = '';
let cellAddress = a1Address;
@hhkaos
hhkaos / arcgis-hosted-services-explained.md
Last active October 22, 2025 13:24
ArcGIS Hosted Services Explained: Feature, Vector & Map Tiles Services [Blog series]
Título del artículo A quién va dirigido Qué ganarás al leerlo
Caso de uso para cada tipo de servicio de datos Product managers, product owners y solution architects. Desarrollar un modelo mental claro de para qué es más adecuado cada servicio (antes de entrar en los detalles).
Diferencias en la creación y mantenimiento Data engineers, desarrolladores, solution architects y technical product managers. Comprender las ventajas y limitaciones de cada servicio, y algunos detalles de implementación de bajo nivel, para poder elegir el adecuado y planificar la mantenibilidad a largo plazo.
**[Diferencias en herramientas de gestión](https://www.esri.com/arcgis-blog/products/developers/developers/arcgis-hosted-dat
@hhkaos
hhkaos / arcgis-developer-guide-snap-to-roads.markdown
Created July 2, 2025 09:20
ArcGIS Developer Guide: Snap to roads
@hhkaos
hhkaos / arcgis-developer-guide-snap-to-roads-using-travel-mode.markdown
Created July 2, 2025 09:20
ArcGIS Developer Guide: Snap to roads using travel mode.
@hhkaos
hhkaos / arcgis-developer-guide-snap-gpx-track-points-to-roads.markdown
Created July 2, 2025 09:20
ArcGIS Developer Guide: Snap GPX track points to roads
@hhkaos
hhkaos / arcgis-developer-guide-snap-to-roads.markdown
Created July 2, 2025 09:20
ArcGIS Developer Guide: Snap to roads
@hhkaos
hhkaos / arcgis-developer-guide-find-the-speed-limit-of-the-closest-road.markdown
Created July 2, 2025 09:19
ArcGIS Developer Guide: Find the speed limit of the closest road
@hhkaos
hhkaos / print-service-example.md
Last active February 16, 2025 15:15
print-service-example

Service endpoint: https://utility.arcgisonline.com/arcgis/rest/services/Utilities/PrintingTools/GPServer/Export%20Web%20Map%20Task/execute

Parameters:

  • format: PNG32
  • Layout_Template: MAP_ONLY
  • Web_Map_as_JSON
{
    "mapOptions": {
@hhkaos
hhkaos / google-app-script.js
Created January 30, 2025 08:53
Automatically update the last update date of a row in a Google Spreadsheet
function onEdit(edit) {
var row = edit.range.getRow()
var timestampTimeZone = "GMT+1"
var timestampFormat = "dd/MM/yyyy"
if( row >=2 ){
var timestamp = Utilities.formatDate(
new Date(),
timestampTimeZone,
timestampFormat)
SpreadsheetApp