Note Lists :
Tags :

Latest Notes

Create a function that stores a X3D file with GeoReference

takes the unique id as text
takes the geometry 

CREATE OR REPLACE FUNCTION 
    public.kolon_aciklama_getir(
            veritabani character varying,
            sema character varying,
            tablo character varying)
RETURNS TABLE(kolon character varying, aciklama text) 
LANGUAGE 'plpgsql'
Creating a function with several I/O parameters

- Add input parameters
- Use the input parameters in the SQL body

<Label>
    <ogc:Function name="strToUpperCase">
        <ogc:PropertyName>NaMe</ogc:PropertyName>
    </ogc:Function>
</Label>
Capitalize feature names in SLD

Replace ID with the actual one in Geoserver

Display the actual id column instead of the auto-generated Feature ID column

for dosyaadi in *.tif
do
gdal_translate -a_srs EPSG:5254 $dosyaadi turef/$dosyaadi
gdaltindex -tileindex location tindex_5254/$dosyaadi.shp turef/$dosyaadi
ogr2ogr -f "ESRI Shapefile" tindex_4326/$dosyaadi.shp tindex_5254/$dosyaadi.shp -s_srs EPSG:5254 -t_srs EPSG:4326
done
Creating the boundaries (tindex) of raster orthophotos with unix script

- Creating the boundaries (tindex) of raster orthophotos with unix script
- masking them with the same name 

gdal_calc.py -A input.tif --outfile=output.tif \
--calc="(A>-32767)*A" --NoDataValue=0.00000 \
--co=COMPRESS=DEFLATE --co=PREDICTOR=3
Assigning Nodata to a GeoTIFF file with a negative Nodata value with GDAL_CALC.py 

gdal2tiles.py --profile=geodetic \
--s_srs='EPSG:4326' --zoom=0-18 \
--tmscompatible --force-kml \
--webviewer=leaflet --title=TumIstanbul \
tum_ist_bffr_250m_v4.tif gdal_tiles_result.tif
Creation of TMS grids and geotiff fragmentation with gdal2tiles 

(~numpy.isnan(A))*A
Changing the nodata value in geotiffs with NAN value with GDAL_CALC

If “nan” is present in geotiff, the expression should be as follows:
"(~numpy.isnan(A))*A"

gdal_fillnodata.py -md 3 \
buyukada.tif buyukada_filled.tif \
-of GTIFF -co COMPRESS=PACKBITS \
-co NUM_THREADS=6 -co BIGTIFF=YES
Removing small holes in raster data

ADD vs COPY

  • ADD allows copying from the URL
  • ADD allows tar file auto-extraction
Differences of Dockerfile Instructions 

for file in *.xyz; 
    # adjust NS resolution
    do echo "$file"; gdalwarp -t_srs EPSG:4647 -overwrite "$file" "$(basename "$file" .xyz).tif"
done
Combine XYZ files and merge as GeoTIFF

Convert and merge XYZ files as GeoTiff

lxc config device \
add pgpp postgres-forward \
proxy listen=tcp:0.0.0.0:5432 \
connect=tcp:127.0.0.1:5432
How to forward a port from an instance to the host in LXD

- adds a rule with a specific name
- rule forwards specific port to another one

Axe Description
Ancestor Selects all ancestors (parent, grandparent, etc.) of the current node
ancestor-or-self Selects all ancestors (parent, grandparent, etc.) of the current node and the current node itself
attribute Selects all attributes of the current node
child Selects all children of the current node
Axes in Xpath

- explains the axes (parent, child etc)
- contains examples with objects

PREDICATE Description
book[1] Frist node in book
book[last()] Last node in book
[last()-1] Last but one
[position<3] First two nodes
Predicates and Operators in Xpath

- explains predicators
- explains simple operators

Expression Description
nodename Selects all nodes with the name "nodename"
/ Selects from the root node
// Selects nodes in the document from the current node that match the selection no matter where they are
Expressions and Wildcards in XPath

- explains expressions in XPath
- explains wildcards

Command in PostgreSQL Command in OracleDB
ARRAY_AGG JSON_ARRAYAGG
anyarray[1] JSON_VALUE(anyarray, '$[0]')
CONCAT(1,2,3) = '123' CONCAT(CONCAT(1,2),3)='123'
ST_Envelope(geometry) SDO_GEOM_MBR(geometry)
JSON Array Aggregation and CONCATenation in Postgre and OracleDB

- compares some aggregation or json functions
- includes unsolved issues

  • INSERT INTO must be declared before the WITH clause.
  • Every (real) table must be called with it's SCHEMA name.
  • If (real) table must be shorten with aliases, don't use "AS" conjunction.
Some rules to generate Postgre compatible SQLs for OracleDB

- INSERT INTO must be declared before the WITH clause.
- Every (real) table must be called with it's SCHEMA name. 

SDO_GEOMETRY
  - SDO_GTYPE
  - SDO_SRID
  - SDO_POINT
    - SDO_POINT_TYPE
  - SDO_ELEM_INFO_ARRAY
    - SDO_STARTING_OFFSET
    - SDO_ETYPE
    - SDO_INTERPRETATION
  - SDO_ORDINATES
OracleDB SDO_GEOMETRY Encoding 

tree.docinfo.xml_version
tree.docinfo.encoding
tree.docinfo.standalone
tree.docinfo.root_name
tree.getroot().prefix
Get some information from the XML document using lxml 

nmap -n -p <PORT_NUMBER> \
--open <LOCAL_IP_RANGE>/24 \
-oG - \
| awk '/Up$/{print$2}'
Search for a computer using a specific TCP port with nmap

scans for the opened ports in local network

xmlstarlet sel --template \
--match "<XPath expression here>" \
--copy-of "<XPath expression here>" \
<file_to_query.xml>
How to query a XML file and save a subset using XPath

- checks for a matching in an XML file
- copies a specific part for every match

Symbol(s) Unicode name(s) of symbol Rule(s)
# hashtag for single line commenting
- dash followed by a space for creating sequences (list member)
[ ] square brackets also works for creating lists
Character sets and the rules in YAML

Which special character used for what?

Slow down mouse wheel zoom in-out speed in Cesium

- cancels the standard zoom function.
- calculates the coordinate of the cursor's last point of movement.

Show only filtered instances of 3DTileset in Cesium

adds OSM buildings tileset
gets height property, converts to number/float and compare with a specif

Move the camera with keyboard shortcuts in Cesium

sets keyboard shortcuts for forward, backward, left, right, up and down moves
activates VR view

Showing Attributes of a GeoJSON data source with labels in Cesium

loads a geojson file into the scene
adds LabelCollection and populate the collection with the attri

Highlight and show an attribute as label on map by hover in Cesium

sets a nameOverlay HTML object to show attributes
assign a custom style to highlight a selected instance of 3DTiles

Get latitude, longitude and elevation on 3dtiles instances by left click in Cesium

checks if pickposition supported by the current browser
picks an instance from the added 3DTiles

Unicode Escape in YAML

How to escape special characters used in a string in YAML?

HTML Entity Escape in YAML

How to escape special characters used in a string in a YAML file?

Get Latitude Longitude and Height on terrain by left click in Cesium

adds a terrain
picks position info by clicking on terrain

Get all attributes of a 3DTiles instance by hovering over it in Cesium

enables position picking
add a function to list the attributes

Fly camera to the specified extents using BoundingSphere in Cesium

creates an extent set using WGS84
creates sphere using extents