Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

7132- Database > Exam 4 (Mod 9-11) > Flashcards

Exam 4 (Mod 9-11) Flashcards

1
Q

What are the 5 key node folders (express framework)?

A

bin, public, views, node_modules, and routes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What folder in the express framework is responsible for the startup (contains core software)?

A

app.js

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which node folder holds the www file containing the startup script for the webserver?

A

bin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Which node folder contains all front-end content?

A

Public -> holds front-end js librarys, css files, static files, favicon.ico,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Which node folder does the require() function look for libraries?

A

node_modules

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Where are node pug files kept within the node folder structure?

A

views

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are 6 common node packages for geospatial (list and describe their purpose)

A

1) Proj -> provides coordinate system transformations
2) Leaflet -> Js web mapping client
3) OpenLayers -> Js web mapping client
4) Pg -> connect and SQL w/ postgresSQL
5) Proj4leaflet -> to reproject for leaflet
6) Express-session -> back-end framework

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is NodeJs and what are its 7 components and their role?

A

NodeJs is an open-source, cross platform JavaScript runtime environment.

NodeJs

Below is a list of its 7 components:

1) crypto -> encryption

2) DNS -> domain name system

3) Event Loop -> for non-blocking IO

4) node bindings -> http, socket, file system

5) node Standard lib -> ~ 35 Js files

6) thread pool -> where all the long-running operations are performed in the background

7) V8 Engine -> interprets the JS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the 6 components of node express?

A

1) node
2) express
3) router
4) Pug What is it?
5) method
6) npm What is it?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the main characteristics of Pug?

A
  • shorthand HTML with no closing tags (mix of Js & HTML)
  • variables that usually contain JSON from server
  • indentation sensitive
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the 9 key files in a node Javascript App?

A

app.js

user.js

index.js

gist7132.js

error.pug

index.pug

layout.pug

styles.css

gist7132.css

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Name 7 current webstorm projects.

A

Angualar

Bootstrap

Dart

Empty

HTML5 BP

Node Express

Phonegap

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What are the 12 possible geometry types?

A

CIRCULARSTRING

CURVEPOLYGON

GEOMETRYCOLLECTION

LINESTRING

MULTILINESTRING

MULTIPOINT

MULTIPOLYGON

POINT

POLYGON

POLYHEDRAL SURFACE

TIN

TRIANGLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What are 8 spatial file formats?

A

Extented Well Known Binary (EWKB) > more info

Extented Well Known Text (EWKT) > more info

GeoJSON

Geography Markup Language (GML)

Keyhole Markup Language (KML) > more info

Scalable Vector Graphics (SVG) > more info

Well Known Binary (WKB) > more info

Well Known Text (WKT) > more info

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are 11 options offered through the D3 Javascript library?

What is D3? –> More info at: D3

A

Circle pack with zoom > image
Circle packing > image
Cluster dendrogram > image
Force-directed graph > image
Force-directed states
Hierarchical edge bundling > image
Motion chart
Non-contiguous cartogram
Projections
Voronoi diagram > image
Voronoi tessellation/hover

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are 12 Google chart style options?

A

Area
Bar
Bubble
Candlestick
Column
Donut
Gantt
Geo
Map
Pie
Table
Trendlines

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What are 8 characters that might be used when parsing?

A

Braces

Brackets

Comma

Equal

Parentheses

Semicolon

Space

Colon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

List 10 functions related to JSON.

A

row_to_json
array_to_json
to_json
json_array_length
json_each
json_object_keys
json_agg
st_geomfromgeojson
st_asgeojson
st_astopojson

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What are 10 functions used to create geometry?

A

ST_Envelope

ST_Buffer

ST_ConvexHull

ST_Difference

ST_Union

ST_Intersection

ST_SymDifference

ST_Area

ST_Extent

ST_3DExtent

20
Q

What are 10 input or output file formats that can be used with Postgis?

A

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

21
Q

What are 10 functions that inspect geometry?

A

ST_X

ST_Y

ST_Length

ST_EndPoint

ST_StartPoint

ST_PointN

ST_NumPoints

ST_Area

ST_ExteriorRing

ST_InteriorRingN

ST_NumInteriorRings

ST_NumGeometries

ST_GeometryN

22
Q

List the SRID’s and the Projections or Coordinate Systems they are associated with. This card will be used as a reference for further SRID questions.

A

SRID—Name—-Type—-Comment

3005—MELP—AblersPlanar—The best ever!

3161—NAD83 / Ontario MNR Lambert—Planar—They think they are the best but there are not

3401—Alberta 10-TM—Planar—Wide like their roads

3857—Web Mercator—Planar—Google Maps, Bing, OSM, OL, Leaflet

3978—NAD83 / Canada Atlas Lambert—Planar—Canada’s projection according to the feds

