SELECT poitab.poiid AS default_poi, UNIX_TIMESTAMP(maptab.dateSubmitted) as dateSubmittedUnix
FROM dfma_pointsofinterest AS poitab
LEFT JOIN dfma_maps_v2 AS maptab ON maptab.mapid=poitab.mapid
WHERE maptab.fortressName = 'Goldparch'
AND (
poitab.mapid = '2762'
OR (
poitab.startYear > 0
AND ( poitab.endYear = 0 OR (poitab.endYear * 100 + poitab.endSeason) >= '105201' )
AND ( (poitab.startYear * 100 + poitab.startSeason) <= '105201' )
)
)
ORDER BY
IF(maptab.default_poi=poitab.poiid,1,0) DESC,
IF(maptab.mapYear>'1052',0,maptab.mapYear) DESC
LIMIT 1
Point of Interest: Overview
(
1052 → 1100 )
A nice overhead shot of the fortress layout. This was achieved with repeated catapult launchings of a very durable engraver. - Yojimbo
There are 12 comments for this map series, last post 2009-07-26
Got something to say, a question or a comment... feel free to post. If you want to reference a point of interest or another map, find its ID number and use BBCode to reference it in your comment. For example [map=67]my map[/map] or What is that [poi=100]cool place[/poi]...
Add new point of interest
If you've found something interesting on this map, or you want to document parts of your fortress, then use this form.
Browse (move/zoom) to a place on the map, its position will be displayed in the boxes below. Fill out the form and hit add to store a new point of interest.
Comments
Submitted by: Yojimbo - 2008-05-24 to 1052 Early Spring
Goldparch was founded on the mandate for a port in the region to handle a major trade route through the area. This will include a light house, port facilities, warehouses, roads leading North and East and a garrison to defend all of it.
Goldparch had a very good first year. Housing and initial production of food stuffs and building material has already gotten underway. 11 immigrants have already joined the work force and have dove right into the projects at hand. The only down spot was that the first caravan wagons coming from the North were unable to make it.
[Message edited on 2008/05/24 at 02:48 by Yojimbo]
Submitted by: Markavian` - 2008-05-24 to 1052 Early Spring
It would be very cool if you could build boats (wagons) in DF and send expeditions off. It could be an alternative to "abandonning a fort" ... you could go off and start a new outpost somewhere else.
Wonderful fortress! I love all the non-functional elements, particularly the docks, map room, and lighthouse. The golden roof is a great touch.
Definately gives me the feeling that I am looking at a port city.
( 1052 to 1100 ) A nice overhead shot of the fortress layout. This was achieved with repeated catapult launchings of a very durable engraver.
- Yojimbo
Just 2 farm plots for now. One is for just plump helmets and the other rotates all other crops throughout the year.
Planning for prepared food to be one of our major exports. The homeland just cant get enough of 'Goldparch' brand biscuits!
- Yojimbo
( 1052 to 1100 ) The homes of the first 7 dwarves. Expedition leader has a full suite up North with the record keeper getting a small connecting office as well.
- Yojimbo
General housing for all the newcomers are here as well as the main dining hall. Both are in the process of being upgraded with better furniture and smoothing out the walls.
We have been able to stay ahead of the immigration so no one has had to sleep out in the hallways yet.
- Yojimbo
[x] This map viewer uses the new ByteArray features only available with the newest version of Flash 9. Please update your player in order to view this map.
Submitted by: Yojimbo - 2008-05-24 to 1052 Early Spring
Goldparch was founded on the mandate for a port in the region to handle a major trade route through the area. This will include a light house, port facilities, warehouses, roads leading North and East and a garrison to defend all of it.
Goldparch had a very good first year. Housing and initial production of food stuffs and building material has already gotten underway. 11 immigrants have already joined the work force and have dove right into the projects at hand. The only down spot was that the first caravan wagons coming from the North were unable to make it.
[Message edited on 2008/05/24 at 02:48 by Yojimbo]
Submitted by: Markavian` - 2008-05-24 to 1052 Early Spring
It would be very cool if you could build boats (wagons) in DF and send expeditions off. It could be an alternative to "abandonning a fort" ... you could go off and start a new outpost somewhere else.
Good work with your fort sofar.
Submitted by: Dakira - 2008-06-01 to 1058 Early Summer
Awesome. This is the first, "port-fort" i've seen.
Submitted by: Markavian - 2008-06-01 to 1058 Early Summer
Well themed, love the great map room.
Submitted by: Charrat - 2008-06-11 to 1061 Mid Winter
Wonderful fortress! I love all the non-functional elements, particularly the docks, map room, and lighthouse. The golden roof is a great touch.
Definately gives me the feeling that I am looking at a port city.
Submitted by: Analfish - 2008-06-13 to 1061 Mid Winter
You have inspired me to make my own port fort Yojimbo. Hopefully I will be releasing it soon.
Submitted by: Sukasa - 2008-06-16 to 1064 Early Spring
the HMS DwarfHammer is incredible! I'm very impressed with the design, it looks like a real ship!
Submitted by: Dakira - 2008-06-18 to 1064 Early Spring
still looking good. I wasn't expecting the HMS DwarHammer and now the idea of a submarine pen is in mind.
Submitted by: Krash - 2008-09-27 to 1064 Early Spring
Dwarves sailing the high seas?! This is madness!
Submitted by: Nair - 2009-01-02 to 1064 Early Spring
This is one of the most unique and awesome forts I've ever seen. Good job!
Submitted by: Myroc - 2009-07-26 to 1064 Early Spring
From now on, every fort i make that reaches at least 30 inhabitants shall have a McUrist's Pub 'n Disco.
[Message edited on 2009/07/26 at 04:45 by Myroc]
Submitted by: Lacero - 2009-07-26 to 1064 Early Spring
I like the map. Great idea.