h |
{'redirect_to': <function redirect_to at 0x7fe4dfaf1670>, 'url': <function url at 0x7fe4dfaf1790>, 'get_site_protocol_and_host': <function get_site_protocol_and_host at 0x7fe4dfaf1700>, 'url_for': <function url_for at 0x7fe4dfaf1940>, 'url_for_static': <function url_for_static at 0x7fe4dfaf1af0>, 'url_for_static_or_external': <function url_for_static_or_external at 0x7fe4dfaf1b80>, 'is_url': <function is_url at 0x7fe4dfaf1c10>, 'url_is_local': <function url_is_local at 0x7fe4dfaf1d30>, 'full_current_url': <function full_current_url at 0x7fe4dfaf1dc0>, 'current_url': <function current_url at 0x7fe4dfaf1e50>, 'lang': <function lang at 0x7fe4dfaf1ee0>, 'ckan_version': <function ckan_version at 0x7fe4dfaf1f70>, 'lang_native_name': <function lang_native_name at 0x7fe4dfaf2040>, 'is_rtl_language': <function is_rtl_language at 0x7fe4dfaf20d0>, 'get_rtl_theme': <function get_rtl_theme at 0x7fe4dfaf2160>, 'get_rtl_css': <function get_rtl_css at 0x7fe4dfaf21f0>, 'flash_notice': <function flash_notice at 0x7fe4dfaf2280>, 'flash_error': <function flash_error at 0x7fe4dfaf2700>, 'flash_success': <function flash_success at 0x7fe4dfaf2790>, 'are_there_flash_messages': <function are_there_flash_messages at 0x7fe4dfaf2820>, 'link_to': <function link_to at 0x7fe4dfaf2ca0>, 'file': <function file at 0x7fe4dfaf2d30>, 'submit': <function submit at 0x7fe4dfaf2dc0>, 'nav_link': <function nav_link at 0x7fe4dfaf2e50>, 'nav_named_link': <function nav_named_link at 0x7fe4dfaf3160>, 'subnav_link': <function subnav_link at 0x7fe4dfaf3280>, 'subnav_named_route': <function subnav_named_route at 0x7fe4dfaf33a0>, 'build_nav_main': <function build_nav_main at 0x7fe4dfaf3040>, 'build_nav_icon': <function build_nav_icon at 0x7fe4dfaf3430>, 'build_nav': <function build_nav at 0x7fe4dfaf34c0>, 'build_extra_admin_nav': <function build_extra_admin_nav at 0x7fe4dfaf35e0>, 'default_group_type': <function default_group_type at 0x7fe4dfaf3700>, 'get_facet_items_dict': <function get_facet_items_dict at 0x7fe4dfaf3790>, 'has_more_facets': <function has_more_facets at 0x7fe4dfaf3820>, 'unselected_facet_items': <function unselected_facet_items at 0x7fe4dfaf38b0>, 'get_facet_title': <function get_facet_title at 0x7fe4dfaf3a60>, 'get_param_int': <function get_param_int at 0x7fe4dfaf3940>, 'sorted_extras': <function sorted_extras at 0x7fe4dfaf3b80>, 'check_access': <function check_access at 0x7fe4dfaf3c10>, 'get_action': <function get_action at 0x7fe4dfaf3dc0>, 'linked_user': <function linked_user at 0x7fe4dfaf3ca0>, 'group_name_to_title': <function group_name_to_title at 0x7fe4dfaf3e50>, 'truncate': <function truncate at 0x7fe4dfaf3ee0>, 'markdown_extract': <function markdown_extract at 0x7fe4dfaf3f70>, 'icon_url': <function icon_url at 0x7fe4dfaf4040>, 'icon_html': <function icon_html at 0x7fe4dfaf40d0>, 'icon': <function icon at 0x7fe4dfaf4160>, 'resource_icon': <function resource_icon at 0x7fe4dfaf41f0>, 'format_icon': <function format_icon at 0x7fe4dfaf4280>, 'dict_list_reduce': <function dict_list_reduce at 0x7fe4dfaf4310>, 'gravatar': <function gravatar at 0x7fe4dfaf43a0>, 'sanitize_url': <function sanitize_url at 0x7fe4dfaf4430>, 'user_image': <function user_image at 0x7fe4dfaf44c0>, 'pager_url': <function pager_url at 0x7fe4dfaf4550>, 'get_page_number': <function get_page_number at 0x7fe4dfaf45e0>, 'get_display_timezone': <function get_display_timezone at 0x7fe4dfaf4670>, 'render_datetime': <function render_datetime at 0x7fe4dfaf4700>, 'date_str_to_datetime': <function date_str_to_datetime at 0x7fe4dfaf4790>, 'parse_rfc_2822_date': <function parse_rfc_2822_date at 0x7fe4dfaf4820>, 'time_ago_from_timestamp': <function time_ago_from_timestamp at 0x7fe4dfaf48b0>, 'button_attr': <function button_attr at 0x7fe4dfaf4b80>, 'dataset_display_name': <function dataset_display_name at 0x7fe4dfaf4c10>, 'dataset_link': <function dataset_link at 0x7fe4dfaf4ca0>, 'resource_display_name': <function resource_display_name at 0x7fe4dfaf4d30>, 'resource_link': <function resource_link at 0x7fe4dfaf4dc0>, 'tag_link': <function tag_link at 0x7fe4dfaf4e50>, 'group_link': <function group_link at 0x7fe4dfaf4ee0>, 'organization_link': <function organization_link at 0x7fe4dfaf4f70>, 'dump_json': <function dump_json at 0x7fe4dfaf5040>, 'auto_log_message': <function auto_log_message at 0x7fe4dfaf50d0>, 'activity_div': <function activity_div at 0x7fe4dfaf5160>, 'snippet': <function snippet at 0x7fe4dfaf51f0>, 'convert_to_dict': <function convert_to_dict at 0x7fe4dfaf5280>, 'follow_button': <function follow_button at 0x7fe4dfaf5310>, 'follow_count': <function follow_count at 0x7fe4dfaf53a0>, 'add_url_param': <function add_url_param at 0x7fe4dfaf54c0>, 'remove_url_param': <function remove_url_param at 0x7fe4dfaf5550>, 'include_resource': <function include_resource at 0x7fe4dfaf55e0>, 'urls_for_resource': <function urls_for_resource at 0x7fe4dfaf5670>, 'debug_inspect': <function debug_inspect at 0x7fe4dfaf5700>, 'popular': <function popular at 0x7fe4dfaf5790>, 'groups_available': <function groups_available at 0x7fe4dfaf5820>, 'organizations_available': <function organizations_available at 0x7fe4dfaf58b0>, 'roles_translated': <function roles_translated at 0x7fe4dfaf5940>, 'user_in_org_or_group': <function user_in_org_or_group at 0x7fe4dfaf59d0>, 'dashboard_activity_stream': <function dashboard_activity_stream at 0x7fe4dfaf5a60>, 'recently_changed_packages_activity_stream': <function recently_changed_packages_activity_stream at 0x7fe4dfaf5af0>, 'escape_js': <function escape_js at 0x7fe4dfaf5b80>, 'get_pkg_dict_extra': <function get_pkg_dict_extra at 0x7fe4dfaf5c10>, 'get_request_param': <function get_request_param at 0x7fe4dfaf5ca0>, 'html_auto_link': <function html_auto_link at 0x7fe4dfaf5d30>, 'render_markdown': <function render_markdown at 0x7fe4dfaf5dc0>, 'format_resource_items': <function format_resource_items at 0x7fe4dfaf5e50>, 'resource_preview': <function resource_preview at 0x7fe4dfaf5ee0>, 'get_allowed_view_types': <function get_allowed_view_types at 0x7fe4dfaf5f70>, 'rendered_resource_view': <function rendered_resource_view at 0x7fe4dfaf6040>, 'view_resource_url': <bound method ResourceProxy.view_resource_url of <Plugin ResourceProxy 'resource_proxy'>>, 'resource_view_is_filterable': <function resource_view_is_filterable at 0x7fe4dfaf6160>, 'resource_view_get_fields': <function resource_view_get_fields at 0x7fe4dfaf61f0>, 'resource_view_is_iframed': <function resource_view_is_iframed at 0x7fe4dfaf6280>, 'resource_view_icon': <function resource_view_icon at 0x7fe4dfaf6310>, 'resource_view_display_preview': <function resource_view_display_preview at 0x7fe4dfaf63a0>, 'resource_view_full_page': <function resource_view_full_page at 0x7fe4dfaf6430>, 'remove_linebreaks': <function remove_linebreaks at 0x7fe4dfaf64c0>, 'list_dict_filter': <function list_dict_filter at 0x7fe4dfaf6550>, 'SI_number_span': <function SI_number_span at 0x7fe4dfaf65e0>, 'new_activities': <function new_activities at 0x7fe4dfaf6670>, 'uploads_enabled': <function uploads_enabled at 0x7fe4dfaf6700>, 'get_featured_organizations': <function get_featured_organizations at 0x7fe4dfaf6790>, 'get_featured_groups': <function get_featured_groups at 0x7fe4dfaf6820>, 'featured_group_org': <function featured_group_org at 0x7fe4dfaf68b0>, 'get_site_statistics': <function get_site_statistics at 0x7fe4dfaf6940>, 'resource_formats': <function resource_formats at 0x7fe4dfaf69d0>, 'unified_resource_format': <function unified_resource_format at 0x7fe4dfaf6a60>, 'check_config_permission': <function check_config_permission at 0x7fe4dfaf6af0>, 'get_boolean_config_option': <function get_boolean_config_option at 0x7fe4dfaf6b80>, 'get_organization': <function get_organization at 0x7fe4dfaf6c10>, 'license_options': <function license_options at 0x7fe4dfaf6ca0>, 'get_translated': <function get_translated at 0x7fe4dfaf6d30>, 'facets': <function facets at 0x7fe4dfaf6dc0>, 'mail_to': <function mail_to at 0x7fe4dfaf6e50>, 'radio': <function radio at 0x7fe4dfaf6ee0>, 'clean_html': <function clean_html at 0x7fe4dfaf6f70>, 'flash': <ckan.lib.helpers._Flash object at 0x7fe4dfbe0820>, 'localised_number': <function localised_number at 0x7fe4dfc390d0>, 'localised_SI_number': <function localised_SI_number at 0x7fe4dfc391f0>, 'localised_nice_date': <function localised_nice_date at 0x7fe4dfc23ee0>, 'localised_filesize': <function localised_filesize at 0x7fe4dfc39160>, 'get_available_locales': <function get_available_locales at 0x7fe4e50d60d0>, 'get_locales_dict': <function get_locales_dict at 0x7fe4e50d6040>, 'literal': <class 'ckan.lib.helpers.literal'>, 'asbool': <function asbool at 0x7fe4e551f3a0>, 'urlencode': <function urlencode at 0x7fe4f03db0d0>, 'include_asset': <function include_asset at 0x7fe4dfaf1160>, 'render_assets': <function render_assets at 0x7fe4dfaf1280>, 'sanitize_id': <function sanitize_id at 0x7fe4dcbb41f0>, 'compare_pkg_dicts': <function compare_pkg_dicts at 0x7fe4dfaf7160>, 'activity_list_select': <function activity_list_select at 0x7fe4dfaf71f0>, 'get_collaborators': <function get_collaborators at 0x7fe4dfaf7280>, 'can_update_owner_org': <function can_update_owner_org at 0x7fe4dfaf7310>, 'check_ckan_version': <function check_ckan_version at 0x7fe4dfaf73a0>, 'csrf_input': <function csrf_input at 0x7fe4dfaf7430>, 'civity_group_list': <function group_list at 0x7fe4dcba51f0>, 'civity_choices_to_json': <function choices_to_json at 0x7fe4dcba5160>, 'civity_donl_theme_list_choices': <function donl_theme_list_choices at 0x7fe4dcbaf790>, 'civity_donl_authority_list_choices': <function donl_authority_list_choices at 0x7fe4dcbaf820>, 'civity_donl_language_list_choices': <function donl_language_list_choices at 0x7fe4dcbaf700>, 'civity_donl_spatial_scheme_list_choices': <function donl_spatial_scheme_list_choices at 0x7fe4dcbaf8b0>, 'civity_donl_spatial_value_list_choices': <function donl_spatial_value_list_choices at 0x7fe4dcbaf940>, 'sweden_theme_list_choices': <function sweden_theme_list_choices at 0x7fe4dcbaf9d0>, 'civity_get_matomo_id': <function get_matomo_id at 0x7fe4dcbafa60>, 'civity_get_matomo_url': <function get_matomo_url at 0x7fe4dcbafaf0>, 'civity_get_matomo_custom_url': <function get_matomo_custom_url at 0x7fe4dcbafb80>, 'civity_get_siteimprove_src': <function get_siteimprove_src at 0x7fe4dcbafc10>, 'civity_get_scheming_package_types_list': <function get_scheming_package_types_list at 0x7fe4dcbafee0>, 'civity_get_now_date': <function get_now_date at 0x7fe4dcbaff70>, 'civity_get_package_title': <function get_package_title at 0x7fe4dcbb4040>, 'civity_get_package_notes': <function get_package_notes at 0x7fe4dcbb40d0>, 'civity_i18n_error_document': <function i18n_error_document at 0x7fe4dcbb4280>, 'package_rating': <function rating_package_get at 0x7fe4dcba5310>, 'get_user_rating': <function get_user_rating at 0x7fe4dcba53a0>, 'show_rating_in_type': <function show_rating_in_type at 0x7fe4dcba5430>, 'get_trackers': <bound method TrackerBackend.get_trackers of <class 'ckanext.tracker_base.backend.TrackerBackend'>>, 'get_tracker_badges': <function get_tracker_badges at 0x7fe4dce49310>, 'get_tracker_statuses': <function get_tracker_statuses at 0x7fe4dce49280>, 'get_tracker_activities': <function get_tracker_activities at 0x7fe4dceee8b0>, 'get_tracker_activities_stream': <function get_tracker_activities_stream at 0x7fe4dce47940>, 'get_tracker_queues': <function get_tracker_queues at 0x7fe4dce478b0>, 'hash': <function hash at 0x7fe4dce49550>, 'helper_available': <function helper_available at 0x7fe4deba2b80>, 'dcat_get_endpoint': <function get_endpoint at 0x7fe4deb32430>, 'package_list_for_source': <function package_list_for_source at 0x7fe4dc7c6f70>, 'package_count_for_source': <function package_count_for_source at 0x7fe4dc7d1040>, 'harvesters_info': <function harvesters_info at 0x7fe4dc7d10d0>, 'harvester_types': <function harvester_types at 0x7fe4dc7d1160>, 'harvest_frequencies': <function harvest_frequencies at 0x7fe4dc7d11f0>, 'link_for_harvest_object': <function link_for_harvest_object at 0x7fe4dc7d1280>, 'harvest_source_extra_fields': <function harvest_source_extra_fields at 0x7fe4dc7d1310>, 'get_harvest_source': <function get_harvest_source at 0x7fe4dc7c6ee0>, 'get_common_map_config_shp': <function get_common_map_config at 0x7fe4debdb430>, 'get_shapefile_viewer_config': <function get_shapefile_viewer_config at 0x7fe4debdb4c0>, 'get_common_map_config_wmts': <function get_common_map_config at 0x7fe4debdb430>, 'get_common_map_config_geojson': <function get_common_map_config at 0x7fe4debdb430>, 'geojson_get_max_file_size': <function get_max_file_size at 0x7fe4debdb550>, 'get_common_map_config_geoviews': <function get_common_map_config at 0x7fe4debdb430>, 'get_openlayers_viewer_config': <function get_openlayers_viewer_config at 0x7fe4debdb5e0>, 'get_map_config': <function get_mapview_config at 0x7fe4debd21f0>, 'get_dataproxy_url': <function get_dataproxy_url at 0x7fe4debd2430>, 'datastore_dictionary': <function datastore_dictionary at 0x7fe4dec04700>, 'scheming_language_text': <function scheming_language_text at 0x7fe4dec79700>, 'scheming_field_choices': <function scheming_field_choices at 0x7fe4dec798b0>, 'scheming_choices_label': <function scheming_choices_label at 0x7fe4dec79940>, 'scheming_datastore_choices': <function scheming_datastore_choices at 0x7fe4dec799d0>, 'scheming_field_required': <function scheming_field_required at 0x7fe4dec79a60>, 'scheming_dataset_schemas': <function scheming_dataset_schemas at 0x7fe4dec79af0>, 'scheming_get_presets': <function scheming_get_presets at 0x7fe4dec79b80>, 'scheming_get_preset': <function scheming_get_preset at 0x7fe4dec79c10>, 'scheming_get_dataset_schema': <function scheming_get_dataset_schema at 0x7fe4dec79ca0>, 'scheming_get_dataset_form_pages': <function scheming_get_dataset_form_pages at 0x7fe4dec79d30>, 'scheming_group_schemas': <function scheming_group_schemas at 0x7fe4dec79dc0>, 'scheming_get_group_schema': <function scheming_get_group_schema at 0x7fe4dec79e50>, 'scheming_organization_schemas': <function scheming_organization_schemas at 0x7fe4dec79ee0>, 'scheming_get_organization_schema': <function scheming_get_organization_schema at 0x7fe4dec79f70>, 'scheming_get_schema': <function scheming_get_schema at 0x7fe4dec7c040>, 'scheming_field_by_name': <function scheming_field_by_name at 0x7fe4dec7c0d0>, 'scheming_datetime_to_utc': <function scheming_datetime_to_utc at 0x7fe4dec7c1f0>, 'scheming_datetime_to_tz': <function scheming_datetime_to_tz at 0x7fe4dec7c280>, 'scheming_get_timezones': <function scheming_get_timezones at 0x7fe4dec7c310>, 'scheming_display_json_value': <function scheming_display_json_value at 0x7fe4dec7c3a0>, 'scheming_render_from_string': <function scheming_render_from_string at 0x7fe4dec7c430>, 'scheming_flatten_subfield': <function scheming_flatten_subfield at 0x7fe4dec7c4c0>, 'scheming_package_type_list': <function scheming_package_type_list at 0x7fe4dec7c550>} |
packages |
[{'access_rights': 'http://publications.europa.eu/resource/authority/access-right/PUBLIC', 'author': None, 'author_email': None, 'authority': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'contact_point_email': 'support@civity.nl', 'contact_point_name': 'Servicedesk', 'contact_point_type': 'organization', 'creator_user_id': '2da92da4-b919-40d6-9afe-60b6fa1310a9', 'donl_link_enabled': 'False', 'geonetwork_link_enabled': 'False', 'geoserver_link_enabled': 'True', 'id': 'd80ce0f5-e043-412f-971b-a74d4cbdc9c6', 'isopen': False, 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'license_id': 'notspecified', 'license_title': 'License not specified', 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2022-11-01T18:36:59.207098', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2024-08-23T12:56:30.806027', 'name': 'slimmelden-reports-utrecht', 'notes': 'Slim Melden meldingen. Openbare gegevens van meldingen worden een keer per dag gesynchroniseerd. ', 'num_resources': 2, 'num_tags': 1, 'organization': {'id': 'c24f840a-2cbd-417b-8655-665e72a8366c', 'name': 'gemeente-utrecht', 'title': 'Gemeente Utrecht', 'type': 'organization', 'description': 'Gemeente Utrecht organisatie aangemaakt om IRIS Utrecht data te kunnen publiceren.', 'image_url': '2021-07-29-123833.980283logo-gemeente-utrecht-nederlands-groot-1200.png', 'created': '2020-10-06T13:54:05.559242', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'c24f840a-2cbd-417b-8655-665e72a8366c', 'private': False, 'publisher': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'spatial_scheme': 'http://standaarden.overheid.nl/owms/4.0/doc/waardelijsten/overheid.gemeente', 'spatial_value': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'state': 'active', 'theme': 'http://standaarden.overheid.nl/owms/terms/Bestuur', 'title': 'Slim Melden Meldingen gemeente Utrecht', 'type': 'dataset', 'update_frequency': 'voortdurend geactualiseerd', 'url': None, 'groups': [{'description': '', 'display_name': 'Bestuur', 'id': 'cad6820b-b76d-455f-bae5-0bffa4f6cda5', 'image_display_url': 'https://tst-ckan.dataplatform.nl/uploads/group/2020-10-27-085107.6511032019-02-13-122400.725142bestuur.png', 'name': 'bestuur', 'title': 'Bestuur'}, {'description': '', 'display_name': 'Bestuur', 'id': 'cad6820b-b76d-455f-bae5-0bffa4f6cda5', 'image_display_url': 'https://tst-ckan.dataplatform.nl/uploads/group/2020-10-27-085107.6511032019-02-13-122400.725142bestuur.png', 'name': 'bestuur', 'title': 'Bestuur'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2022-11-01T18:39:06.277851', 'datastore_active': False, 'description': 'Classificatie en symbolisatie meldingen openbare ruimte', 'format': 'SLD', 'hash': 'b3a8694b17143f502cb7a5974c51a82c303a0dc0', 'id': 'reports-sld-utrecht', 'last_modified': '2022-11-03T10:50:04.455347', 'metadata_modified': '2022-11-01T18:39:06.277851', 'mimetype': None, 'mimetype_inner': None, 'name': 'Classificatie en symbolisatie meldingen openbare ruimte', 'package_id': 'd80ce0f5-e043-412f-971b-a74d4cbdc9c6', 'position': 0, 'resource_type': None, 'size': 3856, 'state': 'active', 'url': 'https://tst-ckan.dataplatform.nl/dataset/d80ce0f5-e043-412f-971b-a74d4cbdc9c6/resource/reports-sld-utrecht/download/status.sld', 'url_type': 'upload'}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-11-03T01:40:01.720572', 'datastore_active': True, 'description': 'Deze resource bevat 2704 meldingen openbare ruimte\r\nCIVDEV-1043\r\nCIVDEV-1043', 'format': 'CSV', 'hash': '18bfc023274e4a8096d75871aa0ad84952e2a17a', 'id': 'r408ea3870a59b0b8525b87db8cfd2d90266dd97fd41d3c20809f80838ca559', 'last_modified': '2023-08-25T00:40:02.559821', 'layer_extent': '[4.99472379684448, 51.553522, 5.684535, 52.5046479680421]', 'layer_srid': 4326, 'metadata_modified': '2024-08-23T12:56:30.816104', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Meldingen openbare ruimte', 'package_id': 'd80ce0f5-e043-412f-971b-a74d4cbdc9c6', 'position': 1, 'resource_type': None, 'size': 1815760, 'state': 'active', 'timestamp_identifier': 'created', 'url': 'https://tst-ckan.dataplatform.nl/dataset/d80ce0f5-e043-412f-971b-a74d4cbdc9c6/resource/r408ea3870a59b0b8525b87db8cfd2d90266dd97fd41d3c20809f80838ca559/download/meldingen-openbare-ruimte-4058927159389047360.csv', 'url_type': 'upload', 'wfs_url': 'https://tst-ckan.dataplatform.nl/geoserver/workspace_datastore_ckan_dataplatform_nl/ckan_r408ea3870a59b0b8525b87db8cfd2d90266dd97fd41d3c20809f80838ca559/ows?service=WFS&version=2.0.0&request=GetFeature&typeName=workspace_datastore_ckan_dataplatform_nl%3Ackan_r408ea3870a59b0b8525b87db8cfd2d90266dd97fd41d3c20809f80838ca559&maxFeatures=50&outputFormat=gml3', 'wms_url': 'https://tst-ckan.dataplatform.nl/geoserver/workspace_datastore_ckan_dataplatform_nl/ckan_r408ea3870a59b0b8525b87db8cfd2d90266dd97fd41d3c20809f80838ca559/ows?service=WMS&version=1.3.0&request=GetMap&layers=ckan_r408ea3870a59b0b8525b87db8cfd2d90266dd97fd41d3c20809f80838ca559&bbox=4.99472379684448%2C+51.553522%2C+5.684535%2C+52.5046479680421&width=768&height=384&srs=EPSG%3A4326&format=image%2Fpng'}], 'tags': [{'display_name': 'Meldingen openbare ruimte', 'id': '8e47e33e-1e91-4de1-aa3a-90d85b5f4a15', 'name': 'Meldingen openbare ruimte', 'state': 'active', 'vocabulary_id': None}], 'relationships_as_subject': [], 'relationships_as_object': []}, {'access_rights': 'http://publications.europa.eu/resource/authority/access-right/PUBLIC', 'author': None, 'author_email': None, 'authority': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'bounding_box': '', 'changetype': 'updated', 'contact_point_email': 'servicedesk@civity.nl', 'contact_point_name': 'Servicedesk', 'contact_point_phone': '', 'contact_point_type': 'organization', 'creator_user_id': '2da92da4-b919-40d6-9afe-60b6fa1310a9', 'dataset_status': 'http://data.overheid.nl/status/beschikbaar', 'definition': '', 'denominator': '', 'donl_link_enabled': 'False', 'geo_ref_system': '', 'geonetwork_link_enabled': 'False', 'geoserver_link_enabled': 'False', 'id': 'ff31cc71-49d9-4e01-9825-68f8f38efe93', 'isopen': False, 'language': 'http://publications.europa.eu/resource/authority/language/ENG', 'license_id': 'notspecified', 'license_title': 'License not specified', 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2022-08-25T18:44:56.966263', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/ENG', 'metadata_modified': '2022-10-13T12:01:05.078473', 'name': 'energy-consumption-observed', 'notes': '# Introduction\r\n\r\nWithin the frame of IRIS Utrecht, data regarding energy consumption is being collected from a number of apartment buildings. Purpose of collecting these data is to be able to evaluate the result of energy saving measures. \r\n\r\nTo be able to calculate energy consumption, the following variables are needed:\r\n\r\n* electricity delivered (from net to connection)\r\n* electricity generated (by PV panels)\r\n* electricity returned (from connection to net)\r\n\r\nUsing these variables, electricity consumption can be calculated using the following formula:\r\n\r\nelectricity consumed = electricity delivered + electricity generated - electricity returned\r\n\r\n![Electricity delivered, produced and generated explained](https://acc-ckan-dataplatform-nl.dataplatform.nl/dataset/ff31cc71-49d9-4e01-9825-68f8f38efe93/resource/4df5ddde-4320-49d2-b9e1-6d9a962b2c4b/download/energy_consumption_observed.png)\r\n\r\n*Electricity delivered, produced and generated explained*\r\n\r\nWe are collecting energy consumption from different sources. \r\n\r\n## Toon smart thermostat\r\n\r\nEvery night, Quby uploads a file containing energy consumption data from Alexander de Grotelaan I, II, III and IV, Columbuslaan II and Rooseveldlaan I and II to a Amazon S3 bucket. Theses data contain average electricity delivered (from net to connection) and electricity received (from connection to net) for two tariffs (low and normal tariff) at 15 minute intervals. In addition to the average, the files contain the standard deviation and the number of connections involved in calculating the average and standard deviation values. The dataset does not contain energy generated, and can thus not be used to calculate energy consumption. To work around this issue, energy generated by Columbuslaan I (downloaded from the myBeNext API) is used to estimate energy generation by the other apartment buildings. \r\n\r\nThe S3 file should contain four rows per hour for each apartment building/variable combination. In the picture below, hours for which this is not the case have been marked red. This is probably due to the fact that there are no households producing data for that timestamp/variable. If all variables are missing for a timestamp, this will lead to a missing data point in this dataset. If at least one variable is present for a timestamp, the missing ones will be zero. \r\n\r\n![Missing data in S3 file](https://acc-ckan-dataplatform-nl.dataplatform.nl/dataset/ff31cc71-49d9-4e01-9825-68f8f38efe93/resource/320177c1-1587-49d4-b3cf-e1c8fc1358e8/download/missing_rows_in_s3_file.png)\r\n\r\n## myBeNext API\r\n\r\nEvery hour, quarterly data is being downloaded from the myBeNext API for two apartment buildings: Henriettedreef and Columbuslaan I. For Henriettedreef, data regarding electricity delivered, electricity returned and electricity produced is collected. This information is available at the level of the individual connections, but this information is never stored in the dataset. The dataset contains the sum for the entire apartment building. \r\n\r\n## Access the data\r\n\r\n### CKAN datastore API\r\n\r\nThe data can be downloaded from the CKAN resource included in this package. Because of the size of the dataset, downloading the entire dataset in one go will probably fail due to time outs. The CKAN datastore API can be used to download the dataset in parts.Example code how that can be done can be found [here](https://github.com/CivityNL/Snuffelfiets-examples). To be able to run this code, you will need a resource identifier (in this case energy_consumption_observed_cepontod) and (in case of a private dataset) an API key. You can find your API key by logging in to CKAN and clicking on your username in the top right corner of the page. You will then find your API key on the left. \r\n\r\n### FIWARE ContextBroker\r\n\r\nThe [get entities](https://acc-toon.dataplatform.nl//smart-thermostat/orion/v2/entities?type=EnergyConsumptionObserved) gets the current state of the different enties. It provides a list of a) the entities and b) the attributes which can be used to compile requests for the Short Term History API. \r\n\r\n### Short Term History API\r\n\r\nThe Short Term History (STH) API provides access to historical information for the different entities in both raw and aggregated form. \r\n\r\n[Columbuslaan II, electricity consumed, raw values](https://acc-toon.dataplatform.nl/smart-thermostat/STH/v2/entities/columbuslaan_ii/attrs/electricityConsumed?type=EnergyConsumptionObserved&lastN=100&count=false)\r\n\r\n[Number of connections corresponding to the previous API call](https://acc-toon.dataplatform.nl/smart-thermostat/STH/v2/entities/columbuslaan_ii/attrs/noConnectionsElectricityConsumed?type=EnergyConsumptionObserved&lastN=100&count=false)\r\n\r\n[Columbuslaan II, electricity delivered, aggregated values per month between January 1, 2022 and January 1, 2023](https://acc-toon.dataplatform.nl/smart-thermostat/STH/v2/entities/columbuslaan_ii/attrs/electricityDelivered?type=EnergyConsumptionObserved&aggrMethod=sum&aggrPeriod=month&dateFrom=2022-01-01T00%3A00%3A00.0%2B02%3A00&dateTo=2023-01-01T00%3A00%3A00.0%2B02%3A00&count=false)', 'num_resources': 4, 'num_tags': 1, 'organization': {'id': 'c24f840a-2cbd-417b-8655-665e72a8366c', 'name': 'gemeente-utrecht', 'title': 'Gemeente Utrecht', 'type': 'organization', 'description': 'Gemeente Utrecht organisatie aangemaakt om IRIS Utrecht data te kunnen publiceren.', 'image_url': '2021-07-29-123833.980283logo-gemeente-utrecht-nederlands-groot-1200.png', 'created': '2020-10-06T13:54:05.559242', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'c24f840a-2cbd-417b-8655-665e72a8366c', 'private': False, 'publisher': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'resolution': '', 'spatial_scheme': 'http://standaarden.overheid.nl/owms/4.0/doc/waardelijsten/overheid.gemeente', 'spatial_value': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'state': 'active', 'subtheme': 'http://standaarden.overheid.nl/owms/terms/Energie', 'theme': 'http://standaarden.overheid.nl/owms/terms/Natuur_en_milieu', 'title': 'Energy consumption observed', 'type': 'dataset', 'update_frequency': 'voortdurend geactualiseerd', 'url': None, 'version': '', 'version_notes': '', 'extras': [{'key': 'linked_datasets', 'value': ''}], 'groups': [{'description': '', 'display_name': 'Natuur en milieu', 'id': 'af36ddfd-2ec1-4266-ad7b-53c089952591', 'image_display_url': 'https://tst-ckan.dataplatform.nl/uploads/group/2020-10-27-090104.5979272019-02-13-122638.391682natuur.png', 'name': 'natuur-en-milieu', 'title': 'Natuur en milieu'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2020-10-23T09:48:15.576528', 'datastore_active': True, 'description': 'Energy consumption at building level', 'format': '', 'hash': '', 'id': 'energy_consumption_observed_cepontod', 'last_modified': None, 'license_id': 'notspecified', 'metadata_modified': '2020-10-23T09:48:15.576528', 'mimetype': None, 'mimetype_inner': None, 'name': 'Energy consumption observed', 'package_id': 'ff31cc71-49d9-4e01-9825-68f8f38efe93', 'position': 0, 'resource_type': None, 'state': 'active', 'url': 'https://tst-ckan.dataplatform.nl/datastore/dump/energy_consumption_observed_cepontod', 'url_type': 'datastore'}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-08-25T18:52:26.742432', 'datastore_active': False, 'description': 'Energy consumption observed picture', 'download_url': '', 'format': 'PNG', 'geonetwork_url': '', 'hash': 'dd7674202866412ff06c4d658f21031aec99d4e9', 'id': '4df5ddde-4320-49d2-b9e1-6d9a962b2c4b', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-08-25T18:52:26.364364', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-08-25T18:52:26.742432', 'mimetype': 'image/png', 'mimetype_inner': None, 'name': 'Energy consumption observed picture', 'package_id': 'ff31cc71-49d9-4e01-9825-68f8f38efe93', 'position': 1, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 10567, 'state': 'active', 'timestamp_identifier': '', 'url': 'https://tst-ckan.dataplatform.nl/dataset/ff31cc71-49d9-4e01-9825-68f8f38efe93/resource/4df5ddde-4320-49d2-b9e1-6d9a962b2c4b/download/energy_consumption_observed.png', 'url_type': 'upload', 'wfs_url': '', 'wms_url': ''}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-08-25T18:54:14.956754', 'datastore_active': False, 'description': 'The S3 file should contain for rows per hour for each apartment building/variable combination. In this picture, hours for which this is not the case have been marked red.', 'download_url': '', 'format': 'PNG', 'geonetwork_url': '', 'hash': 'a1929594d58f6f9d776d811c757ca9398ea2dde2', 'id': '320177c1-1587-49d4-b3cf-e1c8fc1358e8', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-08-25T18:54:14.610856', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-08-25T18:54:14.956754', 'mimetype': 'image/png', 'mimetype_inner': None, 'name': 'Example of missing rows in S3 file', 'package_id': 'ff31cc71-49d9-4e01-9825-68f8f38efe93', 'position': 2, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 120685, 'state': 'active', 'timestamp_identifier': '', 'url': 'https://tst-ckan.dataplatform.nl/dataset/ff31cc71-49d9-4e01-9825-68f8f38efe93/resource/320177c1-1587-49d4-b3cf-e1c8fc1358e8/download/missing_rows_in_s3_file.png', 'url_type': 'upload', 'wfs_url': '', 'wms_url': ''}, {'cache_last_updated': None, 'cache_url': None, 'created': '2021-09-16T13:09:51.672994', 'datastore_active': False, 'description': 'Metadata for apartment buildings for which energy consumption related data is being collected', 'format': 'CSV', 'hash': 'd5e9f6e941ed61334be9fe25f4932bedf9608eb4', 'id': 'apartment_building_cepontod', 'last_modified': '2022-10-13T12:01:04.612304', 'metadata_modified': '2021-09-16T13:09:51.672994', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Apartment buildings', 'package_id': 'ff31cc71-49d9-4e01-9825-68f8f38efe93', 'position': 4, 'resource_type': None, 'size': 962, 'state': 'active', 'url': 'https://tst-ckan.dataplatform.nl/dataset/ff31cc71-49d9-4e01-9825-68f8f38efe93/resource/apartment_building_cepontod/download/apartment_buildings.csv', 'url_type': 'upload'}], 'tags': [{'display_name': 'Energyconsumption', 'id': '86540fae-f468-4bd8-a7a2-d52b07ae358f', 'name': 'Energyconsumption', 'state': 'active', 'vocabulary_id': None}], 'relationships_as_subject': [], 'relationships_as_object': []}, {'access_rights': 'http://publications.europa.eu/resource/authority/access-right/PUBLIC', 'author': None, 'author_email': None, 'authority': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'bounding_box': '', 'changetype': 'updated', 'contact_point_email': 'support@civity.nl', 'contact_point_name': 'Servicedesk', 'contact_point_phone': '', 'contact_point_type': 'individual', 'creator_user_id': '2da92da4-b919-40d6-9afe-60b6fa1310a9', 'dataset_status': 'http://data.overheid.nl/status/beschikbaar', 'definition': '', 'denominator': '', 'donl_link_enabled': 'False', 'geo_ref_system': '', 'geonetwork_link_enabled': 'False', 'geoserver_link_enabled': 'False', 'id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'isopen': False, 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'license_id': 'notspecified', 'license_title': 'License not specified', 'maintainer': None, 'maintainer_email': None, 'metadata_created': '2022-01-19T12:03:38.117221', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-10-11T06:25:29.511429', 'name': 'slimmelden-datasets-utrecht', 'notes': 'Slim Melden datasets', 'num_resources': 6, 'num_tags': 2, 'organization': {'id': 'c24f840a-2cbd-417b-8655-665e72a8366c', 'name': 'gemeente-utrecht', 'title': 'Gemeente Utrecht', 'type': 'organization', 'description': 'Gemeente Utrecht organisatie aangemaakt om IRIS Utrecht data te kunnen publiceren.', 'image_url': '2021-07-29-123833.980283logo-gemeente-utrecht-nederlands-groot-1200.png', 'created': '2020-10-06T13:54:05.559242', 'is_organization': True, 'approval_status': 'approved', 'state': 'active'}, 'owner_org': 'c24f840a-2cbd-417b-8655-665e72a8366c', 'private': False, 'publisher': 'http://standaarden.overheid.nl/owms/terms/Utrecht_(gemeente)', 'resolution': '', 'spatial_scheme': 'http://standaarden.overheid.nl/owms/4.0/doc/syntax-codeerschemas/overheid.epsg28992', 'spatial_value': '', 'state': 'active', 'subtheme': '', 'theme': 'http://standaarden.overheid.nl/owms/terms/Bestuur', 'title': 'Slim Melden Datasets', 'type': 'dataset', 'update_frequency': 'voortdurend geactualiseerd', 'url': None, 'version': '', 'version_notes': '', 'extras': [{'key': 'linked_datasets', 'value': ''}], 'groups': [{'description': '', 'display_name': 'Bestuur', 'id': 'cad6820b-b76d-455f-bae5-0bffa4f6cda5', 'image_display_url': 'https://tst-ckan.dataplatform.nl/uploads/group/2020-10-27-085107.6511032019-02-13-122400.725142bestuur.png', 'name': 'bestuur', 'title': 'Bestuur'}], 'resources': [{'cache_last_updated': None, 'cache_url': None, 'created': '2022-01-19T12:03:49.759574', 'datastore_active': True, 'description': 'Openbaar verlichting 20220802', 'download_url': '', 'format': 'CSV', 'geonetwork_url': '', 'hash': '223cf02c1cbf2e90a3f05c704868c59363726782', 'id': 'ovl-utrecht', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-10-11T06:25:15.726741', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-01-19T12:03:49.759574', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Openbare verlichting', 'package_id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'position': 0, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 10592763, 'state': 'active', 'timestamp_identifier': '', 'url': 'https://tst-ckan.dataplatform.nl/dataset/a344a76f-44e6-4ef9-b8c6-c5ed9749d5da/resource/ovl-utrecht/download/20221011paaldump.csv', 'url_type': 'upload', 'wfs_url': '', 'wms_url': ''}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-01-19T12:03:53.522944', 'datastore_active': True, 'description': 'Afvalbakken', 'download_url': '', 'format': 'CSV', 'hash': 'df433a1feed42150a3e9eb95b4eead3e624bb7e9', 'id': 'afvalbakken-utrecht', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-01-20T07:55:18.403366', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-01-19T12:03:53.522944', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Afvalbakken', 'package_id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'position': 1, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 825641, 'state': 'active', 'url': 'https://tst-ckan.dataplatform.nl/dataset/a344a76f-44e6-4ef9-b8c6-c5ed9749d5da/resource/afvalbakken-utrecht/download/20210316afvalbakdump.csv', 'url_type': 'upload'}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-01-19T12:03:58.081477', 'datastore_active': True, 'description': 'Speelplaatsen', 'download_url': '', 'format': 'CSV', 'hash': 'c72e3a4c05d2102e761cb214abe83553fa6cc1bf', 'id': 'speelplaatsen-utrecht', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-01-20T07:55:31.426753', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-01-19T12:03:58.081477', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Speelplaatsen', 'package_id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'position': 2, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 594062, 'state': 'active', 'url': 'https://tst-ckan.dataplatform.nl/dataset/a344a76f-44e6-4ef9-b8c6-c5ed9749d5da/resource/speelplaatsen-utrecht/download/speelplaatsen.csv', 'url_type': 'upload'}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-01-19T12:04:02.215253', 'datastore_active': True, 'description': 'Parkeerautomaten', 'download_url': '', 'format': 'XLSX', 'geonetwork_url': '', 'hash': 'fde90f71474385d3d7c94ff512bcfe0d641ba8c2', 'id': 'parkeerautomaten-utrecht', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-07-22T10:13:17.757443', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-01-19T12:04:02.215253', 'mimetype': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'mimetype_inner': None, 'name': 'Parkeerautomaten', 'package_id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'position': 3, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 62804, 'state': 'active', 'timestamp_identifier': '', 'url': 'https://tst-ckan.dataplatform.nl/dataset/a344a76f-44e6-4ef9-b8c6-c5ed9749d5da/resource/parkeerautomaten-utrecht/download/kopie-van-parkeerautomaten-per-21-juli-2022-slimmelden.xlsx', 'url_type': 'upload', 'wfs_url': '', 'wms_url': ''}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-01-19T12:04:06.029203', 'datastore_active': True, 'description': 'Bomen', 'download_url': '', 'format': 'CSV', 'hash': '00dc52985d75146a94d46a2af9c05cc9acf5d0fc', 'id': 'bomen-utrecht', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-05-11T14:31:21.593965', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-01-19T12:04:06.029203', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Bomen', 'package_id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'position': 4, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 25729460, 'state': 'active', 'timestamp_identifier': '', 'url': 'https://tst-ckan.dataplatform.nl/dataset/a344a76f-44e6-4ef9-b8c6-c5ed9749d5da/resource/bomen-utrecht/download/20211028-bomen.csv', 'url_type': 'upload', 'wfs_url': '', 'wms_url': ''}, {'cache_last_updated': None, 'cache_url': None, 'created': '2022-01-19T12:04:10.464022', 'datastore_active': True, 'description': 'Containers 3-3-2022', 'download_url': '', 'format': 'CSV', 'hash': '7eddecc843c88b34fbf3b21ea0cca1072f0b8ace', 'id': 'containers-utrecht', 'language': 'http://publications.europa.eu/resource/authority/language/NLD', 'last_modified': '2022-05-16T07:31:46.471397', 'layer_extent': '', 'linked_schemas': '', 'metadata_language': 'http://publications.europa.eu/resource/authority/language/NLD', 'metadata_modified': '2022-01-19T12:04:10.464022', 'mimetype': 'text/csv', 'mimetype_inner': None, 'name': 'Containers', 'package_id': 'a344a76f-44e6-4ef9-b8c6-c5ed9749d5da', 'position': 5, 'resource_status': 'http://purl.org/adms/status/Completed', 'resource_type': None, 'rights': '', 'size': 1062599, 'state': 'active', 'timestamp_identifier': '', 'url': 'https://tst-ckan.dataplatform.nl/dataset/a344a76f-44e6-4ef9-b8c6-c5ed9749d5da/resource/containers-utrecht/download/containeroverzicht-16-5-2022.csv', 'url_type': 'upload', 'wfs_url': '', 'wms_url': ''}], 'tags': [{'display_name': 'lantarenpalen', 'id': '19b82ed8-f28f-4002-8828-cceeb97cb59b', 'name': 'lantarenpalen', 'state': 'active', 'vocabulary_id': None}, {'display_name': 'openbare verlichting', 'id': 'eb530017-9b3b-40ee-9c8c-11670f383b3c', 'name': 'openbare verlichting', 'state': 'active', 'vocabulary_id': None}], 'relationships_as_subject': [], 'relationships_as_object': []}] |