Elasticsearch, register multiple geo_point types to single index

gistfile1.txt

# first geo_point mapping: map1.json

    "place" : {
        "properties" : {
            "geometry": {
                "properties": {
                    "coordinates": {
                        "type": "geo_point"
                    }
                }
            }
        }
    }
}

curl -XPUT http://localhost:9200/geo/place/_mapping -d @map1.json
{"ok":true,"acknowledged":true}

# the data 
head -n4 place_es.json 

{"index":{"_index":"geo","_type":"place","_id":0}}
{"geometry":{"coordinates":{"lat":43.005895,"lon":-71.013202}},"zipcode":"00210","city":"Portsmouth","state":"NH","city_phone":"PRTSM","latitude":"43.005895","longitude":"-71.013202","status":"U","fips_class":"C5","fips_place":"3362900","fips_county":"33015","priority":"1"}
{"index":{"_index":"geo","_type":"place","_id":1}}
{"geometry":{"coordinates":{"lat":43.005895,"lon":-71.013202}},"zipcode":"00211","city":"Portsmouth","state":"NH","city_phone":"PRTSM","latitude":"43.005895","longitude":"-71.013202","status":"U","fips_class":"C5","fips_place":"3362900","fips_county":"33015","priority":"1"}

# load the data
time curl -XPUT 'http://localhost:9200/_bulk/' --data-binary @place_es.json

# returns:

...{"index":{"_index":"geo","_type":"place","_id":"105244","_version":1,"ok":true}},{"index":{"_index":"geo","_type":"place","_id":"105245","_version":1,"ok":true}},{"index":{"_index":"geo","_type":"place","_id":"105246","_version":1,"ok":true}}]}

#search

curl -XGET 'http://localhost:9200/geo/place/_search' -d '{
    "query": {
        "filtered": {
            "query": {
                "match_all": {}
            },
            "filter": {
                "geo_distance": {
                    "distance": "20km",
                    "geometry.coordinates": {
                        "lat": 32.25,
                        "lon": -97.75
                    }
                }
            }
        }
    }
}'

# returns:

... {"_index":"geo","_type":"place","_id":"86704","_score":1.0, "_source" : {"geometry":{"coordinates":{"lat":32.421697,"lon":-97.811051}},"zipcode":"76048","city":"Acton","state":"TX","city_phone":"AKTN","latitude":"32.421697","longitude":"-97.811051","status":"C","fips_class":"U6","fips_place":"4801144","fips_county":"48221","priority":"3"}}]}}



# add second mapping for zipcodes; map3.json
{
    "zipcode" : {
        "properties" : {
            "geometry": {
                "properties": {
                    "coordinates": {
                        "type": "geo_point"
                    }
                }
            }
        }
    }

}

curl -XPUT http://localhost:9200/geo/zipcode/_mapping -d @map3.json{"ok":true,"acknowledged":true}

# load zipcode data

head -n4 zipcode.json

head zipcode.json 
{"index":{"_index":"geo","_type":"zipcode","_id":0}}
{"geometry":{"coordinates":{"lat":46.66262363305924,"lon":-68.17241080966178}},"ZCTA5CE10":"04757","GEOID10":"04757","CLASSFP10":"B5","MTFCC10":"G6350","FUNCSTAT10":"S"}
{"index":{"_index":"geo","_type":"zipcode","_id":1}}
{"geometry":{"coordinates":{"lat":46.554241657415005,"lon":-67.8472337219097}},"ZCTA5CE10":"04758","GEOID10":"04758","CLASSFP10":"B5","MTFCC10":"G6350","FUNCSTAT10":"S"}

time curl -XPUT 'http://localhost:9200/_bulk/' --data-binary @zipcode.json

#returns:

...{"index":{"_index":"geo","_type":"zipcode","_id":"33117","_version":1,"ok":true}},{"index":{"_index":"geo","_type":"zipcode","_id":"33118","_version":1,"ok":true}},{"index":{"_index":"geo","_type":"zipcode","_id":"33119","_version":1,"ok":true}}]}


# query for zipcode geo_point

curl -XGET 'http://localhost:9200/geo/zipcode/_search' -d '{
    "query": {
        "filtered": {
            "query": {
                "match_all": {}
            },
            "filter": {
                "geo_distance": {
                    "distance": "20km",
                    "geometry.coordinates": {
                        "lat": 32.25,
                        "lon": -97.75
                    }
                }
            }
        }
    }
}'


# returns

{"took":14,"timed_out":false,"_shards":{"total":5,"successful":5,"failed":0},"hits":{"total":4,"max_score":1.0,"hits":[{"_index":"geo","_type":"zipcode","_id":"28018","_score":1.0, "_source" : {"geometry":{"coordinates":{"lat":32.28214132796423,"lon":-97.70542826804316}},"ZCTA5CE10":"76077","GEOID10":"76077","CLASSFP10":"B5","MTFCC10":"G6350","FUNCSTAT10":"S"}},{"_index":"geo","_type":"zipcode","_id":"29249","_score":1.0, "_source" : {"geometry":{"coordinates":{"lat":32.082253927219824,"lon":-97.7332717789152}},"ZCTA5CE10":"76690","GEOID10":"76690","CLASSFP10":"B5","MTFCC10":"G6350","FUNCSTAT10":"S"}},{"_index":"geo","_type":"zipcode","_id":"27996","_score":1.0, "_source" : {"geometry":{"coordinates":{"lat":32.20530457721625,"lon":-97.79713295504516}},"ZCTA5CE10":"76043","GEOID10":"76043","CLASSFP10":"B5","MTFCC10":"G6350","FUNCSTAT10":"S"}},{"_index":"geo","_type":"zipcode","_id":"28015","_score":1.0, "_source" : {"geometry":{"coordinates":{"lat":32.262468127364365,"lon":-97.65430177697428}},"ZCTA5CE10":"76070","GEOID10":"76070","CLASSFP10":"B5","MTFCC10":"G6350","FUNCSTAT10":"S"}}]}}