meters 1725753.18181859795004129 216298.20406072237528861 7479504.45965391676872969 3262198.3356605339795351 1 +proj=lcc +lat_1=35 +lat_2=65 +lat_0=52 +lon_0=10 +x_0=4000000 +y_0=2800000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs 999 3034 EPSG:3034 ETRS89 / ETRS-LCC lcc GRS80 false city20140410113435271 study_area20140410171029594 province20141009110401131 conventus20141009110712107 civitas20141009111228730 area20140417170111467 name20140410113435539 event20140410124009541 status20141030150020729 city_ref20140724113849039 area_cat20140417170111656 area_ref20140724113838976 name_cat20140410113435701 name_ref20140724113854267 event_cat20140410124009741 event_ref20140724113851443 status_cat20141030150022465 status_ref20141030150024225 emperor20140606104652675 admin_status_cat20140502113803970 econ_social_profile_cat20140502114608439 juridical_status_cat20140925151548393 reference20140724113925498 reference_type20140724110207777 SR_HYP_Water___drain20141016143937583 material_attrib20141128121236469 material_attrib_cat20141128121237011 material_attrib_ref20141128121237354 awmc_dem_rendered20141211120726211 awmc_hillshade20141211133710218 Status_at_300_CE20150129122358063 Material_attributes20150205155734914 Civitates20150205175557987 Material_attributes__entertainment_20150205180717613

