Research Task - See if ArcPro can write geoparquets to file geodatabase's feature classes

[tiffanychu90]

Research Task

Use this template to create issues that represent small chunks of work (.5 - 2 days) that stand alone, or represent incremental work as part of an Epic Issue Template.

• Relevant PR (if applicable):

• Question or Goal: Open data metadata constantly getting overwritten each month, even if it now takes 30 min, is a bit redundant. Having to re-generate metadata associated with a feature class seems to occur when we delete a feature class and create it from a zipped shapefile over and over.

• Research Required:

• Test out whether the ArcGIS geoanalytics package that's available can help us convert a geoparquet directly to feature class?

• https://developers.arcgis.com/geoanalytics/install/

• https://community.esri.com/t5/arcgis-api-for-python-questions/unable-to-read-parquet-file-with-arcgis-per-docs/td-p/1287888

• It requires Spark...can we use it still?

[tiffanychu90]

References

• need geopandas, trouble installing: https://community.esri.com/t5/arcgis-pro-ideas/installing-geopandas-on-jupyter-notebook/idi-p/937095
• https://pro.arcgis.com/en/pro-app/latest/arcpy/get-started/what-is-conda.htm
• https://developers.arcgis.com/python/guide/part3-introduction-to-pandas/
• import arcgis.features.GeoAccessor and pandas: https://developers.arcgis.com/python/api-reference/arcgis.features.toc.html#geoaccessor
• this syntax doesn't work: https://developers.arcgis.com/python/api-reference/arcgis.features.toc.html?#arcgis.features.GeoAccessor.from_parquet
• https://community.esri.com/t5/data-management-questions/how-do-i-completely-overwrite-a-table-with-the/td-p/625226

[tiffanychu90]

Closing - geoanalytics package requires additional Arc licenses, also some connection to a Spark database. Also, pandas.spatial extension doesn't work...even though the syntax looks remarkably similar to geopandas, Arc insists on tacking on modules to pandas