SWEREF insert procsys v090 sql.json (setup_db)
Insert table data for process systems
The json command file SWEREF_insert-procsys_v090_sql.json is part of karttur’s GeoImagine project setup_db. Calling the json file will execute the following commands of the GeoImagine Framework.
{
"process": [
{
"processid": "tableinsert",
"overwrite": false,
"parameters": {
"db": "karttur",
"schema": "process",
"table": "procsys",
"command": {
"columns": [
"subprocid",
"system",
"srcsystem",
"dstsystem",
"srcdivision",
"dstdivision",
"srcepsg",
"dstepsg"
],
"values": [
[
"'DefaultRegionFromCoords'",
"'sweref'",
"'NA'",
"'system'",
"'NA'",
"'region'",
"0",
"3006"
],
[
"'DefaultRegionFromVector'",
"'sweref'",
"'sweref'",
"'system'",
"'NA'",
"'region'",
"0",
"3006"
],
[
"'ExtractTileCoords'",
"'sweref'",
"'ancillary'",
"'sweref'",
"'region'",
"'tiles'",
"0",
"3006"
],
[
"'VectorizeRegionTiling'",
"'sweref'",
"'system'",
"'sweref'",
"'region'",
"'region'",
"4326",
"3006"
],
[
"'MosaicTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'region'",
"3006",
"3006"
],
[
"'MosaicAdjacentTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ReprojectAncillaryRegion'",
"'sweref'",
"'ancillary'",
"'sweref'",
"'region'",
"'region'",
"0",
"3006"
],
[
"'GdalDemRegion'",
"'sweref'",
"'sweref'",
"'sweref'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'GdalDemTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'NumpyDemRegion'",
"'sweref'",
"'sweref'",
"'sweref'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'NumpyGeomorphology'",
"'sweref'",
"'sweref'",
"'sweref'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'NumpyDemTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'NumpyGeomorphologyTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'GrassDemFillDirTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'GrassDemHydroDemTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'GrassDemReInterpolateTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'BasinOutletTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExtractTilesPointList'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExtractTilesPointVector'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExtractTilesLineVector'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExtractTilesPolyVector'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'Grass1to1Tiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'GrassOnetoManyTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'TranslateRegion'",
"'sweref'",
"'sweref'",
"'sweref'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'TranslateTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportTilesToByte'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportShadedTilesToByte'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportTilesToMap'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportTilesToSvg'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportsToMovieFrames'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportMovieClockLayout'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ExportMovieOverlayFrames'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'ZipArchiveRegion'",
"'sweref'",
"'sweref'",
"'export'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'ZipArchiveTiles'",
"'sweref'",
"'sweref'",
"'export'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'DuplicateRegion'",
"'sweref'",
"'sweref'",
"'sweref'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'DuplicateTiles'",
"'sweref'",
"'sweref'",
"'sweref'",
"'tiles'",
"'tiles'",
"3006",
"3006"
],
[
"'LinkDefaultRegionTiles'",
"'sweref'",
"'system'",
"'sweref'",
"'region'",
"'region'",
"0",
"3006"
],
[
"'TileAncillaryRegion'",
"'sweref'",
"'ancillary'",
"'sweref'",
"'region'",
"'tiles'",
"0",
"3006"
],
[
"'OrganizeProjSysData'",
"'sweref'",
"'sweref'",
"'sweref'",
"'region'",
"'region'",
"3006",
"3006"
],
[
"'ReprojectAncillaryRegionProjSys'",
"'sweref'",
"'ancillary'",
"'sweref'",
"'region'",
"'region'",
"0",
"3006"
],
[
"'ReprojectDefaultRegionProjSys'",
"'sweref'",
"'system'",
"'sweref'",
"'region'",
"'region'",
"0",
"3006"
]
]
}
}
},
{
"processid": "tableinsert",
"overwrite": false,
"parameters": {
"db": "karttur",
"schema": "system",
"table": "systemepsg",
"command": {
"columns": [
"system",
"epsg"
],
"values": [
[
"'sweref'",
"3006"
]
]
}
}
}
]
}