| 1 | CREATE INDEX "geoapp_country_mpoly_id" ON "geoapp_country" USING GIST ("mpoly")
|
|---|
| 2 | CREATE INDEX "geoapp_countrywebmercator_mpoly_id" ON "geoapp_countrywebmercator" USING GIST ("mpoly")
|
|---|
| 3 | CREATE INDEX "geoapp_city_point_id" ON "geoapp_city" USING GIST ("point")
|
|---|
| 4 | CREATE INDEX "geoapp_state_poly_id" ON "geoapp_state" USING GIST ("poly")
|
|---|
| 5 | CREATE INDEX "geoapp_track_line_id" ON "geoapp_track" USING GIST ("line")
|
|---|
| 6 | CREATE INDEX "geoapp_multifields_point_id" ON "geoapp_multifields" USING GIST ("point")
|
|---|
| 7 | CREATE INDEX "geoapp_multifields_poly_id" ON "geoapp_multifields" USING GIST ("poly")
|
|---|
| 8 | CREATE INDEX "geoapp_uniquetogethermodel_point_id" ON "geoapp_uniquetogethermodel" USING GIST ("point")
|
|---|
| 9 | CREATE INDEX "geoapp_feature_geom_id" ON "geoapp_feature" USING GIST ("geom")
|
|---|
| 10 | CREATE INDEX "geoapp_minusonesrid_geom_id" ON "geoapp_minusonesrid" USING GIST ("geom")
|
|---|
| 11 | CREATE INDEX "geoapp_nonconcretemodel_point_id" ON "geoapp_nonconcretemodel" USING GIST ("point")
|
|---|
| 12 | CREATE INDEX "geoapp_manypointmodel_point1_id" ON "geoapp_manypointmodel" USING GIST ("point1")
|
|---|
| 13 | CREATE INDEX "geoapp_manypointmodel_point2_id" ON "geoapp_manypointmodel" USING GIST ("point2")
|
|---|
| 14 | CREATE INDEX "geoapp_manypointmodel_point3_id" ON "geoapp_manypointmodel" USING GIST ("point3")
|
|---|
| 15 | CREATE INDEX "distapp_southtexascity_point_id" ON "distapp_southtexascity" USING GIST ("point")
|
|---|
| 16 | CREATE INDEX "distapp_southtexascityft_point_id" ON "distapp_southtexascityft" USING GIST ("point")
|
|---|
| 17 | CREATE INDEX "distapp_australiacity_point_id" ON "distapp_australiacity" USING GIST ("point")
|
|---|
| 18 | CREATE INDEX "distapp_australiacity_ref_point_id" ON "distapp_australiacity" USING GIST ("ref_point")
|
|---|
| 19 | CREATE INDEX "distapp_censuszipcode_poly_id" ON "distapp_censuszipcode" USING GIST ("poly")
|
|---|
| 20 | CREATE INDEX "distapp_southtexaszipcode_poly_id" ON "distapp_southtexaszipcode" USING GIST ("poly")
|
|---|
| 21 | CREATE INDEX "distapp_interstate_path_id" ON "distapp_interstate" USING GIST ("path")
|
|---|
| 22 | CREATE INDEX "distapp_southtexasinterstate_path_id" ON "distapp_southtexasinterstate" USING GIST ("path")
|
|---|
| 23 | CREATE INDEX "geogapp_city_point_id" ON "geogapp_city" USING GIST ("point")
|
|---|
| 24 | CREATE INDEX "geogapp_zipcode_poly_id" ON "geogapp_zipcode" USING GIST ("poly")
|
|---|
| 25 | CREATE INDEX "geogapp_county_mpoly_id" ON "geogapp_county" USING GIST ("mpoly")
|
|---|
| 26 | CREATE INDEX "geo3d_city3d_point_id" ON "geo3d_city3d" USING GIST ("point" GIST_GEOMETRY_OPS_ND)
|
|---|
| 27 | CREATE INDEX "geo3d_city3d_pointg_id" ON "geo3d_city3d" USING GIST ("pointg")
|
|---|
| 28 | CREATE INDEX "geo3d_interstate2d_line_id" ON "geo3d_interstate2d" USING GIST ("line")
|
|---|
| 29 | CREATE INDEX "geo3d_interstate3d_line_id" ON "geo3d_interstate3d" USING GIST ("line" GIST_GEOMETRY_OPS_ND)
|
|---|
| 30 | CREATE INDEX "geo3d_interstateproj2d_line_id" ON "geo3d_interstateproj2d" USING GIST ("line")
|
|---|
| 31 | CREATE INDEX "geo3d_interstateproj3d_line_id" ON "geo3d_interstateproj3d" USING GIST ("line" GIST_GEOMETRY_OPS_ND)
|
|---|
| 32 | CREATE INDEX "geo3d_polygon2d_poly_id" ON "geo3d_polygon2d" USING GIST ("poly")
|
|---|
| 33 | CREATE INDEX "geo3d_polygon3d_poly_id" ON "geo3d_polygon3d" USING GIST ("poly" GIST_GEOMETRY_OPS_ND)
|
|---|
| 34 | CREATE INDEX "geo3d_point2d_point_id" ON "geo3d_point2d" USING GIST ("point")
|
|---|
| 35 | CREATE INDEX "geo3d_point3d_point_id" ON "geo3d_point3d" USING GIST ("point" GIST_GEOMETRY_OPS_ND)
|
|---|
| 36 | CREATE INDEX "geo3d_multipoint3d_mpoint_id" ON "geo3d_multipoint3d" USING GIST ("mpoint" GIST_GEOMETRY_OPS_ND)
|
|---|
| 37 | CREATE INDEX "layermap_county_mpoly_id" ON "layermap_county" USING GIST ("mpoly")
|
|---|
| 38 | CREATE INDEX "layermap_countyfeat_poly_id" ON "layermap_countyfeat" USING GIST ("poly")
|
|---|
| 39 | CREATE INDEX "layermap_city_point_id" ON "layermap_city" USING GIST ("point")
|
|---|
| 40 | CREATE INDEX "layermap_interstate_path_id" ON "layermap_interstate" USING GIST ("path")
|
|---|
| 41 | CREATE INDEX "layermap_citybase_point_id" ON "layermap_citybase" USING GIST ("point")
|
|---|
| 42 | CREATE INDEX "layermap_invalid_point_id" ON "layermap_invalid" USING GIST ("point")
|
|---|
| 43 | CREATE INDEX "layermap_hasnulls_geom_id" ON "layermap_hasnulls" USING GIST ("geom")
|
|---|
| 44 | CREATE INDEX "layermap_doesnotallownulls_geom_id" ON "layermap_doesnotallownulls" USING GIST ("geom")
|
|---|
| 45 | CREATE INDEX "inspectapp_allogrfields_geom_id" ON "inspectapp_allogrfields" USING GIST ("geom")
|
|---|
| 46 | CREATE INDEX "inspectapp_allogrfields_point_id" ON "inspectapp_allogrfields" USING GIST ("point")
|
|---|
| 47 | CREATE INDEX "inspectapp_fields3d_point_id" ON "inspectapp_fields3d" USING GIST ("point" GIST_GEOMETRY_OPS_ND)
|
|---|
| 48 | CREATE INDEX "inspectapp_fields3d_pointg_id" ON "inspectapp_fields3d" USING GIST ("pointg")
|
|---|
| 49 | CREATE INDEX "inspectapp_fields3d_line_id" ON "inspectapp_fields3d" USING GIST ("line" GIST_GEOMETRY_OPS_ND)
|
|---|
| 50 | CREATE INDEX "inspectapp_fields3d_poly_id" ON "inspectapp_fields3d" USING GIST ("poly" GIST_GEOMETRY_OPS_ND)
|
|---|
| 51 | CREATE INDEX "relatedapp_location_point_id" ON "relatedapp_location" USING GIST ("point")
|
|---|
| 52 | CREATE INDEX "relatedapp_parcel_center1_id" ON "relatedapp_parcel" USING GIST ("center1")
|
|---|
| 53 | CREATE INDEX "relatedapp_parcel_mycenter_id" ON "relatedapp_parcel" USING GIST ("mycenter")
|
|---|
| 54 | CREATE INDEX "relatedapp_parcel_border1_id" ON "relatedapp_parcel" USING GIST ("border1")
|
|---|
| 55 | CREATE INDEX "relatedapp_parcel_border2_id" ON "relatedapp_parcel" USING GIST ("border2")
|
|---|
| 56 | CREATE INDEX "geoadmin_city_point_id" ON "geoadmin_city" USING GIST ("point")
|
|---|
| 57 | CREATE INDEX "gis_migrations_neighborhood_geom_id" ON "gis_migrations_neighborhood" USING GIST ("geom")
|
|---|
| 58 | CREATE INDEX "gis_migrations_household_geom_id" ON "gis_migrations_household" USING GIST ("geom")
|
|---|
| 59 | CREATE INDEX "gis_migrations_heatmap_rast_id" ON "gis_migrations_heatmap" USING GIST (ST_ConvexHull("rast"))
|
|---|
| 60 | CREATE INDEX "rasterapp_rastermodel_rast_id" ON "rasterapp_rastermodel" USING GIST (ST_ConvexHull("rast"))
|
|---|
| 61 | CREATE INDEX "rasterapp_rastermodel_rastprojected_id" ON "rasterapp_rastermodel" USING GIST (ST_ConvexHull("rastprojected"))
|
|---|
| 62 | CREATE INDEX "rasterapp_rastermodel_geom_id" ON "rasterapp_rastermodel" USING GIST ("geom")
|
|---|
| 63 |
|
|---|