Map and Table Calculation

PNTCRD( ) function

Returns the (X,Y) coordinate of the point with record number PointNumber or with point name PointName from point map PointMap

Syntax

PNTCRD(PointMap, PointNumber)
PNTCRD(PointMap, "PointName")

Input

PointMap is a point map
PointNumber is the record number of a point
Domain type: any Value domain
PointName is a point name or a point value
Domain type: domain of the PointMap

Output

PNTCRD returns: the (X,Y) coordinate of a point
Coordinate System: same as input PointMap

Notes:

Tips:

Usable in

Simple calculators, MapCalc, TabCalc

Examples

Pocket line calculator examples:

Point map Rainfall stores rainfall values of rainfall station located in the area of Cochabamba (Bolivia). To retrieve the point of a certain rainfall station:

? PNTCRD(Rainfall,3)

returns e.g. (803511.00, 8087422.00)

? PNTCRD(Rainfall,"Laguna Santa Rosa")

returns e.g. (803511.00, 8087422.00)

TabCalc examples:

OutCol = PNTCRD(Rainfall,3)

 

Rainfall.mpp opened as table

Recordnr

Name

Coordinate

1

UMSS

(803429.00, 8074631.00)

2

Taquina

(799748.00, 8082415.00)

3

Laguna Santa Rosa

(803511.00, 8087422.00)

4

Laguna Totura

(801281.00, 8088967.00)

5

PROMIC

(802613.00, 8080483.00)

6

Aro Caqua

(806816.00, 8076585.00)

7

Colca Pithua

(797465.00, 8078352.00)

8

Cerro MachaMach

(796346.00, 8087736.00)

9

Laguna WaraWara

(806042.00, 8085414.00)

Applied example:

Given is a point map Pollution with points indicating sources of pollution. Create a raster map PolCircle with concentric circles with diminishing pollution around the point with identifier Plant 1. The pollution is 100% at the circle center and 0 at 1 km distance. Use a linear function. The output raster map has the same georeference as map BaseMap. The coordinate system is assumed to be in meters.

PolDist = DIST(PNTCRD(Pollution,"Plant 1"),MAPCRD(BaseMap))

PolCircle = IFF(PolDist>1000,0,PNTVAL(Pollution,"Plant 1")*(1-Pollution/1000)

if you would like to use the calculation for a point map that has pollution centers only identified by their pollution value (i.e. a value point map), you can find individual point numbers by opening the point map as a table. For doing the previous operation on the point with the highest pollution, open the point map as a table and identify the record number with the highest pollution. If the record number is 5, the Map calculation statement would be:

PolCircle = IFF(DIST(PNTCRD(Pollution, 5), MAPCRD(BaseMap)) > 1000, 0, PNTVAL(Pollution, 5) * (1 - DIST(PNTCRD(Pollution, 5), MAPCRD(BaseMap))/1000)

See also: