PostgreSQL et PostGIS dynamisent le SI du CEN LR

!"#$%&'()*+'$+!"#$,-(+./0123#'0$+4'+ (-+.5+678+*9: !"#$%&'()*+('##,"-# ('##,"-+./+0+!"#$12( 34$5,'6+7"##4'&$ 8'#9"-#4:;'+<6+(2+=>?+*@8 !4&,#+@+/A+B6,-+/CDD

!

!

!410 !

"#$%&'()(*+'!,-!./0!123

!

4()(!,&%!5*&-6!*'*(*)5!7899:;

!

<*==*>-5($%!&(!=#-%(#)(*+'%!&'?&',#$&%

!

@AB&>(*=%!=*6$%

!

3$C+'%&!)CC+#($&

!

@-(*5%!-(*5*%$%

!

@#?)'*%)(*+'!)>(-&55&

!

.)%!,D-(*5*%)(*+'

!!

E*5)'!&(!"&#%C&>(*F&%

!

!&;#'0$1$3"0+.'#+678 !

8G!.3/0H!I!.</0H!G!=$,$#)(*+'

!

J%%+>*)(*+'%!,&!5+*!GK9G!L!J?#$M&'(!=-(-#

!

N*%%*+'%

!

!

"

1)!C#+(&>(*+'!&(!5)!?&%(*+'!,&%!&%C)>&%!')(-#&5%

"

1D&6C&#(*%&!%>*&'(*=*O-&!&(!(&>P'*O-&

"

1)!%&'%*A*5*%)(*+'!Q!5D&'F*#+''&M&'(

"

1D)'*M)(*+'!,&!C#+B&(%!,&!(&##*(+*#&

8899!%*(&%H!G89!999!P&>()#&%H G9999!A$'$F+5&%H!R99!%)5)#*$%!7I:S!.<T; !

*'+678+*9:

!

!

8R!C&#%+''&%

!

GHI!NU!,&!A-,?&(!7K9SC-A5*>;

!

.+MC$(&'>&%!(P$M)(*O-&%!F)#*$&% "

4>+5+?*&

"

E+()'*O-&H!"PV(+%+>*+5+?*&

"

W)-'*%(*O-&!7+#'*(P+5+?*&H!P&#C$(+5+?*&H! &'(+M+5+?*&;

"

J?#+'+M*&

"

J,M*'*%(#)(*+'!,&%!&'(#&C#*%&%

"

!

X&%(*+'!,&!YV%(ZM&%!,D*'=+#M)(*+'

*'+678+*9: !

!

!

!

J>>+MC)?'&M&'(!,&%!>+55&>(*F*($%!&(!,&%! $()A5*%%&M&'(%!C-A5*>%!,)'%!5)!?&%(*+'!,&!5&-#%! &%C)>&%!')(-#&5% J>>+MC)?'&M&'(!,&!5)!M*%&!&'![-F#&!,&%!

C+5*(*O-&%!C-A5*O-&% 0$>&%%*(&'( "

<D!)>>$,&#!=)>*5&M&'(!\!#)C*,&M&'(!Q!5)!,+''$&

"

<D&'!=)*#&!5D)')5V%&!&(!5)!%V'(PZ%&

"

<&!C+-F+*#!,*==-%&#!5&%!>+'')*%%)'>&%!C#+,-*(&% !

<$1$+.'#+43'5=+>?@@AB

!

!

C3DD3E54$;#+'$+D&5#$&1$3"0#+'0%'0.&;'# !

!

.+'%+5*,)(*+'!\!YV'(PZ%&%!,*==*>*5&%!\!*MC+%%*A5&% "

]P$M)(*O-&

"

X$+?#)CP*O-&

!

.+-#(&!,-#$&!,&!F*&!,&!5)!,+''$&

!

W)*A5&!^!#&',&M&'(!_!,&!5)!>+'')*%%)'>&!C#+,-*(&

!

3$)>(*F*($!&'!,&`Q!,-!C+(&'(*&5

!

<*==-%*+'!,*==*>*5&!,&!,+''$&%!C+-#()'(!C-A5*O-&%

!

")%!+-!C&-!,&!M$(),+''$&% !

FGH'E$3D#+D3=;# !

J>>Z%!>+'>-##&'(%!&(!?&%(*+'!,&%!,#+*(%!,D)>>Z%

!

.&'(#)5*%)(*+'!&(!%(#->(-#)(*+'!&==*>)>&%

!

X)#)'(*&!,&!5D*'($?#*($

!

J>>Z%!?$+?#)CP*O-&!&(!(P$M)(*O-&!Q!5D*'=+#M)(*+'

!

<&%>#*C(*+'!,&%!M$(),+''$&%aaa

!

N&*55&-#%!,*==-%*+'!&(!$>P)'?&%!,&%!*'=+#M)(*+'%aaa "

!

J>>&%%*A*5*($!,&%!,+''$&%!b!3$)>(*F*($

!

:;I"0#'+1II"&$;' !

!

N*%&!&'![-F#&!,D-'&!A)%&!,&!,+''$&%!#&5)(*+''&55&! )-!>[-#!,-!YT Y(+>c)?&!,&%!,+''$&%!C#+,-*(&%!&(!-(*5*%$&% "

! !

!

E*+,*F&#%*($H!#$=$#&'(*&5%!()6+'+M*O-&%H!=+'>*&#H! #$%&)-6H!C$#*MZ(#&%!,D*'F&'()*#&%!&(!#$?5&M&'()*#&%

.P+*6!,&!"+%(?#&Yd1\"+%(XTY!7899R; e(*5*%)(*+'!,&!'+MA#&-6!+-(*5%!5*A#&%!#$C+',)'(!Q! '+%!,*==$#&'(%!A&%+*'% !

*'#+"5$34#+5$343#;# !

.)#(+?#)CP*&!\!.+'%-5()(*+' "

!

YV'(PZ%&%!\!#&C+#(*'? "

!

!

T#&C+#(!f!N)CY&#F&#

<*==-%*+'!&(!>)()5+?)?& "

/]1!7]@Y\Y<TH!?,)5\+?#;!bg!C5)(&=+#M&!.J3N/0

"

N<h/E!7C#$2#&MC5*%%)?&!,&!%O-&5&((&!6M5;

.+'>&C(*+'!\!M+,$5*%)(*+' "

!

dXTY!\!C?),M*'

N+%c*(( !

!

Y)*%*&!>+'(#i5$&!j!@C&'1)V&#%!f!/6(!k%

F&%103#1$3"0+1E$5'44'

!

!

61#+.J5$343#1$3"0 !

!

!

!

!

.)#(+?#)CP*&!,&%!&'B&-6!,&!>+'%&#F)(*+'!,&%!

C#+C#*$($%!,-!.<1 N+,&#'*%)(*+'!,&!5D*'F&'()*#&!,&%!l0T/WW!,&!5)! #$?*+'!7&6&MC5&!,&!=*>P&!C#+,-*(&; <*)?'+%(*>%!,&!A*+,*F&#%*($!,&%!&6C5+*()(*+'%! )?#*>+5&% N*%&!&'!C5)>&!,D-'!)CC5*>)(*+'!m&A!,&!%)*%*&! >+'(#i5$&!7+C&'5)V&#%!\!&6(;!7,$M+; !

K3410 !

@-(*5!?#)(*=*)'(!n

!

/6(#)+#,*')*#&!#*>P&%%&!,&!5D&'F*#+''&M&'(!5*A#&!n

!

e(*5*%)(*+'!>+-#)'(&!7%&5&>(;!#&5)(*F&M&'(!)*%$&

!

W)>*5*($!,D),M*'*%(#)(*+'!7Q!'+(#&!$>P&55&;

!

!

J!>&!B+-#!(+-%!5&%!+AB&>(*=%!+'(!$($!)((&*'(%!+-!

C#&%O-& "&#%C&>(*F&%!'+MA#&-%&%!,D-(*5*%)(*+'!&(!,&!

F)5+#*%)(*+'!,&%!,+''$&% "

!

&6a!J')5V%&%!=+'>*Z#&% !

!'&#I'E$3L'# !

W5-*,*=*&#!&(!5*&#!5&%!M)*55+'%!7(+-%!=+'>(*+''&5%;!,&!

5)!>P)*'&!,&!(#)*(&M&'(% "

!

!

Y)*%*&!o!,+>-M&'()(*+'!o!&6C+#(!f!>)()5+?)?&

X$'$#)5*%&#!5D)>>Z%!,*#&>(!Q!5)!A)%&!,&!,+''$&%!C+-#!

5)!>)#(+?#)CP*&!7d?*%H!A&%+*'!,&!=+#M)(*+';

!

e(*5*%)(*+'!,&%!#)%(&#%

!

e(*5*%)(*+'!,&!#!\!M+,$5*%)(*+' "

J')5V%&%!,&!5)>-'&%

"

<$(&>(*+'!,&!'*>P&% !

6"22'0$+E"0$&3G5'&+M !

<+'%!*MC+%%*A5&%

!

")%!,&!A&%+*'!,&!,$F&5+CC&M&'(!%C$>*=*O-& o=+#M)(*+'%!7&'>),#&M&'(!,&!%()?*)*#&%; oC#+M+(*+'!,&%!+-(*5%!7@0.WYH!.J!3J; o^!,*%%$M*')(*+'!_!%-#!5&!%*(&!P((Cj\\%*?a>&'5#a+#? oC)#(*>*C)(*+'!)-6!#$%&)-6!?$+M)(*O-&%

!

!

N'&E3+.'+L"$&'+1$$'0$3"0

!

!