07-23-2018 04:03 AM
Dear Team,
As i have tried storing raster data in sql server through filestream method, but while accessing the data from erdas apollo data manager im getting error as.
" Failed to crawl feature images. No geometry field found. "
(and more: Any other method to store data in sql server)
All suggestions are highly appricieted
Thanks
Solved! Go to Solution.
07-23-2018 06:55 PM
I dont think you can serve raster data stored in a database with Apollo.
Is there a reason you need to store Raster data in a database then serve it via Apollo?
You will get the best performance if you serve the raster data stored in an image format (ECW, JP2, etc) from the file system.
07-23-2018 09:45 PM
Dear phudson,
storing data in sql server is the requirement of costumer, can you please suggest how can i store data in sql server which can be serve using erdas apollo data manager
07-23-2018 11:50 PM
Hi sivaram,
APOLLO doesn't support raster databases.
You can suggest the idea in Ideation or submit a development ticket (HGDN credits) if you want this feature to be implemented.
Florent
07-24-2018 12:03 AM - edited 07-24-2018 12:05 AM
Apollo can't serve raster datasets from SQL Server (only Vector) but I believe WebMap can (Someone correct me if I am wrong).
Apollo will serve the data much faster than anything else but unfortunately it needs the imagery files.
Using HGND Credits you may be able to get a custom decoder developed to serve your imagery stored in the Database or possibly a custom crawler that could catalogue your original data for serving and add to the metadata a link to the raster stored in the database to fulfil your customer requirement. The custom crawler could probably also add the raster to the database as the image is crawled.
But you will need to make sure the customer is aware of the fact that storing the Raster data in the database will:
That is just a short list, there will be other benefits.
There is also additional performance to be gained by using compressed formats like ECW or JP2
08-02-2018 09:20 PM
Dear Phudson,
Thanks for your reply, As you said ,Using HGND Credits you may be able to get a custom decoder developed to serve your imagery stored in the Database or possibly a custom crawler that could catalogue your original data for serving and add to the metadata a link to the raster stored in the database to fulfil your customer requirement. The custom crawler could probably also add the raster to the database as the image is crawled.
As iam newbie to this, Can you please guide me how to get custom decoder developed.
Thanks
imtiyaz
08-02-2018 09:43 PM
Imtiyaz,
You will need to contact you local Hexagon representative
If you are unsure who you need to speak to you can leave a message here http://go.hexagongeospatial.com/contact-us-today and someone will contact you.
You will need to explain what you need Apollo to do and they will calculate how many HGDN Credits it will take.
Regards,
Phil
08-02-2018 09:47 PM
Phudson,
Sure i will follow the link, thanks for all your supports,
Thanks