Capabilities & Infrastructure

Capabilities

• Custom web programming for environmental data management and dissemination (Grails, PHP, Javascript)
• GIS data production, modeling, analysis and programming
• Environmental data management for long-term monitoring and special projects
• Custom web mapping development (ArcGIS Server, Mapserver, Openlayers, Google API)
• Spatial and tabular database server configuration and deployment
• Web, email and file server configuration and deployment
• Website design, creation and management (static HTML, Drupal)
• Database design and programming (MS Access, PostGres, SQL Server)
• Field data form design and deployment (MS Access, HTML)

Website Hosting and Management

SFEI continues to expand website hosting and management services, both for SFEI projects and for external partners. Sites include:

• www.sfei.org — Main SFEI site
• www.californiawetlands.net — Wetland information for California
• www.cramwetlands.org — CRAM wetland assessments
• www.exoticsguide.org — Invasive species identification
• www.cuactionplan.org — Copper in SF Bay information & resources
• www.centralvalleymonitoring.org — Central Valley water monitoring inventory
• www.wrmp.org — Wetlands Regional Monitoring Program
• www.centralcoastwetlands.org — Central coast wetlands working group (partner site)
• www.irwm.org — Integrated regional wetlands project (partner site)
• www.napa-sonoma-marsh.org — Napa-Sonoma restoration (partner site)
• www.southbayrestoration.org — South Bay restoration (partner site)
• www.searspointrestoration.org — Restoration collaboration (partner site)
• www.southbayshoreline.org — Army Corps South Bay shoreline study (partner site)

Infrastructure

Servers

• 16 physical servers; Over 10 terabytes of raided storage

Database technologies used at SFEI

• Microsoft SQL Server; PostgreSQL/PostGIS; mySQL

Web servers, application frameworks and libraries used at SFEI

• Apache; Tomcat; Grails; jQuery

GIS Software

• ArcGIS; ArcSDE

Web GIS technologies

• ArcGIS Server; Mapserver; Openlayers Google Maps API

Offsite backup

• LTO-3 tape autoloader; LTO-4 tape autoloader; Self-starting diesel backup generator for all servers and desktops

Printing

• 6 networked printers and printer-copiers; 42" large format poster & map printer

Internet

• 6Mbps burstable point-to-point wireless

Colocation

• Co-located email and web server in Sacramento for disaster resilience and recovery

Software Development SOP

In 2008 a standard operating procedure for the development of software was put in place. The SOP emphasizes fully planning software features and interactions in mockups and software specifications prior to initiating programming. This way, the programming task is well defined, costs and schedule can be better estimated, and all members of the project can align on needs and expectations.