Ticket #301: uninstall_rtpostgis.sql

File uninstall_rtpostgis.sql, 42.7 KB (added by dustymugs, 5 months ago)

Uninstall sql for raster rtpostgis generated by uninstall_script.

Line 
1DROP VIEW IF EXISTS raster_overviews;
2DROP VIEW IF EXISTS raster_columns;
3DROP CAST IF EXISTS (raster AS geometry);
4DROP CAST IF EXISTS (raster AS bytea);
5DROP CAST IF EXISTS (raster AS box3d);
6DROP OPERATOR IF EXISTS ~= (raster, raster);
7DROP OPERATOR IF EXISTS ~ (raster, raster);
8DROP OPERATOR IF EXISTS |>> (raster, raster);
9DROP OPERATOR IF EXISTS |&> (raster, raster);
10DROP OPERATOR IF EXISTS @ (raster, raster);
11DROP OPERATOR IF EXISTS >> (raster, raster);
12DROP OPERATOR IF EXISTS <<| (raster, raster);
13DROP OPERATOR IF EXISTS << (raster, raster);
14DROP OPERATOR IF EXISTS &> (raster, raster);
15DROP OPERATOR IF EXISTS &<| (raster, raster);
16DROP OPERATOR IF EXISTS &< (raster, raster);
17DROP OPERATOR IF EXISTS && (raster, raster);
18DROP AGGREGATE IF EXISTS st_union(raster, integer, text);
19DROP AGGREGATE IF EXISTS st_union(raster, text);
20DROP AGGREGATE IF EXISTS st_union(raster, integer);
21DROP AGGREGATE IF EXISTS st_union(raster);
22DROP FUNCTION IF EXISTS st_world2rastercoordy(rast raster, xw double precision, yw double precision);
23DROP FUNCTION IF EXISTS st_world2rastercoordy(rast raster, pt geometry);
24DROP FUNCTION IF EXISTS st_world2rastercoordy(rast raster, yw double precision);
25DROP FUNCTION IF EXISTS st_world2rastercoordx(rast raster, xw double precision, yw double precision);
26DROP FUNCTION IF EXISTS st_world2rastercoordx(rast raster, pt geometry);
27DROP FUNCTION IF EXISTS st_world2rastercoordx(rast raster, xw double precision);
28DROP FUNCTION IF EXISTS st_width(raster);
29DROP FUNCTION IF EXISTS st_valuepercent(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision);
30DROP FUNCTION IF EXISTS st_valuepercent(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision, OUT value double precision, OUT percent double precision);
31DROP FUNCTION IF EXISTS st_valuepercent(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision);
32DROP FUNCTION IF EXISTS st_valuepercent(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision, OUT value double precision, OUT percent double precision);
33DROP FUNCTION IF EXISTS st_valuepercent(rast raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision);
34DROP FUNCTION IF EXISTS st_valuepercent(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision, OUT value double precision, OUT percent double precision);
35DROP FUNCTION IF EXISTS st_valuepercent(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision);
36DROP FUNCTION IF EXISTS st_valuepercent(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision, OUT value double precision, OUT percent double precision);
37DROP FUNCTION IF EXISTS st_valuepercent(rast raster, nband integer, searchvalue double precision, roundto double precision);
38DROP FUNCTION IF EXISTS st_valuepercent(rast raster, nband integer, searchvalues double precision[], roundto double precision, OUT value double precision, OUT percent double precision);
39DROP FUNCTION IF EXISTS st_valuepercent(rast raster, searchvalue double precision, roundto double precision);
40DROP FUNCTION IF EXISTS st_valuepercent(rast raster, searchvalues double precision[], roundto double precision, OUT value double precision, OUT percent double precision);
41DROP FUNCTION IF EXISTS st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision);
42DROP FUNCTION IF EXISTS st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision, OUT value double precision, OUT count integer);
43DROP FUNCTION IF EXISTS st_valuecount(rastertable text, rastercolumn text, nband integer, searchvalue double precision, roundto double precision);
44DROP FUNCTION IF EXISTS st_valuecount(rastertable text, rastercolumn text, nband integer, searchvalues double precision[], roundto double precision, OUT value double precision, OUT count integer);
45DROP FUNCTION IF EXISTS st_valuecount(rast raster, nband integer, exclude_nodata_value boolean, searchvalue double precision, roundto double precision);
46DROP FUNCTION IF EXISTS st_valuecount(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision, OUT value double precision, OUT count integer);
47DROP FUNCTION IF EXISTS st_valuecount(rastertable text, rastercolumn text, searchvalue double precision, roundto double precision);
48DROP FUNCTION IF EXISTS st_valuecount(rastertable text, rastercolumn text, searchvalues double precision[], roundto double precision, OUT value double precision, OUT count integer);
49DROP FUNCTION IF EXISTS st_valuecount(rast raster, nband integer, searchvalue double precision, roundto double precision);
50DROP FUNCTION IF EXISTS st_valuecount(rast raster, nband integer, searchvalues double precision[], roundto double precision, OUT value double precision, OUT count integer);
51DROP FUNCTION IF EXISTS st_valuecount(rast raster, searchvalue double precision, roundto double precision);
52DROP FUNCTION IF EXISTS st_valuecount(rast raster, searchvalues double precision[], roundto double precision, OUT value double precision, OUT count integer);
53DROP FUNCTION IF EXISTS st_value(rast raster, band integer, x integer, y integer, hasnodata boolean);
54DROP FUNCTION IF EXISTS st_value(rast raster, band integer, pt geometry, hasnodata boolean);
55DROP FUNCTION IF EXISTS st_value(rast raster, x integer, y integer, hasnodata boolean);
56DROP FUNCTION IF EXISTS st_value(rast raster, pt geometry, hasnodata boolean);
57DROP FUNCTION IF EXISTS st_upperlefty(raster);
58DROP FUNCTION IF EXISTS st_upperleftx(raster);
59DROP FUNCTION IF EXISTS st_transform(rast raster, srid integer, scalex double precision, scaley double precision, algorithm text, maxerr double precision);
60DROP FUNCTION IF EXISTS st_transform(rast raster, srid integer, algorithm text, maxerr double precision, scalex double precision, scaley double precision);
61DROP FUNCTION IF EXISTS st_transform(rast raster, srid integer, scalexy double precision, algorithm text, maxerr double precision);
62DROP FUNCTION IF EXISTS st_summarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean);
63DROP FUNCTION IF EXISTS st_summarystats(rastertable text, rastercolumn text, exclude_nodata_value boolean);
64DROP FUNCTION IF EXISTS st_summarystats(rast raster, nband integer, exclude_nodata_value boolean);
65DROP FUNCTION IF EXISTS st_summarystats(rast raster, exclude_nodata_value boolean);
66DROP FUNCTION IF EXISTS st_sum4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
67DROP FUNCTION IF EXISTS st_srid(raster);
68DROP FUNCTION IF EXISTS st_snaptogrid(rast raster, gridx double precision, gridy double precision, scalex double precision, scaley double precision, algorithm text, maxerr double precision);
69DROP FUNCTION IF EXISTS st_snaptogrid(rast raster, gridx double precision, gridy double precision, algorithm text, maxerr double precision, scalex double precision, scaley double precision);
70DROP FUNCTION IF EXISTS st_snaptogrid(rast raster, gridx double precision, gridy double precision, scalexy double precision, algorithm text, maxerr double precision);
71DROP FUNCTION IF EXISTS st_slope(rast raster, band integer, pixeltype text);
72DROP FUNCTION IF EXISTS st_skewy(raster);
73DROP FUNCTION IF EXISTS st_skewx(raster);
74DROP FUNCTION IF EXISTS st_setvalue(rast raster, band integer, x integer, y integer, newvalue double precision);
75DROP FUNCTION IF EXISTS st_setvalue(rast raster, band integer, pt geometry, newvalue double precision);
76DROP FUNCTION IF EXISTS st_setvalue(rast raster, x integer, y integer, newvalue double precision);
77DROP FUNCTION IF EXISTS st_setvalue(rast raster, pt geometry, newvalue double precision);
78DROP FUNCTION IF EXISTS st_setupperleft(rast raster, upperleftx double precision, upperlefty double precision);
79DROP FUNCTION IF EXISTS st_setsrid(rast raster, srid integer);
80DROP FUNCTION IF EXISTS st_setskew(rast raster, skewx double precision, skewy double precision);
81DROP FUNCTION IF EXISTS st_setskew(rast raster, skew double precision);
82DROP FUNCTION IF EXISTS st_setscale(rast raster, scalex double precision, scaley double precision);
83DROP FUNCTION IF EXISTS st_setscale(rast raster, scale double precision);
84DROP FUNCTION IF EXISTS st_setrotation(rast raster, rotation double precision);
85DROP FUNCTION IF EXISTS st_setgeoreference(rast raster, georef text, format text);
86DROP FUNCTION IF EXISTS st_setbandnodatavalue(rast raster, band integer, nodatavalue double precision, forcechecking boolean);
87DROP FUNCTION IF EXISTS st_setbandnodatavalue(rast raster, nodatavalue double precision);
88DROP FUNCTION IF EXISTS st_setbandisnodata(rast raster, band integer);
89DROP FUNCTION IF EXISTS st_scaley(raster);
90DROP FUNCTION IF EXISTS st_scalex(raster);
91DROP FUNCTION IF EXISTS st_samealignment(ulx1 double precision, uly1 double precision, scalex1 double precision, scaley1 double precision, skewx1 double precision, skewy1 double precision, ulx2 double precision, uly2 double precision, scalex2 double precision, scaley2 double precision, skewx2 double precision, skewy2 double precision);
92DROP FUNCTION IF EXISTS st_samealignment(rast1 raster, rast2 raster);
93DROP FUNCTION IF EXISTS st_rotation(raster);
94DROP FUNCTION IF EXISTS st_reskew(rast raster, skewx double precision, skewy double precision, algorithm text, maxerr double precision);
95DROP FUNCTION IF EXISTS st_reskew(rast raster, skewxy double precision, algorithm text, maxerr double precision);
96DROP FUNCTION IF EXISTS st_rescale(rast raster, scalex double precision, scaley double precision, algorithm text, maxerr double precision);
97DROP FUNCTION IF EXISTS st_rescale(rast raster, scalexy double precision, algorithm text, maxerr double precision);
98DROP FUNCTION IF EXISTS st_resample(rast raster, width integer, height integer, srid integer, gridx double precision, gridy double precision, skewx double precision, skewy double precision, algorithm text, maxerr double precision);
99DROP FUNCTION IF EXISTS st_resample(rast raster, srid integer, scalex double precision, scaley double precision, gridx double precision, gridy double precision, skewx double precision, skewy double precision, algorithm text, maxerr double precision);
100DROP FUNCTION IF EXISTS st_resample(rast raster, ref raster, usescale boolean, algorithm text, maxerr double precision);
101DROP FUNCTION IF EXISTS st_resample(rast raster, ref raster, algorithm text, maxerr double precision, usescale boolean);
102DROP FUNCTION IF EXISTS st_reclass(rast raster, nband integer, reclassexpr text, pixeltype text, nodataval double precision);
103DROP FUNCTION IF EXISTS st_reclass(rast raster, reclassexpr text, pixeltype text);
104DROP FUNCTION IF EXISTS st_reclass(rast raster, VARIADIC reclassargset reclassarg[]);
105DROP FUNCTION IF EXISTS st_raster2worldcoordy(rast raster, xr integer, yr integer);
106DROP FUNCTION IF EXISTS st_raster2worldcoordy(rast raster, yr integer);
107DROP FUNCTION IF EXISTS st_raster2worldcoordx(rast raster, xr integer, yr integer);
108DROP FUNCTION IF EXISTS st_raster2worldcoordx(rast raster, xr integer);
109DROP FUNCTION IF EXISTS st_range4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
110DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, quantile double precision);
111DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, quantiles double precision[]);
112DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, exclude_nodata_value boolean, quantile double precision);
113DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, nband integer, quantile double precision);
114DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, nband integer, quantiles double precision[]);
115DROP FUNCTION IF EXISTS st_quantile(rast raster, nband integer, exclude_nodata_value boolean, quantile double precision);
116DROP FUNCTION IF EXISTS st_quantile(rast raster, nband integer, exclude_nodata_value boolean, quantiles double precision[]);
117DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, quantile double precision);
118DROP FUNCTION IF EXISTS st_quantile(rastertable text, rastercolumn text, quantiles double precision[]);
119DROP FUNCTION IF EXISTS st_quantile(rast raster, exclude_nodata_value boolean, quantile double precision);
120DROP FUNCTION IF EXISTS st_quantile(rast raster, nband integer, quantile double precision);
121DROP FUNCTION IF EXISTS st_quantile(rast raster, nband integer, quantiles double precision[]);
122DROP FUNCTION IF EXISTS st_quantile(rast raster, quantile double precision);
123DROP FUNCTION IF EXISTS st_quantile(rast raster, quantiles double precision[]);
124DROP FUNCTION IF EXISTS st_polygon(rast raster, band integer);
125DROP FUNCTION IF EXISTS st_pixelwidth(raster);
126DROP FUNCTION IF EXISTS st_pixelheight(raster);
127DROP FUNCTION IF EXISTS st_pixelaspolygons(rast raster, band integer, OUT geom geometry, OUT val double precision, OUT x integer, OUT y integer);
128DROP FUNCTION IF EXISTS st_pixelaspolygon(rast raster, band integer, x integer, y integer);
129DROP FUNCTION IF EXISTS st_pixelaspolygon(rast raster, x integer, y integer);
130DROP FUNCTION IF EXISTS st_numbands(raster);
131DROP FUNCTION IF EXISTS st_minpossiblevalue(pixeltype text);
132DROP FUNCTION IF EXISTS st_min4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
133DROP FUNCTION IF EXISTS st_metadata(rast raster, OUT upperleftx double precision, OUT upperlefty double precision, OUT width integer, OUT height integer, OUT scalex double precision, OUT scaley double precision, OUT skewx double precision, OUT skewy double precision, OUT srid integer, OUT numbands integer);
134DROP FUNCTION IF EXISTS st_mean4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
135DROP FUNCTION IF EXISTS st_max4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
136DROP FUNCTION IF EXISTS st_mapalgebrafctngb(rast raster, band integer, pixeltype text, ngbwidth integer, ngbheight integer, onerastngbuserfunc regprocedure, nodatamode text, VARIADIC args text[]);
137DROP FUNCTION IF EXISTS st_mapalgebrafct(rast1 raster, band1 integer, rast2 raster, band2 integer, tworastuserfunc regprocedure, pixeltype text, extenttype text, VARIADIC userargs text[]);
138DROP FUNCTION IF EXISTS st_mapalgebrafct(rast1 raster, rast2 raster, tworastuserfunc regprocedure, pixeltype text, extenttype text, VARIADIC userargs text[]);
139DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, band integer, pixeltype text, onerastuserfunc regprocedure, VARIADIC args text[]);
140DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, pixeltype text, onerastuserfunc regprocedure, VARIADIC args text[]);
141DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, band integer, onerastuserfunc regprocedure, VARIADIC args text[]);
142DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, band integer, pixeltype text, onerastuserfunc regprocedure);
143DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, onerastuserfunc regprocedure, VARIADIC args text[]);
144DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, pixeltype text, onerastuserfunc regprocedure);
145DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, band integer, onerastuserfunc regprocedure);
146DROP FUNCTION IF EXISTS st_mapalgebrafct(rast raster, onerastuserfunc regprocedure);
147DROP FUNCTION IF EXISTS st_mapalgebraexpr(rast1 raster, band1 integer, rast2 raster, band2 integer, expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision);
148DROP FUNCTION IF EXISTS st_mapalgebraexpr(rast1 raster, rast2 raster, expression text, pixeltype text, extenttype text, nodata1expr text, nodata2expr text, nodatanodataval double precision);
149DROP FUNCTION IF EXISTS st_mapalgebraexpr(rast raster, band integer, pixeltype text, expression text, nodataval double precision);
150DROP FUNCTION IF EXISTS st_mapalgebraexpr(rast raster, pixeltype text, expression text, nodataval double precision);
151DROP FUNCTION IF EXISTS st_makeemptyraster(width integer, height integer, upperleftx double precision, upperlefty double precision, scalex double precision, scaley double precision, skewx double precision, skewy double precision, srid integer);
152DROP FUNCTION IF EXISTS st_makeemptyraster(width integer, height integer, upperleftx double precision, upperlefty double precision, pixelsize double precision);
153DROP FUNCTION IF EXISTS st_makeemptyraster(rast raster);
154DROP FUNCTION IF EXISTS st_isempty(rast raster);
155DROP FUNCTION IF EXISTS st_intersects(rast1 raster, nband1 integer, rast2 raster, nband2 integer);
156DROP FUNCTION IF EXISTS st_intersects(geom geometry, rast raster, nband integer);
157DROP FUNCTION IF EXISTS st_intersects(rast raster, nband integer, geom geometry);
158DROP FUNCTION IF EXISTS st_intersects(rast raster, geom geometry, nband integer);
159DROP FUNCTION IF EXISTS st_intersects(rast1 raster, rast2 raster);
160DROP FUNCTION IF EXISTS st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, returnband text, otheruserfunc regprocedure);
161DROP FUNCTION IF EXISTS st_intersection(rast1 raster, band1 integer, geom geometry, extenttype text, otheruserfunc regprocedure);
162DROP FUNCTION IF EXISTS st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, otheruserfunc regprocedure);
163DROP FUNCTION IF EXISTS st_intersection(rast1 raster, geom geometry, extenttype text, otheruserfunc regprocedure);
164DROP FUNCTION IF EXISTS st_intersection(rast1 raster, band1 integer, geom geometry, otheruserfunc regprocedure);
165DROP FUNCTION IF EXISTS st_intersection(rast1 raster, rast2 raster, returnband text, otheruserfunc regprocedure);
166DROP FUNCTION IF EXISTS st_intersection(rast1 raster, geom geometry, otheruserfunc regprocedure);
167DROP FUNCTION IF EXISTS st_intersection(rast1 raster, rast2 raster, otheruserfunc regprocedure);
168DROP FUNCTION IF EXISTS st_intersection(geomin geometry, rast raster, band integer);
169DROP FUNCTION IF EXISTS st_histogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, bins integer, width double precision[], "right" boolean);
170DROP FUNCTION IF EXISTS st_histogram(rastertable text, rastercolumn text, nband integer, bins integer, width double precision[], "right" boolean);
171DROP FUNCTION IF EXISTS st_histogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, bins integer, "right" boolean);
172DROP FUNCTION IF EXISTS st_histogram(rast raster, nband integer, exclude_nodata_value boolean, bins integer, width double precision[], "right" boolean);
173DROP FUNCTION IF EXISTS st_histogram(rastertable text, rastercolumn text, nband integer, bins integer, "right" boolean);
174DROP FUNCTION IF EXISTS st_histogram(rast raster, nband integer, bins integer, width double precision[], "right" boolean);
175DROP FUNCTION IF EXISTS st_histogram(rast raster, nband integer, exclude_nodata_value boolean, bins integer, "right" boolean);
176DROP FUNCTION IF EXISTS st_histogram(rast raster, nband integer, bins integer, "right" boolean);
177DROP FUNCTION IF EXISTS st_hillshade(rast raster, band integer, pixeltype text, azimuth double precision, altitude double precision, max_bright double precision, elevation_scale double precision);
178DROP FUNCTION IF EXISTS st_height(raster);
179DROP FUNCTION IF EXISTS st_hasnoband(rast raster, nband integer);
180DROP FUNCTION IF EXISTS st_georeference(rast raster, format text);
181DROP FUNCTION IF EXISTS st_gdaldrivers(OUT idx integer, OUT short_name text, OUT long_name text, OUT create_options text);
182DROP FUNCTION IF EXISTS st_envelope(raster);
183DROP FUNCTION IF EXISTS st_dumpaspolygons(rast raster, band integer);
184DROP FUNCTION IF EXISTS st_count(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean);
185DROP FUNCTION IF EXISTS st_count(rastertable text, rastercolumn text, exclude_nodata_value boolean);
186DROP FUNCTION IF EXISTS st_count(rast raster, nband integer, exclude_nodata_value boolean);
187DROP FUNCTION IF EXISTS st_count(rast raster, exclude_nodata_value boolean);
188DROP FUNCTION IF EXISTS st_convexhull(raster);
189DROP FUNCTION IF EXISTS st_clip(rast raster, band integer, geom geometry, nodata double precision, trimraster boolean);
190DROP FUNCTION IF EXISTS st_clip(rast raster, band integer, geom geometry, trimraster boolean);
191DROP FUNCTION IF EXISTS st_clip(rast raster, geom geometry, nodata double precision, trimraster boolean);
192DROP FUNCTION IF EXISTS st_clip(rast raster, geom geometry, trimraster boolean);
193DROP FUNCTION IF EXISTS st_bandpixeltype(rast raster, band integer);
194DROP FUNCTION IF EXISTS st_bandpath(rast raster, band integer);
195DROP FUNCTION IF EXISTS st_bandnodatavalue(rast raster, band integer);
196DROP FUNCTION IF EXISTS st_bandmetadata(rast raster, band integer, OUT pixeltype text, OUT hasnodata boolean, OUT nodatavalue double precision, OUT isoutdb boolean, OUT path text);
197DROP FUNCTION IF EXISTS st_bandmetadata(rast raster, band integer[], OUT bandnum integer, OUT pixeltype text, OUT hasnodata boolean, OUT nodatavalue double precision, OUT isoutdb boolean, OUT path text);
198DROP FUNCTION IF EXISTS st_bandisnodata(rast raster, band integer, forcechecking boolean);
199DROP FUNCTION IF EXISTS st_bandisnodata(rast raster, forcechecking boolean);
200DROP FUNCTION IF EXISTS st_band(rast raster, nbands text, delimiter character);
201DROP FUNCTION IF EXISTS st_band(rast raster, nband integer);
202DROP FUNCTION IF EXISTS st_band(rast raster, nbands integer[]);
203DROP FUNCTION IF EXISTS st_astiff(rast raster, nbands integer[], compression text, srid integer);
204DROP FUNCTION IF EXISTS st_astiff(rast raster, nbands integer[], options text[], srid integer);
205DROP FUNCTION IF EXISTS st_astiff(rast raster, compression text, srid integer);
206DROP FUNCTION IF EXISTS st_astiff(rast raster, options text[], srid integer);
207DROP FUNCTION IF EXISTS st_asraster(geom geometry, width integer, height integer, pixeltype text, value double precision, nodataval double precision, upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean);
208DROP FUNCTION IF EXISTS st_asraster(geom geometry, width integer, height integer, gridx double precision, gridy double precision, pixeltype text, value double precision, nodataval double precision, skewx double precision, skewy double precision, touched boolean);
209DROP FUNCTION IF EXISTS st_asraster(geom geometry, scalex double precision, scaley double precision, pixeltype text, value double precision, nodataval double precision, upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean);
210DROP FUNCTION IF EXISTS st_asraster(geom geometry, scalex double precision, scaley double precision, gridx double precision, gridy double precision, pixeltype text, value double precision, nodataval double precision, skewx double precision, skewy double precision, touched boolean);
211DROP FUNCTION IF EXISTS st_asraster(geom geometry, width integer, height integer, pixeltype text[], value double precision[], nodataval double precision[], upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean);
212DROP FUNCTION IF EXISTS st_asraster(geom geometry, width integer, height integer, gridx double precision, gridy double precision, pixeltype text[], value double precision[], nodataval double precision[], skewx double precision, skewy double precision, touched boolean);
213DROP FUNCTION IF EXISTS st_asraster(geom geometry, scalex double precision, scaley double precision, pixeltype text[], value double precision[], nodataval double precision[], upperleftx double precision, upperlefty double precision, skewx double precision, skewy double precision, touched boolean);
214DROP FUNCTION IF EXISTS st_asraster(geom geometry, scalex double precision, scaley double precision, gridx double precision, gridy double precision, pixeltype text[], value double precision[], nodataval double precision[], skewx double precision, skewy double precision, touched boolean);
215DROP FUNCTION IF EXISTS st_asraster(geom geometry, ref raster, pixeltype text, value double precision, nodataval double precision, touched boolean);
216DROP FUNCTION IF EXISTS st_asraster(geom geometry, ref raster, pixeltype text[], value double precision[], nodataval double precision[], touched boolean);
217DROP FUNCTION IF EXISTS st_aspng(rast raster, nband integer, compression integer);
218DROP FUNCTION IF EXISTS st_aspng(rast raster, nband integer, options text[]);
219DROP FUNCTION IF EXISTS st_aspng(rast raster, nbands integer[], compression integer);
220DROP FUNCTION IF EXISTS st_aspng(rast raster, nbands integer[], options text[]);
221DROP FUNCTION IF EXISTS st_aspng(rast raster, options text[]);
222DROP FUNCTION IF EXISTS st_aspect(rast raster, band integer, pixeltype text);
223DROP FUNCTION IF EXISTS st_asjpeg(rast raster, nband integer, quality integer);
224DROP FUNCTION IF EXISTS st_asjpeg(rast raster, nband integer, options text[]);
225DROP FUNCTION IF EXISTS st_asjpeg(rast raster, nbands integer[], quality integer);
226DROP FUNCTION IF EXISTS st_asjpeg(rast raster, nbands integer[], options text[]);
227DROP FUNCTION IF EXISTS st_asjpeg(rast raster, options text[]);
228DROP FUNCTION IF EXISTS st_asgdalraster(rast raster, format text, options text[], srid integer);
229DROP FUNCTION IF EXISTS st_asbinary(raster);
230DROP FUNCTION IF EXISTS st_approxsummarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision);
231DROP FUNCTION IF EXISTS st_approxsummarystats(rastertable text, rastercolumn text, nband integer, sample_percent double precision);
232DROP FUNCTION IF EXISTS st_approxsummarystats(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision);
233DROP FUNCTION IF EXISTS st_approxsummarystats(rastertable text, rastercolumn text, sample_percent double precision);
234DROP FUNCTION IF EXISTS st_approxsummarystats(rastertable text, rastercolumn text, exclude_nodata_value boolean);
235DROP FUNCTION IF EXISTS st_approxsummarystats(rast raster, exclude_nodata_value boolean, sample_percent double precision);
236DROP FUNCTION IF EXISTS st_approxsummarystats(rast raster, nband integer, sample_percent double precision);
237DROP FUNCTION IF EXISTS st_approxsummarystats(rast raster, sample_percent double precision);
238DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision);
239DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]);
240DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, nband integer, sample_percent double precision, quantile double precision);
241DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, nband integer, sample_percent double precision, quantiles double precision[]);
242DROP FUNCTION IF EXISTS st_approxquantile(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantile double precision);
243DROP FUNCTION IF EXISTS st_approxquantile(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]);
244DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, exclude_nodata_value boolean, quantile double precision);
245DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, sample_percent double precision, quantile double precision);
246DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, sample_percent double precision, quantiles double precision[]);
247DROP FUNCTION IF EXISTS st_approxquantile(rast raster, nband integer, sample_percent double precision, quantile double precision);
248DROP FUNCTION IF EXISTS st_approxquantile(rast raster, nband integer, sample_percent double precision, quantiles double precision[]);
249DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, quantile double precision);
250DROP FUNCTION IF EXISTS st_approxquantile(rastertable text, rastercolumn text, quantiles double precision[]);
251DROP FUNCTION IF EXISTS st_approxquantile(rast raster, exclude_nodata_value boolean, quantile double precision);
252DROP FUNCTION IF EXISTS st_approxquantile(rast raster, sample_percent double precision, quantile double precision);
253DROP FUNCTION IF EXISTS st_approxquantile(rast raster, sample_percent double precision, quantiles double precision[]);
254DROP FUNCTION IF EXISTS st_approxquantile(rast raster, quantile double precision);
255DROP FUNCTION IF EXISTS st_approxquantile(rast raster, quantiles double precision[]);
256DROP FUNCTION IF EXISTS st_approxhistogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], "right" boolean);
257DROP FUNCTION IF EXISTS st_approxhistogram(rastertable text, rastercolumn text, nband integer, sample_percent double precision, bins integer, width double precision[], "right" boolean);
258DROP FUNCTION IF EXISTS st_approxhistogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, "right" boolean);
259DROP FUNCTION IF EXISTS st_approxhistogram(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], "right" boolean);
260DROP FUNCTION IF EXISTS st_approxhistogram(rastertable text, rastercolumn text, nband integer, sample_percent double precision, bins integer, "right" boolean);
261DROP FUNCTION IF EXISTS st_approxhistogram(rast raster, nband integer, sample_percent double precision, bins integer, width double precision[], "right" boolean);
262DROP FUNCTION IF EXISTS st_approxhistogram(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, "right" boolean);
263DROP FUNCTION IF EXISTS st_approxhistogram(rast raster, nband integer, sample_percent double precision, bins integer, "right" boolean);
264DROP FUNCTION IF EXISTS st_approxhistogram(rastertable text, rastercolumn text, nband integer, sample_percent double precision);
265DROP FUNCTION IF EXISTS st_approxhistogram(rastertable text, rastercolumn text, sample_percent double precision);
266DROP FUNCTION IF EXISTS st_approxhistogram(rast raster, nband integer, sample_percent double precision);
267DROP FUNCTION IF EXISTS st_approxhistogram(rast raster, sample_percent double precision);
268DROP FUNCTION IF EXISTS st_approxcount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision);
269DROP FUNCTION IF EXISTS st_approxcount(rastertable text, rastercolumn text, exclude_nodata_value boolean, sample_percent double precision);
270DROP FUNCTION IF EXISTS st_approxcount(rastertable text, rastercolumn text, nband integer, sample_percent double precision);
271DROP FUNCTION IF EXISTS st_approxcount(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision);
272DROP FUNCTION IF EXISTS st_approxcount(rastertable text, rastercolumn text, sample_percent double precision);
273DROP FUNCTION IF EXISTS st_approxcount(rast raster, exclude_nodata_value boolean, sample_percent double precision);
274DROP FUNCTION IF EXISTS st_approxcount(rast raster, nband integer, sample_percent double precision);
275DROP FUNCTION IF EXISTS st_approxcount(rast raster, sample_percent double precision);
276DROP FUNCTION IF EXISTS st_addband(rast raster, index integer, pixeltype text, initialvalue double precision, nodataval double precision);
277DROP FUNCTION IF EXISTS st_addband(torast raster, fromrast raster, fromband integer, torastindex integer);
278DROP FUNCTION IF EXISTS st_addband(rast raster, pixeltype text, initialvalue double precision, nodataval double precision);
279DROP FUNCTION IF EXISTS st_addband(torast raster, fromrasts raster[], fromband integer);
280DROP FUNCTION IF EXISTS raster_same(raster, raster);
281DROP FUNCTION IF EXISTS raster_right(raster, raster);
282DROP FUNCTION IF EXISTS raster_overright(raster, raster);
283DROP FUNCTION IF EXISTS raster_overleft(raster, raster);
284DROP FUNCTION IF EXISTS raster_overlap(raster, raster);
285DROP FUNCTION IF EXISTS raster_overbelow(raster, raster);
286DROP FUNCTION IF EXISTS raster_overabove(raster, raster);
287DROP FUNCTION IF EXISTS raster_left(raster, raster);
288DROP FUNCTION IF EXISTS raster_contained(raster, raster);
289DROP FUNCTION IF EXISTS raster_contain(raster, raster);
290DROP FUNCTION IF EXISTS raster_below(raster, raster);
291DROP FUNCTION IF EXISTS raster_above(raster, raster);
292DROP FUNCTION IF EXISTS postgis_raster_lib_version();
293DROP FUNCTION IF EXISTS postgis_raster_lib_build_date();
294DROP FUNCTION IF EXISTS postgis_gdal_version();
295DROP FUNCTION IF EXISTS droprasterconstraints(rastschema name, rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, extent boolean);
296DROP FUNCTION IF EXISTS droprasterconstraints(rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, extent boolean);
297DROP FUNCTION IF EXISTS droprasterconstraints(rastschema name, rasttable name, rastcolumn name, VARIADIC constraints text[]);
298DROP FUNCTION IF EXISTS droprasterconstraints(rasttable name, rastcolumn name, VARIADIC constraints text[]);
299DROP FUNCTION IF EXISTS dropoverviewconstraints(ovschema name, ovtable name, ovcolumn name);
300DROP FUNCTION IF EXISTS dropoverviewconstraints(ovtable name, ovcolumn name);
301DROP FUNCTION IF EXISTS bytea(raster);
302DROP FUNCTION IF EXISTS box3d(raster);
303DROP FUNCTION IF EXISTS addrasterconstraints(rastschema name, rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, extent boolean);
304DROP FUNCTION IF EXISTS addrasterconstraints(rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, extent boolean);
305DROP FUNCTION IF EXISTS addrasterconstraints(rastschema name, rasttable name, rastcolumn name, VARIADIC constraints text[]);
306DROP FUNCTION IF EXISTS addrasterconstraints(rasttable name, rastcolumn name, VARIADIC constraints text[]);
307DROP FUNCTION IF EXISTS addoverviewconstraints(ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, ovfactor integer);
308DROP FUNCTION IF EXISTS addoverviewconstraints(ovtable name, ovcolumn name, reftable name, refcolumn name, ovfactor integer);
309DROP FUNCTION IF EXISTS _st_valuecount(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision);
310DROP FUNCTION IF EXISTS _st_valuecount(rast raster, nband integer, exclude_nodata_value boolean, searchvalues double precision[], roundto double precision);
311DROP FUNCTION IF EXISTS _st_summarystats(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision);
312DROP FUNCTION IF EXISTS _st_summarystats(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision);
313DROP FUNCTION IF EXISTS _st_slope4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
314DROP FUNCTION IF EXISTS _st_resample(rast raster, algorithm text, maxerr double precision, srid integer, scalex double precision, scaley double precision, gridx double precision, gridy double precision, skewx double precision, skewy double precision, width integer, height integer);
315DROP FUNCTION IF EXISTS _st_reclass(rast raster, VARIADIC reclassargset reclassarg[]);
316DROP FUNCTION IF EXISTS _st_quantile(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]);
317DROP FUNCTION IF EXISTS _st_quantile(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, quantiles double precision[]);
318DROP FUNCTION IF EXISTS _st_mapalgebra4unionstate(rast1 raster, rast2 raster, p_expression text, p_nodata1expr text, p_nodata2expr text, p_nodatanodataval double precision, t_expression text, t_nodata1expr text, t_nodata2expr text, t_nodatanodataval double precision);
319DROP FUNCTION IF EXISTS _st_mapalgebra4unionstate(rast1 raster, rast2 raster, bandnum integer, p_expression text);
320DROP FUNCTION IF EXISTS _st_mapalgebra4unionstate(rast1 raster, rast2 raster, p_expression text);
321DROP FUNCTION IF EXISTS _st_mapalgebra4unionstate(rast1 raster, rast2 raster, bandnum integer);
322DROP FUNCTION IF EXISTS _st_mapalgebra4unionstate(rast1 raster, rast2 raster);
323DROP FUNCTION IF EXISTS _st_mapalgebra4unionfinal1(rast raster);
324DROP FUNCTION IF EXISTS _st_intersects(rast1 raster, nband1 integer, rast2 raster, nband2 integer);
325DROP FUNCTION IF EXISTS _st_intersects(geom geometry, rast raster, nband integer);
326DROP FUNCTION IF EXISTS _st_intersects(rast raster, geom geometry, nband integer);
327DROP FUNCTION IF EXISTS _st_intersection(rast1 raster, band1 integer, rast2 raster, band2 integer, extenttype text, returnband text, otheruserfunc regprocedure);
328DROP FUNCTION IF EXISTS _st_histogram(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], "right" boolean, min double precision, max double precision);
329DROP FUNCTION IF EXISTS _st_histogram(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision, bins integer, width double precision[], "right" boolean);
330DROP FUNCTION IF EXISTS _st_hillshade4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
331DROP FUNCTION IF EXISTS _st_dumpaswktpolygons(rast raster, band integer);
332DROP FUNCTION IF EXISTS _st_count(rastertable text, rastercolumn text, nband integer, exclude_nodata_value boolean, sample_percent double precision);
333DROP FUNCTION IF EXISTS _st_count(rast raster, nband integer, exclude_nodata_value boolean, sample_percent double precision);
334DROP FUNCTION IF EXISTS _st_asraster(geom geometry, scalex double precision, scaley double precision, width integer, height integer, pixeltype text[], value double precision[], nodataval double precision[], upperleftx double precision, upperlefty double precision, gridx double precision, gridy double precision, skewx double precision, skewy double precision, touched boolean);
335DROP FUNCTION IF EXISTS _st_aspect4ma(matrix double precision[], nodatamode text, VARIADIC args text[]);
336DROP FUNCTION IF EXISTS _raster_constraint_pixel_types(rast raster);
337DROP FUNCTION IF EXISTS _raster_constraint_nodata_values(rast raster);
338DROP FUNCTION IF EXISTS _raster_constraint_info_srid(rastschema name, rasttable name, rastcolumn name);
339DROP FUNCTION IF EXISTS _raster_constraint_info_scale(rastschema name, rasttable name, rastcolumn name, axis character);
340DROP FUNCTION IF EXISTS _raster_constraint_info_regular_blocking(rastschema name, rasttable name, rastcolumn name);
341DROP FUNCTION IF EXISTS _raster_constraint_info_pixel_types(rastschema name, rasttable name, rastcolumn name);
342DROP FUNCTION IF EXISTS _raster_constraint_info_num_bands(rastschema name, rasttable name, rastcolumn name);
343DROP FUNCTION IF EXISTS _raster_constraint_info_nodata_values(rastschema name, rasttable name, rastcolumn name);
344DROP FUNCTION IF EXISTS _raster_constraint_info_extent(rastschema name, rasttable name, rastcolumn name);
345DROP FUNCTION IF EXISTS _raster_constraint_info_blocksize(rastschema name, rasttable name, rastcolumn name, axis text);
346DROP FUNCTION IF EXISTS _raster_constraint_info_alignment(rastschema name, rasttable name, rastcolumn name);
347DROP FUNCTION IF EXISTS _overview_constraint_info(ovschema name, ovtable name, ovcolumn name, OUT refschema name, OUT reftable name, OUT refcolumn name, OUT factor integer);
348DROP FUNCTION IF EXISTS _overview_constraint(ov raster, factor integer, refschema name, reftable name, refcolumn name);
349DROP FUNCTION IF EXISTS _drop_raster_constraint_srid(rastschema name, rasttable name, rastcolumn name);
350DROP FUNCTION IF EXISTS _drop_raster_constraint_scale(rastschema name, rasttable name, rastcolumn name, axis character);
351DROP FUNCTION IF EXISTS _drop_raster_constraint_regular_blocking(rastschema name, rasttable name, rastcolumn name);
352DROP FUNCTION IF EXISTS _drop_raster_constraint_pixel_types(rastschema name, rasttable name, rastcolumn name);
353DROP FUNCTION IF EXISTS _drop_raster_constraint_num_bands(rastschema name, rasttable name, rastcolumn name);
354DROP FUNCTION IF EXISTS _drop_raster_constraint_nodata_values(rastschema name, rasttable name, rastcolumn name);
355DROP FUNCTION IF EXISTS _drop_raster_constraint_extent(rastschema name, rasttable name, rastcolumn name);
356DROP FUNCTION IF EXISTS _drop_raster_constraint_blocksize(rastschema name, rasttable name, rastcolumn name, axis text);
357DROP FUNCTION IF EXISTS _drop_raster_constraint_alignment(rastschema name, rasttable name, rastcolumn name);
358DROP FUNCTION IF EXISTS _drop_raster_constraint(rastschema name, rasttable name, cn name);
359DROP FUNCTION IF EXISTS _drop_overview_constraint(ovschema name, ovtable name, ovcolumn name);
360DROP FUNCTION IF EXISTS _add_raster_constraint_srid(rastschema name, rasttable name, rastcolumn name);
361DROP FUNCTION IF EXISTS _add_raster_constraint_scale(rastschema name, rasttable name, rastcolumn name, axis character);
362DROP FUNCTION IF EXISTS _add_raster_constraint_regular_blocking(rastschema name, rasttable name, rastcolumn name);
363DROP FUNCTION IF EXISTS _add_raster_constraint_pixel_types(rastschema name, rasttable name, rastcolumn name);
364DROP FUNCTION IF EXISTS _add_raster_constraint_num_bands(rastschema name, rasttable name, rastcolumn name);
365DROP FUNCTION IF EXISTS _add_raster_constraint_nodata_values(rastschema name, rasttable name, rastcolumn name);
366DROP FUNCTION IF EXISTS _add_raster_constraint_extent(rastschema name, rasttable name, rastcolumn name);
367DROP FUNCTION IF EXISTS _add_raster_constraint_blocksize(rastschema name, rasttable name, rastcolumn name, axis text);
368DROP FUNCTION IF EXISTS _add_raster_constraint_alignment(rastschema name, rasttable name, rastcolumn name);
369DROP FUNCTION IF EXISTS _add_raster_constraint(cn name, sql text);
370DROP FUNCTION IF EXISTS _add_overview_constraint(ovschema name, ovtable name, ovcolumn name, refschema name, reftable name, refcolumn name, factor integer);
371DROP TYPE IF EXISTS wktgeomval;
372DROP TYPE IF EXISTS valuecount;
373DROP TYPE IF EXISTS summarystats;
374DROP TYPE IF EXISTS reclassarg;
375DROP TYPE IF EXISTS raster CASCADE;
376DROP FUNCTION IF EXISTS raster_out(raster);
377DROP FUNCTION IF EXISTS raster_in(cstring);
378DROP TYPE IF EXISTS quantile;
379DROP TYPE IF EXISTS histogram;
380DROP TYPE IF EXISTS geomval;