Latest Contributions by EarlMedina

Hi, Seems like your problem is related to create_engine. pyodbc is used as the default DBAPI. You may also use pymssql. You can learn more about this here: https://docs.sqlalchemy.org/en/20/core/engines.html I would explain to your team that's just how things work. You need some kind of DBAPI and here you have two options. ... View more

That doesn't sound expected. Does the same thing happen if you try to add record manually via the UI/Pro? Maybe you're missing editing privileges? I doubt the process is taking so long it's exceeding the token expiration. ... View more

Hi @TommyTaylorDev ,   Since you said the data is being used in an app with filters, I'm assuming the schema doesn't change all the often if at all? If that's the case, you could do what a lot of people do and just truncate/append new records. This is a good option if the new data coming in is just an updated version of what's already published. It also causes less disruption to your end users than an overwrite, I'd say. There are a few different examples of how to do this if you just search "truncate append". Here's a script you can start with: Overwrite ArcGIS Online Feature Service using Trun... - Esri Community     ... View more

Hi @CarlSunderman , I read the from_parquet documentation and I believe it may need to be updated. It states: if no geometry columns are read, this will raise a ValueError - you should use the pandas read_parquet method instead. My reading of this is you should use the standard pandas.read_parquet method, completely separate from GeoAccessor. This makes sense because if you have no geometry column(s) in your data, then you are working with non-spatial data. Of course, later on the User is told to do this: df = pd.DataFrame.spatial.read_parquet("data.parquet") This seems to contradict the previous statement. If you have spatial data, then you should be using pd.DataFrame.spatial.from_parquet.   So, to read non-spatial parquet data use: pd.read_parquet(your_parquet_file_path)   Hope this helps clear up some confusion. I think submitting feedback on the documentation is in order. ... View more

I've run into the Lambda deployment size limitation in the past, so I understand your predicament. What functionality do you need from the Python API? On at least one occasion, it was easier to just write a custom class for my Lambdas that handled the essentials. I was doing simple stuff like querying a service to generate a report. ... View more

Hey, Not sure if this will help you, but here's a simple example that works for me to update an existing point: from arcgis import GIS from arcgis.geometry import Point from arcgis.features import FeatureLayer gis = GIS("https://www.arcgis.com", "username", "password") fl_url = url = "https://server.com/arcgis/rest/services/ex/FeatureServer/0" fl = FeatureLayer(url, gis) sdf = fl.query(as_df=True) example_df = sdf.loc[sdf.OBJECTID==1].copy()[["OBJECTID", "SHAPE"]] example_df.at[0, "SHAPE"] = Point({"x" : -118.15, "y" : 33.80, "spatialReference" : {"wkid" : 4326}}) update_fs = example_df.spatial.to_featureset() fl.edit_features(updates=update_fs) ... View more

Hi, Using the sample you provided, I was able to parse the JSON correctly into an SEDF like so: import pandas as pd from arcgis.features import GeoAccessor, GeoSeriesAccessor parsed_json = [ { **feature["properties"], "geom": { "rings" : feature["geometry"]["coordinates"], "spatialReference" : {"wkid" : 4326} } } for feature in json["features"]] df = pd.DataFrame.from_dict(parsed_json) sedf = pd.DataFrame.spatial.from_df(df, geometry_column="geom")   Hope this helps!   ... View more

@SupriyaK @WilliamKyngesburye    Here's what I would do next: go to he Contents page where you're assigning Categories to your items, open your browser's developer tools and switch to the Network tab, clear any existing traffic, make a nominal change to one of your items (add/remove a category), and see what the traffic reports back after you click Save. You'll be looking for an updateItems request - check what the request body for that is. It should look like this: items: [{"abcdefghijklmnop123456789":{"categories":["/Categories/test"]}}] There's probably some encoding to account for if your category has special characters in it. ... View more

Hey, you were pretty close! Categories takes a string or list, so form your example it would be either item_search = gis.content.search(query="", categories=["/Categories/category_1", "/Categories/category_2"]) OR item_search = gis.content.search(query="", categories="/Categories/test")   So, the key is just to make sure you're writing "/Categories/{your_category_name}" Hope this helps! ... View more

I've used the Python API in a Lambda before and ran into the bloat issue with dependencies that you hint at. In my case, I was able to get it under the size limit but not without some work. My recommendation would be to take a moment to consider what functionality you actually need from the api and any other 3rd party libraries. If all you're using the api for is 2-3 things it might make sense just to code those parts yourself and keep things lean. As far as setup goes, I'd recommend trying out a Serverless - it makes things much easier and leaves you with a template you can use for future Lambdas. ... View more

I've gotten this to work like so: Edit the VS Code settings.json file located here on Windows: C:\Users\[YOUR_USER]\AppData\Roaming\Code\User\settings.json From there, update the line with "python.pythonPath" to  "python.pythonPath": "C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\Scripts\\propy.bat"​     If for some reason that does not work, I have gotten it to work by pointing to the desired cloned environment directly like this: "python.pythonPath": "C:\\Users\\[YOUR_USER]\\AppData\\Local\ESRI\\conda\\envs\\[NAME_OF_ENV]\\python.exe"​   Hope this helps! ... View more

I have done this, but on the Feature Service side (for which I made use of the ArcGIS API for Python). In my case, I was re-attaching files on a Hosted Feature service so that was the most feasible option.   You've probably already seen this, but to do it locally you would use this function: Add Attachments (Data Management)—ArcGIS Pro | Documentation So, you'd need a match table seems like - I'm guessing you could programmatically create a csv with summary information on the directory containing the images, create a TableView from that, and that would basically get you most of the way there. ... View more