degrees 0 -2143 2650 0 0 +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true Civitates20150205175557987 ./temp/Civitates.shp Civitates +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true ogr 0 0 0 Name 0 . 0 . generatedlayout Material_attributes20150205155734914 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="(SELECT * FROM e2kc_material_attrib() )" (centroid) sql= Material attributes +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres 0 0 0 name 0 . 0 . generatedlayout Material_attributes__entertainment_20150205180717613 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="(SELECT * FROM e2kc_material_attrib_entertainment() )" (centroid) sql= Material attributes (entertainment) +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "name", '<NULL>' ) 0 0 0 name 0 . 0 . generatedlayout SR_HYP_Water___drain20141016143937583 crs=EPSG:3034&dpiMode=7&featureCount=10&format=image/png&layers=hyp_water_drain&styles=&url=http://vps.empireof2000cities.org:8080/geoserver/Basemaps/wms SR HYP Water + drain +proj=lcc +lat_1=35 +lat_2=65 +lat_0=52 +lon_0=10 +x_0=4000000 +y_0=2800000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs 999 3034 EPSG:3034 ETRS89 / ETRS-LCC lcc GRS80 false wms 0 Status_at_300_CE20150129122358063 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="(SELECT * FROM e2kc_status(300) )" (centroid) sql= Status at 300 CE +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "name", '<NULL>' ) 0 0 0 name 0 . 0 . generatedlayout admin_status_cat20140502113803970 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."admin_status_cat" sql= admin_status_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout area20140417170111467 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."area" sql= area +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS tablayout area_cat20140417170111656 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."area_cat" sql= area_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout area_ref20140724113838976 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."area_ref" sql= area_ref +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>')||', '||COALESCE("area", '<NULL>')||', '||COALESCE("ref", '<NULL>') . 0 . generatedlayout awmc_dem_rendered20141211120726211 crs=EPSG:3034&dpiMode=7&featureCount=10&format=image/png&layers=awmc_dem_rendered&styles=&url=http://vps.empireof2000cities.org:8080/geoserver/Basemaps/wms awmc_dem_rendered +proj=lcc +lat_1=35 +lat_2=65 +lat_0=52 +lon_0=10 +x_0=4000000 +y_0=2800000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs 999 3034 EPSG:3034 ETRS89 / ETRS-LCC lcc GRS80 false wms 0 awmc_hillshade20141211133710218 crs=EPSG:3034&dpiMode=7&featureCount=10&format=image/png&layers=awmc_hillshade&styles=&url=http://vps.empireof2000cities.org:8080/geoserver/Basemaps/wms awmc_hillshade +proj=lcc +lat_1=35 +lat_2=65 +lat_0=52 +lon_0=10 +x_0=4000000 +y_0=2800000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs 999 3034 EPSG:3034 ETRS89 / ETRS-LCC lcc GRS80 false wms 9 city20140410113435271 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' srid=4326 type=POINT table="public"."city" (centroid) sql= city +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "", '<NULL>' ) 0 0 0 canon_name 0 P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS tablayout city_ref20140724113849039 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."city_ref" sql= city_ref +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "ref", '<NULL>' ) . 0 . generatedlayout civitas20141009111228730 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' srid=4326 type=POLYGON table="public"."civitas" (boundary) sql= civitas +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "name", '<NULL>' ) 0 0 0 name 0 . 0 . generatedlayout conventus20141009110712107 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' srid=4326 type=MULTIPOLYGON table="public"."conventus" (boundary) sql= conventus +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "name", '<NULL>' ) 0 0 0 name 0 . 0 . generatedlayout econ_social_profile_cat20140502114608439 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."econ_social_profile_cat" sql= econ_social_profile_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout emperor20140606104652675 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."emperor" sql= emperor +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout event20140410124009541 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."event" sql= event +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS tablayout event_cat20140410124009741 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."event_cat" sql= event_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout event_ref20140724113851443 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."event_ref" sql= event_ref +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>')||', '||COALESCE("event", '<NULL>')||', '||COALESCE("ref", '<NULL>') . 0 . generatedlayout juridical_status_cat20140925151548393 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."juridical_status_cat" sql= juridical_status_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres . 0 . generatedlayout material_attrib20141128121236469 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."material_attrib" sql= material_attrib +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "cat", '<NULL>' ) . 0 . tablayout material_attrib_cat20141128121237011 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."material_attrib_cat" sql= material_attrib_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres . 0 . generatedlayout material_attrib_ref20141128121237354 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."material_attrib_ref" sql= material_attrib_ref +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres coalesce(id, '<NULL>') . 0 . generatedlayout name20140410113435539 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."name" sql= name +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "name", '<NULL>' ) P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS tablayout name_cat20140410113435701 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."name_cat" sql= name_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout name_ref20140724113854267 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."name_ref" sql= name_ref +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>')||', '||COALESCE("name", '<NULL>')||', '||COALESCE("ref", '<NULL>') . 0 . generatedlayout province20141009110401131 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' srid=4326 type=MULTIPOLYGON table="public"."province" (boundary) sql= province +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "name", '<NULL>' ) 0 0 0 name 0 . 0 . generatedlayout reference20140724113925498 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."reference" sql=name = 'bart' reference +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE("id", '<NULL>') . 0 . generatedlayout reference_type20140724110207777 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."reference_type" sql= reference_type +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres . 0 . generatedlayout status20141030150020729 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."status" sql= status +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "id", '<NULL>' ) . 0 . tablayout status_cat20141030150022465 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."status_cat" sql= status_cat +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres . 0 . generatedlayout status_ref20141030150024225 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' table="public"."status_ref" sql= status_ref +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres coalesce(id, '<NULL>') . 0 . generatedlayout study_area20140410171029594 dbname='romancities' host=vps.empireof2000cities.org port=5432 user='bart' sslmode=require key='id' srid=4326 type=MULTIPOLYGON table="public"."study_area" (boundary) sql= study_area +proj=longlat +datum=WGS84 +no_defs 3452 4326 EPSG:4326 WGS 84 longlat WGS84 true postgres COALESCE( "id", '<NULL>' ) 0 0 0 descr 0 P:/My Documents/ERC-project/GIS 0 P:/My Documents/ERC-project/GIS generatedlayout false city20140410113435271 study_area20140410171029594 must be inside 1 0 false 0 0 false 0 0 true 30 2 true D false 359 false 1 true false GRS80 select city.id, city.centroid, city.canon_name, min(status_cat.name) from city join status on city.id = status.city join status_cat on status.cat = status_cat.id where from_taq <= 0 and to_tpq >= 0 group by city.id; select city.id, city.centroid, city.canon_name, min(status_cat.name) from city join status on city.id = status.city join status_cat on status.cat = status_cat.id where from_taq <= 0 and to_tpq >= 0 group by city.id; City status 8 0 255 255 255 255 255 255 Civitates20150205175557987 Material_attributes20150205155734914 Material_attributes__entertainment_20150205180717613 Status_at_300_CE20150129122358063 city20140410113435271 civitas20141009111228730 conventus20141009110712107 province20141009110401131 study_area20140410171029594 disabled disabled disabled disabled disabled disabled disabled disabled enabled true 1 1 1 1 1 1 1 1 1 to_vertex to_vertex to_vertex to_vertex to_vertex_and_segment to_vertex_and_segment to_vertex to_vertex to_vertex 15.000000 15.000000 15.000000 15.000000 0.000000 7.000000 15.000000 15.000000 20.000000 0 false 8 false true 8 8 false true 0 700000 700000 MS Shell Dlg 2,16,-1,5,50,0,0,0,0,0 0 <symbol alpha="1" type="marker" name="marker symbol"> <layer pass="0" class="SimpleMarker" locked="0"> <prop k="angle" v="0"/> <prop k="color" v="255,0,0,255"/> <prop k="color_border" v="0,0,0,255"/> <prop k="horizontal_anchor_point" v="1"/> <prop k="name" v="cross"/> <prop k="offset" v="0,0"/> <prop k="offset_unit" v="MM"/> <prop k="outline_style" v="solid"/> <prop k="outline_width" v="0"/> <prop k="outline_width_unit" v="MM"/> <prop k="scale_method" v="area"/> <prop k="size" v="20"/> <prop k="size_unit" v="MM"/> <prop k="vertical_anchor_point" v="1"/> </layer> </symbol> false 0 <symbol alpha="1" type="line" name="line symbol"> <layer pass="0" class="SimpleLine" locked="0"> <prop k="capstyle" v="square"/> <prop k="color" v="0,0,0,255"/> <prop k="customdash" v="5;2"/> <prop k="customdash_unit" v="MM"/> <prop k="draw_inside_polygon" v="0"/> <prop k="joinstyle" v="bevel"/> <prop k="offset" v="0"/> <prop k="offset_unit" v="MM"/> <prop k="penstyle" v="solid"/> <prop k="use_custom_dash" v="0"/> <prop k="width" v="0.26"/> <prop k="width_unit" v="MM"/> </layer> </symbol> 0 0 false 0

false

+proj=lcc +lat_1=35 +lat_2=65 +lat_0=52 +lon_0=10 +x_0=4000000 +y_0=2800000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs EPSG:3034 999 1 true 255 90