Select to view content in your preferred language

Display points from table in another layer

12-03-2017 12:51 PM
New Contributor

I download .bil files from PRISM Climate Group, Oregon State U  . I need to store information, that contains in .bil files, in Azure SQL database. Because I don't know how store .bil files in SQL database I do the following: 1. Use toolbox conversion tool -> raster to float. I get file .flt. 2. Use DIVA GIS to convert .flt to .grd and next .grd to .shp. 3. Use ogr2ogr to import .shp to th Azure SQL database. Now when I want to see what table stores, I connect database to ArcGIS Pro. And I see that not all points contains in table (almost 22000 points but should be almost 400000) and it displays in another layer then topographic map (Screenshot 1) . How I can display this data (PRISM Climate Group, Oregon State U ) like a table in Azure SQL database on topographic map?
P.S. I need to store this data in database that have only 8 Mbytes of memory.

Screenshot 1

Screenshot 2

0 Kudos
1 Reply
Esri Esteemed Contributor

Instead of converting the .grd to a .shp, are you able to convert it to a File Geodatabase feature class?  There is a 2 GB limit for shapefiles.  You may be hitting that limitation.