Name: agglo.adminthema.Etablissement_SIRENE

Display Field: result_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1673659.5471
YMin: 9240747.6272
XMax: 1695228.2721
YMax: 9256161.4368
Spatial Reference: 3950 (3950)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[81,130,55,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• siren (type: esriFieldTypeInteger, alias: siren, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nic (type: esriFieldTypeInteger, alias: nic, SQL Type: sqlTypeOther, nullable: true, editable: true)
• siret (type: esriFieldTypeDouble, alias: siret, SQL Type: sqlTypeOther, nullable: true, editable: true)
• statutdiffusionetablissement (type: esriFieldTypeString, alias: statutDiffusionEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [O: établissement faisant partie de la diffusion publique])
• datecreationetablissement (type: esriFieldTypeDate, alias: dateCreationEtablissement, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• trancheeffectifsetablissement (type: esriFieldTypeString, alias: trancheEffectifsEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• anneeeffectifsetablissement (type: esriFieldTypeInteger, alias: anneeEffectifsEtablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• activiteprincipaleregistremetie (type: esriFieldTypeString, alias: activitePrincipaleRegistreMetiersEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• datederniertraitementetablissem (type: esriFieldTypeString, alias: dateDernierTraitementEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• etablissementsiege (type: esriFieldTypeString, alias: etablissementSiege, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [false: Non], [true: Oui])
• etatadministratifunitelegale (type: esriFieldTypeString, alias: etatAdministratifUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [A: Active], [C: Cessée])
• statutdiffusionunitelegale (type: esriFieldTypeString, alias: statutDiffusionUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [O: unité légale faisant partie de la diffusion publique])
• unitepurgeeunitelegale (type: esriFieldTypeString, alias: unitePurgeeUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• datecreationunitelegale (type: esriFieldTypeDate, alias: dateCreationUniteLegale, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• categoriejuridiqueunitelegale (type: esriFieldTypeInteger, alias: categorieJuridiqueUniteLegale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• denominationunitelegale (type: esriFieldTypeString, alias: denominationUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sigleunitelegale (type: esriFieldTypeString, alias: sigleUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• denominationusuelle1unitelegale (type: esriFieldTypeString, alias: denominationUsuelle1UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• denominationusuelle2unitelegale (type: esriFieldTypeString, alias: denominationUsuelle2UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• denominationusuelle3unitelegale (type: esriFieldTypeString, alias: denominationUsuelle3UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• sexeunitelegale (type: esriFieldTypeString, alias: sexeUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [F: Féminin], [M: Masculin])
• nomunitelegale (type: esriFieldTypeString, alias: nomUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• nomusageunitelegale (type: esriFieldTypeString, alias: nomUsageUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prenom1unitelegale (type: esriFieldTypeString, alias: prenom1UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prenom2unitelegale (type: esriFieldTypeString, alias: prenom2UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prenom3unitelegale (type: esriFieldTypeString, alias: prenom3UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prenom4unitelegale (type: esriFieldTypeString, alias: prenom4UniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• prenomusuelunitelegale (type: esriFieldTypeString, alias: prenomUsuelUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• pseudonymeunitelegale (type: esriFieldTypeString, alias: pseudonymeUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• activiteprincipaleunitelegale (type: esriFieldTypeString, alias: activitePrincipaleUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [01.11Z: Culture de céréales (à l'exception du riz), de légumineuses et de graines oléagineuses], [01.12Z: Culture du riz], [01.13Z: Culture de légumes, de melons, de racines et de tubercules], ... 729 more ...)
• nomenclatureactiviteprincipaleu (type: esriFieldTypeString, alias: nomenclatureActivitePrincipaleUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• identifiantassociationunitelega (type: esriFieldTypeString, alias: identifiantAssociationUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• economiesocialesolidaireunitele (type: esriFieldTypeString, alias: economieSocialeSolidaireUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [O: l'entreprise appartient au champ de l’économie sociale et solidaire], [N: l'entreprise n'appartient pas au champ de l’économie sociale et solidaire])
• caractereemployeurunitelegale (type: esriFieldTypeString, alias: caractereEmployeurUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [O: unité légale employeuse], [N: unité légale non employeuse], [null: sans objet])
• trancheeffectifsunitelegale (type: esriFieldTypeString, alias: trancheEffectifsUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• anneeeffectifsunitelegale (type: esriFieldTypeInteger, alias: anneeEffectifsUniteLegale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• nicsiegeunitelegale (type: esriFieldTypeInteger, alias: nicSiegeUniteLegale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datederniertraitementunitelegal (type: esriFieldTypeString, alias: dateDernierTraitementUniteLegale, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• categorieentreprise (type: esriFieldTypeString, alias: categorieEntreprise, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [PME: petite ou moyenne entreprise], [ETI: entreprise de taille intermédiaire], [GE: grande entreprise])
• anneecategorieentreprise (type: esriFieldTypeInteger, alias: anneeCategorieEntreprise, SQL Type: sqlTypeOther, nullable: true, editable: true)
• complementadresseetablissement (type: esriFieldTypeString, alias: complementAdresseEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• numerovoieetablissement (type: esriFieldTypeInteger, alias: numeroVoieEtablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• indicerepetitionetablissement (type: esriFieldTypeString, alias: indiceRepetitionEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• typevoieetablissement (type: esriFieldTypeString, alias: typeVoieEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellevoieetablissement (type: esriFieldTypeString, alias: libelleVoieEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• codepostaletablissement (type: esriFieldTypeInteger, alias: codePostalEtablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• libellecommuneetablissement (type: esriFieldTypeString, alias: libelleCommuneEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellecommuneetrangeretablisse (type: esriFieldTypeString, alias: libelleCommuneEtrangerEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• distributionspecialeetablisseme (type: esriFieldTypeString, alias: distributionSpecialeEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• codecommuneetablissement (type: esriFieldTypeInteger, alias: codeCommuneEtablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• codecedexetablissement (type: esriFieldTypeInteger, alias: codeCedexEtablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• libellecedexetablissement (type: esriFieldTypeString, alias: libelleCedexEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• codepaysetrangeretablissement (type: esriFieldTypeString, alias: codePaysEtrangerEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellepaysetrangeretablissemen (type: esriFieldTypeString, alias: libellePaysEtrangerEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• complementadresse2etablissement (type: esriFieldTypeString, alias: complementAdresse2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• numerovoie2etablissement (type: esriFieldTypeString, alias: numeroVoie2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• indicerepetition2etablissement (type: esriFieldTypeString, alias: indiceRepetition2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• typevoie2etablissement (type: esriFieldTypeString, alias: typeVoie2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellevoie2etablissement (type: esriFieldTypeString, alias: libelleVoie2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• codepostal2etablissement (type: esriFieldTypeInteger, alias: codePostal2Etablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• libellecommune2etablissement (type: esriFieldTypeString, alias: libelleCommune2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellecommuneetranger2etabliss (type: esriFieldTypeString, alias: libelleCommuneEtranger2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• distributionspeciale2etablissem (type: esriFieldTypeString, alias: distributionSpeciale2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• codecommune2etablissement (type: esriFieldTypeInteger, alias: codeCommune2Etablissement, SQL Type: sqlTypeOther, nullable: true, editable: true)
• codecedex2etablissement (type: esriFieldTypeString, alias: codeCedex2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellecedex2etablissement (type: esriFieldTypeString, alias: libelleCedex2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• codepaysetranger2etablissement (type: esriFieldTypeString, alias: codePaysEtranger2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• libellepaysetranger2etablisseme (type: esriFieldTypeString, alias: libellePaysEtranger2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• etatadministratifetablissement (type: esriFieldTypeString, alias: etatAdministratifEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [A: Actif], [F: Fermé])
• enseigne1etablissement (type: esriFieldTypeString, alias: enseigne1Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• enseigne2etablissement (type: esriFieldTypeString, alias: enseigne2Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• enseigne3etablissement (type: esriFieldTypeString, alias: enseigne3Etablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• denominationusuelleetablissemen (type: esriFieldTypeString, alias: denominationUsuelleEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• activiteprincipaleetablissement (type: esriFieldTypeString, alias: activitePrincipaleEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [01.11Z: Culture de céréales (à l'exception du riz), de légumineuses et de graines oléagineuses], [01.12Z: Culture du riz], [01.13Z: Culture de légumes, de melons, de racines et de tubercules], ... 729 more ...)
• nomenclatureactiviteprincipalee (type: esriFieldTypeString, alias: nomenclatureActivitePrincipaleEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• caractereemployeuretablissement (type: esriFieldTypeString, alias: caractereEmployeurEtablissement, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true, Coded Values: [O: établissement employeur], [N: établissement non employeur], [null: sans objet])
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_label (type: esriFieldTypeString, alias: result_label, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_score (type: esriFieldTypeDouble, alias: result_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_type (type: esriFieldTypeString, alias: result_type, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_id (type: esriFieldTypeString, alias: result_id, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_housenumber (type: esriFieldTypeInteger, alias: result_housenumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_name (type: esriFieldTypeString, alias: result_name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_street (type: esriFieldTypeString, alias: result_street, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_postcode (type: esriFieldTypeInteger, alias: result_postcode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_city (type: esriFieldTypeString, alias: result_city, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_context (type: esriFieldTypeString, alias: result_context, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_citycode (type: esriFieldTypeInteger, alias: result_citycode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• result_oldcitycode (type: esriFieldTypeString, alias: result_oldcitycode, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_oldcity (type: esriFieldTypeString, alias: result_oldcity, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• result_district (type: esriFieldTypeString, alias: result_district, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)

Templates:

Name: agglo.adminthema.Etablissement_SIRENE
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/15/2023 2:17:31 PM

Schema Last Edit Date: 6/15/2023 2:17:31 PM

Data Last Edit Date: 6/15/2023 2:17:31 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat