JLL and London & Partners. Forbes Welcome. Search for a Dataset - the Datahub. ANALYTICS AS A SERVICE - Ontodia. We take opendata from raw datasets in the cloud, to actionable information you can use with our integrated collaborative analytics.
We do this by aggregating data from various sources – public and private, and combining it with YOUR data, to help you bring data-driven solutions to YOUR issues. – Marshall your disparate data sources from various silos – Discover, analyze, collaborate and get insights – Easily identify patterns in your data Configuring and launching an Open Data Portal is just the beginning of a comprehensive Open Data Program. Analytics-as-a-Service complements your internal data science capacity with Solution Templates and Consulting Hours. Ontodia offers additional value added services in these areas: – Development of ETL (Extract, Transform, Load) scripts – Geospatial Enrichment Services (geocoding, data contextualization, etc.) – Visualization creation/development – Dashboard creation/customization (CivicDashboards.com)
Instances around the world. Postgis - Is there a CASE Tool for modelling spatial databases? See Moskitt Geo for this.
Some demos available on youtube and For the moment, there are some problems with type for generated sql. After not especially for gis database but PostgreSQL in general, see The first use JDBC, so it keeps PK (Primary Key) and FK (Foreign Key) when reverse engineering, the second use ODBC, so it only retrieves tables structures but no PK or FK. The last one is one of the recent tools and lack reverse engineering (ability to generate visual schema from tables structures) The 3 previous tools can create database from the schema you create or generate from a pre-existing database, the schema (the second process is usually call reverse engineering) An other tool can be Perceptory but it uses Visio and Oracle and seems to not be maintained. If your looking for others database case tools, a good list can be found on the LASIG EPFL website (sorry, in french)
Web Services & Spatial SQL. Flash Earth - Zoom into satellite and aerial imagery. Employment Data. BI Reporting & Analysis Tool: SQL Power Wabit. The SQL Power Wabit empowers database & business users around the world to perform ALL their reporting and analytics from one straightforward, easy-to-use interface.
SQL Power Wabit just works! Recognizing that end-users struggling with overly-complex BI Tools is the number one reason why Business Intelligence projects fail to deliver the desired ROI, SQL Power Wabit was designed to conquer this primary issue. Although there are many BI Reporting tools on the market (both proprietary and Open Source), most of these tools are fairly difficult to use and require one or more days of training before a user can get started. Committed to providing business users around the world with an intuitive BI Tool for everyday data analysis and decision making, SQL Power Wabit designers set out to create the simplest and most intuitive BI Reporting tool on the market. Features. Data Modeling & Profiling Tool: SQL Power Architect. Features Accesses source databases via JDBC Connects to multiple source databases concurrently Compares data models & database structures and identifies discrepancies Drag-and-drop source tables & columns into the playpen Remembers the origin of each column Generates source-to-target visual Mapping Reports Forward/reverse engineers PostgreSQL, Oracle, MS SQL Server & more Saves source data structure snapshots in the project, so you can work remotely All project data is stored in an easy-to-parse XML format OLAP schema modeling: Cubes, Measures, Dimensions, Hierarchies & Levels Visual Mapping Report for data lineage tracking Free Download (Open Source, GPL v.3 licensed) (Community Edition) Data Architects, DBA's, Analysts and Designers rely on Data Modeling tools to facilitate and simplify their data Modeling efforts, while maximizing the use of their resources.
SQL Power Architect can also open multiple source databases concurrently, even if they are from competing database vendors. CartoWorld Consulting - Strategic GIS and Analytics Consultants. Data Cleansing & Address Correction: SQL Power DQguru. Features Whether you're building a Data Warehouse, Data Mart or CRM, the SQL Power DQguru goes a long way towards ensuring the data integrity of your decision support environment or CRM database.
PgModeler - PostgreSQL Database Modeler.