3979—Canada Atlas Lambert—Planar—Web Services at geogratis (federal data)

4267—NAD 27—Polar—We are in Kansas

4326—WGS 84—Polar—YOUR phone!

26907—UTM zone 7N nad83—Planar—BC - Tatshenshini

26908—UTM zone 8N nad83—Planar—BC - Masset

26909—UTM zone 9N nad83—Planar—BC - Port Hardy

26910—UTM zone 10N nad83—Planar—BC - Lower Mainland

26911—UTM zone 11N nad83—Planar—BC - Cranbrook

23
Q

What is the SRID for Alberta?

A

3401—Alberta 10-TM—Planar—Wide like their roads

24
Q

What is are the SRID’s for the two most common coordinate systems WGS 84 and NAD 1927

A

4326—WGS 84—Polar—YOUR phone!

4267—NAD 27—Polar—We are in Kansas

25
Q

What are 11 types of spatial relationships?

A

st_disjoint: link

st_equals: link

st_intersects: link

st_crosses: link

st_overlaps: link

st_touches: link

st_covers: link

st_coversby: link

st_within: link

st_contains: link

st_dwithin: link

26
Q

Name 5 spatial extentions for PostgreSQL.

A

topology

tiger

pointcloud

pointcloud_postgis

pg_routing

27
Q

What are 8 Postgis components?

A

POSTGIS
GEOS
PROJ
GDAL
LIBXML
LIBJSON
RASTER
SFCGAL

28
Q

What are 5 Metadata tables and views.

A

public.spatial_ref_sys

public.geometry_columns

public.geography_columns

public.raster_columns

punlic.raster_overviews

29
Q

What is Webstorm?

A

Webstorm is an Itegrated Development Environment for Javascript

Webstorm

30
Q

What is VSCode?

A

VSCode is a multi language code Integrated Development Environment.

VSCode

31
Q

List some common webserver methods.

A

OPTIONS
GET
HEAD
POST
PUT
DELETE
TRACE
CONNECT
PROPFIND
PROPPATCH
MKCOL
COPY
MOVE
LOCK
UNLOCK
VERSION-CONTROL
REPORT
CHECKOUT
CHECKIN
UNCHECKOUT
MKWORKSPACE
UPDATE
LABEL
MERGE
BASELINE-CONTROL
MKACTIVITY
ORDERPATCH
ACL
PATCH
SEARCH

32
Q

What is 3NECBH ™?

A

Node Never Ending Nested CallBack Hell

33
Q

What are the various JS coding styles?

A
  • Old school functions (KISS-style)
  • New school objects (WAR-style) FLATTEN EVERYTHING!
  • JSON - way too many colons when there should be none!
  • 3NECBH ™ - Node Never Ending Nested CallBack Hell
  • Promises, Promises
34
Q

What web-browser is Fetch incompatible with?

A

Internet Explorer

35
Q

What are the two core components of AJAX?

A

a XMLHttp request (can also be JSON or plain HTML) and a callback function responsible for the UI unpdating

36
Q

What is the main purpose of AJAX and Fetch?

A

reactive webpages -> updating content without needing to refresh the entire webpage

37
Q

What is the core component/paradigm of the Fetch API?

A

Promise chain

38
Q

<blank> is a translator library for raster and vector geospatial data formats as a core dependency of the postgis extension
</blank>

A

GDAL

39
Q

<blank> and <blank> are both a C/C++ library for computational geometry with a focus on algorithms used in geographic information systems (GIS) software as a core dependency of the PostGIS extension
</blank></blank>

A

GEOS and SFCGAL

40
Q

<blank> is a generic coordinate transformation software that transforms geospatial coordinates from one coordinate reference system (CRS) to another. This includes cartographic projections as well as geodetic transformations. It is a core dependency of the PostGIS extension
</blank>

A

proj

41
Q

What’s the difference between WKT and WKTE?

A

WKTE is Well know text but with knowledge of SRIDs

42
Q

what is GML?

A

Geography Markup Language (GML) is an XML grammar for expressing geographical Features

43
Q

What are the OGC geometry types supported by PostGIS?

A

POINT, LINESTRING, POLYGON
MULTIPOINT, MULTILINESTRING, MULTIPOLYGON
GEOMETRY COLLECTION
*Also supports Z and M versions and SRID

44
Q

what is the general syntax for the PostGIS geometry constructor?

A

geometry(type,srid)

45
Q

What functionality does the tiger extension provide?

A

geocoding

46
Q

what is the role of the;
1) Space
2) Comma
3) Paraenthises
4) Semicolon
5) Equal signs
in WKT and EWKT syntax

A

1) separates X Y Z and M values
2) separates coordinates/ordinates
3) group and separate coordinate pairs
4) separates the SRID from the geometry
5) assigns the SRID value

7132- Database (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions