{"id":1038,"date":"2012-01-21T18:23:10","date_gmt":"2012-01-21T17:23:10","guid":{"rendered":"https:\/\/blog.georezo.net\/parcellair\/?page_id=1038"},"modified":"2012-01-21T19:11:31","modified_gmt":"2012-01-21T18:11:31","slug":"analyse-table-pev","status":"publish","type":"page","link":"https:\/\/blog.georezo.net\/parcellair\/analyse\/analyse-table-pev\/","title":{"rendered":"Analyse Table PEV"},"content":{"rendered":"<h3>Dans la table PEV<\/h3>\n<p style=\"padding-left: 30px\">dnupev : 001 pour la taxation principale<br \/>\nccoaff : permet de cibler par exemple les logements : H comme habitation et de calculer \u00e0 la parcelle le nombre d&rsquo;occupations diff\u00e9rentes (analyse crois\u00e9e)<br \/>\ndcapec : cat\u00e9gorie de local, champ utilis\u00e9 dans les analyses de parc \u201cpotentiellement indigne\u201d mais \u00e0 manipuler avec pr\u00e9caution<br \/>\nccthp : code coccupation permettant notamment de distinguer les occupations en tant que propri\u00e9taire, locataire ou les locaux vacants<\/p>\n<p style=\"padding-left: 90px\">&nbsp;<\/p>\n<h4 style=\"padding-left: 60px\">Densit\u00e9 logements \u00e0 la parcelle<\/h4>\n<p style=\"padding-left: 60px\">On peut aussi faire cette requ\u00eate en partant de la table habitation (voir ci-dessous)<\/p>\n<p style=\"padding-left: 30px\"><code>select keypar, count(keypar)from majic_84142.bati00 as bati, majic_84142.bati21 as pev<br \/>\nwhere bati.invar=pev.invar  and ccoaff=\"H\" and dnupev=001<br \/>\ngroup by keypar<\/code><\/p>\n<h4 style=\"padding-left: 60px\">Analyse g\u00e9n\u00e9rale logements :<\/h4>\n<p style=\"padding-left: 60px\">Cette analyse sort par logement les principaux \u00e9l\u00e9ments descriptifs : cat\u00e9gorie (dcapec), occupation (ccthp), surface (dsupdc)<\/p>\n<p style=\"padding-left: 30px\"><code>select keypar, dcapec,ccthp,dsupdc,ccoaff,concat(bati.ccodep,bati.ccocom) \"CODCOMM\"<br \/>\nfrom majic_05000.bati00 as bati,majic_05000.bati21 as pev<br \/>\nwhere  bati.invar=pev.invar<\/code><\/p>\n<h4 style=\"padding-left: 60px\">Rep\u00e9rage des copro<\/h4>\n<p style=\"padding-left: 60px\">Requ\u00eate cibl\u00e9e sur les copropri\u00e9t\u00e9s horizontales (cconlc=AP), tri sur gpdl diff\u00e9rent de 0.<\/p>\n<p style=\"padding-left: 30px\"><code>TRANSFORM Count(DGI_PEV.CCTHP) AS CompteDeCCTHP<br \/>\nSELECT DGI_COMM.NOMCOMM, DGI_INVAR.CODCOMM, DGI_INVAR.CODPARC,<br \/>\nMax(DGI_INVAR.DNIV) AS MaxDeDNIV,<br \/>\nFirst(DGI_LOCAL.HLMSEM) AS HLMSEM,<br \/>\nMax(DGI_PEV.DCAPEC) AS MaxDeDCAPEC,<br \/>\nMax(Val(DGI_LOCAL.JANNAT)) AS ACONST,<br \/>\nCount(DGI_PEV.CCOAFF) AS TOTLOGTS_CCOAFF,<br \/>\nCount(DGI_PEV.CCTHP) AS TOTLOGTS_CCTHP,<br \/>\nFirst(DGI_LOCAL.CCONLC) AS CCONLC, First(DGI_LOCAL.GPDL) AS GPDL<br \/>\nFROM (DGI_LOCAL LEFT JOIN (DGI_INVAR LEFT JOIN DGI_COMM<br \/>\nON DGI_INVAR.CODCOMM = DGI_COMM.CODCOMM)<br \/>\nON DGI_LOCAL.ID_LOCAL = DGI_INVAR.INVAR) RIGHT JOIN DGI_PEV<br \/>\nON DGI_LOCAL.ID_LOCAL = DGI_PEV.INVAR<br \/>\nWHERE (((DGI_LOCAL.CCONLC)=\"AP\")<br \/>\nAND ((DGI_LOCAL.GPDL)\"0\")<br \/>\nAND ((Right((([DGI_PEV].[ID_PEV])),3))='001')<br \/>\nAND ((DGI_PEV.CCOAFF)=\"H\"))<br \/>\nGROUP BY DGI_COMM.NOMCOMM, DGI_INVAR.CODCOMM,<br \/>\nDGI_INVAR.CODPARC, DGI_LOCAL.CCONLC, DGI_PEV.CCOAFF<br \/>\nPIVOT DGI_PEV.CCTHP;<\/code><\/p>\n<h4 style=\"padding-left: 90px\">Analyse des activit\u00e9s (logements, commerces, &#8230;)<\/h4>\n<p style=\"padding-left: 30px\"><code>select keypar, ccoaff, ccthp,concat(bati.ccodep,bati.ccocom) \"CODCOMM\"  from majic_05000.bati00 as bati, majic_05000.bati21 as pev<br \/>\nwhere bati.invar=pev.invar<\/code><\/p>\n<p style=\"padding-left: 30px\">&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dans la table PEV dnupev : 001 pour la taxation principale ccoaff : permet de cibler par exemple les logements : H comme habitation et de calculer \u00e0 la parcelle le nombre d&rsquo;occupations diff\u00e9rentes (analyse crois\u00e9e) dcapec : cat\u00e9gorie de local, champ utilis\u00e9 dans les analyses de parc \u201cpotentiellement indigne\u201d mais \u00e0 manipuler avec pr\u00e9caution [&hellip;]<\/p>\n","protected":false},"author":47,"featured_media":0,"parent":733,"menu_order":9,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1038","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/pages\/1038","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/comments?post=1038"}],"version-history":[{"count":4,"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/pages\/1038\/revisions"}],"predecessor-version":[{"id":1069,"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/pages\/1038\/revisions\/1069"}],"up":[{"embeddable":true,"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/pages\/733"}],"wp:attachment":[{"href":"https:\/\/blog.georezo.net\/parcellair\/wp-json\/wp\/v2\/media?parent=1038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}