Latest Contributions by MatthewSanders1

I made up those coordinates to look similar to the ones I am working with. So I changed the spatial reference to 4326 as suggested. Now I'm getting the same 'Spatial index grid is too small' error I was getting before. Any thoughts? Edit: its worth noting that I am only getting the error on certain rows. Most of them work just fine and have for every test I've run in the last few months. ... View more

Turns out you're right! I have some crazy looking lines now. So if I have decimal degrees (40.64577832, -68.655557412) I should use 4326 as my spatial reference? ... View more

Thanks for the correction. I was doing arcpy.Point(longitude, latitude) correctly, I just misspoke. I just tried using web-Mercator as the spatial reference and the error went away. I am now doing arcpy.Polyline(point_array, arcpy.SpatialReference(3857)) Does that seem like the correct solution? ... View more

Thanks for the reply! That seems like a good place to start looking. I am still new to arcpy/GIS in general and don't know much about working with spatial references. I'm reading coordinates from one GIS(ish) system that uses Web Mercator (EPSG:3857), using those coordinate pairs to create points (arcpy.Point(latitude, longitude)), creating an array of those Points, then using that array to create a Polyline (arcpy.Polyline), and then using arcpy.da.InsertCursor to insert the polyline into the ArcGIS database. I read somewhere that in order to do high precision geometry, the polyline needs a spatial reference, so I've been using a blank one:     poly = arcpy.Polyline(point_array, arcpy.SpatialReference()) which has worked every time so far. The ArcGIS feature class uses GCS_WGS_1984. Should I be specifying anywhere that I am using coordinates from 3857? How should I go about doing this? Thanks for your help! ... View more

Joshua, thanks for all the help you provided. In the end I realized I just need to use ArcPy. Unfortunately, some of my existing code doesn't work in the Python interpreter supplied by ArcGIS Desktop, and therefor needs rewriting.  Thanks again for not only helping me with the problem, but helping me learn as I dove straight into ArcGIS. ... View more

Thanks for all the help. I've since realized I need to bite the bullet and just use ArcPy. It did exactly what I needed it to do, and with much ease (after a steep learning curve!). The downside is that I have modules that do not work with the Python environment used by ArcPy, so I am rewriting some of my existing code. Thanks again! ... View more

Jay Strahan wrote:   Simply getting lat/lon pairs into SDEBINARY is the easy part, How would I go about doing this? You are correct though: I have a non-Esri table that uses lat/long pairs to store geodata (points, and lines). My main goal is to take that table and add its entries into a customer's database which is used with ArcGIS. The customer's database has 3 tables (base(?), f, and s). I'm taking my data and inserting it accordingly, but the customer's F table uses SDEBinary instead of lat/longs. I'm struggling with finding an easy way to convert my lat/longs into SDEBinary. Eventually I'll want to be able to transform them back from SDEBinary, but that can wait. How do you suggest I convert lat/long to SDEBinary? ... View more

I do. I have access to their entire production database, so I have all three tables. ... View more

Yes, sorry, the original column names were a mistype. The tables are set up like the link you provided, and the column names are eminx/emaxx/etc Thanks for sharing my post. Hopefully that will bring in some good help! ... View more

I've done some digging myself. It appears that the data in my database is Esri Binary spatial type (SDEBinary) and is Esri's own way to encode geo data. However, I believe support for SDEBinary is being phased out. The link I provided explains the logical and physical representation of geometry. I'm going to keep looking for a premade tool to convert lat/long coordinates to SDEBinary, and the worst case scenario is that I have to make my own.  Thanks again for the help! ... View more

Good morning Joshua, and thanks for the reply! Sorry it took so long for me to respond, I've been out of the office this week. I do have eminx and such. I seem to have two or three tables for each feature layer. One table has data about a point, one has the eminx/emaxx/eminy/emaxy. numofpoints, and points(the varbinary in question) columns, and the third table ALMOST seems like an exact copy of the first table I mentioned which leads me to believe it's used for something else. My problem is that I don't know how to interpret or create the data in the points column. Here is an example of the points binary: 0x0C00000001000000838C9A99EF12A091D8A3EC19 (where numofpoints = 1) 0x3D03000001000000A7D0DEEBEC128FDAA2BFCA19DA0EA7E3019E9E01C0A302A2E90FEFAB098BF90EFCDD089BC20EFB8E09BCFE0ECBD808A5BA0BE3F406EA0892118B14D211 (where numofpoints = 4) Does that sound familiar to you? ... View more

Thank you! This is what I needed. It turned out that the database server was somehow unregistered as a data store, which is why I couldn't find anything that pointed that direction. Whoops!  Your answer was still very helpful, though. Thanks again! ... View more