mod10 - AJAX

Question 1

What is AJAX?

Answer 1

Asynchronous JavaScript & XML.
AJAX updates parts of a webpage without reloading the entire page.

Question 2

Name the 8 PostGIS components.

Answer 2

1) PostGIS
2) GEOS
3) GDAL
4) SFCGAL
5) LIBJSON
6) LIBXML
7) PROJ
8) RASTER

Question 3

What are the 5 key metadata views?

Answer 3

public.spatial_ref_sys
public.geometry_columns
public.geography_columns
public.raster_columns
public.raster_overviews

Question 4

List the SRIDs.

Answer 4

3005 MELP - Albers
3165 NAD 83 / Ontario MNR Lambert
3401 Alberta 10 - TM
3857 Web Mercator
3978 NAD 83 / Canada Atlas Lambert
3979 Canada Atlas Lambert
4267 NAD27
4326 WGS
26907 UTM zone 7N nad83
26908 UTM zone 8N nad83
26909 UTM zone 9N nad83
26910 UTM zone 10N nad83
26911 UTM zone 11N nad83

Question 5

What are the 10 PostGIS formats?

Answer 5

ewkb
ewkt
geoJSON
shapefile
wkb
wkt
kml
gml
svg
JDBC - native

Question 6

What are the spatial extensions of PostgreSQL other than PostGIS?

Answer 6

topology
tiger
pointcloud
pointcloud_postgis
pg_routing

Question 7

Which functions create new geometries in PostGIS?

Answer 7

St_Area
St_envelope
St_extent
St_3DExtent
St_Union
St_Intersection
St_buffer
St_symDifference
St_convexhull
St_difference

Question 8

What function can create new geometries but also inspect geometries?

Answer 8

St_Area

Question 9

Which functions inspect geometry?

Answer 9

St_X
St_Y
St_Area
St_NumGeometries
St_GeometryN
St_StartPoint
St_EndPoint
St_PointN
St_NumPoints
St_Length
St_ExteriorRing
St_InteriorRingN

Question 10

What functions can define spatial relationships?

Answer 10

St_intersect
St_within
St_contains
St_covers
St_coversBy
St_touches
St_crosses
St_Dwithin
St_overlaps
St_disjoint
St_equal