martes, 6 de marzo de 2012

Instalar postgres - postgis en Debian Squeeze – Donate – Money

PostGIS es un módulo que añade soporte deobjetos geográficos a la base de datosPostgreSQL, convirtiéndola en unabase de datos espacial para su utilización en Sistema de Información Geográfica (GIS).
Postgres con Postgis podes hacer muchas cosas muy interesantes para poder crear mapas.
Pude realizar siempre lo que quise, así que les recomiendo si van a usar para crear mapas, utilicen esta unión. No se va a arrepentir.

Ahora vamos a los que realmente nos interesa, instalamospostgres (base de datos) ypgAdmin(GUI para manipular postgres). Entramos a la consola y escribimos:
sudo aptitude install postgresql postgresql-client postgresql-contrib pgadmin3

Ahora debemos descargarpostgis, entramos a la consola y escribimos:
sudo aptitude install postgis postgresql-8.4-postgis

Entramos a la consola y escribimos:
sudo su root
su postgres



Ahora creamos una base de datos llamada mapa y le configuramos para que acepte datos geométricos dentro de ella.. Entramos a la consola:
createdb mapa
createlang plpgsql mapa
psql -d mapa -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
psql -d mapa -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql


En la cuarta sentencia debería de salir algo similar a esto:
COMMIT
ANALYZE

Con los pasos anteriores ya tenemos preparado la base de datos para manejar geometrías. Ahora escribimos en la consola para cambiar el password del usuario postgres.
psql
alter user postgres with password '123456';

OBS:
'123456' - es el password que le asignamos. Podes colocarlo el que quieras.

Despliega por pantalla el siguiente mensaje:
ALTER ROLE

Escribimos en la consola:
\q

Les dejo unarchivo sql para que importen a su base datos y tengan datos geométricos.
psql -d mapa -W -f /home/proyectosbeta/pruebas\ Mapas/osm_polygons.sql

Para verificar que contiene datos geométricos usamospgAdmin.
Imagen de usando pgAdmin
Fuente 1:Thinking in GIS
Fuente 2:Smartl gic
Fuente 3:Wikipedia

lawsuit mesothelioma cloud identity and access management asbestos mesothelioma lawyers most profitable internet business master in healthcare administration online selling annuity virtual data room pricing wellsfargo mortgage customer service auto insurance conroe tx mesothelioma claim cloud computering car accident attorney tampa define welfare motorcycle accident lawyer california national structured settlement trade association san diego criminal defense attorneys business finance courses personal injury attorney clearwater structured settlement annuity companies colorado injury lawyers houston tx auto insurance lawyers for mesothelioma auto accident lawyer in los angeles auto accident attorney michigan personal injury lawyer attorney colorado auto accident attorney los angeles motorcycle accident lawyer sell my structured settlement payment mesothelioma lawyer dallas it managing mesothelioma survival rates windows phone for business metlife structured settlement quotes car chicago condo insurance lost car insurance card mesothelioma lawyer texas mesothelioma settlement amounts american telecom solutions telco solutions scottsdale accident attorney causes of mesothelioma mesothelioma cases best mesothelioma lawyer nv auto tucson car accident attorney state of california car insurance earthlink business internet sell annuity for cash cloud computin structured settlement blog houston motorcycle accident lawyer mesothelioma attorneys california information about car insurance criminal defense lawyer pittsburgh dallas car wreck attorney asbestos mesothelioma lawsuit outbound predictive dialer personal injury attorney newport beach car accident attorney colorado springs internet savings account rates baton rouge personal injury lawyer alabama mesothelioma lawyer injury lawyer virginia business phone and internet providers structured settlements annuities mesothelioma lawsuits california motorcycle accident lawyers statnamic load test houston mesothelioma attorney jones act attorney structured settlement buyer mesothelioma suit california car accident attorney personal injury attorney ocala fl small business administration sba structured settlement purchasers business administration masters online graduate programs education mesothelioma lawyer virginia car accident attorney new york city mesothelioma attorney baltimore marketing online degrees wisconsin mesothelioma attorney tucson dui attorney mesothelioma attorneys personal injury attorney Palm Beach County denver auto accident attorneys mesothelioma claims asterisk call center software plumber richardson tx personal injury attorny mesothelioma law suits jg wentworth commercial lyrics mesotheliama mesothelioma xray php web application development mesothelioma attorney illinois personal injury lawyer sarasota fl structured settlement brokers illinois mesothelioma lawyer seattle mesothelioma lawyer delaware mesothelioma lawyer south florida personal injury attorney free electronic medical records software download car insuarnce quotes selling my structured settlement free online car quotes big data analytics software top business apps for iphone best dui lawyer los angeles mesothlioma structered settlement verizon wireless business phone web conferencing companies lawyers accidents citrix blogs tampa car accident colorado springs car accident attorney orange county accident attorney dui attorney tempe accounting degree online accredited sacramento car accident attorney cash annuity best criminal lawyer in texas best personal injury lawyer dallas truck accident attorney los angeles ft lauderdale personal injury attorney cash for my structured settlement dui austin ehr inc buying an annuity calculator cloud infrastructure as a service mesothelioma law suit mesothelioma lawyer massachusetts truck accident attorney texas mesothelioma trial attorney selling a structured settlement sell my settlement structured settlement sell injury lawyer houston tx annuity payment buyers of structured settlements private cloud mesothelioma lawyers san diego business phone internet service accident lawyers in los angeles car accident lawyers los angeles auto insurance yuba city ca baltimore mesothelioma attorneys cloud call center software houston mesothelioma lawyers auto accident lawyers california banking offers to open accounts structured settlement need cash now mesothelioma care network trailer sell structured settlement calculator enterprise cloud solution average mesothelioma settlement fast cash for house la casa mental health rehabilitation center buying structured settlements mesothelioma law firm structured settlement agreement solar lease programs factoring accounts receivable tax treatment austin tx auto insurance structured settlement investments sell a structured settlement caraccidentlawyer mesothelioma attorney assistance truck accident lawyer dallas structured settlemen ft lauderdale personal injury lawyer cash out structured settlement sell your structured settlement payments peruvianconnection co uk sell my annuity payments lump sum ak auto insurance business pbx system broward county dui lawyer dui attorney tempe az lasvegas criminal defense attorneys bus accident attorneys mesothelioma incidence workplace accident attorney new york mesothelioma law firm structured settlement company mesothelioma lawyer houston mesothelioma lawyer chicago car accident law firms investing in structured settlements mesothelioma lawyer louisiana asbestos exposure lawyers structured settlements companies attorney baton rouge emergency response plan ppt car insurance aurora il buy structured settlements supportpeachtreecom houston accident lawyer structured settlement quote call center agent software semi truck accident lawyers online schools for social worker degree java cloud development auto accident attorney Torrance network disaster recovery plan personal injury lawyer west palm beach new mexico mesothelioma lawyer online bank savings account los angeles workers compensation lawyers denver car accident lawyer yahoo web based mail mesothelioma lawyer asbestos cancer lawsuit accident attorney san bernardino injurylawyer feds liability insurance internet serious business Palm Beach Criminal Defense Attorney irvine car accident lawyer alcoholics rehabilitation paychex naperville alcohol rehab center in florida maritime lawyer houston information technology colleges in california dallas mesothelioma attorneys phoenix park hotel washington dc bed bugs dui lawyer tempe structured settlement companies the latest developments in the treatment of mesothelioma saskatchewan auto insurance tennessee mesothelioma lawyer meso lawyer personal injury attorney bronx workers compensation lawyer los angeles personal injury accident lawyer jg wentworth rip off accident attorney orange county injury attorney baton rouge mesothelioma litigation bus accident attorney los angeles nsync bye bye bye accident attorney michigan mesothelioma settlements amounts mesothelioma law firms auto accident lawyer austin colorado accident lawyers accident attorneys orange county car crash attorneys anaheim dui lawyer mesothelioma lawsuit purchase structured settlements companies that buy annuities firm law mesothelioma car insurance quotes florida online california motorcycle accident lawyer best mesothelioma lawyers voip business providers denver injury attorney pensacola personal injury lawyer personal injury firm masters degree public administration auto accident lawyer san francisco mesothelioma attorney florida mesotheolima cloud tecnology voip services for small business milwaukee personal injury attorney online degree in international business florida auto ins new jersey medical malpractice lawyer bowne virtual data room car accident lawyer florida business by phone la personal injury lawyer best accident attorneys auto accident lawyer in maryland best dui attorney orange county mesothelioma ct accident attorney in los angeles atlanta truck accident attorney hughes net business car insuran e mesothelioma help washington mesothelioma attorney diagnosed with mesothelioma internet fax telus online masters degree in corporate communications motorcycle accident attorney chicago call centers software epithelioid mesothelioma vehicle information center auto accident lawyer west palm beach best pbx phone system for small business santa ana auto accident lawyer motorcycle accident attorney sacramento new business phone service selling an annuity car accident lawyer michigan boost mobile corporate office phone number integrated management log dallas mesothelioma lawyer raid cash for structured settlements drug rehab centers in new england voice phone system mesothelioma personal injury lawyers office phone plans business voice mail service scholarship opportunities for middle school students business email web hosting california mesothelioma attorney offshore accident lawyer philadelphia mesothelioma lawyer citrix xendesktop price selling structured settlement verizon sip personal injury lawyer lafayette la mesothelioma attorney a a accident attorneys auto insurance cost by state personal injury lawyer miami florida car insurance company structured settlement cash out mesothelioma settlements mesothelioma compensation attorney lawyer mesothelioma car accident lawyers in los angeles probability of dying in a car accident colorado mesothelioma lawyers cell cycle regulation ppt residential treatment centers florida virtual dataroom mba in health administration integrated ehr best virtual data room buy my structured settlement highest yield online savings structured settlements cyber security small business structured settlement attorneys utah mesothelioma lawyer how to diagnose mesothelioma lowest rates on car insurance car accident lawyer phoenix jg wentworth peachtree ashely madis sell my structured settlement accident lawyer orange county health care reform impact on employers las vegas personal injury lawyer car accident attorneys los angeles buyer of structured settlement annuity workers compensation attorney atlanta ga water restoration san diego personal injury lawyers sarasota arizona auto accident attorney cash out annuity sell my annuity arizona dui attorneys injury lawyers west palm beach mesothelioma attorney california hosted predictive dialers boca raton personal injury attorney how to change auto insurance companies dui lawyer scottsdale truck wreck lawyer online ba degree in early childhood education structure settlements chicago work injury lawyer brooklyn accident lawyer personal injury attorney springfield mo motorcycle lawyer los angeles business telephone service provider bluehost vs ipage michigan motorcycle accident lawyer mesotheioma selling annuity payments for cash car cheap insurance uk very boulder personal injury lawyers mesothelioma lawyer california arizona car accident lawyer cheaper insurance companies georgia truck accident lawyer a structured settlement drug rehab fl mesothelioma drug mesothelioma attorney directory best structured settlement companies master of public policy programs alcohol rehabilitation florida structured settlement broker personal injury attorney sacramento ca personal injury attorney torrance Los Angeles water damage restoration motorcycle accident lawyer san francisco city college in miami plueral mesothelioma

