side effects of propranolol 20 mg anal sex uti dose of epinephrine for managing anaphylaxis war paint horses ear canal swollen spanish bee pollen stages of liver disease from alcohol broken clavicle healing what is doliprane tubal ligation effects celiac sprue disease symptoms what is post streptococcal glomerulonephritis std bumps on vagina c-212 back muscle pain left side 50 g to mg vicks vapor rub steam what is cefprozil bladder inflammation symptoms planters wart pain relief benefits of amino acid supplements infant crossing eyes dark brown discharge before period starts how to use stridex federal controlled substance act mexican arthritis medicine iron low blood knee and ankle pain thyroid medication side effects hair loss potassium chloride uses and side effects poppy seed flower new bph treatments emdr conference 2015 safe sleeping pills penicillin vk used to treat pregnant one leg swollen topical 5 fu debrox ear wax removal video pee color when pregnant difference between advil and aleve lower rib pain both sides blood work interpretation helico pylori infection do written prescriptions expire side effects of pulmicort flexhaler grape seed resveratrol benefits tylenol in pregnancy dosage birth control patch placement 2 doses of zzzquil thomas labs fish mox 1 mg folic acid can nyquil get u high 349 white pill side effects of too much sodium what to do if tick bite a pimple on my penis steroids for men dosage for phenergan can you overdose on wellbutrin lexapro with adderall how big is 4cm good appetite suppressant pills 2% salicylic acid anabolic steroid withdrawal symptoms of otitis media xanax for anxiety disorder carlson vit d symptoms of maltreatment include: cefuroxime 250 mg nitrofurantoin mcr 50 mg cap side effect garcinia cambogia medication for claudication amlactin on face will strep go away without antibiotics mg/dl diabetes range blister like bumps on body what is lindane side effect of sertraline lipitor vs crestor does pus mean infection cvs natural sleep aid get drugs las vegas toddler cough and fever can nexium stop working lidocaine epinephrine tetracaine gel jaw popping while eating calcium supplement while pregnant potassium and kidney disease std what is it pregnancy symptoms on the depo shot best allergy medicine 2015 grapefruit juice cyp3a4 allergic to fluoride how to stop taking simvastatin mineral oil constipation dosage yellow vicodin 3601 where to buy kava pills chronic cystitis symptoms can the pancreas regenerate does clomid make you tired taking too much adderall calcium for osteoporosis zofran vs compazine sindrome de serotonina baxter international inc. can zoloft cause infertility non prescription prednisone l-thyroxine dosage fluor i strip bumps in back of throat std overdose on magnesium preventing vaginal odor hydrochlorot side effects c section after what is tinnitus a symptom of nose cellulitis symptoms ibuprofen vs motrin foods good for liver health name of elbow skin severe stomach pain and diarrhea urinating often at night metronidazole (flagyl) what is molluscum virus oral sex safe 3m cavilon barrier spray heel spur pain location insulin pen brands can anxiety cause headaches can too much sleep be harmful what is sinus bradycardia natural 5 htp lump on the vagina alopecia hair treatment urine burning sensation klor con 10 how to cure sinus pain circle around nipple is l carnitine safe boobs filled with milk how many ounces is 10 ml cephalexin 500mg side effects cleaning a catheter is smallpox caused by a virus too much sodium side effects prenatal vitamins and headaches resection of bladder tumor symptoms of ocular rosacea photos mace spice uses prozac for children rx stress tea wound ointment humans 101 temperature fever in adults when to start clomid eye infection treatment over the counter antibiotics and mirena what causes smallpox prescription tracker app weaning off effexor with prozac nicotine patch withdrawal symptoms hurts behind my ear over the counter alli breast cancer treatment pill womens one a day vitamins gallbladder attack after removal interferon beta 1a avonex beta blockers list for anxiety ms and fatigue what is trace conditioning pregnant food ideas bumps on my foot what is generic drug gastritis over the counter medicine fluoride supplements infants ceraloft side effects do drugs cause schizophrenia valium recreational dose freezing point definition bupropion xl 300mg do opiates lower blood pressure sodium acetate safety why is my finger swollen pill with apo methotrexate rheumatoid arthritis medications wonder laboratories valerin humana over the counter pharmacy purified chondroitin sulfates anterior interventricular artery tea colored urine and back pain is pink eye painful my stomach burns and hurts street price for xanax infants tylenol dosage chart does ibuprofen expire groin burning pain popeyes nutrition information lamictal bipolar 2 nexplanon and antibiotics use does tylenol thin the blood where is the right ovary located right femoral endarterectomy what are night terrors tizanidine and flexeril together blood pressure medication amlodipine tinea versicolor topical treatment vitamin e uses sharp pains in heart area how to relieve excessive gas can allergies cause earache mirena removal pregnancy 30 days since last period justice tween brands dermatitis cream over the counter how to get good erections diverticulitis with fever micrococcus luteus facts second degree burn peeling what makes a mole itch monistat or vagisil headache relief without pills ear drum wax broken arm recovery definition of superior vena cava strange migraine symptoms how many people have fibromyalgia 4mg dilaudid street price best eye drops dry eyes bronchitis shortness of breath and wheezing abdominal surgery scar queen of the meadow flower norco dosage 10 325 symptoms of ibs-d no pregnancy symptoms but pregnant one drop equals how many ml pregnancy tests and birth control bronchitis symptoms in children medical freeze spray american recovery center how do penicillins work elf zit zapper meaning of turpentine bubbles between toes dehydration and chest pain causes and treatment of gout sharp pain above groin bad taste in mouth sinus infection stop irrational thoughts irreversible inhibitor definition sinus back of head pull your ear opioid overdose symptoms prescription weight loss drugs cup of spinach calories r and c cramps in my toes cold induced hives back spasms what to do low blood oxygen level pliva 433 effects avon sss bug guard how to take suboxone strips why need blood transfusion sertraline and weed dmsa chelation side effects when does coffee kick in skullcap aerial parts amitriptyline for interstitial cystitis my toddler is constipated sulfur burps and diarrhea causes isotonic nasal spray atropine cardiac arrest saliva drug test faq how to avoid a pregnancy toenail separated from nail bed injury what is nomogram fractured bone in foot symptoms coumadin levels normal range leaking mitral valve symptoms medications for scabies in humans my doctor now getting rid of kidney stones skin tag removal products cvs valtrex 1 gram dosage can you overdose on b12 hawthorn berry extract dosage celery seeds benefits skin rash on face and neck intravenous medications 2015 is there a cure for hypertension bacitracin vs bacitracin zinc antifungal cream for scalp ringworm proactiv plus complexion perfecting hydrator long term anxiety cleft palate surgery drug stronger than morphine hemorrhagic stroke survival rate 3 months late period not pregnant neural foraminal stenosis cefotetan brand name executive eye care after birth control symptoms how to bandage a knee pain right upper chest how to reduce cheek swelling amlodipine dosage for hypertension mardel maracyn-two spotting 1 day after period allergy nasal spray xanax side effects alcohol switching birth control pills missed period ophthalmic ointment over the counter clavicle fracture recovery time ingrown infected toenail g1 8 pill dry skin on wrist rite aid refill sam-e depression dosage opiates brain damage calm aid lavender side effects vascular system definition what is lortab 10 para que sirve el acetaminofen generic suboxone film inner ear infection medicine acid reflux sharp pain in chest eyes rolled back in head how to stop period spotting what to do for high cholesterol obagi skin lightening cream reactive arthritis symptoms urinary infection medication advantage vs advantage 2 how to break your own finger pyridoxine 50 mg epiduo forte gel what is ibgard herpes on the lip inguinal hernia burning pain dosage for black cohosh bmx oral solution what is nefazodone seizure petit mal birth control on arm muscle pain in legs and arms can bronchitis cause back pain sebaceous cyst skin cancer what causes colitis in humans abilify for kids best pain reliever for period cramps allergic reaction on face and neck signs you have pneumonia how fast does kidney cancer grow manipulation of shoulder drugs for irritable bowel syndrome post-herpetic neuralgia patellar dislocation exercises pinched sciatic nerve sources of potassium and magnesium perianal blood vessel generalized malaise definition does penicillin expire max dose of niacin 8987 blue pill show me sexual intercourse symptoms of too much magnesium side affects of advil effects of smoking black and milds symptoms of broken nose in child plantar wart cure bleeding while having sex negative side effects of statins stiff neck headache pregnant bleeding after sex most common depression medication school age social development what type of antibiotic is azithromycin azo cranberry pill where to buy calcium lactate stage 2 pressure ulcer when should levothyroxine be taken does tylenol help cramps mag citrate constipation zi;; mirena issues symptoms pred mild eye drops partial thyroidectomy and weight gain conjunctivitis medicine over the counter scarlet fever after antibiotics fever first trimester side effects of anal weight gain on depo propecia side effects high dose of acetaminophen medications for narcolepsy bleeding out of the anus ear pain treatment adults hypertonic saline nasal spray axe brand oil can you fracture your elbow maximum magnesium dosage 1 retin a bystolic and weight gain worm medication for puppies side effects of too much progesterone burning itching hands tylenol pm pills does oxycodone help migraines what is the lumbar region sinus headache fever minipress for nightmares vetri science pro line enlarged lymp nodes asthmatic cough sound platinum chemotherapy side effects production of testosterone endoscopy after care lisinopril user reviews why am i pooping out blood nioxin reviews for men gram negative bacilli in blood metronidazole and azithromycin medical terminology search allergic to sunlight herpes burning skin underarm yeast rash what is tdap for why i feel dizzy and nauseous lexapro and cocaine american academy of dermatology annual meeting strep throat spreading all the information is marijuana a cns depressant how does penicillin work does biotin cause breakouts hartz ultraguard ear mite treatment what is a hematoba bubbles in stomach benefits of hoodia xanax with hydrocodone getting your period while pregnant whats in excedrin aplastic anemia prognosis red papules on skin when will cialis go generic theraflu apple cinnamon started my period a week early low blood pressure medical term first signs of genital warts pictures will antibiotics help bronchitis spike lavender vs lavender dhe nasal spray does azithromycin need to be refrigerated za-10 20mg vertigo medication over the counter benefits of mustard powder definition of clenched micronized progesterone cream best throat lozenges 7 weeks pregnant no symptoms miscarriage metronidazole or tinidazole over the counter how to treat an itchy rash uti not going away sinus infection how to treat plan b while on period mucinex cold and flu why does my heart rate increase vitamin d and migraines tri vi sol side effects infants can imodium cause constipation azelaic acid skin lightening tannic acid ph aortic valve regurgitation exercise incontinence medical definition clobetasol foam coupon miscarriage fetal tissue claritin food allergy cialis didnt work otezla copay assistance molluscum contagiosum after cryotherapy stress and abdominal pain the positive effects of weed is vicodin a barbiturate how to treat a bruised ankle causes of heat rash yellow energy pill inflammation of prostate gland what is molly drug look like definition of canal great burdock plant pro growth hormone diarrhea and blood in stool when mmr vaccine given side effects prometrium allergic transfusion reaction neo poly dex ophth susp 5ml depressed no motivation why is my vitamin b12 low what is a bacterial blood infection clogged ears causes diabetes vaginal discharge boudreaux butt paste

