City of Berkeley Enlists Farallon Geographics to Migrate to Esri LGIM and Leverage Off-the-Shelf Services, Applications and Workflows

San Francisco, CA, Sep 21, 2016 -- Farallon Geographics worked with the City of Berkeley to migrate their GIS from a legacy data model to Esri’s “Local Government Information Model” (LGIM). Farallon assisted the City’s GIS staff with LGIM strategic planning and provided the technical expertise necessary for an efficient migration.

Farallon was selected for this project because of its wide experience in LGIM strategic planning, migration, customization and application integration including solution development for various California municipalities including City of Foster City, Town of Danville, City of Walnut Creek and Tulare County.

For the City of Berkeley project, Farallon first developed a matrix that specified how feature classes in the legacy data model should be “mapped” into the LGIM. The process of moving data from one database to another is called “ETL” (Extract, Transform, and Load).  It involves reading data from a source data set, transforming the data into a structure and/or format that is consistent with a target database, and populating the target database with the re-formatted data content.

During this analysis, Farallon also identified legacy source data and classes that would not naturally map into the off-the-shelf LGIM. In these cases, Farallon and the City worked together to construct enhancements to the LGIM to support Berkeley’s unique needs.

Based on this analysis, Farallon delivered an ETL script, verified the integrity of the transformed data and deployed the populated LGIM database to the new server architecture and geodatabase.

About Farallon Geographics: 
Farallon Geographics ( fargeo.com), based in San Francisco, is a leader in the planning, implementation, and integration of GIS systems and software to support mission critical business functions. As systems integrators focused on geographical data, Farallon provides unique and unbiased strategic and technical implementation services for enterprise-scale GIS on web, desktop and mobile. 




Review Article Be the first to review this article
Trimble

Harris

Featured Video
Jobs
Senior Mechanical Engineer for BAE Systems Intelligence & Security at Arlington, VA
Geospatial Systems Administrator for BAE Systems Intelligence & Security at arnold, MO
Geospatial Analyst - Senior for BAE Systems Intelligence & Security at Springfield, VA
Mechanical Design Engineer 3 for KLA-Tencor at Milpitas, CA
Sr Mechanical Design Engineer for Medtronic at mounds view, MN
Urban Designer - Urban Design/Planning for SERA Architects, Inc at Portland, OR
Upcoming Events
Geospatial World Forum 2018 at Hyderabad International Convention Centre Hyderabad India - Jan 16 - 19, 2018
2018 Annual Convention of Virginia Association of Surveyors at 24 S. Market St Staunton VA - Jan 18 - 20, 2018
ArcGIS: Introduction at Environmental and Natural Resource Building 14 College Farm Rd New Brunswick NJ - Feb 1 - 22, 2018
International LiDAR Mapping Forum at Hyatt Regency 650 15th Street, Denver CO - Feb 5 - 7, 2018
Teledyne Optech
University of Denver GIS Masters Degree Online
CADalog.com - Countless CAD add-ons, plug-ins and more.



Internet Business Systems © 2017 Internet Business Systems, Inc.
25 North 14th Steet, Suite 710, San Jose, CA 95112
+1 (408) 882-6554 — Contact Us, or visit our other sites:
AECCafe - Architectural Design and Engineering EDACafe - Electronic Design Automation TechJobsCafe - Technical Jobs and Resumes  MCADCafe - Mechanical Design and Engineering ShareCG - Share Computer Graphic (CG) Animation, 3D Art and 3D Models
  Privacy PolicyAdvertise