cloud computing security companies mesothelioma lawyers best structured settlement companies mesothelioma staging structured settlement annuity companies mesothelioma law firms banking offers to open accounts mesothelioma suit magento dedicated hosting scalable cloud hosting plueral mesothelioma miami dui lawyers find personal injury attorney mesothelioma diagnosis nashville car accident lawyer hughes net business sacramento car accident lawyer rehab centers in orlando florida accident attorney orange county annuity payment mesothelioma rates chicago work injury lawyer business grade internet personal injury attorney ocala fl colorado injury lawyers caraccidentlawyer online school in indiana michigan injury lawyer structured settlement cash out sell my annuity payments lump sum wisconsin mesothelioma attorney mesothelioma lawsuits settlements top small business phone systems auto insurance yuba city ca internet provider business plan structured settlements annuities mesothelioma survival rates florida drug and alcohol treatment general business credit online ba degree in early childhood education car accident lawyers los angeles sell annuity payment the latest developments in the treatment of mesothelioma voip business providers katy auto insurance jones act attorney mesothelioma attorneys california aa accident attorneys structured settlement buyer la personal injury lawyer predictive dailer fort lauderdale criminal defense lawyer structured settlement sell metlife structured settlement sell an annuity lift master garage door opener troubleshooting public service telephone company broward county dui lawyer structured settlement quote mesothelioma claim personal injury attorney bronx cash for annuity payment mesothelioma lawsuits mesothelioma help small business administration sba sell a structured settlement list of structured settlement companies phoenix park hotel washington dc bed bugs fort collins car accident attorney fast cash for house truck accident attorney los angeles injury lawyer houston tx mesothelioma lawsuit selling annuity mesothelioma care car accident lawyers san diego business voice mail service structured settlment structured settlement purchasers asbestos mesothelioma lawsuit truck accident attorney california life contingent structured settlements houston tx auto insurance drug rehabilitation centers florida mesothelioma lawyer virginia i got into a car accident without insurance accident lawyers in los angeles emergency response plan ppt raid recovery labs arizona injury lawyer t att business sales phone number mesothelioma lawyers new york car accident attorney tampa information technology colleges in california call centers software business phones service car insurancs accident lawyer orange county car accident lawyer michigan sell my structured settlement business email web hosting mesotheliama seattle mesothelioma lawyer tennessee mesothelioma lawyer legit online business mesothelioma lawyer asbestos cancer lawsuit mesothelioma lawyer car quotes tumblr sell structured settlements dallas hvac service selling my structured settlement structured settlement buyers mesothelioma attorney illinois san antonio car accident lawyer alcohol rehab centers florida motorcycle lawyer los angeles master of business administration online programs mesothelioma trial attorney washington mesothelioma attorney earthlink business internet how do create a website buy structured settlements motorcycle accident attorney chicago baltimore mesothelioma attorneys internet phone service business data recovery raid car insuran e virtual data room review cloudservice mesothelioma lawyer texas houston motorcycle accident lawyer texting from the internet to cell phone structered settlement car accident lawyers in los angeles structured settlement investments business telephone service provider allstate structured settlement annuity personal injury attorney torrance best internet service for business cash out structured settlement nist cloud security mesothelioma cases mesothelioma lawyer dallas mesothelioma attorney assistance how to sell structured settlement integrated management log small business voip services fastest internet services car accident lawyer pittsburgh best mesothelioma lawyers sell your annuity internet savings account rates structured settlemen inpatient drug rehab florida new york mesothelioma law firm auto insurance loveland co az dui lawyer new mexico mesothelioma lawyer houston mesothelioma attorney truck accident attorney texas firm law mesothelioma mesothelioma lawyer chicago how to get a masters in business administration auto accident lawyer denver my family app lawsuit mesothelioma afordable car insurance sports management degree programs auto accident defense attorney mesothelioma law suit asbestos exposure lawyers california mesothelioma attorney motorcycle accident lawyer california car insurance seattle washington alcohol treatment center florida selling structured settlement california insurance car purchase structured settlements sell your structured settlement payments personal injury attorney austin michigan motorcycle accident lawyer supportpeachtreecom attorney for injury best android business card scanner personal injury attorney newport beach what is structured settlement best buy business phone systems houston accident lawyer semi truck accident lawyers structure settlements auto accident attorney Torrance online graduate programs education auto insurance grand junction mesotheolima dui lawyer scottsdale can i sell my annuity mesothelioma lawyers san diego new business phone service personal injury accident lawyer wireless security systems for business online degree in international business most profitable internet business buying structured settlements business long distance phone mesothelioma incidence meso attorney meso lawyer structural settlement mesothelioma compensation tucson car accident attorney workers compensation attorney atlanta ga los angeles car donation vehicle information center mesothelioma ct mesothelioma litigation unethical business cases colorado auto accident attorney criminal defense lawyer pittsburgh mesothelioma settlements amounts sell annuity for cash structured settlement broker st louis mesothelioma attorney network trailer compare small business phone systems structured settlement purchaser network disaster recovery plan personal injury lawyer boca raton accident attorneys orange county microsoft private cloud certification building online stores mesothelioma claims tom brady draft pick masters of nursing online degree programs workers compensation lawyer los angeles new voip phone service florida car insurance company motorcycle accident lawyer san francisco best personal injury lawyer dallas purchasing annuity city college in miami austin tx auto insurance personal injury lawyers michigan mesothelioma attorneys boca raton personal injury attorney business pbx system american telecom solutions structured settlement company auto accident lawyer san francisco best business voip phone system business phone service in my area los angeles motorcycle accident lawyer structured settlement blog mesothelioma attorney florida car accident lawyer phoenix personal injury firm online website store builder state of california car insurance buying an annuity calculator selling a structured settlement best accident attorneys arizona auto accident lawyer accident attorney san bernardino business internet phones california motorcycle accident lawyer payout annuity car accident lawyer colorado springs cloud identity and access management car cheap insurance uk very mesothelioma attorney multicystic mesothelioma social work degree on line diagnosed with mesothelioma auto insurance redlands ca mesothelioma attorney massachusetts rehabilitation associates fairfield ct personal injury lawyer sarasota fl mesothelioma attorney california philadelphia mesothelioma lawyer structured settlement need cash now denver auto accident attorneys illinois mesothelioma lawyer mesothelioma settlement amounts motorcycle accident attorney sacramento alcohol rehab center in florida business internet houston customer relationship management web based florida car accident attorney cash out annuity car accident attorney baton rouge average mesothelioma settlement auto accident lawyer in los angeles motorcycle accident attorneys maritime lawyer houston mesothelioma personal injury lawyers integrated ehr motorcycle accident lawyer los angeles auto accident injury lawyers business compliance package verizon wireless business phone offshore accident lawyer car accident lawyers west palm beach buy my structured settlement workplace accident attorney structured settlements calculator purchase annuities personal injury attorney sacramento ca online masters degree in corporate communications accident attorney michigan cash for my structured settlement car accident attorney orange county auto insurance cost by state boost mobile corporate office phone number water restoration san diego houston car wreck attorney i have a structured settlement and i need cash car accident attorney new york city paychex naperville voip services for small business mesothelioma settlements virtual dataroom business internet san francisco pensacola personal injury lawyer attorney lawyer mesothelioma colorado mesothelioma lawyers maryland mesothelioma lawyers host virtual machine car accident lawyer houston jg wentworth commercial lyrics sell structured settlement payments cell cycle regulation ppt sell structured settlement delaware mesothelioma lawyer motorcycle accident lawyer denver brooklyn car accident lawyer injury attorney milwaukee voice phone system personal injury lawyer bronx mesotheleoma card services direct login car injury health care reform impact on employers mesothelioma attorney directory nv auto sell your structured settlement utah mesothelioma lawyer companies that buy annuities broadband phone service alabama mesothelioma lawyer

Share:

Popular Posts

Recent Posts

Blog Archive

Con la tecnología de Blogger.