Last active
April 1, 2020 16:30
-
-
Save geobabbler/603d09b42458fc45313935d2b0969983 to your computer and use it in GitHub Desktop.
FME workspace to scrape JHU COVID-19 county-level data into a geopackage.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #! <?xml version="1.0" encoding="UTF-8" ?> | |
| #! <WORKSPACE | |
| # Command-line to run this workspace: | |
| # /opt/fme-desktop-2020/fme /home/myname/jhu_counties2gpkg.fmw | |
| # --SourceDataset_GEOJSON "https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/ncov_cases_US/FeatureServer/0/query?where=1%3D1&outFields=*&f=geojson&token=" | |
| # --DestDataset_OGCGEOPACKAGE "/home/myname/jhu_county.gpkg" | |
| # | |
| #! ATTR_TYPE_ENCODING="SDF" | |
| #! BEGIN_PYTHON="" | |
| #! BEGIN_TCL="" | |
| #! CATEGORY="" | |
| #! DESCRIPTION="" | |
| #! DESTINATION="NONE" | |
| #! DESTINATION_ROUTING_FILE="" | |
| #! DOC_EXTENTS="2987.01 71" | |
| #! DOC_TOP_LEFT="-817.008 636.009" | |
| #! END_PYTHON="" | |
| #! END_TCL="" | |
| #! EXPLICIT_BOOKMARK_ORDER="false" | |
| #! FME_BUILD_NUM="20202" | |
| #! FME_DOCUMENT_GUID="00421f35-c16a-44e1-9417-9590f414b2cc" | |
| #! FME_DOCUMENT_PRIORGUID="" | |
| #! FME_GEOMETRY_HANDLING="Enhanced" | |
| #! FME_IMPLICIT_CSMAP_REPROJECTION_MODE="Auto" | |
| #! FME_REPROJECTION_ENGINE="FME" | |
| #! FME_SERVER_SERVICES="" | |
| #! FME_STROKE_MAX_DEVIATION="0" | |
| #! HISTORY="" | |
| #! IGNORE_READER_FAILURE="No" | |
| #! LAST_SAVE_BUILD="FME(R) 2020.0.0.1 (20200316 - Build 20202 - linux-x64)" | |
| #! LAST_SAVE_DATE="2020-04-01T10:34:02" | |
| #! LOG_FILE="" | |
| #! LOG_MAX_RECORDED_FEATURES="200" | |
| #! MARKDOWN_DESCRIPTION="" | |
| #! MARKDOWN_USAGE="" | |
| #! MAX_LOG_FEATURES="200" | |
| #! MULTI_WRITER_DATASET_ORDER="BY_ID" | |
| #! PASSWORD="" | |
| #! PYTHON_COMPATIBILITY="37" | |
| #! REDIRECT_TERMINATORS="NONE" | |
| #! SAVE_ON_PROMPT_AND_RUN="Yes" | |
| #! SHOW_ANNOTATIONS="true" | |
| #! SHOW_INFO_NODES="true" | |
| #! SOURCE="NONE" | |
| #! SOURCE_ROUTING_FILE="" | |
| #! TERMINATE_REJECTED="YES" | |
| #! TITLE="" | |
| #! USAGE="" | |
| #! USE_MARKDOWN="" | |
| #! VIEW_POSITION="-1458.01 927.009" | |
| #! WARN_INVALID_XFORM_PARAM="Yes" | |
| #! WORKSPACE_VERSION="1" | |
| #! ZOOM_SCALE="100" | |
| #! > | |
| #! <DATASETS> | |
| #! <DATASET | |
| #! IS_SOURCE="true" | |
| #! ROLE="READER" | |
| #! FORMAT="GEOJSON" | |
| #! DATASET="$(SourceDataset_GEOJSON)" | |
| #! KEYWORD="GEOJSON_1" | |
| #! MULTI_GEOM_ALLOWED="false" | |
| #! ATTR_MAX_LENGTH="0" | |
| #! ATTR_CASE="ANY" | |
| #! ALLOWED_FEAT_TYPES="" | |
| #! WRITE_DEFS="true" | |
| #! DEFLINE_TEMPLATE="" | |
| #! DEFLINE_ATTRS="true" | |
| #! EXPOSABLE_ATTRS="fme_secondary_axis float fme_sweep_angle float fme_text_string string fme_feature_type string fme_type string fme_text_size float fme_dataset string fme_rotation float multi_reader_keyword string fme_start_angle float multi_reader_type string fme_geometry string fme_fill_color string fme_basename string multi_reader_full_id int multi_reader_id int fme_color string fme_primary_axis float" | |
| #! DEFLINE_PARMS="" | |
| #! ATTR_INDEX_TYPES="" | |
| #! ATTR_NAME_INVALID_CHARS="" | |
| #! SUPPORTS_FEATURE_TYPE_FANOUT="true" | |
| #! ENABLED="true" | |
| #! DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE="true" | |
| #! DATASET_TYPE="FILE" | |
| #! FTTR_TYPE="LISTBOX_ENCODED" | |
| #! GENERATE_FME_BUILD_NUM="20202" | |
| #! COORDSYS="EPSG:4326" | |
| #! FEATURE_TYPES="" | |
| #! MAX_FEATURES="" | |
| #! MAX_FEATURES_PER_FEATURE_TYPE="" | |
| #! MIN_FEATURES="" | |
| #! START_FEATURE="" | |
| #! > | |
| #! <METAFILE_PARAMETER | |
| #! NAME="DATASET_NAME" | |
| #! VALUE="json file" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="MIME_TYPE" | |
| #! VALUE="application/geo+json ADD_DISPOSITION" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="READER_DATASET_HINT" | |
| #! VALUE="Select the GeoJSON file(s) or type the GeoJSON URL" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="WRITER_DATASET_HINT" | |
| #! VALUE="Specify a name for the GeoJSON file" | |
| #! /> | |
| #! </DATASET> | |
| #! <DATASET | |
| #! IS_SOURCE="false" | |
| #! ROLE="WRITER" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! DATASET="$(DestDataset_OGCGEOPACKAGE)" | |
| #! KEYWORD="OGCGEOPACKAGE_1" | |
| #! MULTI_GEOM_ALLOWED="false" | |
| #! ATTR_MAX_LENGTH="256" | |
| #! ATTR_CASE="ANY" | |
| #! ALLOWED_FEAT_TYPES="" | |
| #! WRITE_DEFS="true" | |
| #! DEFLINE_TEMPLATE="geopackage_type {FME_GEN_GEOMETRY} fme_feature_operation INSERT fme_table_handling CREATE_IF_MISSING fme_selection_method MATCH_ID fme_match_id_attribute "geopackage_fid" geopackage_geometry_column geom geopackage_primary_index_column id geopackage_create_spatial_index YES geopackage_z_capability NOT_ALLOWED geopackage_m_capability NOT_ALLOWED" | |
| #! DEFLINE_ATTRS="true" | |
| #! EXPOSABLE_ATTRS="fme_color text(50) fme_secondary_axis double fme_type text(50) fme_basename text(50) fme_text_string text(50) fme_text_size double fme_dataset text(50) fme_geometry text(50) fme_start_angle double fme_feature_type text(50) fme_rotation double fme_fill_color text(50) fme_sweep_angle double geopackage_type text(255) fme_primary_axis double" | |
| #! DEFLINE_PARMS=""GUI OPTIONAL NAMEDGROUP fme_configuration_group fme_configuration_common_group%fme_spatial_group%fme_advanced_group%oracle_advanced_group Table" "" "GUI OPTIONAL NAMEDGROUP fme_configuration_common_group fme_feature_operation%fme_table_handling%mie_pack%oracle_model%fme_update_geometry%fme_selection_group%fme_table_creation_group General" "" "GUI ACTIVECHOICE_LOOKUP fme_feature_operation Insert,INSERT,fme_update_geometry,fme_selection_group%Update,UPDATE,++fme_table_handling+USE_EXISTING,++fme_selection_group+FME_DISCLOSURE_OPEN%Delete,DELETE,++fme_table_handling+USE_EXISTING,fme_update_geometry,++fme_selection_group+FME_DISCLOSURE_OPEN,fme_spatial_group,fme_advanced_group,oracle_sequenced_cols%<at>Value<openparen>fme_db_operation<closeparen>,MULTIPLE,++fme_table_handling+USE_EXISTING,++fme_selection_group+FME_DISCLOSURE_OPEN Feature Operation" INSERT "GUI ACTIVECHOICE_LOOKUP fme_table_handling Use<space>Existing,USE_EXISTING,fme_table_creation_group%Create<space>If<space>Needed,CREATE_IF_MISSING%Drop<space>and<space>Create,DROP_CREATE Table Handling" CREATE_IF_MISSING "GUI OPTIONAL DISCLOSUREGROUP fme_selection_group fme_match_id_attribute Row Selection" "" "GUI WHOLE_LINE ATTR fme_match_id_attribute \" \" ID Attribute" geopackage_fid "GUI OPTIONAL DISCLOSUREGROUP fme_table_creation_group geopackage_primary_index_column%geopackage_geometry_column%geopackage_create_spatial_index%geopackage_z_capability%geopackage_m_capability Table Creation Parameters" "" "GUI OPTIONAL TEXT_ENCODED geopackage_primary_index_column Primary Index Column" id "GUI OPTIONAL TEXT_ENCODED geopackage_geometry_column Spatial Column" geom "GUI CHOICE geopackage_create_spatial_index Yes%No Create Spatial Index" Yes "GUI LOOKUP_CHOICE_ENCODED geopackage_z_capability Not<space>Allowed,NOT_ALLOWED%Required,REQUIRED%Optional,OPTIONAL Z" NOT_ALLOWED "GUI LOOKUP_CHOICE_ENCODED geopackage_m_capability Not<space>Allowed,NOT_ALLOWED%Required,REQUIRED%Optional,OPTIONAL M" NOT_ALLOWED " | |
| #! ATTR_INDEX_TYPES="Indexed" | |
| #! ATTR_NAME_INVALID_CHARS="\\"{}()',@&`~!#$%^*+-=|[]:;<>?./" | |
| #! SUPPORTS_FEATURE_TYPE_FANOUT="true" | |
| #! ENABLED="true" | |
| #! DYNAMIC_FEATURE_TYPES_LIST_ON_MERGE="true" | |
| #! DATASET_TYPE="FILE" | |
| #! FTTR_TYPE="" | |
| #! GENERATE_FME_BUILD_NUM="20202" | |
| #! COORDSYS="" | |
| #! FANOUT_EXPRESSION="" | |
| #! FANOUT_GROUP="NO" | |
| #! > | |
| #! <METAFILE_PARAMETER | |
| #! NAME="ADVANCED_PARMS" | |
| #! VALUE="OGCGEOPACKAGE_OUT_TRANSACTION_SIZE" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="ALLOW_DATASET_CONFLICT" | |
| #! VALUE="YES" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="ATTRIBUTE_READING" | |
| #! VALUE="DEFLINE" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="DATASET_NAME" | |
| #! VALUE="GeoPackage file" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="FEATURE_TYPE_DEFAULT_NAME" | |
| #! VALUE="Table1" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="FEATURE_TYPE_NAME" | |
| #! VALUE="Table" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="READER_DATASET_HINT" | |
| #! VALUE="Select the GeoPackage file(s)" | |
| #! /> | |
| #! <METAFILE_PARAMETER | |
| #! NAME="WRITER_DATASET_HINT" | |
| #! VALUE="Specify a name for the GeoPackage file" | |
| #! /> | |
| #! </DATASET> | |
| #! </DATASETS> | |
| #! <DATA_TYPES> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_buffer" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_binarybuffer" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_xml" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_varchar(width)" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_varbinary(width)" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="boolean" | |
| #! FME_TYPE="fme_boolean" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_char(width)" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_binary(width)" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_datetime" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_time" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_date" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="float" | |
| #! FME_TYPE="fme_real64" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="float" | |
| #! FME_TYPE="fme_real32" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_int64" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_uint64" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_int32" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_uint32" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_int16" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_uint16" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_int8" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_uint8" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="string" | |
| #! FME_TYPE="fme_decimal(width,decimal)" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json" | |
| #! FME_TYPE="fme_json" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="text" | |
| #! FME_TYPE="fme_buffer" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="text" | |
| #! FME_TYPE="fme_xml" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="text" | |
| #! FME_TYPE="fme_json" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="text(width)" | |
| #! FME_TYPE="fme_varchar(width)" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="text(width)" | |
| #! FME_TYPE="fme_char(width)" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="blob" | |
| #! FME_TYPE="fme_binarybuffer" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="blob(width)" | |
| #! FME_TYPE="fme_varbinary(width)" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="blob(width)" | |
| #! FME_TYPE="fme_binary(width)" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="date" | |
| #! FME_TYPE="fme_date" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="datetime" | |
| #! FME_TYPE="fme_datetime" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="datetime" | |
| #! FME_TYPE="fme_time" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="float" | |
| #! FME_TYPE="fme_real32" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="double" | |
| #! FME_TYPE="fme_real64" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="double" | |
| #! FME_TYPE="fme_decimal(width,decimal)" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="boolean" | |
| #! FME_TYPE="fme_boolean" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="tinyint" | |
| #! FME_TYPE="fme_int8" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="smallint" | |
| #! FME_TYPE="fme_int16" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="smallint" | |
| #! FME_TYPE="fme_uint8" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="mediumint" | |
| #! FME_TYPE="fme_int32" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="mediumint" | |
| #! FME_TYPE="fme_uint16" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_int64" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="int" | |
| #! FME_TYPE="fme_uint32" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <DATA_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="text(20)" | |
| #! FME_TYPE="fme_uint64" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! </DATA_TYPES> | |
| #! <GEOM_TYPES> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_point" | |
| #! FME_TYPE="fme_point" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_line" | |
| #! FME_TYPE="fme_line" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_polygon" | |
| #! FME_TYPE="fme_area" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_text" | |
| #! FME_TYPE="fme_text" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_ellipse" | |
| #! FME_TYPE="fme_ellipse" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_arc" | |
| #! FME_TYPE="fme_arc" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_rectangle" | |
| #! FME_TYPE="fme_rectangle" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_rounded_rectangle" | |
| #! FME_TYPE="fme_rounded_rectangle" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_raster" | |
| #! FME_TYPE="fme_raster" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_no_geom" | |
| #! FME_TYPE="fme_no_geom" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_collection" | |
| #! FME_TYPE="fme_collection" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_line" | |
| #! FME_TYPE="fme_surface" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_line" | |
| #! FME_TYPE="fme_solid" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_polygon" | |
| #! FME_TYPE="fme_point_cloud" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="true" | |
| #! FORMAT_TYPE="json_no_geom" | |
| #! FME_TYPE="fme_feature_table" | |
| #! FORMAT="GEOJSON" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_point" | |
| #! FME_TYPE="fme_point" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_multipoint" | |
| #! FME_TYPE="fme_point" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_point" | |
| #! FME_TYPE="fme_text" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_linestring" | |
| #! FME_TYPE="fme_line" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_multilinestring" | |
| #! FME_TYPE="fme_line" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_circularstring" | |
| #! FME_TYPE="fme_arc" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_compoundcurve" | |
| #! FME_TYPE="fme_line" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_curve" | |
| #! FME_TYPE="fme_line" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_multicurve" | |
| #! FME_TYPE="fme_line" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_linestring" | |
| #! FME_TYPE="fme_solid" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_linestring" | |
| #! FME_TYPE="fme_surface" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_polygon" | |
| #! FME_TYPE="fme_area" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_multipolygon" | |
| #! FME_TYPE="fme_area" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_curvepolygon" | |
| #! FME_TYPE="fme_area" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_curvepolygon" | |
| #! FME_TYPE="fme_ellipse" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_curvepolygon" | |
| #! FME_TYPE="fme_rounded_rectangle" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_surface" | |
| #! FME_TYPE="fme_area" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_multisurface" | |
| #! FME_TYPE="fme_area" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_polygon" | |
| #! FME_TYPE="fme_rectangle" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_polygon" | |
| #! FME_TYPE="fme_raster" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_polygon" | |
| #! FME_TYPE="fme_point_cloud" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_geometrycollection" | |
| #! FME_TYPE="fme_collection" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_geometry" | |
| #! FME_TYPE="fme_no_geom" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_none" | |
| #! FME_TYPE="fme_no_geom" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! <GEOM_TYPE | |
| #! IS_SOURCE="false" | |
| #! FORMAT_TYPE="geopackage_geometry" | |
| #! FME_TYPE="fme_feature_table" | |
| #! FORMAT="OGCGEOPACKAGE" | |
| #! /> | |
| #! </GEOM_TYPES> | |
| #! <FEATURE_TYPES> | |
| #! <FEATURE_TYPE | |
| #! IS_SOURCE="true" | |
| #! NODE_NAME="query" | |
| #! FEATURE_TYPE_NAME="" | |
| #! FEATURE_TYPE_NAME_QUALIFIER="" | |
| #! IS_EDITABLE="false" | |
| #! IDENTIFIER="2" | |
| #! FEAT_GEOMTYPE="json_point json_no_geom" | |
| #! POSITION="-817.00837008370081 707.00942009420089" | |
| #! BOUNDING_RECT="-817.00837008370081 707.00942009420089 454 71" | |
| #! ORDER="500000000000000" | |
| #! COLLAPSED="true" | |
| #! KEYWORD="GEOJSON_1" | |
| #! PARMS_EDITED="true" | |
| #! ENABLED="true" | |
| #! HIDDEN_USER_ATTRS="" | |
| #! MERGE_FILTER="" | |
| #! MERGE_FILTER_TYPE="FILTER_TYPE_GLOB" | |
| #! MERGE_FILTER_CASE_SENSITIVE="true" | |
| #! DYNAMIC_SCHEMA="false" | |
| #! > | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="id" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="OBJECTID" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Province_State" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Country_Region" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Last_Update" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Lat" ATTR_TYPE="float" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Long_" ATTR_TYPE="float" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Confirmed" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Recovered" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Deaths" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Active" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Admin2" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="FIPS" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Combined_Key" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Incident_Rate" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="People_Tested" ATTR_TYPE="string" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! </FEATURE_TYPE> | |
| #! <FEATURE_TYPE | |
| #! IS_SOURCE="false" | |
| #! NODE_NAME="covid_counties" | |
| #! FEATURE_TYPE_NAME="" | |
| #! FEATURE_TYPE_NAME_QUALIFIER="" | |
| #! IS_EDITABLE="true" | |
| #! IDENTIFIER="3" | |
| #! FEAT_GEOMTYPE="geopackage_point" | |
| #! POSITION="1720 707.00942009420089" | |
| #! BOUNDING_RECT="1720 707.00942009420089 450.00106825772946 71" | |
| #! ORDER="500000000000001" | |
| #! COLLAPSED="true" | |
| #! KEYWORD="OGCGEOPACKAGE_1" | |
| #! PARMS_EDITED="true" | |
| #! ENABLED="true" | |
| #! SCHEMA_ATTRIBUTE_SOURCE="1" | |
| #! > | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="id" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="OBJECTID" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Province_State" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Country_Region" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Last_Update" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Lat" ATTR_TYPE="double" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Long_" ATTR_TYPE="double" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Confirmed" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Recovered" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Deaths" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Active" ATTR_TYPE="int" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Admin2" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="FIPS" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Combined_Key" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="Incident_Rate" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <FEAT_ATTRIBUTE ATTR_NAME="People_Tested" ATTR_TYPE="text" ATTR_HAS_PORT="true" ATTR_VALUE=""/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_configuration_common_group" PARM_VALUE=""/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_configuration_group" PARM_VALUE=""/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_feature_operation" PARM_VALUE="INSERT"/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_match_id_attribute" PARM_VALUE="<Unused>"/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_selection_group" PARM_VALUE=""/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_table_creation_group" PARM_VALUE="FME_DISCLOSURE_OPEN"/> | |
| #! <DEFLINE_PARM PARM_NAME="fme_table_handling" PARM_VALUE="DROP_CREATE"/> | |
| #! <DEFLINE_PARM PARM_NAME="geopackage_create_spatial_index" PARM_VALUE="Yes"/> | |
| #! <DEFLINE_PARM PARM_NAME="geopackage_geometry_column" PARM_VALUE="geom"/> | |
| #! <DEFLINE_PARM PARM_NAME="geopackage_m_capability" PARM_VALUE="NOT_ALLOWED"/> | |
| #! <DEFLINE_PARM PARM_NAME="geopackage_primary_index_column" PARM_VALUE="id"/> | |
| #! <DEFLINE_PARM PARM_NAME="geopackage_z_capability" PARM_VALUE="NOT_ALLOWED"/> | |
| #! </FEATURE_TYPE> | |
| #! </FEATURE_TYPES> | |
| #! <FMESERVER> | |
| #! <READER_DATASETS> | |
| #! <DATASET | |
| #! NAME="GEOJSON_1" | |
| #! OVERRIDE="-GEOJSON_1_DATASET" | |
| #! DATASET="GEOJSON_1/query?where=1%3D1&outFields=*&f=geojson&token=" | |
| #! /> | |
| #! </READER_DATASETS> | |
| #! <WRITER_DATASETS> | |
| #! <DATASET | |
| #! NAME="OGCGEOPACKAGE_1" | |
| #! OVERRIDE="-OGCGEOPACKAGE_1_DATASET" | |
| #! DATASET="OGCGEOPACKAGE_1/jhu_county.gpkg" | |
| #! /> | |
| #! </WRITER_DATASETS> | |
| #! </FMESERVER> | |
| #! <GLOBAL_PARAMETERS> | |
| #! <GLOBAL_PARAMETER | |
| #! GUI_LINE="GUI FILE_OR_URL SourceDataset_GEOJSON GeoJSON_Documents(*.json;*.geojson)|*.json;*.geojson|Compressed_Files(*.bz2;*.gz)|*.bz2;*.gz|Archive_Files(*.7z;*.7zip;*.rar;*.rvz;*.tar;*.tar.bz2;*.tar.gz;*.tgz;*.zip;*.zipx)|*.7z;*.7zip;*.rar;*.rvz;*.tar;*.tar.bz2;*.tar.gz;*.tgz;*.zip;*.zipx|All_Files|* Source GeoJSON File or URL:" | |
| #! DEFAULT_VALUE="https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/ncov_cases_US/FeatureServer/0/query?where=1%3D1&outFields=*&f=geojson&token=" | |
| #! IS_STAND_ALONE="false" | |
| #! /> | |
| #! <GLOBAL_PARAMETER | |
| #! GUI_LINE="GUI FILENAME DestDataset_OGCGEOPACKAGE GeoPackage_Files(*.gpkg)|*.gpkg|All_files(*)|* GeoPackage File:" | |
| #! DEFAULT_VALUE="$(FME_MF_DIR)jhu_county.gpkg" | |
| #! IS_STAND_ALONE="false" | |
| #! /> | |
| #! </GLOBAL_PARAMETERS> | |
| #! <COMMENTS> | |
| #! </COMMENTS> | |
| #! <CONSTANTS> | |
| #! </CONSTANTS> | |
| #! <BOOKMARKS> | |
| #! </BOOKMARKS> | |
| #! <TRANSFORMERS> | |
| #! </TRANSFORMERS> | |
| #! <FEAT_LINKS> | |
| #! <FEAT_LINK | |
| #! IDENTIFIER="4" | |
| #! SOURCE_NODE="2" | |
| #! TARGET_NODE="3" | |
| #! SOURCE_PORT_DESC="-1" | |
| #! TARGET_PORT_DESC="-1" | |
| #! ENABLED="true" | |
| #! EXECUTION_IDX="0" | |
| #! HIDDEN="false" | |
| #! COLOUR="0,0,0,1" | |
| #! PEN_WIDTH="4" | |
| #! PEN_STYLE="1" | |
| #! LINK_STYLE_NAME="<Default>" | |
| #! EXTRA_POINTS="" | |
| #! /> | |
| #! </FEAT_LINKS> | |
| #! <BREAKPOINTS> | |
| #! </BREAKPOINTS> | |
| #! <ATTR_LINKS> | |
| #! </ATTR_LINKS> | |
| #! <SUBDOCUMENTS> | |
| #! </SUBDOCUMENTS> | |
| #! <LOOKUP_TABLES> | |
| #! </LOOKUP_TABLES> | |
| #! </WORKSPACE> | |
| FME_PYTHON_VERSION 37 | |
| GUI IGNORE SourceDataset_GEOJSON_1,GEOJSON_IN_USE_SEARCH_ENVELOPE_GEOJSON_1,GEOJSON_IN_SEARCH_ENVELOPE_MINX_GEOJSON_1,GEOJSON_IN_SEARCH_ENVELOPE_MINY_GEOJSON_1,GEOJSON_IN_SEARCH_ENVELOPE_MAXX_GEOJSON_1,GEOJSON_IN_SEARCH_ENVELOPE_MAXY_GEOJSON_1,GEOJSON_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_GEOJSON_1,GEOJSON_IN_CLIP_TO_ENVELOPE_GEOJSON_1,GEOJSON_IN_NETWORK_AUTHENTICATION_GEOJSON_1,DestDataset_OGCGEOPACKAGE_1,OGCGEOPACKAGE_OUT_FME_CONNECTION_GROUP_OGCGEOPACKAGE_1,OGCGEOPACKAGE_OUT_OVERWRITE_DATASET_OGCGEOPACKAGE_1,OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1,OGCGEOPACKAGE_OUT_GEOPACKAGE_WRT_ADV_PARM_OGCGEOPACKAGE_1,OGCGEOPACKAGE_OUT_TRANSACTION_SIZE_OGCGEOPACKAGE_1 | |
| DEFAULT_MACRO SourceDataset_GEOJSON https://services1.arcgis.com/0MSEUqKaxRlEPj5g/ArcGIS/rest/services/ncov_cases_US/FeatureServer/0/query?where=1%3D1&outFields=*&f=geojson&token= | |
| GUI FILE_OR_URL SourceDataset_GEOJSON GeoJSON_Documents(*.json;*.geojson)|*.json;*.geojson|Compressed_Files(*.bz2;*.gz)|*.bz2;*.gz|Archive_Files(*.7z;*.7zip;*.rar;*.rvz;*.tar;*.tar.bz2;*.tar.gz;*.tgz;*.zip;*.zipx)|*.7z;*.7zip;*.rar;*.rvz;*.tar;*.tar.bz2;*.tar.gz;*.tgz;*.zip;*.zipx|All_Files|* Source GeoJSON File or URL: | |
| DEFAULT_MACRO DestDataset_OGCGEOPACKAGE $(FME_MF_DIR)jhu_county.gpkg | |
| GUI FILENAME DestDataset_OGCGEOPACKAGE GeoPackage_Files(*.gpkg)|*.gpkg|All_files(*)|* GeoPackage File: | |
| INCLUDE [ if {{$(SourceDataset_GEOJSON)} == {}} { puts_real {Parameter 'SourceDataset_GEOJSON' must be given a value.}; exit 1; }; ] | |
| INCLUDE [ if {{$(DestDataset_OGCGEOPACKAGE)} == {}} { puts_real {Parameter 'DestDataset_OGCGEOPACKAGE' must be given a value.}; exit 1; }; ] | |
| #! START_HEADER | |
| #! START_WB_HEADER | |
| READER_TYPE MULTI_READER | |
| MULTI_READER_TYPE{0} GEOJSON | |
| MULTI_READER_KEYWORD{0} GEOJSON_1 | |
| MULTI_READER_GEN_DIRECTIVES{0} USE_SEARCH_ENVELOPE,NO,SEARCH_ENVELOPE_MAXY,0,NETWORK_AUTHENTICATION,,FLATTEN_MODE,ALL_LEVELS,EXPOSE_ATTRS_GROUP,,SEARCH_ENVELOPE_MINX,0,SEARCH_ENVELOPE_COORDINATE_SYSTEM,,GEOJSON_EXPOSE_FORMAT_ATTRS,,CLIP_TO_ENVELOPE,NO,SEARCH_ENVELOPE_MAXX,0,SEARCH_ENVELOPE_MINY,0,_MERGE_SCHEMAS,YES,USE_BASENAME_AS_DEFAULT_FEATURE_TYPE,Yes | |
| WRITER_TYPE MULTI_WRITER | |
| MULTI_WRITER_DATASET_ORDER BY_ID | |
| MULTI_WRITER_FIRST_WRITER_ID 0 | |
| MULTI_WRITER_TYPE{0} OGCGEOPACKAGE | |
| MULTI_WRITER_KEYWORD{0} OGCGEOPACKAGE_1 | |
| #! END_WB_HEADER | |
| #! START_WB_HEADER | |
| MACRO WB_KEYWORD "GEOJSON_1" | |
| #! END_WB_HEADER | |
| #! START_SOURCE_HEADER GEOJSON GEOJSON_1 | |
| # The dataset this mapping file was generated from was: | |
| #! END_SOURCE_HEADER | |
| #! START_WB_HEADER | |
| DEFAULT_MACRO SourceDataset | |
| INCLUDE [ if {{$(SourceDataset)} != ""} { \ | |
| puts {DEFAULT_MACRO SourceDataset_GEOJSON_1 $(SourceDataset)} \ | |
| } ] | |
| #! END_WB_HEADER | |
| #! START_SOURCE_HEADER GEOJSON GEOJSON_1 | |
| DEFAULT_MACRO SourceDataset_GEOJSON_1 $(SourceDataset_GEOJSON) | |
| GUI FILE_OR_URL SourceDataset_GEOJSON_1 GeoJSON_Documents(*.json;*.geojson)|*.json;*.geojson|All_Files|* Source GeoJSON File or URL: | |
| DEFAULT_MACRO GEOJSON_IN_FLATTEN_MODE_GEOJSON_1 ALL_LEVELS | |
| GEOJSON_1_FLATTEN_MODE "$(GEOJSON_IN_FLATTEN_MODE_GEOJSON_1)" | |
| DEFAULT_MACRO GEOJSON_IN_EXPOSE_ATTRS_GROUP_GEOJSON_1 | |
| GEOJSON_1_EXPOSE_ATTRS_GROUP "$(GEOJSON_IN_EXPOSE_ATTRS_GROUP_GEOJSON_1)" | |
| DEFAULT_MACRO GEOJSON_IN_USE_BASENAME_AS_DEFAULT_FEATURE_TYPE_GEOJSON_1 Yes | |
| GEOJSON_1_USE_BASENAME_AS_DEFAULT_FEATURE_TYPE "$(GEOJSON_IN_USE_BASENAME_AS_DEFAULT_FEATURE_TYPE_GEOJSON_1)" | |
| # Include this file in source setting section to add external search envelope processing | |
| # Zero as a default means we don't do any search -- this makes workbench happier | |
| DEFAULT_MACRO GEOJSON_IN_USE_SEARCH_ENVELOPE_GEOJSON_1 NO | |
| GEOJSON_1_USE_SEARCH_ENVELOPE "$(GEOJSON_IN_USE_SEARCH_ENVELOPE_GEOJSON_1)" | |
| GUI ACTIVEDISCLOSUREGROUP GEOJSON_IN_USE_SEARCH_ENVELOPE_GEOJSON_1 GEOJSON_IN_SEARCH_ENVELOPE_MINX_GEOJSON_1%GEOJSON_IN_SEARCH_ENVELOPE_MINY_GEOJSON_1%GEOJSON_IN_SEARCH_ENVELOPE_MAXX_GEOJSON_1%GEOJSON_IN_SEARCH_ENVELOPE_MAXY_GEOJSON_1%GEOJSON_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_GEOJSON_1%GEOJSON_IN_CLIP_TO_ENVELOPE_GEOJSON_1%GEOJSON_IN_SEARCH_METHOD%GEOJSON_IN_SEARCH_METHOD_FILTER%GEOJSON_IN_SEARCH_ORDER%GEOJSON_IN_SEARCH_FEATURE%GEOJSON_IN_DUMMY_SEARCH_ENVELOPE_PARAMETER Use Search Envelope | |
| # =========================================================================== | |
| GUI LOOKUP GEOJSON_IN_SEARCH_ENVELOPE_MINX_GEOJSON_1 <Unused>,0 | |
| DEFAULT_MACRO GEOJSON_IN_SEARCH_ENVELOPE_MINX_GEOJSON_1 0 | |
| GEOJSON_1_SEARCH_ENVELOPE "$(GEOJSON_IN_SEARCH_ENVELOPE_MINX_GEOJSON_1)" | |
| GUI OPTIONAL FLOAT GEOJSON_IN_SEARCH_ENVELOPE_MINX_GEOJSON_1 Minimum X: | |
| # =========================================================================== | |
| GUI LOOKUP GEOJSON_IN_SEARCH_ENVELOPE_MINY_GEOJSON_1 <Unused>,0 | |
| DEFAULT_MACRO GEOJSON_IN_SEARCH_ENVELOPE_MINY_GEOJSON_1 0 | |
| GEOJSON_1_SEARCH_ENVELOPE "$(GEOJSON_IN_SEARCH_ENVELOPE_MINY_GEOJSON_1)" | |
| GUI OPTIONAL FLOAT GEOJSON_IN_SEARCH_ENVELOPE_MINY_GEOJSON_1 Minimum Y: | |
| # =========================================================================== | |
| GUI LOOKUP GEOJSON_IN_SEARCH_ENVELOPE_MAXX_GEOJSON_1 <Unused>,0 | |
| DEFAULT_MACRO GEOJSON_IN_SEARCH_ENVELOPE_MAXX_GEOJSON_1 0 | |
| GEOJSON_1_SEARCH_ENVELOPE "$(GEOJSON_IN_SEARCH_ENVELOPE_MAXX_GEOJSON_1)" | |
| GUI OPTIONAL FLOAT GEOJSON_IN_SEARCH_ENVELOPE_MAXX_GEOJSON_1 Maximum X: | |
| # =========================================================================== | |
| GUI LOOKUP GEOJSON_IN_SEARCH_ENVELOPE_MAXY_GEOJSON_1 <Unused>,0 | |
| DEFAULT_MACRO GEOJSON_IN_SEARCH_ENVELOPE_MAXY_GEOJSON_1 0 | |
| GEOJSON_1_SEARCH_ENVELOPE "$(GEOJSON_IN_SEARCH_ENVELOPE_MAXY_GEOJSON_1)" | |
| GUI OPTIONAL FLOAT GEOJSON_IN_SEARCH_ENVELOPE_MAXY_GEOJSON_1 Maximum Y: | |
| # =========================================================================== | |
| GUI LOOKUP GEOJSON_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_GEOJSON_1 <Unused>, | |
| DEFAULT_MACRO GEOJSON_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_GEOJSON_1 | |
| GEOJSON_1_SEARCH_ENVELOPE "$(GEOJSON_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_GEOJSON_1)" | |
| GUI OPTIONAL COORDSYS GEOJSON_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_GEOJSON_1 Search Envelope Coordinate System: | |
| # =========================================================================== | |
| # BUG18999: We now have a soft clip to fall back on like native spatial index | |
| # thus we are reintroducing the clip to envelop as an option for users. | |
| # Defualt to soft clip as per the existing database readers we are emulating | |
| GUI LOOKUP GEOJSON_IN_CLIP_TO_ENVELOPE_GEOJSON_1 <Unused>,NO | |
| DEFAULT_MACRO GEOJSON_IN_CLIP_TO_ENVELOPE_GEOJSON_1 NO | |
| GEOJSON_1_CLIP_TO_ENVELOPE "$(GEOJSON_IN_CLIP_TO_ENVELOPE_GEOJSON_1)" | |
| GUI OPTIONAL CHECKBOX GEOJSON_IN_CLIP_TO_ENVELOPE_GEOJSON_1 YES%NO Clip to Search Envelope | |
| # =========================================================================== | |
| DEFAULT_MACRO GEOJSON_IN_NETWORK_AUTHENTICATION_GEOJSON_1 | |
| GEOJSON_1_NETWORK_AUTHENTICATION "$(GEOJSON_IN_NETWORK_AUTHENTICATION_GEOJSON_1)" | |
| GUI OPTIONAL AUTHENTICATOR GEOJSON_IN_NETWORK_AUTHENTICATION_GEOJSON_1 CONTAINER%GROUP%CONTAINER_TITLE%"Network Authentication"%PROMPT_TYPE%NETWORK Network Authentication | |
| # ============================================================================ | |
| DEFAULT_MACRO GEOJSON_IN_ATTRIBUTE_READING_GEOJSON_1 ALL | |
| GEOJSON_1_ATTRIBUTE_READING "$(GEOJSON_IN_ATTRIBUTE_READING_GEOJSON_1)" | |
| # ============================================================================ | |
| GEOJSON_1_GENERATE_FME_BUILD_NUM 20202 | |
| GEOJSON_1_DATASET "$(SourceDataset_GEOJSON_1)" | |
| #! END_SOURCE_HEADER | |
| #! START_WB_HEADER | |
| MACRO WB_KEYWORD "OGCGEOPACKAGE_1" | |
| #! END_WB_HEADER | |
| #! START_DEST_HEADER OGCGEOPACKAGE OGCGEOPACKAGE_1 | |
| # ============================================================================ | |
| # The following GUI line prompts for a file to be used as the | |
| # destination of the GEOPACKAGE File. The user input is stored | |
| # in a macro, which is then used to define the dataset to be written. | |
| GUI MULTIFILE DestDataset_OGCGEOPACKAGE_1 GeoPackage_Files(*.gpkg)|*.gpkg|All_files(*)|* GeoPackage File: | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_FME_CONNECTION_GROUP_OGCGEOPACKAGE_1 | |
| GUI OPTIONAL DISCLOSUREGROUP OGCGEOPACKAGE_OUT_FME_CONNECTION_GROUP_OGCGEOPACKAGE_1 OGCGEOPACKAGE_OUT_NAMED_CONNECTION%OGCGEOPACKAGE_OUT_OVERWRITE_DATASET_OGCGEOPACKAGE_1%OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1 Database Connection | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_OVERWRITE_DATASET_OGCGEOPACKAGE_1 NO | |
| OGCGEOPACKAGE_1_OVERWRITE_DATASET "$(OGCGEOPACKAGE_OUT_OVERWRITE_DATASET_OGCGEOPACKAGE_1)" | |
| GUI OPTIONAL ACTIVECHECK OGCGEOPACKAGE_OUT_OVERWRITE_DATASET_OGCGEOPACKAGE_1 YES%NO,OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1 Overwrite Existing Database: | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1 | |
| OGCGEOPACKAGE_1_DATASET_TEMPLATE "$(OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1)" | |
| GUI OPTIONAL FILENAME_MUSTEXIST OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1 GeoPackage_Files(*.gpkg)|*.gpkg|All_files(*)|* Template File: | |
| GUI LOOKUP OGCGEOPACKAGE_OUT_DATASET_TEMPLATE_OGCGEOPACKAGE_1 <Unused>, | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_GEOPACKAGE_WRT_ADV_PARM_OGCGEOPACKAGE_1 | |
| GUI OPTIONAL DISCLOSUREGROUP OGCGEOPACKAGE_OUT_GEOPACKAGE_WRT_ADV_PARM_OGCGEOPACKAGE_1 OGCGEOPACKAGE_OUT_TRANSACTION_SIZE_OGCGEOPACKAGE_1 Advanced | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_TRANSACTION_SIZE_OGCGEOPACKAGE_1 5000 | |
| OGCGEOPACKAGE_1_TRANSACTION_SIZE "$(OGCGEOPACKAGE_OUT_TRANSACTION_SIZE_OGCGEOPACKAGE_1)" | |
| GUI INTEGER OGCGEOPACKAGE_OUT_TRANSACTION_SIZE_OGCGEOPACKAGE_1 Features Per Transaction: | |
| # ============================================================================ | |
| # Opt in for destination dataset type vs format type validation | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_DESTINATION_DATASETTYPE_VALIDATION_OGCGEOPACKAGE_1 Yes | |
| OGCGEOPACKAGE_1_DESTINATION_DATASETTYPE_VALIDATION "$(OGCGEOPACKAGE_OUT_DESTINATION_DATASETTYPE_VALIDATION_OGCGEOPACKAGE_1)" | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_COORDINATE_SYSTEM_GRANULARITY_OGCGEOPACKAGE_1 FEATURE_TYPE | |
| OGCGEOPACKAGE_1_COORDINATE_SYSTEM_GRANULARITY "$(OGCGEOPACKAGE_OUT_COORDINATE_SYSTEM_GRANULARITY_OGCGEOPACKAGE_1)" | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_ENCODE_FEATURE_TYPE_AND_ATTR_NAMES_OGCGEOPACKAGE_1 YES | |
| OGCGEOPACKAGE_1_ENCODE_FEATURE_TYPE_AND_ATTR_NAMES "$(OGCGEOPACKAGE_OUT_ENCODE_FEATURE_TYPE_AND_ATTR_NAMES_OGCGEOPACKAGE_1)" | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_ENFORCE_GEOMETRY_COLUMN_CONSTRAINTS_OGCGEOPACKAGE_1 YES | |
| OGCGEOPACKAGE_1_ENFORCE_GEOMETRY_COLUMN_CONSTRAINTS "$(OGCGEOPACKAGE_OUT_ENFORCE_GEOMETRY_COLUMN_CONSTRAINTS_OGCGEOPACKAGE_1)" | |
| DEFAULT_MACRO OGCGEOPACKAGE_OUT_WRITE_NULLS_OGCGEOPACKAGE_1 YES | |
| OGCGEOPACKAGE_1_WRITE_NULLS "$(OGCGEOPACKAGE_OUT_WRITE_NULLS_OGCGEOPACKAGE_1)" | |
| # ============================================================================ | |
| OGCGEOPACKAGE_1_GENERATE_FME_BUILD_NUM 20202 | |
| #! END_DEST_HEADER | |
| #! START_WB_HEADER | |
| DEFAULT_MACRO DestDataset | |
| INCLUDE [ if {"$(DestDataset)" != ""} { \ | |
| puts {DEFAULT_MACRO DestDataset_OGCGEOPACKAGE_1 $(DestDataset)} \ | |
| } ] | |
| #! END_WB_HEADER | |
| #! START_DEST_HEADER OGCGEOPACKAGE OGCGEOPACKAGE_1 | |
| DEFAULT_MACRO DestDataset_OGCGEOPACKAGE_1 $(DestDataset_OGCGEOPACKAGE) | |
| OGCGEOPACKAGE_1_DATASET "$(DestDataset_OGCGEOPACKAGE_1)" | |
| #! END_DEST_HEADER | |
| #! START_WB_HEADER | |
| #! END_WB_HEADER | |
| #! END_HEADER | |
| LOG_FILENAME "$(FME_MF_DIR)jhu_counties2gpkg.log" | |
| LOG_APPEND NO | |
| LOG_FILTER_MASK -1 | |
| LOG_MAX_FEATURES 200 | |
| LOG_MAX_RECORDED_FEATURES 200 | |
| FME_REPROJECTION_ENGINE FME | |
| FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto | |
| FME_GEOMETRY_HANDLING Enhanced | |
| FME_STROKE_MAX_DEVIATION 0 | |
| DEFAULT_MACRO DATASET_KEYWORD_GEOJSON_1 GEOJSON_1 | |
| DEFAULT_MACRO DATASET_KEYWORD_OGCGEOPACKAGE_1 OGCGEOPACKAGE_1 | |
| # ------------------------------------------------------------------------- | |
| GEOJSON_1_READER_META_ATTRIBUTES fme_feature_type | |
| # ------------------------------------------------------------------------- | |
| GEOJSON_1_COORDINATE_SYSTEM EPSG:4326 | |
| MULTI_READER_CONTINUE_ON_READER_FAILURE No | |
| # ------------------------------------------------------------------------- | |
| MACRO WORKSPACE_NAME jhu_counties2gpkg | |
| MACRO FME_VIEWER_APP fmedatainspector | |
| # ------------------------------------------------------------------------- | |
| GEOJSON_1_DEF query id int OBJECTID int Province_State string Country_Region string Last_Update int Lat float Long_ float Confirmed int Recovered int Deaths int Active int Admin2 string FIPS string Combined_Key string Incident_Rate string People_Tested string | |
| # ------------------------------------------------------------------------- | |
| FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD $(DATASET_KEYWORD_GEOJSON_1) INPUT FEATURE_TYPE * ROUTE GEOJSON GEOJSON_1::query multi_reader_keyword,$(DATASET_KEYWORD_GEOJSON_1) TO FME_GENERIC ::query ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * | |
| GEOJSON_1_MERGE_DEF GEOJSON_1::query EXACT query | |
| # ------------------------------------------------------------------------- | |
| FACTORY_DEF * TeeFactory FACTORY_NAME "query(GEOJSON_1) Splitter" INPUT FEATURE_TYPE query OUTPUT FEATURE_TYPE query_GEOJSON_1 | |
| DEFAULT_MACRO WB_CURRENT_CONTEXT | |
| # ------------------------------------------------------------------------- | |
| FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC query_GEOJSON_1 TO OGCGEOPACKAGE __GO_TO_FINAL_OUTPUT_ROUTER__ multi_writer_id,0,<at>SupplyAttributes<openparen>ENCODED<comma>__wb_out_feat_type__<comma>covid_counties<closeparen> GEOMETRY FEATURE_TYPE_ATTRIBUTE __wb_out_feat_type__ OUTPUT ROUTED FEATURE_TYPE * OUTPUT NOT_ROUTED FEATURE_TYPE __nuke_me__ @Tcl2("FME_StatMessage 818059 [FME_GetAttribute fme_template_feature_type] 818060 818061 fme_warn") | |
| # ------------------------------------------------------------------------- | |
| FACTORY_DEF * TeeFactory FACTORY_NAME "Final Output Nuker" INPUT FEATURE_TYPE __nuke_me__ | |
| # ------------------------------------------------------------------------- | |
| OGCGEOPACKAGE_1_DEF covid_counties geopackage_type geopackage_point fme_feature_operation INSERT fme_table_handling DROP_CREATE fme_selection_method MATCH_ID geopackage_geometry_column geom geopackage_primary_index_column id geopackage_create_spatial_index Yes geopackage_z_capability NOT_ALLOWED geopackage_m_capability NOT_ALLOWED id int OBJECTID int Province_State text Country_Region text Last_Update int Lat double Long_ double Confirmed int Recovered int Deaths int Active int Admin2 text FIPS text Combined_Key text Incident_Rate text People_Tested text |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment