All Projects → ArrayAccess → Indonesia Postal And Area

ArrayAccess / Indonesia Postal And Area

Licence: mit
Indonesia Postal Code & Area (BPS)

Projects that are alternatives of or similar to Indonesia Postal And Area

Node Gtfs
Import GTFS transit data into SQLite and query routes, stops, times, fares and more.
Stars: ✭ 323 (+404.69%)
Mutual labels:  sqlite, geojson
Datasette
An open source multi-tool for exploring and publishing data
Stars: ✭ 5,640 (+8712.5%)
Mutual labels:  csv, sqlite
Pgloader
Migrate to PostgreSQL in a single command!
Stars: ✭ 3,754 (+5765.63%)
Mutual labels:  csv, sqlite
dbd
dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
Stars: ✭ 30 (-53.12%)
Mutual labels:  csv, sqlite
Sqlitebiter
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file.
Stars: ✭ 601 (+839.06%)
Mutual labels:  csv, sqlite
geojson-bbox
Calculates extent/bbox for a given valid geojson object.
Stars: ✭ 25 (-60.94%)
Mutual labels:  geojson, geometry
Pytablewriter
pytablewriter is a Python library to write a table in various formats: CSV / Elasticsearch / HTML / JavaScript / JSON / LaTeX / LDJSON / LTSV / Markdown / MediaWiki / NumPy / Excel / Pandas / Python / reStructuredText / SQLite / TOML / TSV.
Stars: ✭ 422 (+559.38%)
Mutual labels:  csv, sqlite
geok
Kotlin geometry library
Stars: ✭ 29 (-54.69%)
Mutual labels:  geojson, geometry
Countries
World countries in JSON, CSV, XML and Yaml. Any help is welcome!
Stars: ✭ 5,379 (+8304.69%)
Mutual labels:  csv, geojson
Daff
align and compare tables
Stars: ✭ 598 (+834.38%)
Mutual labels:  csv, sqlite
geoh
Transform a geoJSON into a list of geohashes that intersect with it
Stars: ✭ 26 (-59.37%)
Mutual labels:  geojson, geometry
Csv To Geojson
Convert a CSV to GeoJSON
Stars: ✭ 46 (-28.12%)
Mutual labels:  csv, geojson
GeoJSON4EntityFramework
Create GeoJSON from Entity Framework Spatial Data or WKT
Stars: ✭ 18 (-71.87%)
Mutual labels:  geojson, geometry
csv-to-sqlite
A desktop app to convert CSV files to SQLite databases!
Stars: ✭ 68 (+6.25%)
Mutual labels:  csv, sqlite
geofeatures2
A lightweight, high performance geometry library in Swift.
Stars: ✭ 18 (-71.87%)
Mutual labels:  geojson, geometry
Visidata
A terminal spreadsheet multitool for discovering and arranging data
Stars: ✭ 4,606 (+7096.88%)
Mutual labels:  csv, sqlite
Mapshaper
Tools for editing Shapefile, GeoJSON, TopoJSON and CSV files
Stars: ✭ 2,813 (+4295.31%)
Mutual labels:  csv, geojson
osm-static-maps
Openstreetmap static maps is a nodejs lib, CLI and server open source inspired on google static map service
Stars: ✭ 130 (+103.13%)
Mutual labels:  geojson, geometry
Csvs To Sqlite
Convert CSV files into a SQLite database
Stars: ✭ 568 (+787.5%)
Mutual labels:  csv, sqlite
Nano Sql
Universal database layer for the client, server & mobile devices. It's like Lego for databases.
Stars: ✭ 717 (+1020.31%)
Mutual labels:  csv, sqlite

INDONESIA POSTAL CODE & AREA

This is collections of Indonesia area & postal codes.

This repository contains THOUSANDS & Binary Data!

Before clone, make sure you know what you'll do.