WKT Format for SUAS MapServer

Dr. Franz-Josef Behr, Karlsruhe,
franz-josef.behr [at] hft[minus]stuttgart[dot]de

Generally spoken geographical entities can be interpreted to belong to one of these categories:

Each geometry type has a so-called Well-known Text Representation that can be easily generated and parsed by programs and human beings as well.

This format has been published by the Open Geospatial Consortium (OGC) by the specification OpenGISŪ Implementation Specification for Geographic information - Simple feature access - Part 1: Common architecture, Version 1.1.0.

In this specification the following geometry types have been taken into consideration:

Now, what's behind these terms? For a point it might be obvious, but what's with the other geometries?

Point, Linestring, Polygon

In the standard, the term curve is introduced, a "1-dimensional geometric object usually stored as a sequence of Points, with the subtype of Curve specifying the form of the interpolation between Points."

In this context, ISO 19125 defines only one subclass (type) of curve, the linestring, which uses linear interpolation between points.

We can imagine that a linestring is nothing else than a polyline, a term which is used in many GIS.

In a similar way a surface is defined being a 2-dimensional geometric object. A simple Surface consists of a single "patch" that is associated with one "exterior boundary" and 0 or more "interior" boundaries. The only instantiable subclass of surface defined in this specification, Polygon, is a simple surface that is planar.

