| Offset 1, 9 lines modified | Offset 1, 9 lines modified | ||
| 1 | ·dd672c2ccedf331ad02968c3ac81f1a5·544844·debug·optional·postgis-dbgsym_3.4.2+dfsg-1_amd64.deb | 1 | ·dd672c2ccedf331ad02968c3ac81f1a5·544844·debug·optional·postgis-dbgsym_3.4.2+dfsg-1_amd64.deb |
| 2 | ·4ccbe11f817883d394b43121fb63363f·2916828·doc·optional·postgis-doc_3.4.2+dfsg-1_all.deb | 2 | ·4ccbe11f817883d394b43121fb63363f·2916828·doc·optional·postgis-doc_3.4.2+dfsg-1_all.deb |
| 3 | ·7d57b3aa94a912b062b2fd75464d0c6d·151708·misc·optional·postgis_3.4.2+dfsg-1_amd64.deb | 3 | ·7d57b3aa94a912b062b2fd75464d0c6d·151708·misc·optional·postgis_3.4.2+dfsg-1_amd64.deb |
| 4 | ·7b9346ae5049b37e193592c1a131922b·4202584·debug·optional·postgresql-16-postgis-3-dbgsym_3.4.2+dfsg-1_amd64.deb | 4 | ·7b9346ae5049b37e193592c1a131922b·4202584·debug·optional·postgresql-16-postgis-3-dbgsym_3.4.2+dfsg-1_amd64.deb |
| 5 | · | 5 | ·e16787a340608e3290048debd61cd5dd·1300292·misc·optional·postgresql-16-postgis-3-scripts_3.4.2+dfsg-1_all.deb |
| 6 | ·ff174c6749bdf5624fb5ecf172855833·3817264·misc·optional·postgresql-16-postgis-3_3.4.2+dfsg-1_amd64.deb | 6 | ·ff174c6749bdf5624fb5ecf172855833·3817264·misc·optional·postgresql-16-postgis-3_3.4.2+dfsg-1_amd64.deb |
| 7 | ·18a3350276fedf3d6a1ac11a97c4927d·20496·misc·optional·postgresql-postgis-scripts_3.4.2+dfsg-1_all.deb | 7 | ·18a3350276fedf3d6a1ac11a97c4927d·20496·misc·optional·postgresql-postgis-scripts_3.4.2+dfsg-1_all.deb |
| 8 | ·04f5d1f748fe1b5f38fbe21d53865ea2·20480·metapackages·optional·postgresql-postgis_3.4.2+dfsg-1_amd64.deb | 8 | ·04f5d1f748fe1b5f38fbe21d53865ea2·20480·metapackages·optional·postgresql-postgis_3.4.2+dfsg-1_amd64.deb |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | -rw-r--r--···0········0········0········4·2024-02-08·17:55:49.000000·debian-binary | 1 | -rw-r--r--···0········0········0········4·2024-02-08·17:55:49.000000·debian-binary |
| 2 | -rw-r--r--···0········0········0·····272 | 2 | -rw-r--r--···0········0········0·····2720·2024-02-08·17:55:49.000000·control.tar.xz |
| 3 | -rw-r--r--···0········0········0··129 | 3 | -rw-r--r--···0········0········0··1297380·2024-02-08·17:55:49.000000·data.tar.xz |
| Offset 1, 13 lines modified | Offset 1, 13 lines modified | ||
| 1 | Package:·postgresql-16-postgis-3-scripts | 1 | Package:·postgresql-16-postgis-3-scripts |
| 2 | Source:·postgis | 2 | Source:·postgis |
| 3 | Version:·3.4.2+dfsg-1 | 3 | Version:·3.4.2+dfsg-1 |
| 4 | Architecture:·all | 4 | Architecture:·all |
| 5 | Maintainer:·Debian·GIS·Project·<pkg-grass-devel@lists.alioth.debian.org> | 5 | Maintainer:·Debian·GIS·Project·<pkg-grass-devel@lists.alioth.debian.org> |
| 6 | Installed-Size:·38 | 6 | Installed-Size:·38818 |
| 7 | Recommends:·postgresql-16-postgis-3 | 7 | Recommends:·postgresql-16-postgis-3 |
| 8 | Provides:·postgresql-16-postgis-scripts | 8 | Provides:·postgresql-16-postgis-scripts |
| 9 | Section:·misc | 9 | Section:·misc |
| 10 | Priority:·optional | 10 | Priority:·optional |
| 11 | Multi-Arch:·foreign | 11 | Multi-Arch:·foreign |
| 12 | Homepage:·https://postgis.net/ | 12 | Homepage:·https://postgis.net/ |
| 13 | Description:·Geographic·objects·support·for·PostgreSQL·16·--·SQL·scripts | 13 | Description:·Geographic·objects·support·for·PostgreSQL·16·--·SQL·scripts |
| Offset 40, 15 lines modified | Offset 40, 15 lines modified | ||
| 40 | -rw-r--r--···0·root·········(0)·root·········(0)·····2027·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer--3.4.2.sql | 40 | -rw-r--r--···0·root·········(0)·root·········(0)·····2027·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer--3.4.2.sql |
| 41 | -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer--ANY--3.4.2.sql | 41 | -rw-r--r--···0·root·········(0)·root·········(0)·····1511·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer--ANY--3.4.2.sql |
| 42 | -rw-r--r--···0·root·········(0)·root·········(0)······144·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer--TEMPLATED--TO--ANY.sql | 42 | -rw-r--r--···0·root·········(0)·root·········(0)······144·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer--TEMPLATED--TO--ANY.sql |
| 43 | -rw-r--r--···0·root·········(0)·root·········(0)······206·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer-3.control | 43 | -rw-r--r--···0·root·········(0)·root·········(0)······206·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer-3.control |
| 44 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--3.4.2--3.4.2next.sql | 44 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--3.4.2--3.4.2next.sql |
| 45 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--3.4.2.sql | 45 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--3.4.2.sql |
| 46 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--3.4.2next--3.4.2.sql | 46 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--3.4.2next--3.4.2.sql |
| 47 | -rw-r--r--···0·root·········(0)·root·········(0)··· | 47 | -rw-r--r--···0·root·········(0)·root·········(0)···505078·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--ANY--3.4.2.sql |
| 48 | -rw-r--r--···0·root·········(0)·root·········(0)······160·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql | 48 | -rw-r--r--···0·root·········(0)·root·········(0)······160·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql |
| 49 | -rw-r--r--···0·root·········(0)·root·········(0)······131·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us-3.control | 49 | -rw-r--r--···0·root·········(0)·root·········(0)······131·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/address_standardizer_data_us-3.control |
| 50 | -rw-r--r--···0·root·········(0)·root·········(0)··7532949·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--3.4.2.sql | 50 | -rw-r--r--···0·root·········(0)·root·········(0)··7532949·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--3.4.2.sql |
| 51 | -rw-r--r--···0·root·········(0)·root·········(0)··7889504·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--ANY--3.4.2.sql | 51 | -rw-r--r--···0·root·········(0)·root·········(0)··7889504·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--ANY--3.4.2.sql |
| 52 | -rw-r--r--···0·root·········(0)·root·········(0)······118·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--TEMPLATED--TO--ANY.sql | 52 | -rw-r--r--···0·root·········(0)·root·········(0)······118·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--TEMPLATED--TO--ANY.sql |
| 53 | -rw-r--r--···0·root·········(0)·root·········(0)··7969178·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--unpackaged--3.4.2.sql | 53 | -rw-r--r--···0·root·········(0)·root·········(0)··7969178·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--unpackaged--3.4.2.sql |
| 54 | -rw-r--r--···0·root·········(0)·root·········(0)·······22·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--unpackaged.sql | 54 | -rw-r--r--···0·root·········(0)·root·········(0)·······22·2024-02-08·17:55:49.000000·./usr/share/postgresql/16/extension/postgis--unpackaged.sql |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·address_standardizer·version·as·"ANY" | 1 | --·Just·tag·extension·address_standardizer·version·as·"ANY" |
| 2 | --·Installed·by·address_standardizer·3.4.2 | 2 | --·Installed·by·address_standardizer·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:19:24·+14·2024 |
| Offset 1, 60 lines modified | Offset 1, 8437 lines modified | ||
| 1 | CREATE·TABLE·IF·NOT·EXISTS·us_lex·( | ||
| 2 | » id·serial, | ||
| 3 | ····seq·integer, | ||
| 4 | ····word·text, | ||
| 5 | ····stdword·text, | ||
| 6 | ····token·integer,·is_custom·boolean·NOT·NULL·DEFAULT·true,·CONSTRAINT·pk_us_lex·PRIMARY·KEY(id) | ||
| 7 | ); | ||
| 8 | --·this·will·be·needed·for·upgrading·to·prevent·purging·of·custom·entries | ||
| 9 | DELETE·FROM·us_lex·WHERE·is_custom·=·false; | ||
| 10 | --·needed·so·entries·we·add·will·default·to·not·custom | ||
| 11 | ALTER·TABLE·us_lex·ALTER·COLUMN·is_custom·SET·DEFAULT·false; | ||
| 12 | INSERT·INTO·us_lex·(seq,·word,·stdword,·token) | ||
| 13 | WITH·t(seq,word,stdword,token)·AS·(·VALUES·(1,·'#',·'#',·16), | ||
| 14 | (2,·'#',·'#',·7), | ||
| 15 | (1,·'&',·'AND',·13), | ||
| 16 | (2,·'&',·'AND',·1), | ||
| 17 | (3,·'&',·'AND',·7), | ||
| 18 | (1,·'-',·'-',·9), | ||
| 19 | (1,·'1·/·2',·'1/2',·25), | ||
| 20 | (1,·'1·/·2·MILE',·'1/2·MI',·1), | ||
| 21 | (1,·'1·/·3',·'1/3',·25), | ||
| 22 | (1,·'1·/·4',·'1/4',·25), | ||
| 23 | (1,·'1·MI',·'ONE·MILE',·1), | ||
| 24 | (1,·'1·MILE',·'ONE·MILE',·1), | ||
| 25 | (1,·'1/2',·'1/2',·25), | ||
| 26 | (1,·'1/2·MILE',·'1/2·MI',·1), | ||
| 27 | (1,·'1/3',·'1/3',·25), | ||
| 28 | (1,·'1/4',·'1/4',·25), | ||
| 29 | (1,·'10·MI',·'TEN·MILE',·1), | ||
| 30 | (1,·'10·MILE',·'TEN·MILE',·1), | ||
| 31 | (1,·'10MI',·'TEN·MILE',·1), | ||
| 32 | (1,·'100·MILE',·'ONE·HUNDRED·MILE',·1), | ||
| 33 | (1,·'11·MI',·'ELEVEN·MILE',·1), | ||
| 34 | (1,·'11·MILE',·'ELEVEN·MILE',·1), | ||
| 35 | (1,·'11MI',·'ELEVEN·MILE',·1), | ||
| 36 | (1,·'12·MI',·'TWELVE·MILE',·1), | ||
| 37 | (1,·'12·MILE',·'TWELVE·MILE',·1), | ||
| 38 | (1,·'12MI',·'TWELVE·MILE',·1), | ||
| 39 | (1,·'13·MI',·'THIRTEEN·MILE',·1), | ||
| 40 | (1,·'13·MILE',·'THIRTEEN·MILE',·1), | ||
| 41 | (1,·'13MI',·'THIRTEEN·MILE',·1), | ||
| 42 | (1,·'14·MI',·'FOURTEEN·MILE',·1), | ||
| 43 | (1,·'14·MILE',·'FOURTEEN·MILE',·1), | ||
| 44 | (1,·'14MI',·'FOURTEEN·MILE',·1), | ||
| 45 | (1,·'15·MI',·'FIFTEEN·MI',·1), | ||
| 46 | (1,·'15·MILE',·'FIFTEEN·MI',·1), | ||
| 47 | (1,·'15MI',·'FIFTEEN·MI',·1), | ||
| 48 | (1,·'16·MI',·'SIXTEEN·MILE',·1), | ||
| 49 | (1,·'16·MILE',·'SIXTEEN·MILE',·1), | ||
| 50 | (1,·'16MI',·'SIXTEEN·MILE',·1), | ||
| 51 | (1,·'17·MI',·'SEVENTEEN·MILE',·1), | ||
| 52 | (1,·'17·MILE',·'SEVENTEEN·MILE',·1), | ||
| 53 | (1,·'17MI',·'SEVENTEEN·MILE',·1), | ||
| 54 | (1,·'18·MI',·'EIGHTEEEN·MILE',·1), | ||
| 55 | (1,·'18·MILE',·'EIGHTEEEN·MILE',·1), | ||
| 56 | (1,·'18MI',·'EIGHTEEEN·MILE',·1), | ||
| 57 | (1,·'19·MI',·'NINETEEN·MILE',·1), | ||
| 58 | (1,·'19·MILE',·'NINETEEN·MILE',·1), | ||
| 59 | (1,·'19MI',·'NINETEEN·MILE',·1), | ||
| 60 | (1,·'1ER',·'PREMIERE',·1), | ||
| 61 | (1,·'1ER',·'1',·15), | ||
| 62 | (1,·'1MI',·'ONE·MILE',·1), | ||
| 63 | (1,·'1RE',·'PREMIERE',·1), | ||
| 64 | (1,·'1RE',·'1',·15), | ||
| 65 | (1,·'1ST',·'1',·1), | ||
| 66 | (2,·'1ST',·'1',·15), | ||
| 67 | (1,·'2·MI',·'TWO·MILE',·1), | ||
| 68 | (1,·'2·MILE',·'TWO·MILE',·1), | ||
| 69 | (1,·'20·MI',·'TWENTY·MILE',·1), | ||
| 70 | (1,·'20·MILE',·'TWENTY·MILE',·1), | ||
| 71 | (1,·'20MI',·'TWENTY·MILE',·1), | ||
| 72 | (1,·'21ST',·'21',·1), | ||
| 73 | (2,·'21ST',·'21',·15), | ||
| 74 | (1,·'22ND',·'22',·1), | ||
| 75 | (2,·'22ND',·'22',·15), | ||
| 76 | (1,·'23·MI',·'TWENTY·THREE·MILE',·1), | ||
| 77 | (1,·'23·MILE',·'TWENTY·THREE·MILE',·1), | ||
| 78 | (1,·'23MI',·'TWENTY·THREE·MILE',·1), | ||
| 79 | (1,·'23RD',·'23',·1), | ||
| 80 | (2,·'23RD',·'23',·15), | ||
| 81 | (1,·'2MI',·'TWO·MILE',·1), | ||
| 82 | (1,·'3·/·4',·'3/4',·25), | ||
| 83 | (1,·'3·/·8',·'3/8',·25), | ||
| 84 | (1,·'3·MI',·'THREE·MILE',·1), | ||
| 85 | (1,·'3·MILE',·'THREE·MILE',·1), | ||
| 86 | (1,·'3/4',·'3/4',·25), | ||
| 87 | (1,·'3/8',·'3/8',·25), | ||
| 88 | (1,·'31ST',·'31',·1), | ||
| 89 | (2,·'31ST',·'31',·15), | ||
| 90 | (1,·'33RD',·'33',·1), | ||
| 91 | (2,·'33RD',·'33',·15), | ||
| 92 | (1,·'3MI',·'THREE·MILE',·1), | ||
| 93 | (1,·'3RD',·'3',·1), | ||
| 94 | (2,·'3RD',·'3',·15), | ||
| 95 | (1,·'4·CORNERS',·'FOUR·CORNERS',·1), | ||
| 96 | (1,·'4·FG',·'FOUR·FLAGS',·1), | ||
| 97 | (1,·'4·FLAGS',·'FOUR·FLAGS',·1), | ||
| 98 | (1,·'4·MI',·'FOUR·MILE',·1), | ||
| 99 | (1,·'4·MILE',·'FOUR·MILE',·1), | ||
| 100 | (1,·'4·SEASONS',·'FOUR·SEASONS',·1), | ||
| 101 | (1,·'4·SN',·'FOUR·SEASONS',·1), | ||
| 102 | (1,·'41ST',·'41',·1), | ||
| 103 | (2,·'41ST',·'41',·15), | ||
| 104 | (1,·'43RD',·'43',·1), | ||
| 105 | (2,·'43RD',·'43',·15), | ||
| 106 | (1,·'4MI',·'FOUR·MILE',·1), | ||
| 107 | (1,·'4WD',·'FOUR·WHEEL·DRIVE·TRAIL',·2), | ||
| 108 | (1,·'4WD·TRAIL',·'FOUR·WHEEL·DRIVE·TRAIL',·2), | ||
| 109 | (1,·'4WD·TRL',·'FOUR·WHEEL·DRIVE·TRAIL',·2), | ||
| 110 | (1,·'5·CEDARS',·'FIVE·CEDARS',·1), | ||
| 111 | (1,·'5·CORNERS',·'FIVE·CORNERS',·1), | ||
| 112 | (1,·'5·MI',·'FIVE·MILE',·1), | ||
| 113 | (1,·'5·MILE',·'FIVE·MILE',·1), | ||
| 114 | (1,·'5·POINTS',·'FIVE·POINTS',·1), | ||
| 115 | (1,·'5·PT',·'FIVE·POINTS',·1), | ||
| 116 | (1,·'5·TO',·'FIVE·TOWN',·1), | ||
| 117 | (1,·'51ST',·'51',·1), | ||
| 118 | (2,·'51ST',·'51',·15), | ||
| 119 | (1,·'53RD',·'53',·1), | ||
| 120 | (2,·'53RD',·'53',·15), | ||
| 121 | (1,·'5MI',·'FIVE·MILE',·1), | ||
| 122 | (1,·'6·FG',·'SIX·FLAGS',·1), | ||
| 123 | (1,·'6·FLAGS',·'SIX·FLAGS',·1), | ||
| 124 | (1,·'6·MI',·'SIX·MILE',·1), | ||
| Max diff block lines reached; 423199/515082 bytes (82.16%) of diff not shown. | |||
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·address_standardizer_data_us·version·as·"ANY" | 1 | --·Just·tag·extension·address_standardizer_data_us·version·as·"ANY" |
| 2 | --·Installed·by·address_standardizer_data_us·3.4.2 | 2 | --·Installed·by·address_standardizer_data_us·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:32:57·+14·2024 |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·postgis·version·as·"ANY" | 1 | --·Just·tag·extension·postgis·version·as·"ANY" |
| 2 | --·Installed·by·postgis·3.4.2 | 2 | --·Installed·by·postgis·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:19:22·+14·2024 |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·postgis_raster·version·as·"ANY" | 1 | --·Just·tag·extension·postgis_raster·version·as·"ANY" |
| 2 | --·Installed·by·postgis_raster·3.4.2 | 2 | --·Installed·by·postgis_raster·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:19:23·+14·2024 |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·postgis_sfcgal·version·as·"ANY" | 1 | --·Just·tag·extension·postgis_sfcgal·version·as·"ANY" |
| 2 | --·Installed·by·postgis_sfcgal·3.4.2 | 2 | --·Installed·by·postgis_sfcgal·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:19:23·+14·2024 |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·postgis_tiger_geocoder·version·as·"ANY" | 1 | --·Just·tag·extension·postgis_tiger_geocoder·version·as·"ANY" |
| 2 | --·Installed·by·postgis_tiger_geocoder·3.4.2 | 2 | --·Installed·by·postgis_tiger_geocoder·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:19:23·+14·2024 |
| Offset 1, 3 lines modified | Offset 1, 3 lines modified | ||
| 1 | --·Just·tag·extension·postgis_topology·version·as·"ANY" | 1 | --·Just·tag·extension·postgis_topology·version·as·"ANY" |
| 2 | --·Installed·by·postgis_topology·3.4.2 | 2 | --·Installed·by·postgis_topology·3.4.2 |
| 3 | --·Built·on· | 3 | --·Built·on·Sun·Apr·28·11:19:23·+14·2024 |