Name: Table layer
Display Field: null
Type: Table
Geometry Type: N/A
Description:
Service Item Id: 95bf8e6b654b4533bff3f2a7cff5ed85
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
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:
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, description: {"fieldValueType":"uniqueIdentifier","value":""}, type: esriFieldTypeGlobalID, alias: globalid
)
-
art_wflaeche
(
nullable: true, editable: true, defaultValue: null, length: 254, alias: Wirtschaftsfläche Art, type: esriFieldTypeString
,
Coded Values:
[0: unbekannt]
,
[1: Gewerbefläche]
,
[2: Gewerbe-/Industrieareal]
)
-
kontakt_firma
(
nullable: true, editable: true, defaultValue: null, length: 32, alias: Kontakt Firma, type: esriFieldTypeString
)
-
kontakt_vorname
(
nullable: true, editable: true, defaultValue: null, length: 32, alias: Kontakt Vorname, type: esriFieldTypeString
)
-
kontakt_nachname
(
nullable: true, editable: true, defaultValue: null, length: 32, alias: Kontakt Nachname, type: esriFieldTypeString
)
-
kontakt_strasse
(
nullable: true, editable: true, defaultValue: null, length: 64, alias: Kontakt Strasse, type: esriFieldTypeString
)
-
kontakt_hausnr
(
nullable: true, editable: true, defaultValue: null, length: 16, alias: Kontakt Haus-Nr., type: esriFieldTypeString
)
-
kontakt_ort
(
nullable: true, editable: true, defaultValue: null, length: 64, description: {"fieldValueType":"locationOrPlaceName","value":""}, type: esriFieldTypeString, alias: Kontakt Ort
)
-
kontakt_land
(
nullable: true, editable: true, defaultValue: null, length: 64, alias: Kontakt Land, type: esriFieldTypeString
)
-
kontakt_email
(
nullable: true, editable: true, defaultValue: null, length: 64, description: {"fieldValueType":"emailAddress","value":""}, type: esriFieldTypeString, alias: Kontakt Email
)
-
kontakt_telefon
(
nullable: true, editable: true, defaultValue: null, length: 16, description: {"fieldValueType":"phoneNumber","value":""}, type: esriFieldTypeString, alias: Kontakt Telefon
)
-
flaeche_grundstueck_von
(
nullable: true, editable: true, defaultValue: null, alias: Grundstückfläche min., type: esriFieldTypeInteger
)
-
flaeche_grundstueck_bis
(
nullable: true, editable: true, defaultValue: null, alias: Grundstückfläche max., type: esriFieldTypeInteger
)
-
flaeche_nutzung_von
(
nullable: true, editable: true, defaultValue: null, alias: Nutzfläche min., type: esriFieldTypeInteger
)
-
flaeche_nutzung_bis
(
nullable: true, editable: true, defaultValue: null, alias: Nutzfläche max., type: esriFieldTypeInteger
)
-
hoehe_raum_von
(
nullable: true, editable: true, defaultValue: null, alias: Raumhöhe min., type: esriFieldTypeDouble
)
-
hoehe_raum_bis
(
nullable: true, editable: true, defaultValue: null, alias: Raumhöhe max., type: esriFieldTypeDouble
)
-
bodenbelastung_von
(
nullable: true, editable: true, defaultValue: null, alias: Bodenbelastung min., type: esriFieldTypeDouble
)
-
bodenbelastung_bis
(
nullable: true, editable: true, defaultValue: null, alias: Bodenbelastung max., type: esriFieldTypeDouble
)
-
etage
(
nullable: true, editable: true, defaultValue: null, length: 16, alias: Etage, type: esriFieldTypeString
)
-
tech_infrastruktur
(
nullable: true, editable: true, defaultValue: null, length: 64, alias: Technische Infrastruktur, type: esriFieldTypeString
)
-
pp_art
(
nullable: true, editable: true, defaultValue: null, length: 254, alias: Parkplätze, type: esriFieldTypeString
,
Coded Values:
[0: unbekannt]
,
[1: keine]
,
[2: Aussenparkplätze]
, ...2 more...
)
-
preis_von
(
nullable: true, editable: true, defaultValue: null, alias: Preis min., type: esriFieldTypeInteger
)
-
preis_bis
(
nullable: true, editable: true, defaultValue: null, alias: Preis max., type: esriFieldTypeInteger
)
-
preis_art
(
nullable: true, editable: true, defaultValue: null, length: 254, alias: Preis Art, type: esriFieldTypeString
,
Coded Values:
[0: unbekannt]
,
[1: Preis/m2/Jahr]
,
[2: Total Miete/Monat]
, ...1 more...
)
-
verfuegbarkeit_ab
(
nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, description: {"fieldValueType":"dateAndTime","value":""}, type: esriFieldTypeDate, alias: Verfügbar ab
)
-
verfuegbarkeit_ab_kat
(
nullable: true, editable: true, defaultValue: null, length: 35, alias: Verfügbar ab Kategorie, type: esriFieldTypeString
,
Coded Values:
[0: unbekannt]
,
[1: ab sofort (< 1 Jahr)]
,
[2: kurzfristig (1-5 Jahre)]
, ...1 more...
)
-
bemerkungen_eingabe
(
nullable: true, editable: true, defaultValue: null, length: 255, description: {"fieldValueType":"description","value":""}, type: esriFieldTypeString, alias: Bemerkungen / weitere Bedürfnisse
)
-
besitzverhaeltnis
(
nullable: true, editable: true, defaultValue: null, length: 254, alias: Besitzverhältnis, type: esriFieldTypeString
,
Coded Values:
[0: unbekannt]
,
[Kaufen: Kaufen]
,
[Miete: Miete]
, ...1 more...
)
-
nutzung_art
(
nullable: true, editable: true, defaultValue: null, length: 254, alias: Nutzung Art, type: esriFieldTypeString
,
Coded Values:
[0: unbekannt]
,
[Büro_HQ: Büro/HQ]
,
[Detailhandel: Detailhandel]
, ...5 more...
)
-
datenschutzerklaerung
(
nullable: true, editable: true, defaultValue: 0, alias: Datenschutzerklärung, type: esriFieldTypeInteger
,
Coded Values:
[0: nein]
,
[1: Ich erkläre mich mit den Datenschutzbestimmungen der Stadt Bern einverstanden]
)
-
url_survey123_form
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: URL Survey123 Formular, type: esriFieldTypeString
)
-
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
)
-
standort
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: Standort, type: esriFieldTypeString
,
Coded Values:
[ganze_Stadt: ganze Stadt]
,
[Innere_Stadt_Altstadt_(Kreis_1): Innere Stadt / Altstadt (Kreis 1)]
,
[Länggasse_Felsenau_(Kreis_2): Länggasse-Felsenau (Kreis 2)]
, ...4 more...
)
-
standort_other
(
nullable: true, editable: true, defaultValue: null, length: 256, alias: standort_other, type: esriFieldTypeString
)
-
kontakt_plz
(
nullable: true, editable: true, defaultValue: null, length: 10, alias: Kontakt PLZ, type: esriFieldTypeString
)
Capabilities: Query,Create,Update,Editing,Sync,Uploads
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Ownership Based Access Control:
- Allow Others to Update: false
- Allow Others to Delete: false
- Allow Others to Query: true
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Field Groups
Contingent Values
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Apply Edits
Add Features
Update Features
Calculate
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata