Instructions for requesting a SDE database on Rubble (development machine)

send an e-mail to terralyn vandetta and sean sanromani with the following information:

1. Have you have attended training on SDE? y or n date____________________ location_____________________
2. Will you be using ARCIMS with this SDE data? y or n
3. What name you would like your database to be called (should be short, but something you can recognize and needs to be unique). It should be something you are ok with others seeing. examples clams, hjandrews name____________________________
4. What size (in computer bits) is your current data set that you will be converting?___________________________
5. What is the size of your raster data?__________________________
6. Are there any other users who will be connecting to your data that requires access? y or n If so, list name, level of access needed name__________________ access level________________
7. Who is the PI or responsible person for this project?_________________________________________________________

Terralyn or Sean will send you the following information when your database has been created:

1. name of the database
2. how to connect (database login/password for loading data and arcims login/password for connecting to arcims)

Spatial Database Connection Properties...

• Server:
• Service:
• Database:
• SDE Admin Account for this SDE DB:
• SDE Admin Password for this SDE DB:
• The IMS Account and Password, if used:

We are suggesting that you load enough data into rubble to be able to publish a website, with a subset of your data. When you are ready to committ to going live (you are ready to pay fees), you can request that your SDE database be moved to rocky, where you can load the rest of your data into SDE, finish up your development work on sandbox (only this time connect to your SDE database on rocky), and when you are stable with your development, move your arcims directories to castanea (you will have help doing this). There might not be enough space on rubble to put all the data you might have in your arcims application there. Remember to center your data (xy shifts) and define your precision and the spatial index.

You are also encouraged to think about designing your geodatabase. There are several resources for this, including the esri web site, and several books published by esri. You most likely will need to modify your coverage or shapefile design in order to take advantage of the benefits of the geodatabase. You need to think about using feature databases if you are at all interested in topology between features. You also need to get rid of items that are not used in the geodatabase (-id, #, area, perimeter, etc). If you are interested in area, you may need to calculate it.

Remember: after you successfully import a coverage or shapefile, you need to register it as versioned or you will run into problems with permissions.

Notify Sean and Terralyn when you are finished loading data into SDE for your database. They can work with fine tuning the database to perform faster when data isn't being loaded.

These instructions will be posted on the SDMG website. We'll be working on an agreement for folks to sign, that specifies the limitations of the development machines, and the user expectations/restrictions.