Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Goals

Our ultimate goal is to use AWS RDS for both input and output of mosaic data set creation. Ideally, input will be a staging RDS and output will be a production RDS.

...

Code Block
languagexml
	<AddRaster>
          <dataset_id>power</dataset_id>
          <raster_type>Table / Raster Catalog</raster_type>
          <Sources>
            <data_path>Z:\home\arcgis\data\CERES.csv</data_path>
          </Sources>
          <filter>*</filter>
     </AddRaster>

Step-by-step guide for AWS RDS Output

  1. Create .sde connection [2].
  2. Use the .sde file to specify mosaic destination (e.g., test_mosaic) using CLI. It will ignore Geodatabase in MDCS.xml file.

    Code Block
    languagepowershell
     PowerShell>%py% MDCS.py -i:MDCS_Solar.xml  -m:Z:\home\arcgis\etc\aws_rds_geodb_conn.sde\test_mosaic
    

Step-by-step guide for AWS RDS Input

  1. Create .sde connection file  [2].
  2. Create a table called test_csv in AWS RDS from CERES.csv file using ArcGIS Pro Geoprocessing Tool in Catalog window.
  3. Use the .sde file to specify table destination.

    Code Block
    languagexml
          <AddRasters>
            <AddRaster>
              <dataset_id>power</dataset_id>
              <raster_type>Table / Raster Catalog</raster_type>
              <Sources>
                <data_path>Z:\home\arcgis\etc\aws_rds_geodb_conn.sde\test_csv</data_path>
              </Sources>
              <filter>*</filter>
            </AddRaster>
          </AddRasters>
    
    
  4. Run the MDCS script as usual.
Info

Raster proxies can refer to AWS RDS [1].


From Abhijit,

In MDCS to add raster to mosaic in SDE ( remote database) you can pass the path as below

C:\Image_Mgmt_Workflows\NASA\Parameter\sde_conn.sde\testmosaic

Where “C:\Image_Mgmt_Workflows\NASA\Parameter\sde_conn.sde” is the connection file for sde

References

  1. https://github.com/Esri/mdcs-py/blob/master/Documentation/MDTools_ReadMe.pdf
  2. https://pro.arcgis.com/en/pro-app/tool-reference/data-management/create-database-connection.htm

Content by Label
showLabelsfalse
max5
spacesSDT
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-how-to-article" and type = "page" and space = "SDT"
labelskb-how-to-article

...