COLLECTIONS

  • Postal Code : 14955
  • Villages : 83342
  • Sub-Districts : 7228
  • Cities : 514
  • Provinces : 34
  • Countries : 1 (Indonesia Only)

STRUCTURES

Data Directory

data/
    ├─── csv/
    |   └─── 62/                                        (Country csv directory)
    |       ├─── countries.csv                          (Countries csv data)
    |       ├─── provinces.csv                          (Provinces csv data)
    |       ├─── cities.csv                             (Cities csv data)
    |       ├─── subDistricts.csv                       (Sub-Districts csv data)
    |       ├─── villages.csv                           (Villages csv data)
    |       ├─── postalCodes.csv                        (Postal Codes csv data)
    |       └─── translations.csv                       (Translations csv data)
    ├─── database/
    |   ├─── records.sqlite.db                          (SQLite Binary Database - geometry records has been set to null)
    |   ├─── ddl.sql                                    (DDL)
    |   ├─── ddl.uml
    |   └─── ddl.uml.png
    ├─── json/
    |   ├─── area/
    |   |   └─── 62/                                    (country root directory)
    |   |       ├─── 62.json                            (country json info)
    |   |       └─── [0-9]{2}/                          (provinces root directory)
    |   |           ├─── [0-9]{2}.json                  (province json info)
    |   |           └─── [0-9]{4}/                      (cities root directory)
    |   |               ├─── [0-9]{4}.json              (city json info)
    |   |               └─── [0-9]{7}/                  (sub-districts root directory)
    |   |                   └─── [0-9]{7}.json          (sub-district json info)
    |   |                       └─── [0-9]{11}/         (villages root directory - contain single file)
    |   |                           └─── [0-9]{11}.json (village json info)
    |   ├─── postal/                                    (country postal codes root directory)
    |   |   └─── 62.json                                (list of country postal codes)
    |   └─── translations/
    |       └─── 62/                                    (country translations root directory)
    |           └─── en.json                            (list of available areas translations)    
    └─── geojson/
       └─── 62/                                         (country geojson root directory)
           ├─── 62.json                                 (country geojson)
           └─── [0-9]{2}/                               (provinces geojson root directory)
               ├─── [0-9]{2}.json                       (province geojson)
               └─── [0-9]{4}/                           (cities geojson root directory)
                   ├─── [0-9]{4}.json                   (city geojson)
                   └─── [0-9]{7}/                       (sub-districts geojson root directory)
                       └─── [0-9]{7}.json               (sub-district geojson)


Json Areas

Latitude & Longitude contains centroid of MultiPolygon take from geojson using geophp

{
  "code": "integer",
  "name": "string",
  "parent": "integer",
  "latitude": "float|null",
  "longitude": "float|null",
  "postal": ["array<integer>"],
  "children": ["array<integer>"]
}

GEO-JSON

Geo-JSON only available from Country to Sub-Districts, villages are not available.

Read More About GeoJSON

{
  "type": "FeatureCollections",
  "features": ["array<object>"]
}

Example :

{
  "type": "FeatureCollections",
  "features": [
    {
      "type": "Feature",
      "code": "integer",
      "properties" : {
        "Kind"  : "string",
        "Code"  : "integer",
        "Name"  : "string",
        "Year"  : "integer|string",
        "Source": "BPS",
        "Parent": "integer"
      },
      "geometry": {
        "type": "MultiPolygon",
        "coordinates" : [
          [
            [
                [
                  91.0000001,
                  1.00000001
                ],
                [
                  92.0000002,
                  2.00000002
                ]
            ]
          ]
        ]
      }
    }
  ]
}

DATA SOURCE

DATA PROCESSOR

NOTE

  • Badan Pusat Statistik Indonesia (BPS) contains detailed polygons, it will make this repository contains huge data.
  • Some of GeoJson not available
  • Database Files on all columns with xxxx_geometry has been set to null. Please insert manually from data/geojson, Trees file name as code

LICENSE

MIT LICENSE

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].