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 |
|
---|