Tables:

Table: survey (0)

Name: survey

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• field_3 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: field_3, type: esriFieldTypeString )
• freizeitaktivitaeten ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Welches sind Ihre bevorzugten Freizeitaktivitäten?, type: esriFieldTypeString )
• freizeitaktivitaeten_andere ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sonstiges (bitte präzisieren):, type: esriFieldTypeString )
• geburtsjahr ( nullable: true, editable: true, defaultValue: null, alias: In welchem Jahr sind Sie geboren? (bspw. 1986), type: esriFieldTypeDouble )
• geschlecht ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Ich bin …, type: esriFieldTypeString , Coded Values: [eine Frau: eine Frau] , [ein Mann: ein Mann] , [anderes: anderes] , ...1 more... )
• nationalitaet ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Welche Nationalität haben Sie?, type: esriFieldTypeString )
• bildung ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Was ist Ihre höchste abgeschlossene Bildung?, type: esriFieldTypeString , Coded Values: [Keine abgeschlossene Schule: Keine abgeschlossene Schule] , [Obligatorische Schule: Obligatorische Schule] , [Lehre, Berufsschule: Lehre, Berufsschule] , ...4 more... )
• bildung_andere ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Andere (bitte präzisieren):, type: esriFieldTypeString )
• arbeitsort_bern ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Arbeiten Sie in der Stadt Bern?, type: esriFieldTypeString , Coded Values: [Ja: Ja] , [Nein: Nein] )
• haushalt_kinder ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Leben in Ihrem Haushalt Kinder?, type: esriFieldTypeString , Coded Values: [Ja: Ja] , [Nein: Nein] )
• kinder_alter ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Wie alt sind die Kinder?, type: esriFieldTypeString )
• hundebesitz ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sind Sie Hundebesitzer*in?, type: esriFieldTypeString , Coded Values: [Ja: Ja] , [Nein: Nein] )
• wohnort ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wo wohnen Sie?, type: esriFieldTypeString , Coded Values: [in der Stadt Bern: in der Stadt Bern] , [in einer anderen Gemeinde: in einer anderen Gemeinde der Schweiz] , [im Ausland: im Ausland] )
• quartier_name ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Quartier, type: esriFieldTypeString )
• wohnort_plz ( nullable: true, editable: true, defaultValue: null, alias: Wie lautet die Postleitzahl Ihres Wohnorts?, type: esriFieldTypeDouble )
• freiraumnutzung ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nutzen Sie die Freiräume in der Stadt Bern (bspw. für Sport, Erholung, Freunde treffen, etc.)?, type: esriFieldTypeString , Coded Values: [Ja: Ja] , [Nein: Nein] )
• freiraumwuensche ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Gibt es in der Stadt Bern Quartiere mit zu wenig Freiräumen?, type: esriFieldTypeString , Coded Values: [Ja: Ja] , [Nein: Nein] )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

• form_genutzte_freir_ume (0) -- Related To: genutzte_freir_ume (1)
• form_quartiere (1) -- Related To: quartiere (2)

Table: genutzte_freir_ume (1)

Name: genutzte_freir_ume

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• field_4 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: field_4, type: esriFieldTypeString )
• fn_besuchsgrund ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Besuchsgrund, type: esriFieldTypeString )
• fn_besuchsgrund_andere ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Anderer (bitte präzisieren):, type: esriFieldTypeString )
• fn_ortname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Wie nennen Sie diesen Ort?, type: esriFieldTypeString )
• fn_aktivitaet ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Aktivität, type: esriFieldTypeString )
• fn_aktivitaet_andere ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Weitere (bitte angeben):, type: esriFieldTypeString )
• fn_regelmaessigkeit ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Regelmässigkeit, type: esriFieldTypeString , Coded Values: [Täglich oder fast täglich: Täglich oder fast täglich] , [Mindestens einmal pro Woche: Mindestens einmal pro Woche] , [Mindestens einmal pro Monat: Mindestens einmal pro Monat] , ...2 more... )
• fn_erholsam_aufregend ( nullable: true, editable: true, defaultValue: null, length: 255, alias: erholsam – aufregend, type: esriFieldTypeString , Coded Values: [sehr erholsam: sehr erholsam] , [erholsam: erholsam] , [neutral: neutral] , ...2 more... )
• fn_kuenstlich_natuerlich ( nullable: true, editable: true, defaultValue: null, length: 255, alias: künstlich – natürlich, type: esriFieldTypeString , Coded Values: [sehr künstlich: sehr künstlich] , [künstlich: künstlich] , [neutral: neutral] , ...2 more... )
• fn_laut_still ( nullable: true, editable: true, defaultValue: null, length: 255, alias: laut – still, type: esriFieldTypeString , Coded Values: [sehr laut: sehr laut] , [laut: laut] , [neutral: neutral] , ...2 more... )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

• form_genutzte_freir_ume (0) -- Related To: survey (0)

Table: quartiere (2)

Name: quartiere

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• field_5 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: field_5, type: esriFieldTypeString )
• fw_quartier ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Quartier, type: esriFieldTypeString )
• fw_nutzungswunsch ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Nutzungswunsch, type: esriFieldTypeString )
• fw_nutzungswunsch_andere ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Anderer (bitte spezifizieren):, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

• form_quartiere (1) -- Related To: survey (0)