In Version 1.2.0 of this specification (making the former specification deprecated) this list has been extended by the following geometry types:

Additionally, geometries with height values (z values) and values in a linear reference system are supported.

A binary equivalent, known as well-known binary (WKB) is used to store the same information on databases.

In OGC's
Coordinate Transformation Service specifications WKT format is also used to describe spatial reference systems and coordinate transformations.

As you will see in the examples from the specification, Well known text is case insensitive and quite easy to understand.

Point POINT (10 10)
LineString LINESTRING (10 10, 20 20)
Polygon POLYGON ((10 10, 10 20, 20 20, 20 15, 10 10))
Multipoint MULTIPOINT (10 10, 20 20)
MultiLineString MULTILINESTRING ((10 10, 20 20),(15 15, 30 15))
MultiPolygon MULTIPOLYGON (((10 10, 10 20, 20 20, 20 15, 10 10)),
((60 60, 70 70, 80 60, 60 60 ) ))
GeomCollection GEOMETRYCOLLECTION (POINT (10 10),
POINT (30 30),
LINESTRING (15 15, 20 20))

WKT format is supported by spatial operations of Database Management Systems like MySQL (version 5), PostGIS, and Oracle.

But perhaps you will notice that labels (textual information) and raster based geodata (gridded data) are not mentioned here at all.

Providing geodata in WKT foramt for SUAS MapServer

SUAS MapServer uses WKT corresponding to Simple feature access Implementation Specification, Version 1.1.0 for uploading data into the database. Internally the WKB format is used to store the geodata in the database.

Each geographical feature is stored in a table record consisting of a unique id, internally provided by SUAS, a layer name, an identifying (perhaps also unique) key provided by the data provider (like you!), information about the geometry type, the bounding box (geographical extents) of the feature, the geometry in WKT format, an optional hyperlink, information about the spatial reference system, alphanumerical attributes, and optional styling information.

SUAS Feature Geometry Table Alphanumerical attributes are stored using an XML fragment, as shown in the example below:
Uploading point data in SUAS MapServer database

The structure of a CSV record for the import of point data into the SUAS MapServer database looks as follows:

In order to import point data into the SUAS MapServer database using CSV format, a CSV record looks like this:

Uploading linestring data in SUAS MapServer database

The structure of a CSV record for the import of linestring data into the SUAS MapServer database looks as follows:

In order to import linestring data into the SUAS MapServer database using CSV format, a CSV record looks like this:

Uploading polygon data in SUAS MapServer database

The structure of a CSV record for the import of polygon data into the SUAS MapServer database looks as follows:

In order to import polygon data into the SUAS MapServer database using CSV format, a CSV record looks like this:

Uploading labels in SUAS MapServer database

Labels (text objects) are stored as Point objects in the database. To upload such records into the database, use the following CSV syntax:

The POINT geometry defines the location of the label. The text itself (and optioally additional parameters) are provided in the attributes field in XML format:


Referencing raster tiles in SUAS MapServer database

Raster tiles are stored as Linestring objects in the database. To upload such records into the database, use the following CSV syntax:

The geo attribute desribes the location of the image by its lower left, upper left, upper right and lower right corner.

The svgxlink attribute contains the URL path to the raster file.