# Pro Juventute — Vendor Intelligence Profile
> Source: Vedex (https://vedex.ai) | Generated: 2026-10-05T10:36:34.267Z

## Overview

- **Headquarters**: Switzerland
- **Description**: We (Pro Juventute) use Swiss geographic entities for a number of analyses and reports. For this purpose we update them daily. And while we're at it, we hereby share them with you.
Content
There are two sources for the three tables in this dataset:
The official directories by
SwissTopo
The basic geographics by the
Federal Statistics Office (BFS)
The combined data offers a robust foundation for:
Precise geocoding and reverse geocoding applications
Spatial data visualization and mapping
Data structure
The source data is provided in the Swiss
LV95
map projection (both points and polygons). To enable using the global
WSG84
map projection, we transform the original points and polygons and provide the second projection alongside the first.
The dataset is organized into three tables, each representing a different aspect of the geospatial information:
Localities and municipalities
Since localities (cities and towns) and municipalities (administrative divisions) can have some overlap (a locality can contain or be contained in multiple municipalities), their polygons are different. Hence we extend the
official directory of towns and cities
from SwissTopo with yearly updated polygons on
municipalities
from the Federal Statistical Office (BFS).
The resulting table contains those columns:
ID (VARCHAR(56)): Combined ID of the locality (city/town) and the municipality
LOCALITY_ID (VARCHAR(40)): ID of the locality (city/town)
LOCALITY (VARCHAR(40)): Name of the locality (city/town); multi-lingual separated by /
MUNICIPALITY_NR (NUMBER(16,0)): Number of the municipality
MUNICIPALITY (VARCHAR(40)): Name of the municipality
ZIP (NUMBER(16,0)): ZIP code of the locality, 4 digits
ZIP_ADD (NUMBER(16,0)): ZIP addition of the locality
CANTON (VARCHAR(2)): Canton of the municipality; one locality can have municipalities in multiple cantons
LANGUAGE (VARCHAR(20)): Language of the name of the locality
VALIDITY (DATE): Name of the locality is valid since
EAST_LV95 (FLOAT): East coordinate, LV95: random point inside the locality
NORTH_LV95 (FLOAT): North coordinate, LV95: random point inside the locality
LONGITUDE (FLOAT): East coordinate, WGS84: random point inside the locality
LATITUDE (FLOAT): North coordinate, WGS84: random point inside the locality
POINT_LV95 (GEOMETRY): Random point inside the locality, LV95
POINT_WGS84 (GEOGRAPHY): Random point inside the locality, WGS84
LOCALITY_POLYGON_LV95 (GEOMETRY): Polygon of the locality, LV95
LOCALITY_POLYGON_WGS84 (GEOGRAPHY): Polygon of the locality, WGS84
MUNICIPALITY_POLYGON_LV95 (GEOMETRY): Polygon of the municipality, LV95
MUNICIPALITY_POLYGON_WGS84 (GEOGRAPHY): Polygon of the municipality, WGS84
Sample values
for the city of Geneva:
LOCALITY: "Genève"
MUNICIPALITY: "Genève", "Le Grand-Saconnex", "Meyrin", "Pregny-Chambésy", "Vernier"
MUNICIPALITY_NR: 6621, 6623, 6630, 6634, 6643
ZIP: 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1215
CANTON: "GE"
LANGUAGE: "FR"
Streets
As each street in Switzerland gets a unique identifier from the federal authorities, we utilize the
official street directory
and simply add a street's coordinates in the WSG84 projection:
STREET_ID (NUMBER(16,0)): ID of the street (ESID: Eidgenössischer Strassenidentifikator)
STREET (VARCHAR(150)): Name of the street; multi-lingual separated by /
ZIP_LOCALITY (VARCHAR(500)): ZIP code and locality; multiple separated by ,
MUNICIPALITY_NR (NUMBER(6,0)): Number of the municipality
MUNICIPALITY (VARCHAR(40)): Name of the municipality
CANTON (VARCHAR(2)): Canton of the municipality
TYPE (VARCHAR(50)): Type of the street
STATUS (VARCHAR(50)): Realization status of the street according to GWR
OFFICIAL (BOOLEAN): Mandatory spelling of the street name according to GWR
LAST_MODIFIED (DATE): Last modification date of the street
EAST_LV95 (NUMBER(16,0)): East coordinate, LV95: random point on the street
NORTH_LV95 (NUMBER(16,0)): North coordinate, LV95: random point on the street
LONGITUDE (FLOAT): East coordinate, WGS84: random point on the street
LATITUDE (FLOAT): North coordinate, WGS84: random point on the street
POINT_LV95 (GEOMETRY): Random point on the street, LV95
POINT_WGS84 (GEOGRAPHY): Random point on the street, WGS84
Sample values
for the most famous street in Bern:
STREET_ID: 10006889
STREET: "Kramgasse"
ZIP_LOCALITY: "3011 Bern"
MUNICIPALITY_NR: 351
MUNICIPALITY: "Bern"
CANTON: "BE"
TYPE: "Street"
STATUS: "real"
OFFICIAL: TRUE
LAST_MODIFIED: 2024-07-23
EAST_LV95: 2600737
NORTH_LV95: 1199656
LONGITUDE: 7.448313238
LATITUDE: 46.947988103
Buildings
The highest level of detail available in the
official registry
goes down to each officially registered building address. Noteworthy in this table are a couple of official IDs - which might be useful as reference to other geographic data provided by the Federal Statistics Office or private entities. Once again the WSG84 projection of the coordinates of a building's address is added:
BUILDINGADDRESS_ID (NUMBER(16,0)): ID of the building address (EGAID: Eidgenössisch
- **Domain**: projuventute.ch
- **Contact Email**: digital+snowflake@projuventute.ch
- **Company Website**: https://projuventute.ch

## Categories & Sectors

- **Categories**: Geospatial, Location Data Enrichment, Location Geocoding

## Marketplace Presence

- **Source Platforms**: snowflake_marketplace
- **Platform Count**: 1

## Intelligence Scores

- **Vendor Score**: 18.6
- **Market Presence**: 13.8
- **Integration**: 20
- **Business Maturity**: 3.2

## Links

- Vedex Profile: https://vedex.ai/vendor/pro-juventute-8f96a7
- Due Diligence: https://vedex.ai/due-diligence/pro-juventute-8f96a7