top of page
![](https://static.wixstatic.com/media/a99595_ecc6a58746ed43c08cc18628b1d28b0f~mv2.jpg/v1/fill/w_147,h_98,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/a99595_ecc6a58746ed43c08cc18628b1d28b0f~mv2.jpg)
Glock City is a hypothetical city sanctuary for firearm enthusiasts like myself. The diagrams illustrate how the city information, spatial and non-spatial could be organized in a relational or object-based database. The original relational database in Microsoft Access format can be downloaded here
Summary
Database Design and Creation: Glock City, a mock-up city spatial database
![](https://static.wixstatic.com/media/a99595_32b2d01c98f14481ba7ba0ada4dc5ea9~mv2.png/v1/fill/w_346,h_162,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/a99595_32b2d01c98f14481ba7ba0ada4dc5ea9~mv2.png)
![](https://static.wixstatic.com/media/a99595_b5698d84e2df4c09b5aa21fb7e65985c~mv2.png/v1/fill/w_332,h_174,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/a99595_b5698d84e2df4c09b5aa21fb7e65985c~mv2.png)
A snippet of the object-based database design for Glock City
A snippet of the relational database design for Glock City
![](https://static.wixstatic.com/media/a99595_14383fa9c3544c19875ee19946002bf1~mv2.png/v1/fill/w_328,h_210,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/a99595_14383fa9c3544c19875ee19946002bf1~mv2.png)
A mock-up visual representation of Glock City. City features are tied to a geodatabase (GDB). The geodatabase was implemented based on the object-based database design.
MSGIS Skills: Data Structures, Database Design
bottom of page